1.0.6 upgrade to 1.1.0 error on 1.0.9 [SOLVED]

defrag

OK today I start upgrade from 1.0.6 v to 1.1.0 v. First time i try to upload all files and update. But I got this error:



Type: 256

Message: mysqlt error: [1005: Can't create table './crm/rc_accounts_edit_history.frm' (errno: 150)] in EXECUTE("CREATE TABLE rc_accounts_edit_history ( id INTEGER NOT NULL AUTO_INCREMENT, rc_accounts_id INTEGER, edited_on DATETIME, edited_by INTEGER, PRIMARY KEY (id) , FOREIGN KEY (edited_by) REFERENCES user_login(id), FOREIGN KEY (rc_accounts_id) REFERENCES rc_accounts_data_1(id) ) TYPE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci")

File: /libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error

File: /libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error

File: /libs/adodb/adodb.inc.php

    line 1043

    function called: ADODB_Error_Handler

File: /libs/adodb/adodb.inc.php

    line 1018

    function called: _Execute

File: /libs/adodb/adodb-datadict.inc.php

    line 378

    function called: Execute

File: /include/database.php

    line 87

    function called: ExecuteSQLArray

File: /modules/Utils/RecordBrowser/RecordBrowserCommon_0.php

    line 351

    function called: CreateTable

File: /modules/CRM/Roundcube/RoundcubeInstall.php

    line 46

    function called: install_new_recordset

[PHP core called function]

    function called: install

File: /include/module_manager.php

    line 502

    function called: call_user_func

File: /update.php

    line 1645

    function called: install

[PHP core called function]

    function called: update_from_1_0_8b_to_1_0_9

File: /update.php

    line 1802

    function called: call_user_func

File: /index.php

    line 38

    function called: require_once

OK after that I update manual from 1.0.6 to 1.0.7 OK, 1.0.7 to 1.0.8 OK, 1.0.8 to 1.0.8b OK, 1.0.8b to 1.0.9 crash error,
from 1.0.6 to 1.0.9 Crash error same
from 1.0.6 to 1.1.0 Crash white screen

But



1005: Can't create table './crm/rc_accounts_edit_history.frm' (errno: 150)] in

In database this table was created rc_accounts_edit_history
So I get try to update on Windows and on Linux same thing.
InnoDB working (becourse I use on other programs)
So I don't know why this upgrade crash... Good for help...

shacky

Hi,
seems like you have already roundcube installed, but you don't have entry in modules table in that...
You can force it to upgrade by commenting out some code from "modules/CRM/Roundcube/RoundcubeInstall.php" install method...

We will take a look into such upgrades. It would be nice if you give us snapshot of your modules table, so we will know what modules you are using and what can cause this bug...

Paul

defrag

some errors: after then I delete rc_ tables and run update again:



Type: 256

Message: mysqlt error: [1146: Table 'recordbrowser_processing_methods' doesn't exist] in EXECUTE("INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')")

File: libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

[PHP core called function]

    function called: handle_epesi_error(256, "mysqlt error: [1146: Table 'recordbrowser_processing_methods' doesn't exist] in EXECUTE(\"INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')\") ", "libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1146, "Table 'recordbrowser_processing_methods' doesn't exist", "INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')", false, Object (ADODB_mysqlt), "INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')", false, "mysqlt error: [1146: Table 'recordbrowser_processing_methods' doesn't exist] in EXECUTE(\"INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')\") "))

File: libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error("mysqlt error: [1146: Table 'recordbrowser_processing_methods' doesn't exist] in EXECUTE(\"INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')\") ", 256)

File: libs/adodb/adodb.inc.php

    line 1043

    function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1146, "Table 'recordbrowser_processing_methods' doesn't exist", "INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')", false, "Object (ADODB_mysqlt)")

File: libs/adodb/adodb.inc.php

    line 999

    function called: _Execute("INSERT INTO recordbrowser_processing_methods (tab, func) VALUES ('rc_accounts', 'CRM_RoundcubeCommon::submit_account')")

[PHP core called function]

    function called: Execute("INSERT INTO recordbrowser_processing_methods (tab, func) VALUES (?, ?)", Array ("rc_accounts", "CRM_RoundcubeCommon::submit_account"))

File: include/database.php

    line 331

    function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("INSERT INTO recordbrowser_processing_methods (tab, func) VALUES (?, ?)", Array (#2)))

File: data/cache/common.php

    line 5213

    function called: Execute("INSERT INTO recordbrowser_processing_methods (tab, func) VALUES (%s, %s)", Array ("rc_accounts", "CRM_RoundcubeCommon::submit_account"))

File: modules/CRM/Roundcube/RoundcubeInstall.php

    line 50

    function called: register_processing_callback("rc_accounts", Array ("CRM_RoundcubeCommon", "submit_account"))

[PHP core called function]

    function called: install()

File: include/module_manager.php

    line 514

    function called: call_user_func(Array (Object (CRM_RoundcubeInstall), "install"))

File: update.php

    line 1648

    function called: install("CRM_Roundcube")

[PHP core called function]

    function called: update_from_1_0_8b_to_1_0_9()

File: update.php

    line 2016

    function called: call_user_func("update_from_1_0_8b_to_1_0_9")

File: index.php

    line 38

    function called: require_once("update.php")

defrag

[quote="shacky":2vooczv9]Hi,
You can force it to upgrade by commenting out some code from "modules/CRM/Roundcube/RoundcubeInstall.php" install method...
Paul[/quote:2vooczv9]

Hi, Paul

can you say that kind of code I must comment.

shacky

Hi,
We gonna to release 1.1.1 and I fixed update there... You can download newest version from sf svn or pre package is here: http://trial.epesicrm.com/epesi-1.1.1.zip

Official package will be available tomorrow or this monday.

Cheers
Paul

defrag

thanx

defrag

1.1.1 upgrade 100%, but load balance are big. I don't know why. then you go to client, and company, now try to debug.

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge