1.0.5 -> 1.0.7 - Base table or view not found

[hjarne]

So i tried to update my instalation from 1.0.5 to 1.0.7 (on a debian lenny) and i get some errors.

First of all i got the error with the MySQL password wich is explained and solved here:
http://isp-control.net/forum/thread-10465-page-2.html

Then it made an [FAILED] when trying to update the databse schema. I looked at the install log and it looks like this:

Quote:Stopping ispCP Network Traffic Logger: ispcp_network failed!
Stopping ispCP GUI-Backend communication Daemon: ispcp_daemon.
Stopping domain name service...: bind9.
Stopping ftp server: proftpd.
Stopping Postfix Mail Transport Agent: postfix.
Stopping Courier authentication services: authdaemond.
Stopping Courier POP3 server: pop3d.
Stopping Courier IMAP server: imapd.

[ERROR]: Database update 33 failed:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.config' doesn't exist
Query: DELETE IGNORE FROM
`ispcp`.`config`
WHERE
`config`.`name` = 'CRITICAL_UPDATE_REVISION'
;

After that i thourght "FUCK!" and restarted the server, it went up as normal, all services running and everything looks fine !BUT! when i login as admin on the web-UI (wich is the only user who can login) it tells me to update my database, i click the link and get this in return:

Quote:Database update 33 failed:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.config' doesn't exist

Query: DELETE IGNORE FROM `ispcp`.`config` WHERE `config`.`name` = 'CRITICAL_UPDATE_REVISION' ;

No usersers are able to login through the web-UI, but all services are working and running. I recieve mails and are able to send mails aswell. All the websites are online, but the admin panel is fucked for everyone els but the admin user.

Can anyone help me?


Hjarne

[sci2tech]

Manually remove from table config if exists record CRITICAL_UPDATE_REVISION, then set DATABASE_REVISION to 33.

[hjarne]

Now i get a:

Quote:Database update 33 failed:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'ip_card'

Query: ALTER IGNORE TABLE `server_ips` ADD `ip_card` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL, ADD `ip_ssl_domain_id` INT( 10 ) NULL, ADD `ip_status` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ;

So basicly what you are telling me is that i need to update the database manually all the way?

Hjarne

[sci2tech]

Yes. It seems that your database is really messed up. many updates where already applied, but version was not set. Do not ask why, because i can not tell you

[jarek]

(10-05-2010 05:22 AM)sci2tech Wrote:  Yes. It seems that your database is really messed up. many updates where already applied, but version was not set. Do not ask why, because i can not tell you

Hi,
I have the same problem with updating from version 1.0.3 to 1.0.7. How do I fix this?
Maybe there is a possibility of returning to version 1.0.3?

[lau.bi]

Hello and sorry for my bad english :-)

i have found a soluition for the "Database 33 Update Problem"

I have the same problem by updating from

1.0.5.
1.0.6.

to 1.0.7 rc1 or final

I think, the reason for the Problem ist thas my ispcp databse not have the default name.
my database was named to: "laubi_ispcp"

The Sollution for me was, dump my database, restore back to default name (ispcp)
change the /etc/ispcp/ispcp.conf and /etc/ispcp/ispcp.old.conf

and restart the update process :-)

Greetings
Laubi

[jarek]

(06-01-2011 11:15 PM)lau.bi Wrote:  Hello and sorry for my bad english :-)

i have found a soluition for the "Database 33 Update Problem"

I have the same problem by updating from

1.0.5.
1.0.6.

to 1.0.7 rc1 or final

I think, the reason for the Problem ist thas my ispcp databse not have the default name.
my database was named to: "laubi_ispcp"

The Sollution for me was, dump my database, restore back to default name (ispcp)
change the /etc/ispcp/ispcp.conf and /etc/ispcp/ispcp.old.conf

and restart the update process :-)

Greetings
Laubi

Thank you for your help
Your solution works!

Jarek.