Announcement

Collapse
No announcement yet.

Changing Permission's getting 1054 errors

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    Reupload the original forumpermission.php file.

    Leave a comment:


  • jayk2
    replied
    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?

    Leave a comment:


  • jayk2
    replied
    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

    Leave a comment:


  • Steve Machol
    replied
    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

    Leave a comment:


  • jayk2
    started a topic Changing Permission's getting 1054 errors

    Changing Permission's getting 1054 errors

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X