The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
SQL Error when editing or creating a new forum HELP
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 |
#2
|
|||
|
|||
You didn't open the quote for allowdollaroffers.
|
#3
|
|||
|
|||
There's a quote missing from this line:
Code:
moderateattach='0',allowdollaroffers = 1',enablewelcome='0',welcometext='' |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
Fixed.
I found the problem in the edited forum.php file. Thanks Reverend, I can now get back to work. Thanks a lot! |
#8
|
|||
|
|||
Quote:
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|