upload on 5.4.1

Permalink 1 user found helpful
Hi

Would appreciate if anyone can help with this problem.

The upload does not work for us on 5.4.1, see attached.

We had this issue with the beta's but this is a clean install, the older versions of c5 work fine.

See attached, we are running IIS and Windows Server 208 at the moment.

Thanks. Craig

1 Attachment

 
ceejay replied on at Permalink Reply 1 Attachment
we also see an error 500 now and again.
jordanlev replied on at Permalink Reply
jordanlev
What size are the image files you're trying to upload? I've seen problems when the file size is too SMALL (yes, I said small, not large!) -- apparently this is due to a limitation of the flash uploader.
It's probably not this, but just in case...
ceejay replied on at Permalink Reply
I can see the files sitting in the file directory when viewing the directory structure in windows, so they are being uploaded fine, it seems to be the new file attribute screen thats not been shown after the file is uploaded.

I have tried different file types and sizes and they all upload fine, the strange thing is this is only happening with version 5.4.1 the older version is fine.

thanks
craig
JustinO replied on at Permalink Reply
I have the same setup and can not upload files of any size or type. I've tried ie firefox ect. and nothing.

Server 2008 R2, IIS 7.5, PHP, ect.
Everything in Concrete5 seems to work fine except the upload files area. Single file up load, incoming, multiple upload none of it works.
ppcc replied on at Permalink Best Answer Reply
For some reason the "ocID" field in the table "files" does not have a default value. I'm not sure why. I noticed this on B2 and RC1.

You can set a default value by using this SQL:

ALTER TABLE `#DBNAME#`.`files` CHANGE COLUMN `ocID` `ocID` INT(10) UNSIGNED NOT NULL DEFAULT '0'  ;


Hope this helps!
andrew replied on at Permalink Reply
andrew
Thanks! Interesting. Not totally sure why that's causing a problem but we can add this into the core to make sure the next upgrade doesn't have the same issues.
ceejay replied on at Permalink Reply
hi all

thanks for your help the fix ppcc has solved the problem for us.

regards

craig
stars replied on at Permalink Reply
"ocID" field in the table "files"

ok, Ill ask the dumb question,

which file, where. :)


Ps. Im on a linux server, php.
does that count
ceejay replied on at Permalink Reply
you need to run the command against your sql db
ALTER TABLE `#DBNAME#`.`files` CHANGE COLUMN `ocID` `ocID` INT(10) UNSIGNED NOT NULL DEFAULT '0' ;

where #DBNAME# is the name of your database.

I ran it in myphpadmin

Regards

Craig
stars replied on at Permalink Reply
#1146 - Table '#dbasename#.files' doesn't exist

Nice try Craig, but that didnt work either.

All the ftp in the files/123/1234/122345/ are at 777, and the image too.
refreshed the cache and cleared it.

still no joy, this was a fresh install of 5.4.1 and a fresh dbase install.

off to bang head on wall.
afixia replied on at Permalink Reply
afixia
I got it to work finally on my environment.

OS: Windows 2003 server

IIS 6

PHP Version 5.2.10

MySQL 5.0.51a

========================================

The Fix:

Well I found that I was having issues with the Blog plugin on another site. The fix for that was to remove strict mode on MySQL. After that fixed my Blog issue, I tried the uploader in 5.4.1 and it worked! So I guess it has something to do with STRICT MODE in MYSQL on my environment. Here is how to remove it with MySQL Administrator:

http://www.iishacks.com/2007/06/21/vbulletin-photopost-and-mysql-5/...

Don't forget to stop and start MySQL service after you change it.
stars replied on at Permalink Reply
ta for the reply,

nopes my strict mode is off.

:(
Kiesel replied on at Permalink Reply
If you have the same 406 Error that I have, then deactivating "mod_security" could help ( You can also do that over the .htaccess file with the entry: SecFilterEngine Off )
stars replied on at Permalink Reply
I didnt have a 406 error, or if I did I did not know where to look.

I think Im a bit to far down the learning curve to pick some of this up.
I have to deactivate mod_security, on the hosting Im with,

SELECT @@GLOBAL.sql_mode;

#1227 - Access denied; you need the SUPER privilege for this operation

Can some one just lend me a VERY BIG hammer.
Mike0051 replied on at Permalink Reply
Mike0051
THANKS A MILLION!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I was stumped.
ofc2logic replied on at Permalink Reply 1 Attachment
Would really like some assistance if someone can spare it. I ran the query against the database and now I'm able to upload files, but the attached screen shows up, and the only thing I can do to continue the process is close the browser window/tab.
Shotster replied on at Permalink Reply
Shotster
Should be remedied in the next update, but until then see here for info...

http://www.concrete5.org/developers/bugs/5-4-1/ie-file-upload-bug/...

-Steve