By Riccardo83 on

I got this error updating the spam module...

spam module
Update #5304

* ALTER TABLE {spam_log} ADD KEY (message);

Update #5305

* ALTER TABLE {spam_filters_errors} ADD uid INT(11) UNSIGNED NOT NULL DEFAULT '0'
* ALTER TABLE {spam_filters_errors} ADD form TEXT NOT NULL
* Failed: ALTER TABLE {spam_filters_errors} DROP KEY content_id_content_type
* ALTER TABLE {spam_filters_errors} ADD KEY id_type (content_id,content_type)

what do i do?

⋅ Categories: Drupal 5.x

Comments

US421’s picture

US421 commented

Do you have PHPMyAdmin? Select the database you are using. The second icon in the Action column is for the structure of each table. When you click on the icon next to the table you want to work on, there will be a page where you can add fields and keys.

Be sure to make a backup first, and then you can make changes without fear, if you mess something up, you can just reload the backup. Even better, load the backup into a new database and play there first without harming your site at all.

Riccardo83’s picture

Riccardo83 commented

Thank you for ur answer, but what exactly is the change that needs to be done? sorry im a newb, i have phpmyadmin...

Check out my blog
http://blog.riccardo-ulpts.com