Forums / Install & configuration / Upgrade from 3.4.1 to 3.4.2 problem !
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.
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).