MySql problem

hi,
Let me tell you this first,this is great php class. thanks.

here is my problem:
what I was trying to do is that I have changed some of the sql fields name.for examle , uid instead of id , password instaed of pw.
I have changed all of them in all files. the program works, it shows the login page, forget paas page any page. but when send any form I got a mysq error stating :

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 '-1.myusers WHERE email = 'test@yahoo.com' AND active = 'y

--- like this..
I check the script . everyhting seem ok to me.. any help appreciated! whats wrong with this? thanks,

Hi,

maybe its about the fact that the database is called with in the sql statement (got the same error on one of my hosts).

remove the database variable from the vars for table names and use the mysql select db command (db_connect method)

gr. Olaf

YES!!!! it works.. thanks. Olaf.

Hi Olaf,

Can you give a little extra help ?
I have the same problem (hostingdiscounter maybe ?)

Can you tell me the module and line ?

Thanks,
Rob

I found the answer:

db_config, line 14, 15, 16 (remove DB_NAME and the .'s)

access_user_class.php line 119 (remove \\)

Thanks,

Rob

PS, Love the script.

great... you found the answer by yourself...

I love the script too... I'm currently busy with a new version with email templates, is much more safe, just better...;-)

But I have not enough for all the documentation... :-(

gr. Olaf