Originally Posted by RedGTiVR6
(Post 1228971)
I just tried to install this update and have run into an issue.
I uploaded the files and I've uploaded the .xml file allowing rewrite.
I then go into the usergroups to allow the various user groups to view, when on an administrator and I select yes to can view, then hit update, I get the following database error:
Code:
Database error in vBulletin 3.6.5:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`vbtrends_permissions` = '1',
`vbgmepermissions` = '31',
`vbclassified` = '122879',
`vbclassified_timeframe_limit` = '365',
`vbimghost` = '3',
`vbimghost_upslots` = '20',
`vbimghost_files` = '500',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '2000',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '1038884799',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '65536',
`signaturepermissions` = '230911',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`akspam_permissions` = '0',
`vbwikiroles` = '',
`vbwikipermissions` = '524287'
WHERE usergroupid=6;
MySQL Error : Unknown column 'vbtrends_permissions' in 'field list'
Error Number : 1054
Seems that there is an issue with "vbtrends_permissions"...
Any help?
Also, do you have any special uninstall instructions? I'd like to be able to uninstall if possible for future.
EDIT: I had to completely uninstall the .xml then reinstall it to prevent this database error from occuring.
On another note, now the stats are all exagerated. Previously, our numbers were up 8%, 11%, etc.
Now it's showing a 90% increase, 88% increase, etc.
The change is just after the update...not after a few days...but rather just within a matter of a few minutes.
|