Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: update.php freeze  (Read 3614 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: 15760
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.015 seconds with 20 queries.