forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: mr.d 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'
....
-
Just remove the following line from sql/update.sql:
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.
-
Just remove the following line from sql/update.sql:
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'