Closed (fixed)
Project:
Listhandler
Version:
4.6.x-1.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Oct 2005 at 14:00 UTC
Updated:
14 Dec 2005 at 10:00 UTC
I am getting this error.. dont know why this is coming.. can someone please help??
user error: Unknown column 'prefix' in 'field list'
query: UPDATE mailhandler SET prefix = '' WHERE mid = 3 in /home/dkapoor/public_html/drupal/includes/database.mysql.inc on line 66.
Comments
Comment #1
nshb commentedAll I did was add a new column in the mailhandler table called "prefix" varchar(255) and it worked fine.
My guess is that the listhandler code was working with the CVS version or something of the sort and is using a new feature which isn't released in the mailhandler 4.6.0 :)
Comment #2
killes@www.drop.org commentedhm, did you check the mailhandler.mysql file?
Comment #3
nshb commentedI just checked my mailhandler.mysql file, which has no reference to the PREFIX column. BUT, I did re-check my listhandler.mysql file and for some reason when I imported it in PHPMyAdmin the mailhandler table did not get altered to add the prefix column like so:
ALTER TABLE mailhandler ADD prefix varchar(255) not null DEFAULT '';
That being said, I may have imported the listhandler SQL prior to the mailhandler SQL which would obviously prevent the addition of the column to the non-existant table.
Thanks for the pointer.
Comment #4
(not verified) commented