[Xerte] Re: Problem with installer

[Brian Chivers]

It's no so much the database name that causes the problem as I'm only using
a simple name it's the hyphen in the connection string for the fqdn.

I'll have a look at this on Monday when I'm back in the office and post
back my results :-)

Thanks
Brian
On 26 Jan 2013 17:57, "Paul Swanson" <Paul.Swanson at harlandfs.com> wrote:

>  The script that creates the database needs to have backticks ( ` )
> around the database name. The backtick character is on the same key as
> the ~ character.****
>
> ** **
>
> https://www.google.com/search?q=mysql+hyphen+database+name****
>
> ** **
>
> You might also need to alter the scripts that connect to the database to
> include backticks around the database name.****
>
> ** **
>
> *Paul Swanson*
>
> Internal Business Systems Analyst****
>
> Internal Business Intelligence****
>
> Harland Financial Solutions****
>
> (800) 274-7280 Ext. 2462****
>
> Paul.Swanson at harlandfs.com****
>
> ** **
>
> *From:* xerte-bounces at lists.nottingham.ac.uk [mailto:
> xerte-bounces at lists.nottingham.ac.uk] *On Behalf Of *Brian Chivers
> *Sent:* Saturday, January 26, 2013 2:27 AM
> *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****
>
>
>
>
> _______________________________________________
> 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/f7972d41/attachment.html>