update.php error

[spuri]

1.3.0 -> 1.3.1 win2k server IIS 5
I get this error message after I uploaded all files (excl config... & install...)
Fatal error: Maximum execution time of 30 seconds exceeded in D:\ftproot\fotoweb.hu\www\fotoalbum\update.php on line 257

I tried to reupload but still the same

[Joachim Müller]

please post a link to your page.

GauGau

[Nibbler]

I changed the topic to read update.php rather than upload.php, makes things less confusing that way.

[spuri]

thanks for the topic chanege, it was my mistake

this is where I get error
http://totalweb.hu/fotoalbum/ update.php
but I downloaded to localhost (files+mysql) than update.php run successfully than I uploaded the database to the server

[Joachim Müller]

is your issue solved then?

GauGau

[spuri]

mostly

is there an an.sql file witch contains the 1.3.0.-> 1.3.1 changes ?
or is there other way to check my database if its 1.3.1 or not ?

[Nibbler]

update.sql contains all the db changes, the version number is on the config page, and in an html comment at the bottom of every page.

[spuri]

this problem is back - win2003server

Fatal error: Maximum execution time of 50 seconds exceeded in D:\ftproot\fotoweb\www\fotoalbum\update.php on line 257

why???

[spuri]

ok - I see this is a php.ini setting 50sec for me  - and it would need more 

so i can see only one chance -  may i split the update.php into 2-3 parts?

thx
spuri

[Nibbler]

Running update.php shouldn't take anywhere near 50 seconds. You can open the update.sql, find/replace CPG_ and change it to your actual prefix set during install. Then save it and import it using phpmyadmin.

[kegobeer]

This is most certainly either a server misconfiguration issue, an example of using outdated versions of php and mysql, or a combination of all three.  What versions of php and mysql are you running?

[spuri]

PHP Version 4.3.7
MYSQL - Client API version  3.23.49 

prefic was cpg130_ I renamed this back to cpg_ /changed in db and config.inc.php/
but still getting error
Fatal error: Maximum execution time of 50 seconds exceeded in D:\ftproot\fotoweb.hu\www\fotoalbum\update.php on line 257

[spuri]

probably the server jail system kills my update.php because it uses too much cpu...
if i split the update.php into 2-3 parts, should this solve ?

[Nibbler]

Do what I suggested, import the modified sql file a few lines at a time.

[spuri]

so if i run coppermine1.3.2\sql\update.sql /in parts/ - I get my db updated ?! 

[spuri]

my host has MySQL 4.1.2-alpha-nt

and I get error if I try to run update.sql    :\'(

SQL-query:
ALTER TABLE `CPG_filetypes` DROP INDEX `EXTENSION` ,
ADD PRIMARY KEY ( `extension` )

MySQL said:  
#1091 - Can't DROP 'EXTENSION'; check that column/key exists
-----------------------------------------------------------------------------------------

ok i tested which mod needed and which not
now it looks ok

[Joachim Müller]

The error means the column isn't there anymore. It's save to ignore this error and continue with the rest of the sql file. It appears you didn't rename the CPG_ bits in all queries though with the extension you're actually using. This is case-sensitive, mind you.

Joachim