FrontAccounting forum — SQL script execution failed in line 4: Table 'frontaccount23.crm_users

Re: SQL script execution failed in line 4: Table 'frontaccount23.crm_users

null@example.com (itronics) — Fri, 10 Sep 2010 21:23:48 +0000

You can change `0_crm_users` to `0_users` in line 4 of /sql/alter2.3rc.sql file and retry upgrade.
Janusz

Re: SQL script execution failed in line 4: Table 'frontaccount23.crm_users

null@example.com (khanhtoan) — Fri, 10 Sep 2010 02:12:33 +0000

Dear Janusz,
I ignored the message as you said but it all doesn 't work normally. the message on all pages:
"System is blocked after source upgrade until database is updated on System/Software Upgrade page"
What should I do next?

Re: SQL script execution failed in line 4: Table 'frontaccount23.crm_users

null@example.com (itronics) — Thu, 09 Sep 2010 19:47:55 +0000

There is a small bug in upgrade script alter2.3rc.sql. You can safely ignore the message, and anyway all should work.
Janusz

SQL script execution failed in line 4: Table 'frontaccount23.crm_users

null@example.com (khanhtoan) — Thu, 09 Sep 2010 10:44:32 +0000

I got this message while upgrading:
"SQL script execution failed in line 4: Table 'mydatabase.crm_users' doesn't existDatabase upgrade to version 2.3 failed for company 'My company.'.
You should restore company database from latest backup file"

Then I try force upgrade and the result is:
"SQL script execution failed in line 54: Table 'mydatabase.company' doesn't existDatabase upgrade to version 2.3 failed for company 'My Company.'.
You should restore company database from latest backup file"

I upgrade from 2.3 beta to 2.3 RC1,
Please help,

Thanks,