re: SQL erro

Corporal Joined: Apr 14, 2003 Posts: 64

hi there,

I've got a problem
when ever I want to update my profile in Forums module
I get this message:

Code:

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'remove this part from that line theme = 'bluebyu', ' at line 2

UPDATE nuke_users SET user_email = 'yahoo@hotmail.com', theme = 'bluebyu', user_icq = '0123123', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 0, user_popup_pm = 0, user_timezone = 10, user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = 7, user_active = 1, user_actkey = '' remove this part from that line theme = 'bluebyu', WHERE user_id = 3

Line : 506
File : /home/virtual/site73/fst/var/www/html/includes/usercp_register.php

I know that I have touched something in mySQL
cause my Forums module, wasn't working correctly

has anybody got any idea ?

Thank you

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

This code can't possibly be right

Code:

remove this part from that line theme = 'bluebyu', WHERE user_id = 3

. You need to restore the code to it's original state and start over. You can't have sentences in the middle of your SQL.

Corporal Joined: Apr 14, 2003 Posts: 64

Raven, thanks very much for replying

I just wanted to ask you
where about I need to restore this code?
in which file/folder ?
is it in module/Forums/
or ist it SQL User Table?

thank you very much

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

The code; not the table. I don't know because I don't know what code you've been mucking with. If you can't remember then you might have to restore the Forum's folder entirely. Just a guess.

Corporal Joined: Apr 14, 2003 Posts: 64

Raven, I have just overwrite all files ine modules/Forums, and is still the same...

have you got any other idea?

thanks...

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

This looks like it's a custom module of somekind. I would disable all custom modules and go from there. If you still can't figure it out, PM me with your

ftp url, id, password
Site url, adminid, adminpw
phpmyadmin url, id, password