Announcement

Collapse
No announcement yet.

Changing Permission's getting 1054 errors

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

  • 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

  • #2
    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
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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

      Comment


      • #4
        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?

        Comment


        • #5
          Reupload the original forumpermission.php file.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X