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.

File Manager issues and errors

December 01, 2010 12:43am

Subscribe [7]
  • #1 / Dec 01, 2010 12:43am

    LissaKay

    46 posts

    Hi all!

    I’m getting back into blogging and EE-ing and I just upgraded my site from 1.6.something to v2.1.0 Build 20101020. I have been completely out of the loop here and have forgotten many, many things, so bear with me!

    I am having problems with the file manager. First, it does not offer any way to insert an image into a post. I can upload, and I can see the thumbnails in the pop-up in-post manager, but when I click on them, nothing happens.

    I went to the File Manager page and verified the file paths, and those are still correct. However, when I attempted to update - whether I made any changes or not - I get an error:

    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 (‘11’, ‘cp’, ‘7’)

    Please let me know what other information is needed.

  • #2 / Dec 01, 2010 1:05pm

    Brandon Jones

    5500 posts

    Hi LissaKay,

    Did you go straight from 1.6 to 2.1? That build should be version 2.1.1, not 2.1.0. Can you also confirm which update instructions you followed?

  • #3 / Dec 02, 2010 5:29pm

    LissaKay

    46 posts

    I updated following the instructions in the user guide here:
    http://ellislab.com/expressionengine/user-guide/installation/update_from_1.x.html

    The version and build information was copied directly from the control panel ... screen shot attached.

  • #4 / Dec 03, 2010 11:34am

    Ingmar

    29245 posts

    What version does it mention in your config.php? What permissions does that file have?

  • #5 / Dec 03, 2010 11:53am

    LissaKay

    46 posts

    According to the config.php file:
    $config[‘app_version’] = “210”;

    Permissions are set to 0666

  • #6 / Dec 03, 2010 5:48pm

    Sue Crocker

    26054 posts

    Hi, LissaKay. There’s a bug in the Info accessory - the actual version is 2.1.1. But in any case, can you do a DESC exp_upload_no_access inside the SQL manager?

    Does upload_loc show there?

    You may need to so a manual query to fix things..

  • #7 / Dec 03, 2010 9:57pm

    LissaKay

    46 posts

    Well how about that ... upload_loc is not there. Only upload_id and member_group

  • #8 / Dec 05, 2010 2:47pm

    Greg Salt

    3988 posts

    Hi LissaKay,

    It looks as if your installation may not have completed properly because your config.php file should have 211 as the app_version. What is shown at the bottom of each page of your CP as the EE version and build?

    In order to manually add the missing column (which should have been created on installation) you can run this in your Tools > Data SQL Manager > SQL Query Form in the CP:

    alter table exp_upload_no_access add column upload_loc varchar(3) not null after upload_id

    Be sure to take a complete backup of your database before attempting this

    Cheers

    Greg

  • #9 / Dec 09, 2010 1:37am

    LissaKay

    46 posts

    The update to the database worked ... I can update the upload locations without getting the error. But I still cannot insert the files into my posts. I see the thumbnails in the File Manager but when I click on one, nothing happens. I did update all of my upload locations.

    Getting very frustrated ... I really don’t have the time to fool with this. Is it possible to downgrade to 1.6?

  • #10 / Dec 09, 2010 4:10pm

    Sue Crocker

    26054 posts

    LissaKay - how much memory is allocated to PHP?

    Have you seen: EEWiki:// HowTo Determine Memory Limits

    -and-

    EEWiki:// HowTo Override Memory Limitations

    Unfortunately there is no way to go back other than to re-upload your 1.6.x files, and putting back in your older database.

  • #11 / Dec 09, 2010 5:53pm

    LissaKay

    46 posts

    It shows a memory limit of 32M. If I add the line to htaccess suggested as a way to override the limit, I get Server error 500 on my site.

    I have also now found that it does work for file types other than .jpg and .gif. I can post a link to a .zip or .png file.

  • #12 / Dec 10, 2010 11:20am

    Ingmar

    29245 posts

    It shows a memory limit of 32M. If I add the line to htaccess suggested as a way to override the limit, I get Server error 500 on my site.

    That probably means that your server does not allow that. You’d have to contact your host for details.

    I have also now found that it does work for file types other than .jpg and .gif. I can post a link to a .zip or .png file.

    Have you tried to disable XSS filtering? Also how large are your images?

  • #13 / Jan 04, 2011 3:47pm

    LissaKay

    46 posts

    Haven’t had the time to deal with this lately ... but I see now that several others are seeing the same issue.

    I have no clue about XSS filtering.

    The image files are not large, typically less than 100KB.

    Firefox error console shows this when I try to insert an image into an entry:

    Error: EE.filebrowser.image_tag is undefined
    Source File: http://www.lissakay.com/admin.php?S=0&D=cp&C=javascript&M=combo_load&ui=datepicker,resizable,draggable,droppable&
    plugin=markitup,toolbox.expose,overlay,scrollable,scrollable.navigator,ee_filebrowser
    &file=json2,cp/publish,cp/publish_admin&v=1286510661
    Line: 468

  • #14 / Jan 05, 2011 9:23am

    Sue Crocker

    26054 posts

    Is this on a MSM site? I notice you’re masking your control panel..

  • #15 / Jan 06, 2011 8:46pm

    LissaKay

    46 posts

    No, it isn’t. I had to delete my other blogs where I discussed specific topics because of the licensing change. I didn’t think it was worth paying the additional fees to have knitting, gardening, photography and other topical blogs. I will put those on a different system.

    I notice that several others are having the same problem with inserting images. Has anyone found a solution for this?

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

ExpressionEngine News!

#eecms, #events, #releases