User warning created when updating
lejon - June 17, 2008 - 15:40
| Project: | Listhandler |
| Version: | 5.x-1.0-beta2 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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?
#1
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.
#2
Hi,
I employed your second solution and it worked. Thanks! I must have installed them at the same time.
#3
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!