Auction Product Type

Wilkesy:

Hi all,

I have just downloaded this and installed it. Everything seems to be working great and will do exactly what im after except that ive come across 1 small problem.

I set a product up with a £50 reserve price, i went in and placed a bid as a customer would for £20, bid accepted. However it still says that the reserve has not been met, but i am not able to enter another bid? Why is this?

Any ideas?

Many thanks

Paul

The intention was that you could not bid against yourself UNLESS the reserve price wasnt met. I thought I had that working.

Since it appears that others are now playing with the code (yeah) I will upload the last load I have. There are only little things in there, but for completeness...

Arnold

AndyII:

here is what I am up against,
if the bidder doesnt follow through with the auction and pay for it, I dont seem to have any records to point me to who it is, and I assumed that the bidder ID was the customer ID but it seems not so, I even bid on an item took the bidder ID (me) and compared it to customer ID's, and it wasn't me :huh:
I have been searching files and did find one I thought would do the trick, (tpl_product_auction_info_display.php)
it had been modified from the original, I replaced the absent code but still showing just the Bidder ID, maybe there is more than 1 file that would need to be changed, anyway we have a forum bridged with zen and was looking into using the forum nick as the identifier
either that or the owner should get an email with the winning bidders info, I hadn't received any.
I did get out bid notices from when I had bid...
original code

changed code
BIDDER_ID <> CUSTOMER_ID the reason is that a customer may make serveral bids on the same item... see zen_products_auctions table

hmmmmm still having alot of trouble with the emails! i am not getting any emails at all when the auctions finish. I have tried it with both the cron job and the now page refresh method. Are there any other settings to try?

I have looked in the database and according to the table the email has been sent as the flags are marked with a 'Y' so the script has run but no emails. hmmmmm confused.

Cheers

I know it works fine for me and it has for others. I also know that some have the same issues as you report. I can only assume that it has to do with the type of sendmail that your server supports. You will need to walk thru the steps and watch what happens. The easiest way to so do that, I think, is to use the cron job. It calls the mail code directly and it is therefore traceable. Setup an auction that ends right away and bid on it. You will have a test item. Then step the cron job into the sendmail code and watch what it does. You might need an SSH / telnet session to do this right, at least that is how I would do it.

Other than that I can tell why email works for some but not for others.

Cheers!
AHB

Hi,

Hmmm thought i had realised why the emails werent working but i turned out to be wrong.

Can i ask a question about the cron job? How does $_SESSION['language']; actually get the language? surely by running thi con job its not going to be getting a proper session with all the variables??

Cheers

Paul

SORTED! i know what is happening with the emails now. For some reason its not getting the customer_email from the table. I have numerous 'Malformed email' alerts in my inbox and the 'to address' is blank.

hmmmm now all i need to do is find out why this is happening.

Anyone got any ideas?

After some testing i have confirmed that the email problem is definately with the variables that are passed into the functions and queries. For some reason they are not being passed through properly from function to function. I took out the variables in the queries and replaced them with the actual values and i got the emails perfectly.

Ill have a good look into this over the weekend, im not sure if its just me but the whole class.productauction.php file seems too complicated and drawn out. Ill have a play around and see what i can come up with.

cheers

Paul

Wilkesy:

After some testing i have confirmed that the email problem is definately with the variables that are passed into the functions and queries. For some reason they are not being passed through properly from function to function. I took out the variables in the queries and replaced them with the actual values and i got the emails perfectly.

Ill have a good look into this over the weekend, im not sure if its just me but the whole class.productauction.php file seems too complicated and drawn out. Ill have a play around and see what i can come up with.

cheers

Paul

Eimails are sending for me on my testing server with sendmail, php 5, mysql 5, Apache 2, zencart 1.3.8a

I get the following error when i go to add a product.Parse error: syntax error, unexpected '<' in /home/corbeau/public_html/catalogue/shop/admin/includes/modules/product_auction/collect_info.php on line 473

I assume that when you add an auction based product that you go to catalogue/products go to the category and choose product-auction from the drop down menu.

Thanks

I just installed v99 into zen138a and I have the server error problem.
Auctions work correctly except the first bid on an item returns the server error page. clicking the back button returns to the auction page and shows the bid placed correctly. My server error log shows this error:

[error] [client ] malformed header from script. Bad header=No recipient addresses found i: /var/chroot/home/content/f/o/r/forgottenwoods/html/index.php

I have uninstalled and reinstalled several times and the problem persists. Any ideas how to solve this?

Emails seem to work OK although I think I was sent a winning bid notice on one that I did not bid on yet. I seem to remember a year or so ago that was a problem with the mod, if an auction closed without a bid then the last winning bidder of the previous auction was sent a winning bid notice?
I will test it more today.

Thanks for any advice

ben harry:

I get the following error when i go to add a product.Parse error: syntax error, unexpected '<' in /home/corbeau/public_html/catalogue/shop/admin/includes/modules/product_auction/collect_info.php on line 473

I assume that when you add an auction based product that you go to catalogue/products go to the category and choose product-auction from the drop down menu.

Thanks

} ?> is missing from line470 in /collect_info.php

gonewild:

} ?> is missing from line470 in /collect_info.php

Thanks for your reply, where abouts does the missing code go in line 470.

I think this is my current line 470.
$oFCKeditor->Create( 'products_description[' . $languages[$i]['id'] . ']' ) ; //instanceName, width, height (px

ben harry:

Thanks for your reply, where abouts does the missing code go in line 470.

I think this is my current line 470.
$oFCKeditor->Create( 'products_description[' . $languages[$i]['id'] . ']' ) ; //instanceName, width, height (px

I put it after the last line in that section and just above the </td> like this:

echo zen_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '20', (isset($products_description[$languages[$i]['id']])) ? stripslashes($products_description[$languages[$i]['id']]) : zen_get_products_description($pInfo->products_id, $languages[$i]['id'])); //,'id="'.'products_description' . $languages[$i]['id'] . '"');
} ?>
</td>
</tr>
</table></td>
</tr

ben harry:

Thanks for your reply, where abouts does the missing code go in line 470.

I think this is my current line 470.
$oFCKeditor->Create( 'products_description[' . $languages[$i]['id'] . ']' ) ; //instanceName, width, height (px

I have managed to get this to work now, but i now get the following error when i go the the installed product.

Do you know what it can be.

1146 Table 'corbeau_shop.TABLE_PRODUCT_AUCTION_EXTRA' doesn't exist
in:
[select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_quantity, p.products_weight, p.products_priced_by_attribute, p.product_is_free, p.products_qty_box_status, p.products_quantity_order_max, p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter, pae.bid_expire_date, pae.bid_reserve_price, pae.bid_expire_hour, pae.bid_start_price, pae.bid_minimum_increase, pae.bid_buynow_price from products p, products_description pd, TABLE_PRODUCT_AUCTION_EXTRA pae where p.products_status = '1' and p.products_id = '206' and pd.products_id = p.products_id and p.products_id = pae.products_id and pd.language_id = '1']

ben harry:

I have managed to get this to work now, but i now get the following error when i go the the installed product.

Do you know what it can be.

1146 Table 'corbeau_shop.TABLE_PRODUCT_AUCTION_EXTRA' doesn't exist
in:
[select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_quantity, p.products_weight, p.products_priced_by_attribute, p.product_is_free, p.products_qty_box_status, p.products_quantity_order_max, p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter, pae.bid_expire_date, pae.bid_reserve_price, pae.bid_expire_hour, pae.bid_start_price, pae.bid_minimum_increase, pae.bid_buynow_price from products p, products_description pd, TABLE_PRODUCT_AUCTION_EXTRA pae where p.products_status = '1' and p.products_id = '206' and pd.products_id = p.products_id and p.products_id = pae.products_id and pd.language_id = '1']

Did you run the sql to create the tables in your database?

gonewild:

Did you run the sql to create the tables in your database?

I did but I got an error message come up saying
Forbidden

You don't have permission to access /catalogue/shop/admin/sqlpatch.php on this server.

, so I did it via FTP direct to sqlpatch.php

ben harry:

I did but I got an error message come up saying
Forbidden

You don't have permission to access /catalogue/shop/admin/sqlpatch.php on this server.

, so I did it via FTP direct to sqlpatch.php

I don't think you can alter the database with FTP. You need to run the sql script to add the tables to the database. How did you try to run the sql?

gonewild:

I don't think you can alter the database with FTP. You need to run the sql script to add the tables to the database. How did you try to run the sql?

My first attemp was the normal copy/paste in admin/tools install sql patches which gave the error code above, i then opened the file in the browse box and uploaded which gave the following message:

1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2
in:
[INSERT INTO product_type_layout VALUES ('','Show Model Number', 'SHOW_PRODUCT_AUCTION_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', last_insert_id(), '1', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT', '1', 'Display Weight on Product Info 0= off 1= on', last_insert_id(), '2', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Attribute Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT_ATTRIBUTES', '1', 'Display Attribute Weight on Product Info 0= off 1= on', last_insert_id(), '3', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Manufacturer', 'SHOW_PRODUCT_AUCTION_INFO_MANUFACTURER', '1', 'Display Manufacturer Name on Product Info 0= off 1= on', last_insert_id(), '4', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Shopping Cart', 'SHOW_PRODUCT_AUCTION_INFO_IN_CART_QTY', '1', 'Display Quantity in Current Shopping Cart on Product Info 0= off 1= on', last_insert_id(), '5', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Stock', 'SHOW_PRODUCT_AUCTION_INFO_QUANTITY', '1', 'Display Quantity in Stock on Product Info 0= off 1= on', last_insert_id(), '6', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Count', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS_COUNT', '1', 'Display Product Reviews Count on Product Info 0= off 1= on', last_insert_id(), '7', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Button', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS', '1', 'Display Product Reviews Button on Product Info 0= off 1= on', last_insert_id(), '8', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Available', 'SHOW_PRODUCT_AUCTION_INFO_DATE_AVAILABLE', '1', 'Display Date Available on Product Info 0= off 1= on', last_insert_id(), '9', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Added', 'SHOW_PRODUCT_AUCTION_INFO_DATE_ADDED', '1', 'Display Date Added on Product Info 0= off 1= on', last_insert_id(), '10', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product URL', 'SHOW_PRODUCT_AUCTION_INFO_URL', '1', 'Display URL on Product Info 0= off 1= on', last_insert_id(), '11', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Starting At text on Price', 'SHOW_PRODUCT_AUCTION_INFO_STARTING_AT', '1', 'Display Starting At text on products with attributes Product Info 0= off 1= on', last_insert_id(), '12', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Tell a Friend button', 'SHOW_PRODUCT_AUCTION_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on Product Info

Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button
0= off 1= on', last_insert_id(), '15', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Image Status - Catalog', 'SHOW_PRODUCT_AUCTION_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '0', 'Show the Free Shipping image/text in the catalog?', last_insert_id(), '16', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')), '), ('','Product Price Tax Class Default - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_TAX_CLASS_ID', '0', 'What should the Product Price Tax Class Default ID be when adding new products?', last_insert_id(), '100', now(), now(), NULL, ''), ('','Product Virtual Default Status - Skip Shipping Address - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_VIRTUAL', '0', 'Default Virtual Product status to be ON when adding new products?', last_insert_id(), '101', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What should the Default Free Shipping status be when adding new products?', last_insert_id(), '102', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[QUOTE=ben harry;612108]My first attemp was the normal copy/paste in admin/tools install sql patches which gave the error code above, i then opened the file in the browse box and uploaded which gave the following message:

1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2
in:
[QUOTE]

I don't know if that is the normal message than comes up but it sounds like you did it correctly. Maybe try uninstalling the sql and then reinstalling it to see if it fixes the problem.

I don't know if that is the normal message than comes up but it sounds like you did it correctly. Maybe try uninstalling the sql and then reinstalling it to see if it fixes the problem.[/quote]

Already tried that, and it says the same messages on both copy/paste and browse the file and upload. I will give it another attempt tomorow as its getting quite late now. Thanks for your help so far.

Ben