[Mosh]

Originally Posted by Corsan

Hi! I get this error everytime i update usergroup settings and i have uninstalled and reinstalled the hack over and over again and still get this.

Im running vb 3.8 latest version.

PHP Code:

Database error in vBulletin 3.8.0 Release Candidate 2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###

took alot of irrelevant code out.

MySQL Error   : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 2nd 2009 @ 04:28:56 PM
Error Date    : Friday, January 2nd 2009 @ 04:28:56 PM
Script        : IGNORE.
Referrer      : IGNORE.
IP Address    : IGNORE.
Username      : Cory
Classname     : vB_Database
MySQL Version : 5.0.67-community-log 


The only way I can see this happening is you mixing up the v3.7.x product file with the v3.8.x bitfield file. As the ms_imageshack_upload_permissions column is not being added to the user table. v3.7.x version of this hack does not include a bitfield file and does not create an extra column in the database.

What I suggest is that you to do the following (exactly):

1. Delete bitfield_ms_imageshack_upload.xml from your /includes/xml folder.
2. Uninstall the hack from your Product Manager
3. Download and unzip ms_imageshack_upload_v3.8.002.zip to an entirely new location
4. Upload bitfield_ms_imageshack_upload.xml from your /includes/xml folder.
5. Import ms_imageshack_upload.xml into vB using the AdminCP Product Manager.
6. In the Admin CP, select vBulletin Options -> Imageshack & MEGAUPLOAD Uploader, and change the size and colour settings for the imageshack and MEGAUPLOAD dialog boxes.
7. In Usergroups -> Usergroup Manager, change the usergroup permissions for each usergroup individually to enable display locations (disabled by default)

That should fix the problem, if it does not let me know.