Auction Product Type

[gonewild]

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

[ben harry]

} ?> 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

[gonewild]

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']

[gonewild]

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?

[ben harry]

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

[gonewild]

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?

[ben harry]

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.

[gonewild]

[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.

[ben harry]

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