2 replies to this topic

[bouncdchk]

I'm hoping someone can assist me in this one

I installed the Credit Class v5.03 and am having check out problems.

First it told me: Unknown column 'Order_Status_Id' - found the fix for that.

Now I'm getting :

1054 - Unknown column 'comments' in 'field list'

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('3', '', now(), '1', '')

[TEP STOP]

I presume I have to insert 'comments' into the table - however, what would the attributes be?

Also - for you sql peeps - the values at the end of the error -values ('3', '', now(), '1', '') - does this information tell me how the field should be set up?

And yes, I'm not very good with sql.

[iiinetworks]

Quote

insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('3', '', now(), '1', '')

Also - for you sql peeps - the values at the end of the error -values ('3', '', now(), '1', '') - does this information tell me how the field should be set up?

No, the final '' tells you that comments can take empty values. The other values are for the other fields (orders_id, etc.).

In my db, comments is of type text. You should be able to let everything else default when you create it.

Good luck,
Matt

[bouncdchk]

Awesome, that seems to have fixed the problem. Thanks!!