Failed to upgrade

mediaman

upgrade from 1.2.2 to 1.3 and the install / upgrade failed

copied all the files over and over written all the files

when to the site folder /epesi my data is installed on

got the messgae Updating epesi from version 1.2.2 to 1.3. This operation may take several minutes. Click here to proceed

click processed and recieved a full page of errors instantly:

Type: 256
Message: mysqlt error: [1146: Table 'localans_database2012.rc_multiple_emails_field' doesn't exist] in EXECUTE("UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'")
File: /home/server/public_html/epesi/libs/adodb/adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "mysqlt error: [1146: Table 'server_database2012.rc_multiple_emails_field' doesn't exist] in EXECUTE(\"UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'\") ", "/home/localans/public_html/epesi/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("mysqlt", "EXECUTE", 1146, "Table 'localans_database2012.rc_multiple_emails_field' doesn't exist", "UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'", false, Object (ADODB_mysqlt), "UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'", false, "mysqlt error: [1146: Table 'localans_database2012.rc_multiple_emails_field' doesn't exist] in EXECUTE(\"UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'\") "))

File: /home/server/public_html/epesi/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("mysqlt error: [1146: Table 'server_database2012.rc_multiple_emails_field' doesn't exist] in EXECUTE(\"UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'\") ", 256)

File: /home/server/public_html/epesi/libs/adodb/adodb.inc.php
line 1043
function called: ADODB_Error_Handler("mysqlt", "EXECUTE", 1146, "Table 'server_database2012.rc_multiple_emails_field' doesn't exist", "UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'", false, "Object (ADODB_mysqlt)")

File: /home/server/public_html/epesi/libs/adodb/adodb.inc.php
line 999
function called: _Execute("UPDATE rc_multiple_emails_field SET type='hidden' WHERE field='Record Type' OR field='Record ID'")

[PHP core called function]
function called: Execute("UPDATE rc_multiple_emails_field SET type=? WHERE field=? OR field=?", Array ("hidden", "Record Type", "Record ID"))

File: /home/server/public_html/epesi/include/database.php
line 339
function called: call_user_func_array(Array (Object (ADODB_mysqlt), "Execute"), Array ("UPDATE rc_multiple_emails_field SET type=? WHERE field=? OR field=?", Array (#3)))

File: /home/server/public_html/epesi/modules/Base/patches/RB_permissions2.php
line 120
function called: Execute("UPDATE rc_multiple_emails_field SET type=%s WHERE field=%s OR field=%s", Array ("hidden", "Record Type", "Record ID"))

File: /home/server/public_html/epesi/include/patches.php
line 181
function called: include("/home/server/public_html/epesi/modules/Base/patches/RB_permissions2.php")

File: /home/server/public_html/epesi/include/patches.php
line 29
function called: apply()

File: /home/server/public_html/epesi/update.php
line 2815
function called: apply_new()

[PHP core called function]
function called: update_from_1_2_2_to_1_3()

File: /home/server/public_html/epesi/update.php
line 2849
function called: call_user_func("update_from_1_2_2_to_1_3")

File: /home/server/public_html/epesi/index.php
line 38
function called: require_once("/home/server/public_html/epesi/update.php")

mediaman

close the screen and tried again now i receive the following

Fatal: Class 'Base_AdminModuleCommon' not found in /home/server/public_html/epesi/data/cache/common.php on line 400

mediaman

I have just installed a fresh copy of 1.3 onto the same server in a new folder and with a new database and all working spot on.

could you please help so i dont loose all my contacts and notes etc

mediaman

i have just dropped all the data from this new fresh install and imported via phpmyadmin the old database and refeshed my firefox screen.

i now have the upgrade screen again, why i try the upgrade i get the exact same error above. must be something wrong in the old database.

mediaman

serached the forum and found this post

viewtopic.php?f=3&t=221&p=741&hilit=Type%3A+256+Message%3A+mysqlt+error%3A#p742

and did what it said but it just over writes the data and created a new data folder on the server. So no joy there

ethnar

Hello,

I apologize for the inconvenience of having to deal with this issue during the upgrade, we're hoping we'll be able to resolve this issue quickly for you.

Does your original installation in version 1.2.2 has CRM/Roundcube module installed?

- If it is installed, is it working properly, no errors? It seems that some critical tables are missing.

- If it's not installed - please try to install that module and after that try the upgrade procedure. If it's working, we'll see about to have Roundcube removed afterwards.

Kind regards,
Arek

mediaman

0.1 roundcude was installed

i reinstalled it and this made no difference.

i have however got some errors when looking on the old 1.2.2 version as below.

Seems to be with the sale op modual. I have tried to uninstall this (as we dont use it it was just tested) and it will not uninstall from the admin side.

mediaman

Type: 256
Message: RecordBrowser critical failure, terminating. (Requested s:11:"rc_accounts";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )
File: /home/server/public_html/databaseOLD2012/data/cache/common.php
Line=4951
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "RecordBrowser critical failure, terminating. (Requested s:11:\"rc_accounts\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", "/home/server/public_html/databaseOLD2012/data/cache/common.php", 4951, Array ("rc_accounts", false, true, Array (#4)))

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 4951
function called: trigger_error("RecordBrowser critical failure, terminating. (Requested s:11:\"rc_accounts\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", 256)

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 5018
function called: check_table_name("rc_accounts")

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 5581
function called: init("rc_accounts", false)

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 5871
function called: build_query("rc_accounts", Array ("1"), false)

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 9280
function called: get_records_count("rc_accounts", Array ("1"))

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 8336
function called: get_mailto_link("")

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 8189
function called: display_email(Array (""), null, Array ("email"))

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 8193
function called: QFfield_email(Object (Libs_QuickForm), "email", "Email", "view", "", Array (#11), Object (Utils_RecordBrowser))

[PHP core called function]
function called: QFfield_unique_email("Object (Libs_QuickForm)", "email", "Email", "view", "", Array (#11), Object (Utils_RecordBrowser), Array (Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2)))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1393
function called: call_user_func_array(Array ("CRM_ContactsCommon", "QFfield_unique_email"), Array ("\"Object (Libs_QuickForm)\"", "email", "Email", "view", "", Array (#11), Object (Utils_RecordBrowser), Array (#8)))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1107
function called: prepare_view_entry_details(Array (#22), "view", 15, Object (Libs_QuickForm))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1002
function called: view_entry("view", "15", Array (), true)

[PHP core called function]
function called: view_entry_with_REQUEST("view", "15", Array (), true, Array ())

File: /home/server/public_html/databaseOLD2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "15", Array (#0), true, Array (#0)))

File: /home/server/public_html/databaseOLD2012/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "15", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/server/public_html/databaseOLD2012/modules/Base/Box/Box_0.php
line 144
function called: display_module("Object (Utils_RecordBrowser)", Array ("view", "15", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 209
function called: body()

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 265
function called: go(Object (Base_Box))

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 288
function called: process("__location=1334219319.33", false, true)

File: /home/server/public_html/databaseOLD2012/process.php
line 32
function called: process("__jump_to_RB_table=company&__jump_to_RB_record=15&__jump_to_RB_action=view", false)

mediaman

and this is the error i get when trying to uninstall the sales op modual

Type: 256
Message: RecordBrowser critical failure, terminating. (Requested s:4:"task";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )
File: /home/server/public_html/databaseOLD2012/data/cache/common.php
Line=4951
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "RecordBrowser critical failure, terminating. (Requested s:4:\"task\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", "/home/server/public_html/databaseOLD2012/data/cache/common.php", 4951, Array ("task", false, true, Array (#4), Array (#4), Array (#2)))

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 4951
function called: trigger_error("RecordBrowser critical failure, terminating. (Requested s:4:\"task\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", 256)

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 5018
function called: check_table_name("task")

File: /home/server/public_html/databaseOLD2012/data/cache/common.php
line 5170
function called: init("task")

File: /home/server/public_html/databaseOLD2012/modules/Premium/SalesOpportunity/SalesOpportunityInstall.php
line 97
function called: delete_record_field("task", "Opportunity")

[PHP core called function]
function called: uninstall()

File: /home/server/public_html/databaseOLD2012/include/module_manager.php
line 613
function called: call_user_func(Array (Object (Premium_SalesOpportunityInstall), "uninstall"))

File: /home/server/public_html/databaseOLD2012/modules/Base/Setup/Setup_0.php
line 356
function called: uninstall("Premium_SalesOpportunity")

File: /home/server/public_html/databaseOLD2012/modules/Base/Setup/Setup_0.php
line 262
function called: validate(Array ("1", Array (#74), "Base_Box", "/Base_Box|0/Base_Admin|main_e0c2c5ba75dd84f734ed44e198f762e2/Base_Setup|0"))

[PHP core called function]
function called: tab(true)

File: /home/server/public_html/databaseOLD2012/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 115
function called: call_user_func_array(Array (Object (Base_Setup), "tab"), Array (true))

File: /home/server/public_html/databaseOLD2012/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 81
function called: display_contents(Array (Array (#2), true, false), 0)

[PHP core called function]
function called: body()

File: /home/server/public_html/databaseOLD2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())

File: /home/server/public_html/databaseOLD2012/include/module.php
line 713
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)

File: /home/server/public_html/databaseOLD2012/modules/Base/Setup/Setup_0.php
line 38
function called: display_module("Object (Utils_TabbedBrowser)")

File: /home/server/public_html/databaseOLD2012/modules/Base/Setup/Setup_0.php
line 22
function called: body()

[PHP core called function]
function called: admin()

File: /home/server/public_html/databaseOLD2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Setup), "admin"), Array ())

File: /home/server/public_html/databaseOLD2012/include/module.php
line 713
function called: get_html_of_module(Object (Base_Setup), null, "admin")

File: /home/server/public_html/databaseOLD2012/include/module.php
line 883
function called: display_module("Object (Base_Setup)", null, "admin")

File: /home/server/public_html/databaseOLD2012/modules/Base/Admin/Admin_0.php
line 31
function called: pack_module("Base_Setup", null, "admin")

[PHP core called function]
function called: body()

File: /home/server/public_html/databaseOLD2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Admin), "body"), Array ())

File: /home/server/public_html/databaseOLD2012/include/module.php
line 713
function called: get_html_of_module(Object (Base_Admin), null, null)

File: /home/server/public_html/databaseOLD2012/modules/Base/Box/Box_0.php
line 148
function called: display_module("Object (Base_Admin)")

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 209
function called: body()

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 265
function called: go(Object (Base_Box))

File: /home/server/public_html/databaseOLD2012/process.php
line 32
function called: process("_qf__libs_qf_e3eb573275bc632e3a9632a251cba6b1=&submited=1&installed%5BApplets_Calc%5D=0&installed%5BApplets_Clock%5D=0&installed%5BApplets_Note%5D=0&installed%5BApps_ActivityReport%5D=0&installed%5BBase%5D=0&installed%5BBase_About%5D=0&installed%5BBase_Acl%5D=0&installed%5BBase_ActionBar%5D=0&installed%5BBase_Admin%5D=0&installed%5BBase_Box%5D=0&installed%5BBase_Dashboard%5D=0&installed%5BBase_HomePage%5D=0&installed%5BBase_Lang%5D=0&installed%5BBase_Lang_Administrator%5D=0&installed%5BBase_Mail%5D=0&installed%5BBase_Mail_ContactUs%5D=0&installed%5BBase_MainModuleIndicator%5D=0&installed%5BBase_Menu%5D=0&installed%5BBase_Menu_QuickAccess%5D=0&installed%5BBase_RegionalSettings%5D=0&installed%5BBase_Search%5D=0&installed%5BBase_Setup%5D=0&installed%5BBase_StatusBar%5D=0&installed%5BBase_Theme%5D=0&installed%5BBase_Theme_Administrator%5D=0&installed%5BBase_User%5D=0&installed%5BBase_User_Administrator%5D=0&installed%5BBase_User_Login%5D=0&installed%5BBase_User_Settings%5D=0&installed%5BCRM_Acl%5D=0&installed%5BCRM_Assets%5D=0&installed%5BCRM_Common%5D=0&installed%5BCRM_Contacts%5D=0&installed%5BCRM_Filters%5D=0&installed%5BCRM_Roundcube%5D=0&installed%5BData_Countries%5D=0&installed%5BFirstRun%5D=0&installed%5BLibs_CKEditor%5D=0&installed%5BLibs_Leightbox%5D=0&installed%5BLibs_OpenFlashChart%5D=0&installed%5BLibs_PHPExcel%5D=0&installed%5BLibs_QuickForm%5D=0&installed%5BLibs_ScriptAculoUs%5D=0&installed%5BLibs_TCPDF%5D=0&installed%5BPremium_SalesOpportunity%5D=-1&installed%5BTools_FontSize%5D=0&installed%5BTools_SessionKeeper%5D=0&installed%5BTools_WhoIsOnline%5D=0&installed%5BUtils_Attachment%5D=0&installed%5BUtils_Attachment_Administrator%5D=0&installed%5BUtils_BBCode%5D=0&installed%5BUtils_BookmarkBrowser%5D=0&installed%5BUtils_Calendar%5D=0&installed%5BUtils_Calendar_Event%5D=0&installed%5BUtils_ChainedSelect%5D=0&installed%5BUtils_CommonData%5D=0&installed%5BUtils_CurrencyField%5D=0&installed%5BUtils_FileDownload%5D=0&installed%5BUtils_FileUpload%5D=0&installed%5BUtils_GenericBrowser%5D=0&installed%5BUtils_Image%5D=0&installed%5BUtils_LeightboxPrompt%5D=0&installed%5BUtils_Menu%5D=0&installed%5BUtils_Messenger%5D=0&installed%5BUtils_PopupCalendar%5D=0&installed%5BUtils_RecordBrowser%5D=0&installed%5BUtils_RecordBrowser_RecordPicker%5D=0&installed%5BUtils_RecordBrowser_Reports%5D=0&installed%5BUtils_Shortcut%5D=0&installed%5BUtils_TabbedBrowser%5D=0&installed%5BUtils_Tooltip%5D=0&installed%5BUtils_Tree%5D=0&installed%5BUtils_Watchdog%5D=0&installed%5BUtils_Wizard%5D=0&default_module=Base_Box&__action_module__=%2FBase_Box%7C0%2FBase_Admin%7Cmain_e0c2c5ba75dd84f734ed44e198f762e2%2FBase_Setup%7C0", false)

mediaman

now i have tried to downgrade to 1.2.0

the downgrade when ok but as soon as i tri to click on a customer i get a pop up saying a modual has failed and get a new error

Type: 2
Message: call_user_func_array() expects parameter 1 to be a valid callback, class 'CRM_ContactsCommon' does not have a method 'QFfield_unique_email'
File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
Line=1374
error backtrace:
[PHP core called function]
function called: handle_epesi_error(2, "call_user_func_array() expects parameter 1 to be a valid callback, class 'CRM_ContactsCommon' does not have a method 'QFfield_unique_email'", "/home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php", 1374, Array (#12))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1374
function called: call_user_func_array(Array ("CRM_ContactsCommon", "QFfield_unique_email"), Array (Object (Libs_QuickForm), "email", "Email", "view", "", Array (#11), Object (Utils_RecordBrowser), Array (#9)))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1092
function called: prepare_view_entry_details(Array (#25), "view", "15", Object (Libs_QuickForm))

File: /home/server/public_html/databaseOLD2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 982
function called: view_entry("view", "15", Array (), true)

[PHP core called function]
function called: view_entry_with_REQUEST("view", "15", Array (), true, Array ())

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 209
function called: body()

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 265
function called: go(Object (Base_Box))

File: /home/server/public_html/databaseOLD2012/include/epesi.php
line 288
function called: process("__location=1334227081.16", false, true)

File: /home/server/public_html/databaseOLD2012/process.php
line 32
function called: process("__jump_to_RB_table=company&__jump_to_RB_record=15&__jump_to_RB_action=view", false)

ethnar

Hello,

The installation you post errors from looks severely damaged. It's missing some very basic recordSets and if some of those modules are installed (like tasks, roundcube), they can not function properly on this installation. Are you perfectly sure that the backup of the database was proper and complete? What was exactly happening to this installation before the upgrade to 1.3? Was it upgraded from older versions? Was is moved across the servers, or restored from some other backups earlier?

It's possible and it's not too hard to restore the database to usable shape, but it'll require some knowledge of the system. One must make sure that contents of modules tables is in sync with recordbrowser_table_properties and that certain tables exist and are filled properly. In general, it looks like this:
- In modules there should be entry about CRM_Tasks.
- In recordbrowser_table_properties you should find a row with tab='task', with other values set to required values
- Following tables must exist in the database:
task_callback
task_recent
task_favorite
task_edit_history_data
task_edit_history
task_field
task_data_1
And that should be done for all tables missing from the system (all roundcube tables, etc)
What exactly is missing is another story.

If you have doubts what to fill the table with, you can check out a fresh 1.2.2 install - it will contain the tables and the values needed.

Hope this helps,
Arek

PS There's no downgrade procedures in EPESI - the version check triggers on different versions and launches appropriate method from-to-version, doesn't differentiate between upgrade/downgrade. Using older code for newer database will always result in unexpected problems.

mediaman

yeah was runninmg fine till i did the upgrade now it broken totally.

i did a copy using file mnager on the server to copy the epesi folder so i had backup etc and i have been making more copies and upgrading this folder etc.

also downloaded full sql of the database from phpmyadmin

but fow some reson when i reinstal the running version i get all the saleoportunity errors and this stop me getting into the customers data.

can you send me the link for a fresh 1.2.2 install please as i cant seem to find it on soureforge

mediaman

founf it

http://sourceforge.net/projects/epesi/f ... esi/1.2.2/

mediaman

reinstated the 1.2.2 version from backup and the database from the backup.

this is showing a sale opportunity error when clicking a customer.

Type: 256
Message: RecordBrowser critical failure, terminating. (Requested s:11:"rc_accounts";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )
File: /home/server/public_html/databaseold2012/data/cache/common.php
Line=4951
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "RecordBrowser critical failure, terminating. (Requested s:11:\"rc_accounts\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", "/home/server/public_html/databaseold2012/data/cache/common.php", 4951, Array ("rc_accounts", false, true, Array (#4)))

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 4951
function called: trigger_error("RecordBrowser critical failure, terminating. (Requested s:11:\"rc_accounts\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", 256)

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 5018
function called: check_table_name("rc_accounts")

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 5581
function called: init("rc_accounts", false)

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 5871
function called: build_query("rc_accounts", Array ("1"), false)

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 9280
function called: get_records_count("rc_accounts", Array ("1"))

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 8336
function called: get_mailto_link("SALES@HWSUPPLIES.CO.UK")

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 8189
function called: display_email(Array ("SALES@HWSUPPLIES.CO.UK"), null, Array ("email"))

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 8193
function called: QFfield_email(Object (Libs_QuickForm), "email", "Email", "view", "SALES@HWSUPPLIES.CO.UK", Array (#11), Object (Utils_RecordBrowser))

[PHP core called function]
function called: QFfield_unique_email("Object (Libs_QuickForm)", "email", "Email", "view", "SALES@HWSUPPLIES.CO.UK", Array (#11), Object (Utils_RecordBrowser), Array (Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2), Array (#2)))

File: /home/server/public_html/databaseold2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1393
function called: call_user_func_array(Array ("CRM_ContactsCommon", "QFfield_unique_email"), Array ("\"Object (Libs_QuickForm)\"", "email", "Email", "view", "SALES@HWSUPPLIES.CO.UK", Array (#11), Object (Utils_RecordBrowser), Array (#8)))

File: /home/server/public_html/databaseold2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1107
function called: prepare_view_entry_details(Array (#22), "view", 1017, Object (Libs_QuickForm))

File: /home/server/public_html/databaseold2012/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1002
function called: view_entry("view", "1017", Array (), true)

[PHP core called function]
function called: view_entry_with_REQUEST("view", "1017", Array (), true, Array ())

File: /home/server/public_html/databaseold2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "1017", Array (#0), true, Array (#0)))

File: /home/server/public_html/databaseold2012/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "1017", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/server/public_html/databaseold2012/modules/Base/Box/Box_0.php
line 144
function called: display_module("Object (Utils_RecordBrowser)", Array ("view", "1017", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/server/public_html/databaseold2012/include/epesi.php
line 209
function called: body()

File: /home/server/public_html/databaseold2012/include/epesi.php
line 265
function called: go(Object (Base_Box))

File: /home/server/public_html/databaseold2012/include/epesi.php
line 288
function called: process("__location=1334230320.39", false, true)

File: /home/server/public_html/databaseold2012/process.php
line 32
function called: process("__jump_to_RB_table=company&__jump_to_RB_record=1017&__jump_to_RB_action=view", false)

think need to fix this issue first before the upgrade will work.

attached is all the modual installed

mediaman

sale opportunity could be removed and uninstalled as we dont use it.

but when i chose not installed and press save i get the following error
Type: 256
Message: RecordBrowser critical failure, terminating. (Requested s:4:"task";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )
File: /home/server/public_html/databaseold2012/data/cache/common.php
Line=4951
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "RecordBrowser critical failure, terminating. (Requested s:4:\"task\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", "/home/server/public_html/databaseold2012/data/cache/common.php", 4951, Array ("task", false, true, Array (#4), Array (#4), Array (#2)))

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 4951
function called: trigger_error("RecordBrowser critical failure, terminating. (Requested s:4:\"task\";, available Array ( [company] => 1 [contact] => 1 [crm_assets] => 1 [premium_salesopportunity] => 1 ) )", 256)

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 5018
function called: check_table_name("task")

File: /home/server/public_html/databaseold2012/data/cache/common.php
line 5170
function called: init("task")

File: /home/server/public_html/databaseold2012/modules/Premium/SalesOpportunity/SalesOpportunityInstall.php
line 97
function called: delete_record_field("task", "Opportunity")

[PHP core called function]
function called: uninstall()

File: /home/server/public_html/databaseold2012/include/module_manager.php
line 613
function called: call_user_func(Array (Object (Premium_SalesOpportunityInstall), "uninstall"))

File: /home/server/public_html/databaseold2012/modules/Base/Setup/Setup_0.php
line 356
function called: uninstall("Premium_SalesOpportunity")

File: /home/server/public_html/databaseold2012/modules/Base/Setup/Setup_0.php
line 262
function called: validate(Array ("1", Array (#14), "/Base_Box|0/Base_Admin|main_7ad8bca1b5e56a68beb9528c55db2dc6/Base_Setup|0"))

[PHP core called function]
function called: tab(true)

File: /home/server/public_html/databaseold2012/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 115
function called: call_user_func_array(Array (Object (Base_Setup), "tab"), Array (true))

File: /home/server/public_html/databaseold2012/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 81
function called: display_contents(Array (Array (#2), true, false), 0)

[PHP core called function]
function called: body()

File: /home/server/public_html/databaseold2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())

File: /home/server/public_html/databaseold2012/include/module.php
line 713
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)

File: /home/server/public_html/databaseold2012/modules/Base/Setup/Setup_0.php
line 38
function called: display_module("Object (Utils_TabbedBrowser)")

File: /home/server/public_html/databaseold2012/modules/Base/Setup/Setup_0.php
line 22
function called: body()

[PHP core called function]
function called: admin()

File: /home/server/public_html/databaseold2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Setup), "admin"), Array ())

File: /home/server/public_html/databaseold2012/include/module.php
line 713
function called: get_html_of_module(Object (Base_Setup), null, "admin")

File: /home/server/public_html/databaseold2012/include/module.php
line 883
function called: display_module("Object (Base_Setup)", null, "admin")

File: /home/server/public_html/databaseold2012/modules/Base/Admin/Admin_0.php
line 31
function called: pack_module("Base_Setup", null, "admin")

[PHP core called function]
function called: body()

File: /home/server/public_html/databaseold2012/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Admin), "body"), Array ())

File: /home/server/public_html/databaseold2012/include/module.php
line 713
function called: get_html_of_module(Object (Base_Admin), null, null)

File: /home/server/public_html/databaseold2012/modules/Base/Box/Box_0.php
line 148
function called: display_module("Object (Base_Admin)")

File: /home/server/public_html/databaseold2012/include/epesi.php
line 209
function called: body()

File: /home/server/public_html/databaseold2012/include/epesi.php
line 265
function called: go(Object (Base_Box))

File: /home/server/public_html/databaseold2012/process.php
line 32
function called: process("_qf__libs_qf_6f78820d7223ed49c72c701b275a92e4=&submited=1&installed%5BApplets_Calc%5D=0&installed%5BApplets_Clock%5D=0&installed%5BApplets_Note%5D=0&installed%5BApps_ActivityReport%5D=0&installed%5BBase%5D=0&installed%5BCRM_Assets%5D=0&installed%5BCRM_Contacts%5D=0&installed%5BCRM_Filters%5D=0&installed%5BCRM_Roundcube%5D=0&installed%5BPremium_SalesOpportunity%5D=-1&installed%5BTools_FontSize%5D=0&installed%5BTools_SessionKeeper%5D=0&installed%5BTools_WhoIsOnline%5D=0&installed%5BUtils_Attachment_Administrator%5D=0&__action_module__=%2FBase_Box%7C0%2FBase_Admin%7Cmain_7ad8bca1b5e56a68beb9528c55db2dc6%2FBase_Setup%7C0", false)

jasiek

Hi,
I noticed that in every error it shows something like this:
File: /home/server/public_html/databaseold2012/data/cache/common.php
This indicates, that you have Common Cache on. Please edit config.php located in data directory and change the following:

/*

 * Turn on common cache.

 */

define('CACHE_COMMON_FILES',1);

/*

 * Turn on common cache.

 */

define('CACHE_COMMON_FILES',0);

and see what errors it generates. Keep Common Cache OFF (0) for now.

ethnar

In my last post I've put some instructions how to check integrity of the database. I see that Roundcube is installed, yet from the error messages it's clear there are no tables that Roundcube operates on.

Installing a fresh 1.2.2 and comparing the tables to the tables in your backup is the way to go right now. As I said before, the installation seems to be heavily damaged and there's no easy route to restore it to proper condition.

Kind regards,
Arek

mediaman

is there a way that if i get a 1.3 version runnign fully on the server as new i could import the contacts, companies, notes etc into from my old databse??

my users would also be a plus

ethnar

Moving the data from old installation will be pretty much the same amount of work as the recovery using method I suggested.

It's possible that installing fresh 1.3 and then writing your backup on top of that installation would allow you to move on with the upgrade. You'd have to drop and recreate all tables that were present in the backup, leaving all other tables intact. You'd also have to copy the contents of /data folder from your backup to that installation. But I can't give you a guarantee it'll get you anywhere, there's just too many variables to assume it's going to work.

It'd be also much better to find out what was the reason for damaging the database in the way you experience, to make sure it won't happen again in the future.

Kind regards,
Arek

mediaman

right well here is another error....

i have now restored the database and files back to a server backup from the 4th of this month.

uploaded all the files, restore database etc.

now i can get on sign in and see customers etc note etc etc but i have loading box in the middle of the screen all the time and in the top left an epesi logo squared flashing like its loading.....

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

Help Me! | Download from SourceForge