Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Unknown column error

Quote Reply
Unknown column error
I am attempting to configure DB SQL.

The program was installed by Gossamer-Threads.

I have modified the db.cfg file to add the fields I will need for the database.

However, when I try to add a record, I receive an "unknown column" error on the first field that contains data. The full text of the message is below.

>>"There were problems with the following fields: Unknown column 'Name_1' in 'field list' "<<

The URL for the database is:
www.sacomaine.org/cgi-bin/db.cgi. You can login using the admin/admin combination.
Any ideas are welcomed.

Thanks,
John

Quote Reply
Re: Unknown column error In reply to
Did you also add the new field in the table in MySQL? If not, then that is what is causing the error message.

Regards,

Eliot Lee
Quote Reply
Re: Unknown column error In reply to
Thank you Eliot!

Now, the next question: is there a simple way to add the fields I need to the MySQL table? Or do I have to edit this table by hand?

John

Quote Reply
Re: Unknown column error In reply to
You can use MySQL commands via your shell telnet account. (Refer to http://www.mysql.com for Alter commands).

OR you could use MySQLMan, which is a Gossamer Thread product that is a web emulerator for MySQL (similar to MySQLPhpAdmin).

OR you could re-set up your script with the new field.

The best solution...option 2....

Good luck!

Regards,

Eliot Lee