[Xerte] Re: Problem with installer

[Ron Mitchell]

When you get to that last page check database.php in the xerte folder and
make sure everything is ok and manually edit it if not. Does that work or is
the problem with inserting the FQDN in the database?

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Brian Chivers
Sent: 26 January 2013 10:27
To: Xerte discussion list
Subject: [Xerte] Re: Problem with installer

 

Yes, I can use localhost but then on the last page where you setup all the
settings such as url, admin password etc it fails at that point as well as
it tries to store this in the database which again uses the fqdn and errors
on the hyphon. 

My boss uses php a lot so he might be able to help me sort it on this page
but I'm just a little concerned that db calls are used on other pages that
will cause problems when Xerte is in use. 

What I'll try and do is sort it on this page and then post how we fixed it
to the developers list to see where else it might need fixing 

Brian 

On 26 Jan 2013 10:19, "Ron Mitchell" <ronm at mitchellmedia.co.uk> wrote:

Just a quick check are you putting that FQDN for the MySQL host? Is the db
on the same server as your XOT install? If so just use localhost in the
mysql host field but run setup from the FQDN.

 

From: xerte-bounces at lists.nottingham.ac.uk
[mailto:xerte-bounces at lists.nottingham.ac.uk] On Behalf Of Brian Chivers
Sent: 25 January 2013 21:37
To: Xerte discussion list
Subject: [Xerte] Re: Problem with installer

 

I realise that one is supposed to to fail but this problem is after this
test that it fails. 

I'll contact the developers list for help and to offer help. 

Thanks 

On 25 Jan 2013 21:02, "Pat @ Pgogy" <xerte at pgogywebstuff.com> wrote:

One of the test scripts is designed to fail, but if you can make /setup
better feel free too.

You might also like the dev list as that is more techie

Pgogy Webstuff - http://www.pgogywebstuff.com
Makers of web things of a fair to middling quality

On 25 Jan 2013, at 15:46, Brian Chivers <brian at portsmouth-college.ac.uk>
wrote:

> I've just tried to install Xerte toolkit 1.9 onto a freshly setup Ubuntu
12.04 LTS server running the latest mysql / php stack and have run into a
problem with the installer php scripts.
>
> The server has a FQDN of xerte.portsmouth-college.ac.uk and when I run
setup/mysql_test.php on the test where it checks connectivity I get this
error
>
> Due to the following error - You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '-college.ac.uk' at line 1 - 1064 we cannot ascertain
whether we can create this database
>
> It would appear that it isn't escaping the FQDN correctly causing the
mysql statement to fail.
>
> If I rename the server to use our secondary domain tpc.ac.uk the installer
goes through fine so I know there is nothing wrong with the install.
>
> I still have the first server so if required I can test altered php files.
>
> Thanks
> Brian Chivers
>
> _______________________________________________
> Xerte mailing list
> Xerte at lists.nottingham.ac.uk
> http://lists.nottingham.ac.uk/mailman/listinfo/xerte
> This message and any attachment are intended solely for the addressee and
may contain confidential information. If you have received this message in
error, please send it back to me, and immediately delete it.   Please do not
use, copy or disclose the information contained in this message or in any
attachment.  Any views or opinions expressed by the author of this email do
not necessarily reflect the views of the University of Nottingham.
>
> This message has been checked for viruses but the contents of an
attachment
> may still contain software viruses which could damage your computer
system:
> you are advised to perform your own checks. Email communications with the
> University of Nottingham may be monitored as permitted by UK legislation.

_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte
This message and any attachment are intended solely for the addressee and
may contain confidential information. If you have received this message in
error, please send it back to me, and immediately delete it.   Please do not
use, copy or disclose the information contained in this message or in any
attachment.  Any views or opinions expressed by the author of this email do
not necessarily reflect the views of the University of Nottingham.

This message has been checked for viruses but the contents of an attachment
may still contain software viruses which could damage your computer system:
you are advised to perform your own checks. Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.






_______________________________________________
Xerte mailing list
Xerte at lists.nottingham.ac.uk
http://lists.nottingham.ac.uk/mailman/listinfo/xerte

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nottingham.ac.uk/pipermail/xerte/attachments/20130126/42c384a0/attachment-0001.html>