The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
database error - please help
Normally I am careful with trying to install add ons etc however I tried to install a chatbox which didnt work out exactly so i removed it again. The main problem with this is it was a couple of weeks ago and I hadnt realised it had left any thing behind.
Today after getting a couple of new members (very important as my membership is only at 30 lol) I tried to alter the PM settings for the registered users usergroup and to my horror I get this error displayed Code:
Database error in vBulletin 3.6.8: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Registered Users', `description` = '', `usertitle` = '', `opentag` = '', `closetag` = '', `passwordexpires` = '0', `passwordhistory` = '0', `forumpermissions` = '782847', `genericpermissions` = '237508295', `attachlimit` = '0', `pmquota` = '50', `pmpermissions` = '7', `pmsendmax` = '2', `calendarpermissions` = '63', `wolpermissions` = '1', `adminpermissions` = '0', `genericoptions` = '62', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '100', `avatarmaxheight` = '100', `avatarmaxsize` = '30000', `signaturepermissions` = '135199', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '10000', `sigmaxrawchars` = '1000', `sigmaxchars` = '500', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '4', `nbmsgshowchatbox` = '', `mgccustomusergroupperms` = '0' WHERE usergroupid=2; MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list' Error Number : 1054 Date : Monday, October 15th 2007 @ 02:42:58 PM Script : http://www.xxxxxxxx.com/xxxxxxx/xxxxxxxxx/usergroup.php?do=update Referrer : http://www.xxxxxxx.com/xxxxxxx/xxxxxx/usergroup.php?do=edit&usergroupid=2 IP Address : xx.xxx.xxx.x Username : xxxxxxxx Classname : vb_database If not can I import an sql query over the top of my database with an older database or would it rewrite all data not just the matching data? Any help at all that doesnt involve me losing todays new members and posts lol. If everything fails I can restore to an earlier time but really dont want to have to do that if possible. Thank you for any help at all. Tinks |
#2
|
|||
|
|||
May this might help: https://vborg.vbsupport.ru/showthread.php?t=152193#2
|
#3
|
||||
|
||||
Perfect, worked a treat. I think I will love you and Dismounted forever.
A huge thank you Tinks |
#4
|
|||
|
|||
:erm:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|