Welcome Visitor, Please Login or Register Now Tuesday, April 16, 2024 07:49 AM 
Forums Index > Mewsoft Products > Auctionawy > Process Closed Auctions SQL Error after update
New Topic   New Reply
Search for:
Author Message
bhlaserjet bhlaserjet's personal page
Registered Member
Posts: 88 Display member's posts
Joined: 04-16-24 07:49 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Process Closed Auctions SQL Error after update Edit Delete Reply with quote Quote
First Post Posted on: 05-14-11 08:50 AM next post first post
Can't process Closed Auctions after update how do I fix.\ Thanks\ BOB\ \ SQL Error: Unknown column 'Method' in 'where clause'\ Query: \ SELECT * FROM Auction_Bids WHERE ID=1191092586 AND Status=1 AND Method<2 ORDER BY Bid DESC, Time DESC LIMIT 1\ Line 348, File /home/bhlaserj/public_html/cgi-bin/auction/ProcessAuctions.pm.
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-16-24 07:49 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: Process Closed Auctions SQL Error after update Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 05-14-11 02:23 PM next post previous post
You seems havenot applied updates for long time, you need to apply all sql updates, search the announcements forums for all updates and apply any sql commands in these updates, we always say apply updates when released.

Mewsoft Support
www.mewsoft.com
huutotalo huutotalo's personal page
Registered Member
Posts: 37 Display member's posts
Joined: 07-27-06 01:10 PM
Member Offline
View Member's Profile Send private message
 
Back to top
Process Closed Auctions SQL Error after update Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 06-09-11 02:24 PM next post previous post
\ \ \ \ \
\ \ \ \ \ \ \ \
bhlaserjet's Wrote:
Can't process Closed Auctions after update how do I fix.\ Thanks\ BOB\ \ SQL Error: Unknown column 'Method' in 'where clause'\ Query: \ SELECT * FROM Auction_Bids WHERE ID=1191092586 AND Status=1 AND Method<2 ORDER BY Bid DESC, Time DESC LIMIT 1\ Line 348, File /home/bhlaserj/public_html/cgi-bin/auction/ProcessAuctions.pm.
\
\ \ I have the above problem. My site is a new installation but the database was replaced by the previous one. I checked in the Mysql database for Auction_bids. It does not have the column "Method".\ HOW TO ADD A COLUMN TO A TABLE USING SQL COMMANDER FROM THE ADMIN PANEL?
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-16-24 07:49 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: Process Closed Auctions SQL Error after update Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 06-09-11 02:52 PM last post previous post
See the announcements forum and apply any sql changes in the updates released. of course you can delete the db and create the tables again.

Mewsoft Support
www.mewsoft.com
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.1057 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation