coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: spuri on July 29, 2004, 11:27:24 PM

Title: update.php error
Post by: spuri on July 29, 2004, 11:27:24 PM
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 :(
Title: Re: upload.php error
Post by: Joachim Müller on July 30, 2004, 08:02:43 AM
please post a link to your page.

GauGau
Title: Re: upload.php error
Post by: Nibbler on July 30, 2004, 05:26:29 PM
I changed the topic to read update.php rather than upload.php, makes things less confusing that way. ;)
Title: Re: update.php error
Post by: spuri on August 02, 2004, 12:37:45 AM
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
Title: Re: update.php error
Post by: Joachim Müller on August 02, 2004, 08:36:12 AM
is your issue solved then?

GauGau
Title: Re: update.php error
Post by: spuri on August 02, 2004, 05:37:24 PM
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 ?
Title: Re: update.php error
Post by: Nibbler on August 02, 2004, 06:02:24 PM
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.
Title: Re: update.php error
Post by: spuri on September 13, 2004, 12:17:14 AM
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???
Title: Re: update.php error
Post by: spuri on September 13, 2004, 12:20:50 AM
ok - I see this is a php.ini setting 50sec for me  - and it would need more  :o

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

thx
spuri
Title: Re: update.php error
Post by: Nibbler on September 13, 2004, 12:23:08 AM
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.
Title: Re: update.php error
Post by: kegobeer on September 13, 2004, 12:35:18 AM
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?
Title: Re: update.php error
Post by: spuri on September 14, 2004, 12:10:48 AM
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
Title: Re: update.php error
Post by: spuri on September 14, 2004, 12:14:47 AM
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 ?
Title: Re: update.php error
Post by: Nibbler on September 14, 2004, 12:39:54 AM
Do what I suggested, import the modified sql file a few lines at a time.
Title: Re: update.php error
Post by: spuri on September 14, 2004, 08:10:05 AM
so if i run coppermine1.3.2\sql\update.sql /in parts/ - I get my db updated ?!  ::)
Title: Re: update.php error
Post by: spuri on September 14, 2004, 09:55:59 PM
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
Title: Re: update.php error
Post by: Joachim Müller on September 15, 2004, 07:53:43 AM
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