Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
rfigley
Forum Commoner
Posts: 70 Joined: Sun Apr 21, 2002 7:10 pm
Post
by rfigley » Sat Jul 24, 2004 1:58 pm
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?
tim
DevNet Resident
Posts: 1165 Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio
Post
by tim » Sat Jul 24, 2004 4:53 pm
maybe show us the code your working with?
rfigley
Forum Commoner
Posts: 70 Joined: Sun Apr 21, 2002 7:10 pm
Post
by rfigley » Sat Jul 24, 2004 7:36 pm
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 » Thu Aug 12, 2004 10:40 pm
it looks like it's related to a column named "name." Do you have that column in your table?