Questions on getting Xerte Toolkits installed on your server and questions about authentication and user logins.

Install PHP and MYSQL Errors

More
12 years 2 weeks ago #2052 by tom
Replied by tom on topic Install PHP and MYSQL Errors
This was caused by the databse name: cl36-xerte21. There is a dash in there, and that only works if the name is enclosed in backticks ( ` ).

Will need to verify if the latest code can handle this.

Please Log in or Create an account to join the conversation.

More
11 years 4 months ago #2639 by Mattward
Replied by Mattward on topic Install PHP and MYSQL Errors
Hi, I'm new to Xerte, and everything seems to be fine until I have this error,

Sorry, the attempt to create the database to the database has failed. MySQL reports the following error -

1064 - 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 'database' at line 1
Creating MySQL Database Failed!

Can you help?

Cheers

Matt

Please Log in or Create an account to join the conversation.

More
11 years 4 months ago #2643 by tom
Replied by tom on topic Install PHP and MYSQL Errors
If the error is exact the same as the error reported here:

www.xerte.org.uk/index.php?option=com_ku...mid=207&lang=en#2642

Then you have named your database 'database', which happens to be a reserved word in MySQL. Can you please confirm that?

Please Log in or Create an account to join the conversation.

Time to create page: 0.209 seconds
Copyright © 2026 The Xerte Project.
Xerte logo Apereo logo OSI Logo