Uploading to Database time outs

[Sugrat]

I've looked through other posts and found some posts that are same and have tried the ideas posted in them, like adding the .htaccess and changing the max time to 1800 for example but nothing seems to be working.

Basically, I've upload 50 pictures to the upload folder, roughy 5mb a picture - made a new gallery and set the default data but when i go in "upload to database" and select pictures (this happens even when i select ONE pictures), then the resize option and then the gallery i want it uploaded to and click on upload after 30-45 seconds, I get a page can't be display error and nothing is uploaded and when i click on the back button, the following message is displayed in the message box:-

msg 23754 | exif: EXIF of 'UPLOAD/046701.jpg':


FileName =>046701.jpg
FileDateTime =>1148328245
FileSize =>5179577
FileType =>2
MimeType =>image/jpeg
SectionsFound =>ANY_TAG, IFD0, EXIF
COMPUTED =>
html =>width="3519" height="2345"
Height =>2345
Width =>3519
IsColor =>1
ByteOrderMotorola =>0
CCDWidth =>22mm
ApertureFNumber =>f/7.1
Make =>Canon
Model =>Canon EOS 20D
XResolution =>300/0
YResolution =>300/0
ResolutionUnit =>2
Exif_IFD_Pointer =>90
ExposureTime =>1/200
FNumber =>71/10
ExposureProgram =>2
ISOSpeedRatings =>100
DateTimeOriginal =>2006:05:16 11:24:17
DateTimeDigitized =>2006:05:16 11:24:17
ShutterSpeedValue =>500948/65536
ApertureValue =>370648/65536
ExposureBiasValue =>0/2
MeteringMode =>5
Flash =>16
FocalLength =>135/1
ColorSpace =>1
ExifImageWidth =>3504
ExifImageLength =>2336
FocalPlaneXResolution =>3504000/885
FocalPlaneYResolution =>2336000/590
FocalPlaneResolutionUnit =>2
CustomRendered =>0
ExposureMode =>0
WhiteBalance =>0
SceneCaptureType =>0

Any ideas? this was working fine last week and I've made no changes to the website or the provider.

Thx

Dave

[Pekka]

With 5MB JPEG's you need at least 32MB allowed RAM for PHP. Blank page is almost always an indicator that PHP runs out of allowed RAM (out of resources).

Try adding

ini_set ("memory_limit","32M");

to upload editor script. You can also change the setting in php.in or htaccess (see PHP manual for that).

[Sugrat]

I added to the editor_upload file so it looks like this :-

ini_set ("memory_limit","32M");
ini_set ("max_execution_time","1800");
$maxtime = ini_get('max_execution_time');

And now before I even upload to the db I get this message displayed in the message box :-

get_message: Got error 127 from table handler
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xxxxxxxx/public_html/eegallery/input/message.php on line 310

(the xxx's are my username so i removed it)

I still tried to upload and it failed still...

With .htaccess file do i remove the memory limit line from the editor_upload file before trying? also, is the php.ini file i need to make because I can't find it in the eegallery folders?

Thx for your help.

[Pekka]

Error 127 means the ee_message database is corrupted. Usually this is fixed by REPAIR TABLE tablename command. PhpMyAdmin is one tool to give those commands and see table status. You can set EE to do repair for all tables by changing SCRIPT_editor_functions.php line 375

REPAIR TABLE $tablename QUICK

to

REPAIR TABLE $tablename

save it, and then run OPTIMIZE command in input/EDITOR_optimize.php

[Sugrat]

After running the Optimize, i got that everything was ok except:-

table: xxxxxxx_pics.ee_message | operation: repair | info: Wrong bytesec: 0-0-0 at 2008; Skipped
table: xxxxxxx_pics.ee_message | operation: repair | warning: Number of rows changed from 3 to 2

I ran it again and they came back as repaired, OK.

But it still times out when trying to upload to the db :-(

Should i try and increase the memory size from 32 to 64?

[Sugrat]

I also just uploaded a couple of smaller jpg files to the upload folder and tried them and got the same time out issue.

But I did notice a difference in the upload screen (screenshot below). Notice how the two smaller files have the X in the EXIF and IPTC listing? does that mean anything?

www.penrice.net\fp\sshot.jpg

[Pekka]

Just a quick note: please try it also with Firefox or Opera. Internet Explorer 7 Beta 2 for example times out for no apparent reason when other browsers do just fine.

[Sugrat]

Just a quick note: please try it also with Firefox or Opera. Internet Explorer 7 Beta 2 for example times out for no apparent reason when other browsers do just fine.

Just tried Firefox and that timed out also - i'm also running IE 6

[Sugrat]

Is there anything server based that I can have tech support look into? I'm currently with ipowerweb and had no problems with them.

[Pekka]

If you PM me you ftp and editor info I could take a look.

[Sugrat]

If you PM me you ftp and editor info I could take a look.

Just sent u the information.

[Sugrat]

Thank Pekka, it works like a gem now - i would have never thought of checking the ftp information.

Thank you again for all your assistance and of course for the wonderful software ;-)