I get this error when saving configurations:

user warning: Unknown column 'prefix' in 'field list' query: UPDATE mailhandler SET prefix = '' WHERE mid = 1 in /usr/local/apache2/htdocs/main/includes/database.mysql.inc on line 172.

However, listhandler seems to be working otherwise.

Any ideas?

Comments

philipnet’s picture

philipnet commented
Status: Active » Postponed (maintainer needs more info)

How did you upgrade your site or set it up in the first place?

Unfortunately Listhandler for Drupal 5.x requires that Mailhandler be enabled before Listhandler. And because modules are enabled alphabetically, if you enable them at the same time Mailhandler will be enabled after Listhandler.

You can do one of two things:
1. Disable Listhandler
2. Uninstall Listhandler
3. Enable Listhanlder
(however you will loose you Listhandler settings)

Or:
1. Launch phpMyAdmin and connect to your Drupal database
2. Modify the Mailhandler table:
3. Add a column a column called "prefix" of type varchar, 255 characters in length, it should be "not null" and the default is "" (i.e. an empty string).

Regards.

P.

lejon’s picture

lejon commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Hi,

I employed your second solution and it worked. Thanks! I must have installed them at the same time.

highermath’s picture

highermath commented

Could you please put a note to the effect that Mailhandler must be fully installed before installing Listhandler, etc. on the project page? This is not obvious to most users and can cause a lot of grief.

Thanks!