This is what i Got !

Everyone was asking what error i got , i managed to get my site back after my host did server back up !

I tried again to install the upgrade and i got this :

 

7.0.2-7.0.3 upgrade can be applied
System SQL script was successfully executed.

The following languages will be affected for system:
- fr
- en

 

Error
Database query error
Query:
SELECT `ID`, `IDCategory` FROM `sys_localization_keys` WHERE `Key`='_sorry, i can not define you ip adress. IT'S TIME TO COME OUT !' LIMIT 1
Mysql 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 'S TIME TO COME OUT !' LIMIT 1' at line 1
Found error in the file '/home/xxxxxx/public_html/www.xxxxxx.com/upgrade/classes/BxDolUpgradeUtil.php' at line 162.
Called 'getRow' function with erroneous argument #0.

Debug backtrace:
Array
(
    [1] => Array
        (
            [file] => /home/xxxx/public_html/www.xxxxx.com/upgrade/classes/BxDolUpgradeDb.php
            [line] => 215
            [function] => error
            [class] => BxDolUpgradeDb
            [type] => ->
            [object] => BxDolUpgradeDb Object
                (
                    [error_checking] => 1
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => xxxx_xxxx
                    [user] => xxxxx_xxx
                    [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [args] => Array ( [0] => Database query error [1] => [2] => SELECT `ID`, `IDCategory` FROM `sys_localization_keys` WHERE `Key`='_sorry, i can not define you ip adress. IT'S TIME TO COME OUT !' LIMIT 1 ) ) [2] => Array ( [file] => /home/xxxx/public_html/www.xxxx.com/upgrade/classes/BxDolUpgradeDb.php [line] => 93 [function] => res [class] => BxDolUpgradeDb [type] => -> [object] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxxxx_xxxx [user] => xxxxx_xxxxxx
                    [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [args] => Array ( [0] => SELECT `ID`, `IDCategory` FROM `sys_localization_keys` WHERE `Key`='_sorry, i can not define you ip adress. IT'S TIME TO COME OUT !' LIMIT 1 ) ) [3] => Array ( [file] => /home/xxxxx/public_html/www.xxxxxx.com/upgrade/classes/BxDolUpgradeUtil.php [line] => 162 [function] => getRow [class] => BxDolUpgradeDb [type] => -> [object] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxxx_xxxx [user] => xxxxx_xxxxxx
                    [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [args] => Array ( [0] => SELECT `ID`, `IDCategory` FROM `sys_localization_keys` WHERE `Key`='_sorry, i can not define you ip adress. IT'S TIME TO COME OUT !' LIMIT 1 ) ) [4] => Array ( [file] => /home/xxxxx/public_html/www.xxxxxx.com/upgrade/classes/BxDolUpgradeUtil.php [line] => 124 [function] => _executeLangAdd [class] => BxDolUpgradeUtil [type] => -> [object] => BxDolUpgradeUtil Object ( [oDb] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxxx_xxxxx [user] => xxxx_xxxxx [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [sFolder] => 7.0.2-7.0.3 ) [args] => Array ( [0] => [1] => fr ) ) [5] => Array ( [file] => /home/xxxxx/public_html/www.xxxxxx.com/upgrade/classes/BxDolUpgradeController.php [line] => 104 [function] => executeLangsAdd [class] => BxDolUpgradeUtil [type] => -> [object] => BxDolUpgradeUtil Object ( [oDb] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxxx_xxxxx
                            [user] => xxxxx_xxxxxx
                            [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [sFolder] => 7.0.2-7.0.3 ) [args] => Array ( ) ) [6] => Array ( [file] => /home/xxxxx/public_html/www.xxxxxxx.com/upgrade/index.php [line] => 30 [function] => runUpgrade [class] => BxDolUpgradeController [type] => -> [object] => BxDolUpgradeController Object ( [oDb] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxx_xxxxx
                            [user] => xxxx_xxxxxx [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [oUtil] => BxDolUpgradeUtil Object ( [oDb] => BxDolUpgradeDb Object ( [error_checking] => 1 [host] => localhost [port] => [socket] => [dbname] => xxxxx_xxxxx [user] => xxxxx_xxxxx
                                    [password] => 3j$>yq3Acd!D [link] => Resource id #43 [current_res] => [current_arr_type] => 1 [oParams] => ) [sFolder] => 7.0.2-7.0.3 ) ) [args] => Array ( [0] => 7.0.2-7.0.3 ) ) )
Called script: /upgrade/index.php
Request parameters:
Array
(
    [folder] => 7.0.2-7.0.3
    [memberSession] => .CxjWg+YPHcvT9?mcF3&Xw,tjsA9wT!n
    [lang] => en
    [memberID] => 1
    [memberPassword] => 90c7718cba005e9d1bc4fee1a476ba2b1a0318f0
)
Proud Hosted by Zarconia.net
Quote · 30 Sep 2010

Fixed i had to keep only english as language and remove my french language ! and finnaly the upgrade went smooth...

Proud Hosted by Zarconia.net
Quote · 30 Sep 2010

 

Everyone was asking what error i got , i managed to get my site back after my host did server back up !

I tried again to install the upgrade and i got this :

 

7.0.2-7.0.3 upgrade can be applied
System SQL script was successfully executed.

The following languages will be affected for system:
- fr
- en

 

Error
Database query error
Query:
SELECT `ID`, `IDCategory` FROM `sys_localization_keys` WHERE `Key`='_sorry, i can not define you ip adress. IT'S TIME TO COME OUT !' LIMIT 1
Mysql 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 'S TIME TO COME OUT !' LIMIT 1' at line 1
Found error in the file '/home/xxxxxx/public_html/www.xxxxxx.com/upgrade/classes/BxDolUpgradeUtil.php' at line 162.
Called 'getRow' function with erroneous argument #0.


It's most likely the apostrophe in the text.

Also never post any database error below the Debug Backtrace line. The only part needed is the part above it. The rest contains sensitive information that should not be posted.

You should edit your post to remove the extra data.




https://www.deanbassett.com
Quote · 30 Sep 2010

There is no language keys with apostrophes by default, also it is assumed that language key is short and simple, but for some reason you have apostrophe in language key.

Don't mix it with language string - it is ok to have apostrophe or any other symbols in language string.

Anyway to make sure that it will not be similar error in future version I escape language key the same way as language string:

http://www.boonex.com/trac/dolphin/ticket/2190

Rules → http://www.boonex.com/terms
Quote · 1 Oct 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.