Please help!!! Error in admin tool with Customer info

[Rosina]

Hi,

I am a newbie to this so please bare with me. I have an error in the Admin tool, when I click on order I do not get any informaton on the customer and get this error at the bottom of the page. I have search so many forums now no one has been able to help me. Hopefully someone here be able to help me.

THANK YOU, to anyone that can help!!

Error is below,

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

select new_value, old_value, date_added, customer_notified from orders_status_history where orders_id = '4' order by orders_status_history_id desc

[TEP STOP]

[wenzlerpaul]

Hi Rosina,

This error is sometimes caused by uploading new files but you are still using the old database of oscommerce, it is like, you have an old installation of oscommerce with an old database and you uploaded the new oscommerce version without updating your database. If this is not the case, what I would suggest is that you try updating your database using the installation tool of the new oscommerce, this has an Upgrade option that will not damage your database, in any case, I suggest that you have to backup everything first, if you are doing this as a test one, then you can play around it.

There are some fields added on the database causing the error to come up because of incompatibility.

However, these are all just my pure assumptions and if any of the above-mentioned scenario doesn't fit yours, please post in here the steps you did to install your oscommerce or what you recently did that got you into this mess.

Hope it helps,
Paul

[Rosina]

Hi,

Thank you so much for your reply!! You are completely right, as I think I did not upgrade properly. Unfortuntely the database is corrupt now so I will just start again.

Once again thank you!