jgnasser
Mon 22 October 2007, 01:05 pm GMT +0200
Dear Forum, I am having a hard time with access_user. I have moved it to a new server and when I try registering a user or login I get this 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 " -main.users WHERE email = 'jgnasser@abcl.com' OR login = 'jgna" and registration or login fails. Any ideas what could be wrong?
olaf
Mon 22 October 2007, 01:46 pm GMT +0200
Hi,
you are using this kind of naming convention for table names:
database.table
this is not allowed in your current configuration, check the source for information about how to call the database (config and AU class file)
jgnasser
Mon 22 October 2007, 02:14 pm GMT +0200
do you mean access_user does not support database.name or my new host may not support that? Thanks.
olaf
Mon 22 October 2007, 02:22 pm GMT +0200
do you mean access_user does not support database.name or my new host may not support that? Thanks.
your host doesn't support this (your db user doesn't have the rights)
jgnasser
Mon 22 October 2007, 03:07 pm GMT +0200
Thanks, I get what you mean. My new server may not support database.table, will check that.