The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Complete db novice... Help Needed
Hi Everyone
Help Needed Please. Whenever I save changes in User Cp - Edit Options, I get the error below. Can anyone tell what the error is and how can I correct the problem without altering the rest of the db? Any ideas guy's? Thanks - Andy :ermm: Database error in vBulletin 3.0.9: Invalid SQL: UPDATE user SET styleid = 0, showvbcode = 2, pmpopup = 0, maxposts = -1, daysprune = 0, timezoneoffset = '0', startofweek = 1, languageid = 0, threadedmode = 0, autosubscribe = -1, showdonor = , options = 2263 WHERE userid = 1 mysql 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 ' options = 2263 WHERE userid = 1' at line 12 mysql error number: 1064 Script: profile.php |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
YEs, im 99.99932% shure thats it, because its telling it to do somethign, but you havent set anyhitng for it to do ^^
|
#4
|
|||
|
|||
This is going a little bit above my head?? - Does this mean its a PHP error or a db error?
the script in the profile.php is // Add user choice to show donor status if ($bbuserinfo['showdonor'] == '1'){ $checked['showdonor'] == HTML_CHECKED; } // End user choice to show donor status AND THEN LATER IN THE SCRIPT $DB_site->query(" UPDATE " . TABLE_PREFIX . "user SET " . $updatestyles . " showvbcode = $showvbcode, pmpopup = $pmpopup, maxposts = $umaxposts, daysprune = $prunedays, timezoneoffset = '$timezoneoffset', startofweek = $startofweek, languageid = $languageid, threadedmode = $threadedmode, autosubscribe = $autosubscribe, showdonor = $showdonor, options = " . convert_array_to_bits($options, $_USEROPTIONS) . " WHERE userid = $bbuserinfo[userid] "); Thanks Andy |
#5
|
|||
|
|||
change
showdonor = $showdonor, to showdonor = '$showdonor', ? |
#6
|
|||
|
|||
Well I took your kind advice but alas the problem continues only this time the error is slightly different. Take a look at the donor section now!
Invalid SQL: UPDATE user SET styleid = 0, showvbcode = 2, pmpopup = 0, maxposts = -1, daysprune = 0, timezoneoffset = '0', startofweek = 1, languageid = 0, threadedmode = 0, autosubscribe = -1, showdonor = $'showdonor', options = 2263 WHERE userid = 1 mysql 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 ''showdonor', options = 2263 WHERE userid = 1' at line 12 Best Regards Andy |
#7
|
|||
|
|||
but the ' before the $
showdonor = '$showdonor', not showdonor = $'showdonor', |
#8
|
|||
|
|||
Yep my mistake....
Well I've just tried again it's working now. FANTASTIC Thanks Loads Best Regards Andy :banana: |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|