| bhlaserjet |
First Post Posted on: 05-14-11 08:50 AM |
| Process Closed Auctions SQL Error after update |
|
| 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 |
Reply #: 1 Posted on: 05-14-11 02:23 PM |
| Re: Process Closed Auctions SQL Error after update |
|
| 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 |
Reply #: 2 Posted on: 06-09-11 02:24 PM |
| Process Closed Auctions SQL Error after update |
|
\
\
| | \
\
\
\
| 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 |
Reply #: 3 Posted on: 06-09-11 02:52 PM |
| Re: Process Closed Auctions SQL Error after update |
|
| 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
|
|
|
|
|
|