Thread

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.

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?

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.

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

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

Permissions are set to 0666

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..

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

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

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?

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.

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.

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?

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

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

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?