Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error in SELECT query
#1
I successfully trialed OpenDocMan on a local xampp server. However my attempts to install on a remote host have been frustrating. Initially I got a login screen but tripped over the dataDir setting. However I now can't seem to get past this error:

Error in query: SELECT cl27-docs-t58.odm_user.username FROM cl27-docs-t58.odm_user WHERE cl27-docs-t58.odm_user.id = 1
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 '-docs-t58.odm_user WHERE cl27-docs-t58.odm_user.id = 1' at line 1


The version of pmpMyAdmin used by the host does not permit renaming the database so I'm stuck with the prefix "cl27-".
It also does not allow me to check table privileges.
The tables are all collated as: "latin1_swedish_ci"

Any suggestions?
#2
I see this issue pop up for other users. I believe this is an issue with dashes "-" being used in the database name.

Can you tell me which php file is showing this error? I thought I had removed all mentions of the database name in the queries.


Forum Jump:


Users browsing this thread: 1 Guest(s)