3 replies to this topic

[zeroradius]

I have a table called medications. One of the fields in this table is instructions. when I run an insert I get this:

Quote

Unknown column 'instructions' in 'field list'

After looking into it this is apparently a problem that occurs when MySQL is upgraded improperly. After checking google I find that running the following should fix it:

ALTER TABLE `medications` ADD `instructions` longtext NOT NULL DEFAULT ''

needless to say it did not. I run on shared hosting so i can't re-install. Any sugestions?

Thanks,
~ZeroRadius

[Alexander]

Hello ZeroRadius, can you show us an example (if not paraphrased to the same syntax) your INSERT query that fails?

Usually such an issue would relate to incorrect quoting, reserved words, malformed strings. Maybe it is as simple as that.

Have you or your host tried to restart the MySQL server to clear any caching that may be an issue?

[zeroradius]

:lol: I made a stupid mistake (this is why you don't code tired) I copied the controller sense it was basically the same as another controller i had just made and forgot to change the value of $table which tells it what table to insert into. I din't check the query out put because it is built via a method and i had just used it and it worked. Next time i know to take all the steps even if i "know" it couldn't be the problem. Thanks Alexander.

[Alexander]

Glad you could get it to work in the end. :)

Alexander.