Supporting each other

Community forums

Welcome, Guest
Username: Password: Remember me
Report any technical problems you discover and discuss solutions.
  • Page:
  • 1
  • 2

TOPIC:

1064 - You have an error in your SQL syntax; check 10 years 3 months ago #1177

  • coursenligne
  • coursenligne's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 43
  • Thank you received: 3
OK if it is a test server (and only a test server !) please try to use the root account (NEVER do that under production environment).
SQL is sometimes a bit tricky to understand.. not only read/write/modify the database, XOT should also have scheme roghts as far as i remember...
Root account has all rights !
As you can read here, i hardly suspect an issue regarding DB rights ....

I really hope you'll soon get rid of your issue.
If I can help I will do for sure...

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

1064 - You have an error in your SQL syntax; check 10 years 3 months ago #1178

  • coursenligne
  • coursenligne's Avatar
  • Offline
  • Senior Member
  • Senior Member
  • Posts: 43
  • Thank you received: 3
I found this on another kind of software forum :
The 1064 error normally indicates a version difference in Mysql. Can you show us on or two queries from your file, one starting with 'CREATE TABLE'.

So the strange thing is that it would be related to your MySQL version.

I don't know if that makes sens to you ?
If I can help I will do for sure...

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

  • Page:
  • 1
  • 2
Moderators: ronmjultenJohnSmith
Time to create page: 0.042 seconds
Copyright © 2024 The Xerte Project.
Xerte logo Apereo logo OSI Logo

Search