Page 1 of 1

Problem adding database field

Posted: Sat Jul 24, 2004 1:58 pm
by rfigley
I've been attempting to add a field to my database and keep getting and 1166 error-:

MySQL said:
#1166 - Incorrect column name 'name '

I've added fields many times and never had a problem like this. I even tried duplicating the parameters form another field similar to this one, but same problem.

Any ideas?

Posted: Sat Jul 24, 2004 4:53 pm
by tim
maybe show us the code your working with?

Posted: Sat Jul 24, 2004 7:36 pm
by rfigley
SQL-query :

ALTER TABLE `tbl_members` ADD `comments` VARCHAR( 100 ) NOT NULL AFTER `member_since`

MySQL said:


#1166 - Incorrect column name 'name '

Posted: Thu Aug 12, 2004 10:40 pm
by sk8erh4x0r
it looks like it's related to a column named "name." Do you have that column in your table?