Welcome Visitor, Please Login or Register Now Monday, April 29, 2024 01:29 AM 
Forums Index > Mewsoft Products > Auctionawy > Unable to sell after upgrade
New Topic   New Reply
Search for:
Author Message
NufSed NufSed's personal page
Registered Member
Posts: 73 Display member's posts
Joined: 04-29-24 01:29 AM
Location: South Carolina. USA!
Member Offline
View Member's Profile Visit member's website http://lowcountrydirect.com Send private message
 
Back to top
Unable to sell after upgrade Edit Delete Reply with quote Quote
First Post Posted on: 03-27-08 02:57 PM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-29-24 01:29 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Unable to sell after upgrade Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 03-27-08 05:00 PM next post previous post
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 NufSed's personal page
Registered Member
Posts: 73 Display member's posts
Joined: 04-29-24 01:29 AM
Location: South Carolina. USA!
Member Offline
View Member's Profile Visit member's website http://lowcountrydirect.com Send private message
 
Back to top
Re: Unable to sell after upgrade Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 03-28-08 01:29 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-29-24 01:29 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Unable to sell after upgrade Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 03-28-08 01:53 AM next post previous post
Admin->Setup Wizard->Create sql tables

You will not loose any data

Mewsoft Support
www.mewsoft.com
NufSed NufSed's personal page
Registered Member
Posts: 73 Display member's posts
Joined: 04-29-24 01:29 AM
Location: South Carolina. USA!
Member Offline
View Member's Profile Visit member's website http://lowcountrydirect.com Send private message
 
Back to top
Thanks Edit Delete Reply with quote Quote
Reply #: 4 Posted on: 03-28-08 02:17 AM last post previous post
Everything seems to e working super!
Thanks for the ultra fast support big grin

Also, the autoinstaller works like a charm!

Paul
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.1187 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation