Problem adding database field

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rfigley
Forum Commoner
Posts: 70
Joined: Sun Apr 21, 2002 7:10 pm

Problem adding database field

Post 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?
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post by tim »

maybe show us the code your working with?
rfigley
Forum Commoner
Posts: 70
Joined: Sun Apr 21, 2002 7:10 pm

Post by rfigley »

SQL-query :

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

MySQL said:


#1166 - Incorrect column name 'name '
sk8erh4x0r
Forum Commoner
Posts: 43
Joined: Wed May 26, 2004 8:27 pm

Post by sk8erh4x0r »

it looks like it's related to a column named "name." Do you have that column in your table?
Post Reply