Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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)
Code: [Download] [Hide]
  1.         $sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, '\\\\\"', '\\\"')"; 
  2.         $sql[] = "UPDATE " . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, \"\\'\", \"\'\")"; 


Replace
Code: [Download] [Hide]
  1.         $sql[] = "UPDATE `" . $table_prefix . "cms_block_settings` SET `content` = REPLACE(`content`, '\\\\\"', '\\\"')"; 
  2.         $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: [Download] [Hide]
  1.             $sql[] = "INSERT INTO `___sessions___` 
  2.             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 
  3.             FROM `" . $table_prefix . "sessions` s 
  4.             ORDER BY s.session_id"; 


Replace
Code: [Download] [Hide]
  1.             $sql[] = "INSERT INTO `___sessions___` 
  2.             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 
  3.             FROM `" . $table_prefix . "sessions` s 
  4.             ORDER BY s.session_id"; 


Bye
 



 
dinoyocoSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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