Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Urgent Help Required


Guest

Recommended Posts

Im getting this error in a couple of places

 

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

 

insert into orders_status_history (orders_id, new_value, date_added, customer_notified) values ('55', '1', now(), '1')

 

[TEP STOP]

 

The first one is in the admin > orders page and the other is when i use a third party test transaction such as 2checkout when i return to oscommerce from there site.

 

Please help, i need the store to be open next week.

 

Thanks in advance.

 

pr

Link to comment
Share on other sites

I had a similar problem and the only way I fixed it was to start over with a new installion and I carefully merged the database data. I dont get it anymore , but what it ws that a value was conflicting.

 

Good luck

Link to comment
Share on other sites

Im afraid its far too late for that......

 

 

Im sure its something to do with the Gift Voucher system but im not really a database wiz so its something i need to get help on.

 

Thanks for the reply

 

PR

Link to comment
Share on other sites

You just need to add a colum to the table.

 

Do you have phpmyadmin? It normally comes estandard with cpanel.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Yes i have phpmyadmin and use it quite frequently.

 

Not sure what parameters to set and in what table. This one is confusing.

 

Thanks for the reply

 

PR

Link to comment
Share on other sites

Well, in the 'orders_status_history ' table, you need to inser a column named 'new_value' right after the 'orders_id' column. You should make it a char 3, and it should not allow nulls.

 

Hope that helps.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Thanks for the reply wizard,

 

i created the new column in the database and it worked but then i got the same error but with 'old value', so i just did the same and added that.

 

It seems to work fine now.

 

Thanks for the reply, its really appreciated.

 

Regards

 

PR

Link to comment
Share on other sites

:wink:

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...