Auction Product Type

[stampsville]

I currently have it set up at my website and have it testing at the moment. When and if I ever get it to a fairly stable level I will let you know. In the categories list- the auctions are at the bottom, currently testing.

http://stampcommune.com/store/

GJW

[Mobilemick]

Looked on your site stampsville but couldnt see the auction mod, maybe it didnt work and u removed it,

Is there a latest release for Zen Cart.

Thanks
Mick

[kuroi]

So far as I know, this hasn't been touched for some time.

[Mobilemick]

Ok thanks for reply, Will wait and hope

[stampsville]

Mobilemick,

I do have it installed and working, but unfortunately still having email problems and way to many mods installed to seperate anything out. I don't want to release it due to it's instability.

Stampsville

[Mobilemick]

Just tried to install it m8,
and now cant access admin page.

Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23

Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23

Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23

Fatal error: main() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kccae/public_html/global/admin/index.php on line 23

Or index page

1146 Table 'kccae_zc1.zen_product_auction_extra' doesn't exist
in:
[SELECT * FROM zen_product_auction_extra WHERE auction_closed = 'N' AND CURDATE() > bid_expire_date or (bid_expire_hour < 16 and bid_expire_date = CURDATE() and auction_closed = 'N')]

Any help would be appreciated :)

Thanks
Mick

[dan_ballan]

Any luck Sid?

[RodG]

Hi Mick,

> 1146 Table 'kccae_zc1.zen_product_auction_extra' doesn't exist
>in: [SELECT * FROM zen_product_auction_extra WHERE auction

One of 'kccae_zc1.zen_product_auction_extra' or 'zen_product_auction_extra' is wrong - They should both be the same (depending whether you use rable prefixes or not).

Sorry, I can't be of more help with this module (I just stumbled across your msg), but I've just been working on a similar problem with another module.

Cheers
Rod

[kuroi]

THe problem is that the code in the mod can't find the table zen_product_auction_extra (the kccae_zc1 is simply the full path to the expected table including the database name).

The two likely reasons are EITHER the SQL that creates the table wasn't executed probably during installation, so it genuinely doesn't exist OR the SQL assumed a database prefix of zen_ but you are not using a prefix, or are using a different one and so the table has been misnamed.

I recommend taking a look at your table names in phpMyAdmin, to establish which. Once you know that the solution (or at least the next step) should be straightforward.

[jamie2k]

Hi Folks,

[FONT=Arial][/FONT][FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]I compared at all the files that are used in this auction mod:-[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]auctions.zip [/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]http://www.zen-cart.com/archived_contributions/other/auctions.zip[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]I am getting this error now and can’t find any pointers on the forum.[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]When I run the sql I got this error:-[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Times New Roman]Error[/FONT]

[FONT=Times New Roman]SQL query:[/FONT]
[FONT=Times New Roman]INSERT[/FONT]INTOproduct_types
VALUES (
[FONT=Times New Roman]''[/FONT], 'Product - Auction', 'product_auction', '1', 'N', '', now( ) , now( )
[FONT=Times New Roman])[/FONT];
[FONT=Times New Roman]MySQL said: [/FONT][FONT=Courier New]#1264 - Out of range value adjusted for column 'type_id' at row 1 [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]any ideas ?[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]kind regards[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]Jamie [/FONT][/FONT]