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

nshb’s picture

All 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 :)

killes@www.drop.org’s picture

hm, did you check the mailhandler.mysql file?

nshb’s picture

Status: Active » Fixed

I 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.

Anonymous’s picture

Status: Fixed » Closed (fixed)