This is a discussion on Please help!!! Error in admin tool with Customer info within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Hi, I am a newbie to this so please bare with me. I have an error in the Admin tool, ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| 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] |
| Sponsored Links | ||
| ||
| |
|
#2
| |||
| |||
| 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 |
|
#3
| |||
| |||
| 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! |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 1064 - error in your SQL syntax admin customer search | webwolfe | osCMax v1.7 Discussion | 0 | 11-10-2006 07:13 AM |
| Error Customer Orders Admin Panel | donm1021 | osCMax v1.7 Discussion | 0 | 08-08-2006 05:50 PM |
| ADMIN TOOL | case510 | osCMax v1.7 Discussion | 3 | 12-25-2004 11:15 AM |
| edit customer in admin error, heelllppp | battleaxe | osCMax v1.7 Discussion | 0 | 10-07-2004 03:38 AM |
| Error when trying to edit customer info | Nugar | osCMax v1.7 Discussion | 9 | 11-13-2003 12:01 PM |