|
Page 1 of 1
|
dinoyoco
Joined: August 2006
Posts: 18
Location: Spain
|
Bugs Sql_update_ip.php
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)
- $sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, '\\\"', '\\"')";
- $sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, \"\'\", \"\'\")";
Replace
- $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)
- $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
- $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
|
#1 Thu 06 Sep, 2012 12:10 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
Re: Bugs Sql_update_ip.php
Thanks for reporting... I confirm these bugs existed.
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#2 Tue 11 Sep, 2012 00:01 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|