Icy Phoenix :: View topic - Bugs Sql_update

Hi

I found these errors while updating the database (script install/database_update.php).

Updating from 1.3.0.53b to 2.0.0.86

Error

Quote:

UPDATE phpbb_cms_block_settings` SET `content` = REPLACE(`content`, '\\"', '\"')
+++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content` = REPLACE(`content`, '\\"', '\"')' at line 1

UPDATE phpbb_cms_block_settings` SET `content` = REPLACE(`content`, "\'", "\'")
+++ Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'content` = REPLACE(`content`, "\'", "\'")' at line 1

Fix
File: install/schemas/sql_update_ip.php
Search (Line 3973)

Code: [Hide]

		$sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, '\\\\\"', '\\\"')"; 
		$sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, \"\\'\", \"\'\")"; 

Replace

Code: [Hide]

		$sql[] = "UPDATE `" . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, '\\\\\"', '\\\"')"; 
		$sql[] = "UPDATE `" . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, \"\\'\", \"\'\")"; 

Error

Quote:

INSERT INTO `___sessions___` SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin FROM `phpbb_sessions` s ORDER BY s.session_id
+++ Error: Column count doesn't match value count at row 1

--> The table is not updated and is empty (I can use the old table).

Fix
File: install/schemas/sql_update_ip.php
Search (Line 4040)

Code: [Hide]

			$sql[] = "INSERT INTO `___sessions___` 
			SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin 
			FROM `" . $table_prefix . "sessions` s 
			ORDER BY s.session_id"; 

Replace

Code: [Hide]

			$sql[] = "INSERT INTO `___sessions___` 
			SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, 0, '', 1, 0, s.session_admin 
			FROM `" . $table_prefix . "sessions` s 
			ORDER BY s.session_id"; 

Bye

Icy Phoenix

Old Support Topics - Bugs Sql_update_ip.php