PDA

View Full Version : SQL Error when editing or creating a new forum HELP

dano
05-19-2003, 07:37 PM
I have a problem and I am not sure where it is coming from. Everytime I try and create a new forum or edit a current forum I get this error:

mysql error number: 1064

Depending on what I try to do the content of the error changes, but it is always a number 1064.

As an example here is one when I simply tried to change the default style:

Database error in vBulletin Control Panel 2.3.0:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE forum
SET
styleid='2', title=`XXXXXXXXXX`, description='',
active='1', displayorder='1', parentid='-1', parentlist='1,-1',
allowposting='0', cancontainthreads='0', daysprune='0',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='0', allowbbcode='0',
allowimages='1', allowsmilies='0', allowicons='0',
styleoverride='0', allowratings='0', countposts='1',
moderateattach='0',allowdollaroffers = 1',enablewelcome='0',welcometext=''
WHERE forumid='1'

mysql error: You have an error in your SQL syntax near '',enablewelcome='0',welcometext=''
WHERE forumid='1'' at line 10

mysql error number: 1064
filburt1
05-19-2003, 07:40 PM
You didn't open the quote for allowdollaroffers.
Reverend
05-19-2003, 07:44 PM
There's a quote missing from this line:

moderateattach='0',allowdollaroffers = 1',enablewelcome='0',welcometext=''

edit: filburt beat me to it. ;)
dano
05-19-2003, 07:51 PM
Wow, ok let me look at this ASAP. The dollar option has been working great.

Let me ask you a question (I am a total newbie to all of this) When you say I didnt open the quote for dollars offers, how do I fix this??

I think I see whats missing, its the ` on the other side of the 1, but where do I change this at?
dano
05-19-2003, 09:29 PM
I know its prolly a stupid questions guys, but I just can't figure it out. I went through myPhp and can not figure out how to fix it.

Any help would really be helpful since I can not do anything with my forums until this is fixed.

Thanks
Reverend
05-19-2003, 09:36 PM
First thing you could try is run a repair on the database.
Upload repair.php from the extras folder in the vb zip file into your forum/admin directory.Close your board and then run the following script from your browser address bar:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1 (replace with your forum url and if neccessary run the script twice).

If that doesn't fix it,upload a new admin/forum.php file (overwriting the old one).

Note: before doing any of the above backup your database first.
dano
05-19-2003, 09:50 PM
Fixed.

I found the problem in the edited forum.php file. Thanks Reverend, I can now get back to work. Thanks a lot! :)
Reverend
05-19-2003, 09:59 PM
Today at 11:50 PM dano said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=397403#post397403)
Fixed.

I found the problem in the edited forum.php file. Thanks Reverend, I can now get back to work. Thanks a lot! :)

No probs.Glad you got it sorted. ;)