♥FWR Media Posted December 24, 2009 Author Share Posted December 24, 2009 Help needed. I'm assuming that this is where I post. I just installed the Auctiontastic contribution but it's not working. The "Auction Products" shows up in the admin section, but when I click on it I get the following: 1146 - Table 'coruscan_p_os1.auctions' doesn't exist select count(*) as total from products p, auctions a, products_description pd where p.products_id = pd.products_id and a.products_id = p.products_id and pd.language_id = '1' and p.products_id = a.products_id [TEP STOP] I don't recall seeing an sql add in. Also, I ran the installer.php and it showed that everything was fine. Am I missing something? Thanks, Mike No if you ran the installer then everything should be in place in the database .. but it isn't, you don't have an auctions table .. someone must have dropped it by mistake. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
coruscant-voyager Posted December 25, 2009 Share Posted December 25, 2009 (edited) Hello. Good to know that I ran things ok... but any suggestions on how to get the auction table back? Thanks again. Edited December 25, 2009 by coruscant-voyager Quote Link to comment Share on other sites More sharing options...
ldon Posted January 1, 2010 Share Posted January 1, 2010 Will you upload the latest version of auctionTastic on osCommerce contributions? Thanks. ldon Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 1, 2010 Author Share Posted January 1, 2010 Will you upload the latest version of auctionTastic on osCommerce contributions? Thanks. ldon Yes, when there is one. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted January 1, 2010 Share Posted January 1, 2010 Yes, when there is one. Nothing new since 28 May 2009? Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 1, 2010 Author Share Posted January 1, 2010 Nothing new since 28 May 2009? Yes plenty .. just nothing new here. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted January 2, 2010 Share Posted January 2, 2010 Yes plenty .. just nothing new here. :D , and are you still working on it? Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 2, 2010 Author Share Posted January 2, 2010 :D , and are you still working on it? Not seen any point in upgrading .. no bugs that I've seen. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted January 2, 2010 Share Posted January 2, 2010 Not seen any point in upgrading .. no bugs that I've seen. What about my neverending problem? :'( 1.let's say I've got 25 products in stock. 2. One of 25 products added to auction 3. Few bids on the product 4. All 25 products were bought before the auction has ended - BUY NOW 5. The product is out of stock 6. Auction ended – the product added to shopping cart of the winning bidder 7. The winning bidder received a winner e-mail 8. Click on a link - log in 9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now 10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart.. ??? I think this is the point which makes the auction not PRO. And one more question. Can you have a look on http://www.oscommerce.com/community/contributions,1237/category,all/search,anti+robot This seems to be a good idea but it doesn't work at all. First problem was to instal sql but after small changes I've done it. Now I've got error 'Missing SID, please refresh borwser' In IE 8 doesn't work alternate view. Cheers :thumbsup: Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 2, 2010 Author Share Posted January 2, 2010 (edited) What about my neverending problem? :'( 1.let's say I've got 25 products in stock. 2. One of 25 products added to auction 3. Few bids on the product 4. All 25 products were bought before the auction has ended - BUY NOW 5. The product is out of stock 6. Auction ended – the product added to shopping cart of the winning bidder 7. The winning bidder received a winner e-mail 8. Click on a link - log in 9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now 10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart.. ??? I think this is the point which makes the auction not PRO. And one more question. Can you have a look on http://www.oscommerce.com/community/contributions,1237/category,all/search,anti+robot This seems to be a good idea but it doesn't work at all. First problem was to instal sql but after small changes I've done it. Now I've got error 'Missing SID, please refresh borwser' In IE 8 doesn't work alternate view. Cheers :thumbsup: :blink: The first thing was a request by you alone . .I don't upgrade for individual requests unless I feel there is a significant and universal benefit. The second point is nothing to do with me whatsoever. Edited January 2, 2010 by FWR Media Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted January 2, 2010 Share Posted January 2, 2010 :blink: The first thing was a request by you alone . .I don't upgrade for individual requests unless I feel there is a significant and universal benefit. The second point is nothing to do with me whatsoever. "The first thing" So if just one person will send you a bug, you not going to fix it until more people will do the same? If not, can you fix it for me please? I do not understand why you don't want to do it. "The second point" I know, it was just call of favour. :rolleyes: Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 2, 2010 Author Share Posted January 2, 2010 "The first thing" So if just one person will send you a bug, you not going to fix it until more people will do the same? If not, can you fix it for me please? I do not understand why you don't want to do it. I don't see it as a bug as I've mentioned before. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted January 11, 2010 Share Posted January 11, 2010 I don't see it as a bug as I've mentioned before. :thumbsup: But can you just make an option in admin to do not display auction item in categories please? This will prevent all (I think not just my) troubles. Thank you. Quote Link to comment Share on other sites More sharing options...
ldon Posted January 28, 2010 Share Posted January 28, 2010 Yes, when there is one. Total problem with auction. Everything was all right until I allowed Tax for prices. Now I've got a big problem. When auction is ended biggest auction price is different from subtotal price. Subtotal price is actually original product price. Can anybody help me? Thanks Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted January 28, 2010 Author Share Posted January 28, 2010 Total problem with auction. Everything was all right until I allowed Tax for prices. Now I've got a big problem. When auction is ended biggest auction price is different from subtotal price. Subtotal price is actually original product price. Can anybody help me? Thanks I'll test this over the weekend. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
ldon Posted February 2, 2010 Share Posted February 2, 2010 I'll test this over the weekend. I've done a new installation of oscommerce and then auctionTastic and the problem is there. Highest bit price is different from price in my shopping basket. (After auction was ended). Quote Link to comment Share on other sites More sharing options...
itmechanic Posted February 9, 2010 Share Posted February 9, 2010 auctionTastic Create multiple product auctions in osCommerce Originally based on another auction contribution (credits.txt included) this is a total rewrite due to the original having unworkable code. At 27 odd files this is quite a large contribution although changes to core files has been kept to very very little. Full instructions are included: Package includes: - Auto Installer Upload folder (contains all files new to oscommerce) Modified files folder (files where we are modifying oscommerce code) Documentation folder (install instructions including manual file changes - new code syntax highlighted) Features:- Multiple auction products Products with attributes can be auctioned Products can be bought as normal even if auctioned Standard product price shown above auction price (including addition of attributes value) product info page refresh options in admin My Auction view in My Account Inform current highest bidders of new bids Inform winning bidders at end of auction Product added to cart of winning bidder at end of auction (Can't be removed by them) Valid HTML (I hope) Compatible with PHP4/5 MySQL4/5 Error free (error_reporting(E_ALL)) Compatible with .. RC2a (lower probably will work but untested) Feedback and bug reports appreciated as always. The files are http://addons.oscommerce.com/info/6431 The contribution is set so that no others can add packages this is to maintain some quality. This does not stop users from making suggestions here that could be integrated into a later release. Finally I wanted to mention that this was not built by design it started off as a customer asking me to install another auctions contrib, the further I went into it the clearer it became that the previous contribution just couldn't work with the code in place, before I knew it I wasn't just changing code I was rewriting it . . the code would have been a lot better if planned from the start but it seems relatively solid. Quote Link to comment Share on other sites More sharing options...
itmechanic Posted February 9, 2010 Share Posted February 9, 2010 Hi FWR Great script would it be possible to code in a reserve price for the auction product kind regards James Quote Link to comment Share on other sites More sharing options...
ldon Posted February 10, 2010 Share Posted February 10, 2010 I'll test this over the weekend. On fresh installation: SHOPPING CART after auction ended Product: Speed (WON in auction) Price: Total = $2 (auction highest bid) Sub-Total = $41.99 (original price) Why is sub-total different from auction highest bid? Quote Link to comment Share on other sites More sharing options...
PiBo Posted February 11, 2010 Share Posted February 11, 2010 Hi ldon, I read the post from start bis end (...) Hummm first u are right ldon but FWmedia work too much but we remerciate alls for this work, thank u buddy. so ldon, go and catalog/includes/classes/shopping_cart.php find, line approximativ 271->285 // BOF AUCTIONS if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){ $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1'); } // EOF AUCTIONS $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows ($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $this->total += $currencies->calculate_price($products_price, $products_tax, $qty); $this->weight += ($qty * $products_weight); } and replace with : // BOF AUCTIONS if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){ $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1'); $this->weight += ($qty * $products_weight); }else{ $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows ($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $this->total += $currencies->calculate_price($products_price, $products_tax, $qty); $this->weight += ($qty * $products_weight); } // EOF AUCTIONS And THE FIRST BIG BUGS FROM THIS CONTRIB WERE RESOLV....YOU MIND ? in PHP (+=) + (+=) = ++== Quote Link to comment Share on other sites More sharing options...
PiBo Posted February 11, 2010 Share Posted February 11, 2010 (edited) If you make take advantage and open oscAuction.php classes change /** * includes/boxes/categories.php * * @param mixed $info_box_contents */ function categoriesAdd(&$info_box_contents){ $info_box_contents[] = array('text' => '<a href="'.tep_href_link(FILENAME_AUCTIONS).'" >' . AUCTIONS_AUCTION_PRODUCTS . '</a>'); return $info_box_contents; } To /** * includes/boxes/categories.php * * @param mixed $info_box_contents */ function categoriesAdd(&$info_box_contents){ //if ($this->count_available_auctions) $auctions_count = 0; $auctions_query = tep_db_query("SELECT COUNT(auctions_id) as total FROM " . TABLE_AUCTIONS . " WHERE status = '1' and expires_date > '" . date("Y-m-d H:i:s") . "'"); $auctions = tep_db_fetch_array($auctions_query); $auctions_count += $auctions['total']; $info_box_contents[] = array('text' => '<a href="'.tep_href_link(FILENAME_AUCTIONS).'" >' . AUCTIONS_AUCTION_PRODUCTS . '</a>' .' ('. $auctions_count . ')'); return $info_box_contents; } You will find a fine counter in you categories menu... Take more advantage if you check some date("Y-M-d ... To date("Y-m-d in sql request example.. ;) ALL RESOLV ARE FOR ms2.2/rc2.2a +++++++++++++++++++++++++++++++ ;) Edited February 11, 2010 by PiBo Quote Link to comment Share on other sites More sharing options...
ldon Posted February 12, 2010 Share Posted February 12, 2010 (edited) Hi ldon, I read the post from start bis end (...) Hummm first u are right ldon but FWmedia work too much but we remerciate alls for this work, thank u buddy. so ldon, go and catalog/includes/classes/shopping_cart.php find, line approximativ 271->285 // BOF AUCTIONS if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){ $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1'); } // EOF AUCTIONS $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows ($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $this->total += $currencies->calculate_price($products_price, $products_tax, $qty); $this->weight += ($qty * $products_weight); } and replace with : // BOF AUCTIONS if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){ $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1'); $this->weight += ($qty * $products_weight); }else{ $specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'"); if (tep_db_num_rows ($specials_query)) { $specials = tep_db_fetch_array($specials_query); $products_price = $specials['specials_new_products_price']; } $this->total += $currencies->calculate_price($products_price, $products_tax, $qty); $this->weight += ($qty * $products_weight); } // EOF AUCTIONS And THE FIRST BIG BUGS FROM THIS CONTRIB WERE RESOLV....YOU MIND ? in PHP (+=) + (+=) = ++== Thank you PiBo. And do you know to sort out my other problem? 1.let's say I've got 25 products in stock. 2. One of 25 products added to auction 3. Few bids on the product 4. All 25 products were bought before the auction has ended - BUY NOW 5. The product is out of stock 6. Auction ended – the product added to shopping cart of the winning bidder 7. The winning bidder received a winner e-mail 8. Click on a link - log in 9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now 10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart.. ??? I think this is the point which makes the auction not PRO. Edited February 12, 2010 by ldon Quote Link to comment Share on other sites More sharing options...
ldon Posted February 22, 2010 Share Posted February 22, 2010 Thank you PiBo. And do you know to sort out my other problem? 1.let's say I've got 25 products in stock. 2. One of 25 products added to auction 3. Few bids on the product 4. All 25 products were bought before the auction has ended - BUY NOW 5. The product is out of stock 6. Auction ended – the product added to shopping cart of the winning bidder 7. The winning bidder received a winner e-mail 8. Click on a link - log in 9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now 10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart.. ??? I think this is the point which makes the auction not PRO. Anybody else can help with this solution please? Quote Link to comment Share on other sites More sharing options...
bryn28 Posted February 24, 2010 Share Posted February 24, 2010 I installed this contribution and it seems to work fine other than a few issues im having. 1. auction info isnt showing in "my account" for members who have bid 2. Is there suppose to be a "buy now" button on the auction page? 3. im getting an error for the auction terms when clicking the link. Fatal error: Class 'infoBoxheading' not found in /home/bryn28/public_html/auction_terms.php on line 40 4. Is there a way to control bidding increments? It seems to be whatever the starting bid is, is what the minimum bidding is going to be. im still testing but these are some issues ive come across so far....how can I fix these? thanks Quote Link to comment Share on other sites More sharing options...
bryn28 Posted March 24, 2010 Share Posted March 24, 2010 can anyone tell me how to fix bidding increments? example: auction starting price : 5.00 overbid amount :2.00 bid price = $6.71 instead of $7.00 any ideas? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.