Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: update.php freeze  (Read 4406 times)

0 Members and 1 Guest are viewing this topic.

mr.d

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 4
update.php freeze
« on: February 25, 2011, 11:47:29 am »


I have update problem. After replacing new files i try to run update.php and everything gone well put at line:

UPDATE cpg132_hit_stats SET `browser` = 'IE5.5' WHERE `browser` ='IE5.5'

update.php just stops without any results. What is problem? Is it possible skip this line somehow?


Coppermine 1.4.27 -> 1.5.12
Apache 2.2.14
MySQL 5.1.41
PHP 5.3.1


.....
INSERT INTO cpg132_config VALUES ('personal_album_on_registration', '0')   Already Done
INSERT INTO cpg132_config VALUES ('slideshow_hits', '1')   Already Done
UPDATE cpg132_hit_stats SET `browser` = 'IE6' WHERE `browser` ='Microsoft Internet Explorer 6.0'   Already Done
UPDATE cpg132_hit_stats SET `browser` = 'IE5.5' WHERE `browser` ='Microsoft Internet Explorer 5.5'   Already Done
UPDATE cpg132_hit_stats SET `browser` = 'IE6' WHERE `browser` ='MSIE 6.0'   Already Done
UPDATE cpg132_hit_stats SET `browser` = 'IE5.5' WHERE `browser` ='IE5.5'
....
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: update.php freeze
« Reply #1 on: February 25, 2011, 12:17:44 pm »

Just remove the following line from sql/update.sql:
Code: [Select]
UPDATE CPG_hit_stats SET `browser` = 'IE5.5' WHERE `browser` ='IE5.5';I don't know why it's there, as it simply does nothing.

I doubt that this line causes the behavior, but I assume the script times out or something like that. Please report what happens when you delete the line.
Logged

mr.d

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 4
Re: update.php freeze
« Reply #2 on: February 25, 2011, 04:28:16 pm »

Just remove the following line from sql/update.sql:
Code: [Select]
UPDATE CPG_hit_stats SET `browser` = 'IE5.5' WHERE `browser` ='IE5.5';I don't know why it's there, as it simply does nothing.

I doubt that this line causes the behavior, but I assume the script times out or something like that. Please report what happens when you delete the line.



I removed and also these lines. Now update.php works. Thank you..!

UPDATE cpg132_hit_stats SET `browser` = 'IE6' WHERE `browser` ='MSIE 6.0'
UPDATE cpg132_hit_stats SET `browser` = 'IE4' WHERE `browser` ='MSIE 4.0'
UPDATE cpg132_hit_stats SET `browser` = 'IE7' WHERE `browser` ='MSIE 7.0'
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.