The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
MYSQL Error--Help Please...
:ninja: I am trying to allow users to use Avatares and when I run a querry from Usergroups I get the following error..I know it has something to do with the fact that I semiinstalled shout box...
Database error in vBulletin 3.0.0: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### title = 'Registered Users', description = '', usertitle = '', opentag = '', closetag = '', passwordexpires = '0', passwordhistory = '0', attachlimit = '0', avatarmaxwidth = '80', avatarmaxheight = '80', avatarmaxsize = '20000', profilepicmaxwidth = '100', profilepicmaxheight = '100', profilepicmaxsize = '65535', pmquota = '50', pmsendmax = '5', forumpermissions = '127487', pmpermissions = '3', calendarpermissions = '19', wolpermissions = '1', adminpermissions = '0', genericpermissions = '5831', genericoptions = '30', shoutboxpermissions = '0', arcadepermissions = '19' WHERE usergroupid=2 mysql error: Unknown column 'shoutboxpermissions' in 'field list' mysql error number: 1054 How can I fix this?? Thanks ahead... |
#2
|
||||
|
||||
Quote:
Please always read instructions carefully, as the DB changes in them are important! |
#3
|
||||
|
||||
I have tried and tried to install the shoutbox correctly..I just tried editing all the php files again a minute ago to no avail..I ended up re uploading my includes/functions_online file because I kep getting a parse error......
Now I cannot reinstall using the admincp/shout_install unless I delte tables from MYSQL and I am scared to do that.... What do you reccomend??? Is there any way someone can edit the php files with the correct shoutbox edits?? I'm messing up somewhere along the line... |
#4
|
||||
|
||||
you'd better ask in the shoutbox support thread.
the permission field is missing, so you have to add the field via phpmyadmin for example. i think it's just a tiny int field, but as said you should ask in the shoutbox support for detailed infos. |
#5
|
||||
|
||||
I didn't thing there was support.. I am just asking whoever might know---
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|