Current time: 12-23-2024, 04:45 AM Hello There, Guest! (LoginRegister)


Post Reply 
[solved] Upgrade 1.0.5 -> 1.0.7 Column already exists: 1060
Author Message
Elber Offline
Junior Member
*

Posts: 51
Joined: Oct 2009
Reputation: 0
Post: #1
[solved] Upgrade 1.0.5 -> 1.0.7 Column already exists: 1060
HI, it's my error:

Quote: Starting ispCP update
* Stopping services: ............ [ Done ]

ispCP main configuration file
* Loading old ispCP configuration file: [ Done ]
* Update ispCP configuration file: [ Done ]
* Check ispCP configuration file: [ Done ]

Pre-installation tasks for Debian
* Postgrey configuration (Updating listening port): [ Done ]

ispCP database
* Update ispCP database schema: [ Failed ]

[FATAL] An error occurred during update process!
Correct it and re-run this program.

Log files are stored in /var/log/ispcp/setup
You can also find help at http://isp-control.net/forum

/var/log/ispcp/setup/ispcp-update.log
Quote:getCmdExitValue() | Starting...
getCmdExitValue() | [DEBUG] External command exited with value 0
getCmdExitValue() | Ending...
sys_command('/bin/bash preinst upgrade') | Ending...
preinst() | Ending...
update_database_schema() | Starting...
get_file() | Starting...
get_file() | Ending...
sys_command_rs() | Starting...
system() | [DEBUG]
[ERROR]: Database update 40 failed:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'subdomain_url_forward'
Query: ALTER IGNORE TABLE
`subdomain`
ADD
`subdomain_url_forward` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
AFTER
`subdomain_mount`;

sys_command_rs() | Ending...
getCmdExitValue() | Starting...
getCmdExitValue() | [DEBUG] External command exited with value 1
getCmdExitValue() | Ending...
exit_msg() | Starting...
exit_msg() | Ending...
del_file() | Starting...
del_file() | Ending...

Please tell my how to fix my problem ??
OK. I remove column subdomain_url_forward and subdomain_alias_url_forward and work Smile But this error is very interesting
(This post was last modified: 01-05-2011 09:00 AM by Elber.)
01-05-2011 07:51 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)