Forums / Install & configuration / Upgrade from 3.4.1 to 3.4.2 problem !

Upgrade from 3.4.1 to 3.4.2 problem !

Author Message

Mieczyslaw Morzonek

Sunday 26 September 2004 1:04:45 am

I`ve upgrade files and database and when i click check files i ve go message " File consistency check OK" but problem is when i click chech database i ve got message like this

Warning, your database is not consistent with the distribution database.
To revert your database to distribution setup, run the following SQL queries:

ALTER TABLE ezurl_object_link DROP INDEX PRIMARY;

What does it mean?
Can i ignore this warning?

Frederik Holljen

Sunday 26 September 2004 11:51:00 pm

This means that the primary key index in the table ezurl_object_link is not present in the main distribution while it is in your installation. You can run the given SQL sentence on you sql database to make the problem go away. This is a small issue and you can also safely ignore it.

Mieczyslaw Morzonek

Monday 27 September 2004 10:23:10 am

When i execute this query " ALTER TABLE ezurl_object_link DROP INDEX PRIMARY " MySQL told me that "#1064 - Something is wrong in your syntax near 'PRIMARY' in line 1 "

What`s wrong with SQL syntax? This is a bug? What i must to do?

Jan Borsodi

Tuesday 28 September 2004 4:33:10 am

I believe it is a small bug in the db consistency checker, the generated SQL is not valid.
The correct SQL is:

ALTER TABLE ezurl_object_link DROP PRIMARY KEY;

But if this is the case did you remember to update the database with the file:

update/database/mysql/3.4/dbupdate-3.4.1-to-3.4.2.sql

This file contains the SQL code above.

--
Amos

Documentation: http://ez.no/ez_publish/documentation
FAQ: http://ez.no/ez_publish/documentation/faq

Derick Rethans

Tuesday 05 October 2004 1:06:54 am

This problem with the DB Consistency Checker is now fixed for 3.4.3 (rev. 8446) and 3.5.0beta (rev. 8445).