Shopping cart

[Stramm]

something's messed up...

some data in the shop table is missing. If you don't have any sensible data already (if you're just testing the shop), then empty the shop table (CPG_shop). If there's already data in it you need, then we have to look what data exactly causes the troubles

[videocp]

something's messed up...

some data in the shop table is missing. If you don't have any sensible data already (if you're just testing the shop), then empty the shop table (CPG_shop). If there's already data in it you need, then we have to look what data exactly causes the troubles

I have deleted all data in shop table and verified that temp_data, and config are empty also. I have turned off the shopping cart my albums at this time (individually). But I was getting the error for that.

Also, I would like to add a new type (DVD) to the shopping cart but can not figure it out. Perhaps this has been posted already, the thread(s) are long for me I guess.

[Stramm]

can you dump your shop tables and attach them to your next post???

[videocp]

can you dump your shop tables and attach them to your next post???

Hope this helps.

[Stramm]

after a quick check I see that all the data in the table prices is invalid...

empty that table and restart (but don't ask me how you succeded to do that, I have no clue at all )


also set the default prices to some value > 0  like USD 5.00. That price gets displayed if you don't set an exception for a specific album.

[videocp]

after a quick check I see that all the data in the table prices is invalid...

empty that table and restart (but don't ask me how you succeded to do that, I have no clue at all )


also set the default prices it to some value > 0  like USD 5.00. That price gets displayed if you don't set an exception for a specific album.

Thanks, I make the changes to the price in prices table.

Your last statement says that price will be shown if I do not set the exception for the album. Are your referring to a situation where I can select from the list of  and offer only selected pricing for a picture, or will the complete list be shown for each picture?


OK, I updated the price table with 5.00 and I still have the problem. I have attached the table again for our review. Thanks again.

[Stramm]

the complete list will be shown... always. If you define an exception it gets displayed in red in the admin (so you know you fiddled with it). The exception just overrides the standard.

You can disable displaying the shop for certain albums though (in the per album settings too)

[Sam Lantz]

confirmed, lil glitch
fix: open shop plugin dir include/functions.inc.php, find

Code Select Expand

$cd_price = number_format($temp_price[1],2);
$photo_price = number_format($temp_price[0],2);
$shipping = number_format(($SHOP_CONFIG['ship']),2);
$tot_price = number_format(($cd_price+$photo_price+$SHOP_CONFIG['ship']),2);


replace with

Code Select Expand

$tot_price = number_format(($temp_price[1]+$temp_price[0]+$SHOP_CONFIG['ship']),2);
$cd_price = number_format($temp_price[1],2);
$photo_price = number_format($temp_price[0],2);
$shipping = number_format(($SHOP_CONFIG['ship']),2);


Thanks Stramm, now it works perfect.
About the other problem, I discovered that final extract doesn't work properly on the search page neither; maybe the bug is on the search page and not in your script.

Regards Sam

[zac]

I have another styling question.... How would one go about moving the drop down price menu that defaults directly above the image?   Thanks in advance.

[Stramm]

Without much code changes... you can move it below the image (if that's what you want)

[zac]

yea that is what i am looking to do

[Stramm]

open codebase.php (the one in plugins/photo_shop) and find

Code Select Expand

$pic_data['html'] = $shop_data.$pic_data['html'];
replace it with

Code Select Expand

$pic_data['html'] = $pic_data['html'].$shop_data;

[zac]

great!  thanks!!

[mpwmedia]

Novice user here, so please be gentle....

Firstly, thanks for the superb plugin.

I want to change the currency from the default USD to GBP. I assume I do this via either "photo_shop_config.php" or "photo_shop_admin.php" but each time I log onto these files through my browser, I get the error message:

"Not in Coppermine..."

Hope someone can help.

Thanks,

Mark

[Stramm]

open the language file (plugins/photo_shop/lang/your_lang.php) and replace all occurances of USD with GBP

[bpatto]

Thanks for the great mod, been looking forward to it.

When I install the plugin, it installs without error, but when I go to 'Shop', 'Config' it does not display any items.  And when I try to 'create new item' it displays a critical error 'There was an error while processing a database query'.

Let me know what info you need from me to assist.

[Joachim Müller]

Turn debug_mode on, then post the actual error message (the query that fails, not the debug_output)

[bpatto]

This is the output from the debug.

While executing query "INSERT INTO cpg1410_shop_config (priority) VALUES ('')" on 0

mySQL error: Out of range value adjusted for column 'priority' at row 1

[Stramm]

http://forum.coppermine-gallery.net/index.php?topic=39212.0

[bpatto]

Thanks Stramm, problem solved.