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.

Unknown column 'upload_loc' in 'field list'

July 01, 2011 1:00pm

Subscribe [3]
  • #1 / Jul 01, 2011 1:00pm

    RevaCo

    240 posts

    This question may be related to a resolved thread.

    I noted in the thread above it stated that a fix has been committed. I’ve just had this same error in v2.2.1 - Build: date 20110630

    This is on a site that’s been on EE2 MSM for a good while now.

    Running the query below worked

    ALTER TABLE exp_upload_no_access ADD COLUMN upload_loc varchar(3) NOT NULL AFTER upload_id

    Thought I’d better pipe up as it’s obviously not gone away.

  • #2 / Jul 05, 2011 3:50am

    John Henry Donovan

    12339 posts

    johnniefp,

    What version did you upgrade from when you got this error?
    The resolved thread error was specifically for the version 2.0.0 updater file
    Did you start your upgrade for a version after that?

  • #3 / Jul 05, 2011 8:49am

    RevaCo

    240 posts

    It was a EE1 > EE2.1.3 Build: 20110411 upgrade. Error didn’t manifest itself for a while and it only showed once. Corrected it with the above sql.

    It seems to be one of those that only throws up when you actually change specific settings.

  • #4 / Jul 07, 2011 4:35pm

    Brandon Jones

    5500 posts

    Hi johnniefp, I believe that was a bug in the 2.0 updater that was corrected in subsequent releases, but not before you had already updated. Thanks for sharing your solution. Does everything else appear to be working normally?

  • #5 / Jul 07, 2011 6:37pm

    RevaCo

    240 posts

    Everything else is fine.

  • #6 / Jul 08, 2011 2:07pm

    Brandon Jones

    5500 posts

    Thanks johnniefp, let us know if anything else crops up!

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

ExpressionEngine News!

#eecms, #events, #releases