By albertc on

Hi

I am trying to upgrade my existing Drupal 5.x site to Drupal 6.1, and this is what I get:

* user warning: Table 'MYSITE_drpl1.flood' doesn't exist query: ALTER TABLE flood ADD fid int NOT NULL AUTO_INCREMENT PRIMARY KEY in /home/MYSITE/public_html/drupal-6.1/modules/system/system.install on line 1438.
    * user warning: Can't DROP 'link'; check that column/key exists query: ALTER TABLE aggregator_feed DROP KEY link in /home/MYSITE/public_html/drupal-6.1/includes/database.mysql-common.inc on line 417.
    * user warning: BLOB/TEXT column 'url' used in key specification without a key length query: ALTER TABLE aggregator_feed ADD UNIQUE KEY url (url) in /home/MYSITE/public_html/drupal-6.1/includes/database.mysql-common.inc on line 403.
    * user warning: Table 'MYSITE_drpl1.flood' doesn't exist query: ALTER TABLE flood ADD INDEX allow (event, hostname, timestamp) in /home/MYSITE/public_html/drupal-6.1/includes/database.mysql-common.inc on line 434.
    * user warning: Duplicate entry '1-0' for key 1 query: ALTER TABLE locales_target ADD PRIMARY KEY (language, lid, plural) in /home/MYSITE/public_html/drupal-6.1/includes/database.mysql-common.inc on line 374.

Now I can't login to the site as administrator. I can't even display the site unless I change the settings.php to:

$update_free_access = FALSE;

Any suggestions for getting the site back online?

Thanlks in advance
--
Albert

⋅ Categories: Drupal 6.x

Comments

bwynants’s picture

bwynants commented

similar errros

	•	user warning: Can't DROP 'link'; check that column/key exists query: update_sql /* Anoniem : update_sql */ ALTER TABLE aggregator_feed DROP KEY link in drupal/includes/database.mysql-common.inc on line 417.
	•	user warning: Duplicate key name 'url' query: update_sql /* Anoniem : update_sql */ ALTER TABLE aggregator_feed ADD UNIQUE KEY url (url) in drupal/includes/database.mysql-common.inc on line 403.
	•	user warning: Can't DROP 'lid'; check that column/key exists query: update_sql /* Anoniem : update_sql */ ALTER TABLE comments DROP INDEX lid in drupal/includes/database.mysql-common.inc on line 448.
	•	user warning: Duplicate key name 'nid' query: update_sql /* Anoniem : update_sql */ ALTER TABLE comments ADD INDEX nid (nid) in drupal/includes/database.mysql-common.inc on line 434.
	•	user warning: Can't DROP 'node_title_type'; check that column/key exists query: update_sql /* Anoniem : update_sql */ ALTER TABLE node DROP INDEX node_title_type in drupal/includes/database.mysql-common.inc on line 448.
	•	user warning: Can't DROP 'tid'; check that column/key exists query: update_sql /* Anoniem : update_sql */ ALTER TABLE term_node DROP INDEX tid in drupal/includes/database.mysql-common.inc on line 448.

no visible problems however so I ignore the warnings?