Changing Permission's getting 1054 errors

[jayk2]

Hey guys.

I didn't know where to post this as it's a mysql problem, but I'm only getting it when I'm trying to change user permissions. Example, I'm trying to enable COPPA on a specific forum and when I click ok, I get this error:

Database error in vBulletin 3.0.0:
Invalid SQL: UPDATE forumpermission SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
forumpermissions = '0'
WHERE forumpermissionid = 31
mysql error: Unknown column 'forumpermissions' in 'field list'
mysql error number: 1054
Date: Thursday 15th of April 2004 01:24:00 PM
Script: http://www.thecandidboard.com/forums...permission.php
Referer: http://www.thecandidboard.com/forums...?do=edit&fp=31

I'm using vb3.0.0 gold

Thanks
jay

[Steve Machol]

Was this an upgrade? For some reason you are missing the forumpermissions field in the forumpermission table. You can add it manually in phpMyAdmin:

Field: forumpermissions
Type: int(10)
Attributes: UNSIGNED
Null: No
Default: 0

[jayk2]

yea it was an upgrade. I tried to run it as a query and put in the info you stated and this is the error message I got:

Error

SQL-query :

Field : forumpermissions TYPE : int( 10 ) Attributes : UNSIGNED NULL : NoDefault :0

MySQL said:


#1064 - 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 'Field : forumpermissions TYPE : int( 10 ) Attributes : UNSIGN

[jayk2]

heh never mind

I added it manually, now when I try and change the permissions, it goes to a "This page can not be displayed" page.

Do I need to reboot anything for it to take effect?

[Steve Machol]

Reupload the original forumpermission.php file.