Forums Index > Mewsoft Products > Auctionawy > Unable to sell after upgrade
NufSed First Post Posted on: 03-27-08 02:57 PM
Unable to sell after upgrade

OK, I did the upgrade. I upgraded everything. I used the autoinstaller, and I also tried doing it with my FTP software and I get the same results either way. When I run the Upgrade.cgi there is a SQL Error message at the bottom.
"SQL Error: Duplicate column name 'User1'
Query:
ALTER TABLE Users ADD User1 VARCHAR(100)
Line 148, File Upgrade.cgi."


After multiple attempts I still get this error when any user tries to sell,

"SQL Error: Table 'lowcountrydirect1.SellerTrack' doesn't exist
Query:
SELECT ID, Time FROM SellerTrack WHERE (User_ID='snoozeyaloose' AND Time >= '1095594663') GROUP BY ID ORDER BY Time DESC
Line 299, File /var/www/lowcountrydirect.com/public_html/cgi-bin/auction/AddItemLib.pm."

I also tried updating the AddItemLib.pm alone with no results.
mewsoft Reply #: 1 Posted on: 03-27-08 05:00 PM
Re: Unable to sell after upgrade

You should do all the updates, update all the cgi files *.cgi and *.pm and click on create tables to create the missing tables.

Mewsoft Support
www.mewsoft.com

NufSed Reply #: 2 Posted on: 03-28-08 01:29 AM
Re: Unable to sell after upgrade

I did do ALL of the updates *.cgi and *.pm.
So where do I find the "create tables" to click on? Also when I "create tables" I should not expect to loose all of the data should I?
Thanks
mewsoft Reply #: 3 Posted on: 03-28-08 01:53 AM
Re: Unable to sell after upgrade

Admin->Setup Wizard->Create sql tables

You will not loose any data

Mewsoft Support
www.mewsoft.com

NufSed Reply #: 4 Posted on: 03-28-08 02:17 AM
Thanks

Everything seems to e working super!
Thanks for the ultra fast support big grin

Also, the autoinstaller works like a charm!

Paul