Cannot update Database error

[TSG]

Hello

I try to update from 1.0.2 to 1.0.3 but i get an Error
Here is the output:

Welcome to ispCP '1.0.3 OMEGA' Update Dialog.

This program will update your current ispCP OMEGA installation on this
server.
Please make sure you did a backup of all your server data.

NOTE: During the migration process some or all services might require to
be shut down.

WARNING: Only services that are not marked with 'NO' in your ispcp.conf
configuration file will be processed by this program.

Do you want to continue [Y/n]: y

NOTICE: Make sure you have read and performed all steps from
docs/distro/INSTALL document (where distro is your linux distribution).

Do you want to continue [Y/n/?]: y

Stopping Services:......... [done]

ispCP main configuration file
Loading old ispCP configuration file: [done]
Update ispCP configuration file: [done]

ispCP database
Update ispCP database schema: [failed]


FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

Here is the debug of the database:
ispCP database
Update ispCP database schema:DEBUG: push_el() sub_name: update_database_schema(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Starting...
DEBUG: push_el() sub_name: get_file(), msg: Ending...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Starting...
DEBUG: push_el() sub_name: sys_command_rs(), msg: Ending...
DEBUG: push_el() sub_name: exit_msg(), msg: Starting...
[failed]


FATAL: An error was occured during update process!
Correct it and re-run this program.

You can find help at http://isp-control.net/forum

How to fix this ?

Greetings TSG

[Nuxwin]

Hello ;


Please, provide us the content of the log files in your /tmp directory.

Cheers ;

If you want, I can help you directly. My skype account ---> nuxwin

if not, you can go to our irc channel ---> irc.freenode.net - #ispcp

[Nuxwin]

Ok Fixed !

The problems were:

1. You've changed the SQL root password manually without updates the file ispcp.conf with the new password encrypted using the ispCP DB key.

2. Your database is in an inconsistent state, it lacked the table 'subdomain_alias'. I created manually.

3. The script updDB.php failed to update 19 because some changes provided by it had already been applied on the base. I corrected manually.

Normally, all should work fine now.

Please, if you have not installed 1.0.3-1, install it now and also, follow this procedure after: http://www.isp-control.net/forum/thread-...tpost.html

Note: During the maintenance, I've changed the root sql password. So, read my PM to get the new.

Note: Sorry for my poor english

Cheers ;

[TSG]

Thank you very very much