Hello. Second time I upgrade my pandora server's to v.2 in both cases I receive similar error's with database upgrading like - ERROR 1091 (42000) at line 8: Can't DROP 'agent_type'; check that column/key exists can you help me? thank's!
Upgrade from v 1.3.1
yduma · 30 oct 2008, 11:16 · 15 mensajes · 59 visitas
- Inicio del debate
Are you using the upgrade tool?
yes. I put migrate sql script and upgrade.php. When I run http://..../upgrade.php I get error. After I try do next - mysql -u root -p pandora2 (I change name of pandora2 - copy of pandora db) < pandora_migrate_2.0.sql and get error - ERROR 1091 (42000) at line 8: Can't DROP 'agent_type'; check that column/key exists
What version are you migrating from ?, the migration script is only for 1.3.1 version. How do you make a copy of pandora db ?, using a full mysqldump ? (this is a good idea). If you're unsure about version, please put here dump for these SQL commands: describe tagente; select * from tconfig;
I run migrate sql script for 1.3 to 1.3.1 after run migrate script for 1.3.1 to 2.0 and get error at line 33.
Ask nil's question. But it works for us, I have to say
Very odd.... Open a window with pandora_migrate_2.0.sql. open another window with a mysql command line and enter line to line, the sql code from pandora_migrate_2.0.sql. Should work fine (i've tested in a lot of systems), if fail, say exactly what line and put it here.
Running this script I receive ERROR 1072 (42000) at line 33: Key column 'disabled' doesn't exist in table Same error when I was doing that line by line.
Do somebody will read this discussions from administrators?
Yes, we are busy, but trying to identify the error
Hi. I think it is big problem when pandora user's can't upgrade it?!!! I really need this. THANKS!!!!!
It's just you who can't
Please, put here the results of mysqldump --nodata -u root -p pandora And we try to solve the migration problem.
In atachement.
I move database manually and get next: 1) pandora don't see my modules. 2) If I create new module host alive - and after delete it, it start check my old module.
Entra en tu cuenta para publicar.
