Shopping cart

[Hot Rides]

  Critical error   

There was an error while processing a database query 

installed photo shop 1.3.6

on a bridged 1.4.17 with the modpak

used plugin manager, clicked install button, next page showed changes made, clicked ok, got error


site; www.hot-rides.net/coppermine/

enabled debugging;
While executing query "SELECT * FROM cpg_shop_config ORDER BY priority ASC" on 0

mySQL error:


need help fast!!!

[Stramm]

That's not much of MySQL tells about the error... so blind guessing

remove the ASC
plugins dir... include/init.inc.php
find

Code Select Expand

$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_CONFIG']} ORDER BY priority ASC");

replace with

Code Select Expand

$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_CONFIG']} ORDER BY 'priority'");


[Hot Rides]

tried that, no effect

moved the troubleshooting here to not clogged up this already enormus thread

http://forum.coppermine-gallery.net/index.php/topic,51906.0.html

[hwilliam]

Just installed Coppermine and Photoshop plug in....followed instructions for installation of photoshop. when I go to checkout all I get is the header "checkout" and nothing else. updated database...any ideas?

[Stramm]

No, maybe when I can see the site...

[hwilliam]

Duh.....when you get old you get stupid....the whole thing was there when I scrolled to the bottom......(I'm having a problem that I guess I need to go to another thread, but on Firefox the site looks totally different and none of the themes seem to work, however on Explorer everything is as it should be) sorry...but, question.is there a paypal addition to this plugin? I really need to have clients to be able to pay that way..

[Stramm]

a basic implementation is supported, read the very first post of this thread for more info

[ib2loud]

Weird question that may have been asked before. I have two instances of coppermine running (not the best way to do this but it works for me). What I have is one photo gallery with the cart and a gallery for merchandise with the cart.

Everything works fine except when you add something to one cart, it tries to add it to the other but gives a database error when you view either cart after viewing both galleries. Confusing I know and I thought maybe I just need to change cookie names but that didn't seem to fix it.

Thanks for any help and thanks again for the great add-on.

[hwilliam]

I see the files in the folders, but are there instructions somewhere on installing the paypal portion of the plug in?

[Stramm]

Weird question that may have been asked before. I have two instances of coppermine running (not the best way to do this but it works for me). What I have is one photo gallery with the cart and a gallery for merchandise with the cart.

Everything works fine except when you add something to one cart, it tries to add it to the other but gives a database error when you view either cart after viewing both galleries. Confusing I know and I thought maybe I just need to change cookie names but that didn't seem to fix it.

Thanks for any help and thanks again for the great add-on.

Db error cause the cookie stored info about pics that one gallery has but not the other. Without haveing tested I suggest (as you've already done) changing the cookies on both galleries to be different, then clear cookies and retry.

[ib2loud]

I tried that, even with different cookie names it still does the same thing

does the plugin create its own cookie that maybe I can change the name to?

[Sy]

Hi Stramm,
  I'm just wondering, and I'm guessing it's been asked before but the search isn't showing anything that answers my question, but when I mark an order as paid or sent is anything meant to happen, because currently it's not?

Thanks for any help, and apologies if I'm being thick.

Sy

[Stramm]

yes and no... this was introduced to be able to use eg. paypal IPN or some CC gateways that send back payment info. IPN marks the item as paid, you know you can send them (or as in some custom work, create a download folder and copy resized versions of the original image there).
On my demo site you can eg. 'buy' a 'free download'. The free download is without watermark in a smaller resolution. Gets placed into your download folder and you get an email with your password. And of course it's getting marked paid, if the download image's getting cretaed, it's marked paid.

As it is now, it's a reminder for you. Nothing less, nothing more.

[Sy]

Hi,
  Thanks for getting back to me and for the info.  A manual reminder is fine for me...now I just need something to remind me to set the manual reminder PMSL .

Thanks again,

Sy

[Gephri]

Stramm's Shopping Cart is a beautiful mod - thanks!
Finishing up on a few trial runs with PayPal as the payment processor.
Discovered two things:
1) how to fix the discount percentage that shows up as 10.5% when the coding calls for 10%
includes/functions.inc.php

Code Select Expand


//another example... 10% if the order volume is > 100USD
if($temp_price[0] >= 100) {
$discount = 0.1 * $temp_price[0];
}


2) PayPal does not show the discount when the order is processed.

Any ideas?

[Stramm]

PayPal again changed things. This time they do not allow 'handling_cart' to have a negative value (I used that as a bundeled value for discount and shipping). Means if you only use a discount, it's < 0 and therefore invalid. Checking the paypal forums it seems they plan to introduce discounts this year... when... no clue.
As a workaround it may be possible to introduce a 'discount item', no global cart var, but a true item. Maybe it's possible to give that a negative value. If that all isn't working, then the only way is to step back a shop version and use only a 'one total price' paypal checkout.

[Gephri]

Thank you very much for the thorough explanation.
If I had the skills to code a solution - I would.  But alas I but a newbie.

[Stramm]

So I did try to send negative values to paypal as an item... server doesn't accept this, as one of the paypal guys said in the forums http://www.paypaldeveloper.com/pdn/board/message?board.id=basicpayments&thread.id=1688&view=by_date_ascending&page=1

At the moment it's not possible to use discounts together with paypal. Except you calculate them before sending the data to paypal. Means, you discount each item and send that data... there may occur a rounding error so the total may differ (~ 1-2 cent). That's cause the shop discounts the total and not each item.
Or you don't send data of each item to paypal but just the discounted total.

Still paypal won't show the discount and not the initial invoice. If the paypal guys add that feature (as said in the thread) I'm going to implement it again.

[Gephri]

Has anyone figured how to add a third category to "prints" and "cd".  I'd like to also give users the chance to buy the photo's from a gift item category in the drop down menu.

[Stramm]

Rename the categories to 'cds' and 'other'