ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

database error when creating new member group

March 27, 2011 7:24pm

Subscribe [1]
  • #1 / Mar 27, 2011 7:24pm

    Manji

    10 posts

    This is the error message:

    A Database Error Occurred
    
    Error Number: 1054
    
    Unknown column 'upload_loc' in 'field list'
    
    INSERT INTO exp_upload_no_access (upload_id, upload_loc, member_group) VALUES ('1', 'cp', '13')
    
    Filename: controllers/cp/members.php
    
    Line Number: 2067

    Build:  20101020

  • #2 / Mar 28, 2011 10:54am

    Sue Crocker

    26054 posts

    Hi, Manji. Was this a brand new install, or did you upgrade from an older version?

  • #3 / Mar 28, 2011 2:19pm

    Manji

    10 posts

    Hi Sue,

    Actually I upgraded from EE1.

    I fixed this error by creating the “upload_loc” column but I don’t know if this causes any trouble in other functions.

  • #4 / Mar 28, 2011 2:22pm

    Sue Crocker

    26054 posts

    It shouldn’t cause you any more errors, but we’ve seen a few cases where upgrading failed with that particular table. The solution was just to add the field, or remove the whole table and remake it.

    Let’s have you go ahead and back up your database just the same. You shouldn’t have to, but I’d feel better if you did.

    How long ago did you upgrade from 1.x?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases