Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: 1 ... 20 21 22 23 [24] 25 26 27 28 ... 30   Go Down

Author Topic: Shopping cart  (Read 651941 times)

0 Members and 1 Guest are viewing this topic.

Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Shopping cart
« Reply #460 on: April 14, 2008, 07:32:58 pm »

  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!!!
« Last Edit: April 14, 2008, 07:42:43 pm by Hot Rides »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #461 on: April 14, 2008, 09:12:30 pm »

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]
$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_CONFIG']} ORDER BY priority ASC");
replace with
Code: [Select]
$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_SHOP_CONFIG']} ORDER BY 'priority'");


Hot Rides

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 108
  • I am
    • Hot Rides Show & Cruise
Re: Shopping cart
« Reply #462 on: April 15, 2008, 03:58:46 pm »

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
Logged

hwilliam

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #463 on: April 16, 2008, 05:50:54 am »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #464 on: April 16, 2008, 08:15:42 am »

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

hwilliam

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #465 on: April 16, 2008, 04:50:18 pm »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #466 on: April 16, 2008, 04:53:05 pm »

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

ib2loud

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 77
  • I <3 CPG!
    • OKShowPics.com
Re: Shopping cart
« Reply #467 on: April 17, 2008, 05:45:08 am »

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

hwilliam

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #468 on: April 17, 2008, 06:16:54 am »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #469 on: April 17, 2008, 12:09:56 pm »

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

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 77
  • I <3 CPG!
    • OKShowPics.com
Re: Shopping cart
« Reply #470 on: April 17, 2008, 02:17:10 pm »

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

Sy

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: Shopping cart
« Reply #471 on: April 19, 2008, 04:03:39 pm »

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
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #472 on: April 19, 2008, 04:14:12 pm »

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

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Re: Shopping cart
« Reply #473 on: April 20, 2008, 09:39:52 am »

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
Logged

Gephri

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 235
Re: Shopping cart discounting
« Reply #474 on: April 22, 2008, 01:24:15 am »

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]
//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?
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #475 on: April 22, 2008, 10:03:08 am »

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

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 235
Re: Shopping cart
« Reply #476 on: April 22, 2008, 10:19:42 am »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #477 on: April 23, 2008, 09:23:08 am »

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

  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 235
Re: Shopping cart
« Reply #478 on: April 23, 2008, 09:47:24 am »

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

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #479 on: April 23, 2008, 09:51:57 am »

Rename the categories to 'cds' and 'other'
Pages: 1 ... 20 21 22 23 [24] 25 26 27 28 ... 30   Go Up
 

Page created in 0.043 seconds with 20 queries.