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 ... 6 7 8 9 [10] 11 12 13 14 ... 30   Go Down

Author Topic: Shopping cart  (Read 507575 times)

0 Members and 2 Guests are viewing this topic.

colin911

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Shopping cart
« Reply #180 on: January 15, 2007, 10:17:05 pm »

Here is what i got:

Quote
There was an error while processing a database query.

While executing query "SELECT * FROM cpg1410_shop_prices WHERE aid=" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

File: /home/content/b/v/i/bviguides/html/Domains/Surfpic/coppermine/include/functions.inc.php - Line: 248

Under "notices" I got:

Quote
plugins/photo_shop/codebase.php
Notice line 187: Undefined index: photo
Notice line 191: Undefined index: cd
/plugins/photo_shop/include/functions.inc.php
Notice line 79: Undefined index: photo
/plugins/photo_shop/photo_shop_cart.php
Notice line 24: Undefined index: cd
Notice line 165: Undefined index: aid
/include/media.functions.inc.php
Notice line 56: Undefined index:
/include/functions.inc.php
Notice line 1995: Undefined index: url_prefix
Notice line 1995: Undefined index:
Notice line 1995: Undefined index: filepath
Notice line 1996: Undefined index: filename

Is this what you needed?
Logged

affeee

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Shopping cart
« Reply #181 on: January 16, 2007, 03:23:36 pm »

Another great mod /plugin from Straam  ;D

One small thing.  When there is no CD option for buyers to purchase, for example you only offer photo prints - there seems to be a totals calculation error.

Screen shot:

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fwww.smileonthetiles.com%2Fimages%2Fphoto_shop_bug.jpg&hash=7d8fc5c5caa57cd620f8db6b74031a79)

Notice that the individual price of the photo is 4.49 but the total shows 4.00.  Interestingly if I do add a CD purchase option in the config this error does not occur at all.

http://www.smileonthetiles.com

Test account:

username: testuser
password: test123




I have the exactly same problem here. I am running latest version of photoshop.

See attached image

I noticed that when total price is over 1000.00 this problem occurs.
« Last Edit: January 16, 2007, 03:29:39 pm by affeee »
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #182 on: January 16, 2007, 04:09:26 pm »

Here is what i got:

Under "notices" I got:

Is this what you needed?

try again clearing your cookies. It's a known problem and I'll adding a check in the next version.

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #183 on: January 16, 2007, 04:11:11 pm »

I have the exactly same problem here. I am running latest version of photoshop.

See attached image

I noticed that when total price is over 1000.00 this problem occurs.

download again version 1.3.1 and replace your existing files. This problem has been fixed. If that doesn't help.... post a link please

colin911

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Shopping cart
« Reply #184 on: January 16, 2007, 05:10:13 pm »

Stramm, Strange, all of a suddeen everything is fine, without deleting more cookies.  Any way it's working.  Thanks.

Another question:  is there any way that through the admin of the shopping cart i would be able to see which member uploaded the photo? The idea is to have multiple photographers upload images then pay them a comission when the photo sells.
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #185 on: January 16, 2007, 05:26:34 pm »

easy, in photo_shop_admin.php find
Code: [Select]
{$lang_photoshop_admin['size']}: {$size[$k]}<br />below add
Code: [Select]
<span style="float:right;" class="smallfont">Pic owner: <a href="profile.php?uid={$row_pic['owner_id']}">{$row_pic['owner_name']}</a></span>

find
Code: [Select]
$select_columns = 'filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title';replace with
Code: [Select]
$select_columns = 'filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title, owner_name, owner_id';

colin911

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: Shopping cart
« Reply #186 on: January 16, 2007, 10:56:46 pm »

Thanks stramm, this is good, but can we put the info for each photographer on the main admin page for the cart?  IE, the pic owner is showing if you click for the details of the order but I was hoping to get it to show where all the orders are listed.  More importantly, I'd like itt to show up in the archives section too since i will be doing the accounting and commissions calculations after processing the order.

Many thanks for your great support on this.  You have lots of patience I can tell.  :-)
Logged

Jeremy Rasmussen

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Shopping cart
« Reply #187 on: January 17, 2007, 06:52:54 am »

Maybe someone can help... I've scanned through the thread to see if i could find anyone with the same problem, if I missed it please let me know.

Anyway when ever an item is added to the cart or when changes are saved in the config section of the shop the browser doesn't redirect to the last page it was on.  However I tested it using the classic theme and I don't have this problem. Are there any suggestions on where to start looking to fix this problem?  I am using a custom made theme and it is possible that some code was inadvertently left out.

thanks for the help and as always great job Stramm!
Logged

affeee

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Shopping cart
« Reply #188 on: January 17, 2007, 08:34:42 am »

download again version 1.3.1 and replace your existing files. This problem has been fixed. If that doesn't help.... post a link please

Done that, but i still cannot get it to work... Here is a link:

http://www.mbfoto.se/dam/

Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #189 on: January 17, 2007, 09:52:16 am »

you're right, I had forgotten to upload the version 1.3.2... my bad, now 1.3.3 is up

affeee

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Shopping cart
« Reply #190 on: January 17, 2007, 09:57:39 am »

you're right, I had forgotten to upload the version 1.3.2... my bad, now 1.3.3 is up

Thx Stramm! Now it works great. You rock!
Logged

angeldevil

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 107
Re: Shopping cart
« Reply #191 on: January 22, 2007, 04:17:49 pm »

Hi Stramm!

I've translated your  Shopping cart plugin in italian language.

I have made some modifications for italian users and italian site use only.

(I've modified a language file only)

USD ---> Euro

account ---> numero carta (card number)
routing  ---> scadenza carta gg.mm.aa. (expiration date dd.mm.yy)
swifth   ---> codice di controllo (check code - last 3 numbers in the back side of card)

like in italian system card payment.



Per gli utenti Italiani (for Italian users): le modifiche che ho apportato riguardano esclusivamente la valuta e i dati da inserire per effettuare la transazione con carta di credito. Vengono qui utilizzati i dati standard del nostro paese al posto di quelli internazionali come previsto nel MOD di Stramm

****************************************************************************************

Last added: italian language for international site (not italian site) use

« Last Edit: January 24, 2007, 04:26:32 pm by angeldevil »
Logged
a

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #192 on: January 22, 2007, 04:39:00 pm »

Thanks, I've added your lang file to my archive. It'll be included in the next update (photo shop ver. > 1.3.3)

angeldevil

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 107
Re: Shopping cart
« Reply #193 on: January 22, 2007, 04:48:39 pm »

Many thanks Stramm!
Logged
a

shayphoto

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #194 on: January 26, 2007, 06:29:57 pm »

Can I change all references from "CD" to "Other". This would, I think, allow me to offer picture packages containing different photos (rather than duplicates as can be done through the price list) or CD's - only the description would need to be changed.

i.e. CD - 25 photographs
Package 1 - (3) 4x6s of different photos

In which files would I change the references, if this would work?

Thanks
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #195 on: January 26, 2007, 07:11:05 pm »

Should be enough to change that in the lang file. If it's still named 'CD' in the admin shouldn't matter at all (as long as the user won't see it).

so just find everything containing CD in the shop's lang file(s) plugins/photo_shop/lang/yourlang.php and modify it to your needs, eg.

change
Code: [Select]
  'CD' => 'Add to CD',to
Code: [Select]
  'CD' => 'Add to other',

shayphoto

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #196 on: January 27, 2007, 09:34:46 pm »

Thanks Stramm. I am still testing the plugin but will implement your suggestion when I can.

However, a strange problem is occurring when I try ordering prints as either a user or admin, but only with one or two of my image files.

In my test album (weddings), I choose the first image in the album, pick the 4x6 size print, click add then move on to the next print and do the same for the first four prints...always choosing the 4x6 print size. When I click on either the images in cart or checkout buttons, the first file displays with more than one print ordered. Some of the other files do not show up.

Yesterday,I deleted my original install of CPG 1.4.10 and the plugin Photo_Shop ver 1.3.3 and the image files. I also removed the database. Also cleared all cookies.

Today, I did a fresh install of CPG 1.4.10 and Photo_shop plugin. I am using the classic theme. I have only made modifications within Coppermine itself (site name, preferences, etc. - no changes in any files) and the Plugin (set up pricing for the prints). I copied Images from the archive to the Classic themes Images directory. Everything seems to be working except I can reproduce the same issue with the 4x6 prints. It also occurs when choosing the 5x7 prints and the 8x10 prints.

This only seems to happen with the first two prints in the gallery. I have deleted them and reinstalled them but get the same issue.

The installation of CPG with the plugin is at: www.shayphoto.ca/cpg1410

Any thoughts??
Logged

Photocumbria

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: Shopping cart
« Reply #197 on: January 28, 2007, 04:17:51 am »

Hi Stramm,

Thanks for the plugin it works a treat!

Would it be possible to add a couple of buttons to the page where you "confirm your order". This would be to add extra shipping costs to the order.

For example (I'm in the UK) so postage to the UK is auto added, but if the client is in europe they could click to add that extra shipping, or if they where international they click another button to add that particular shipping cost.

Thanks in advance.:)
Logged

Stramm

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Shopping cart
« Reply #198 on: January 28, 2007, 12:16:50 pm »

However, a strange problem is occurring when I try ordering prints as either a user or admin, but only with one or two of my image files.

Indeed, really weird. I tried to replicate it on my loacl install with no success. But I've seen what you mean. The third pic in the mentioned album gets added to pic_id 1 if another pic is already in the cart. And that if the sort order is by filename. By date it acted normal.

Without the possibility to test a few things I only can guess. Find in codebase.php (in photo_shop plugin directory)
Code: [Select]
       else if(photoshop_deep_in_array($value, $value2, $item)) return true;and comment that line out
Code: [Select]
       //else if(photoshop_deep_in_array($value, $value2, $item)) return true;
please tell me if that helped

shayphoto

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: Shopping cart
« Reply #199 on: January 28, 2007, 04:23:47 pm »

Stramm

Have commented out the line as you suggested. Does not seem to help - same issue.

I have left the line commented out if you have time to give it a try.

Unfortunately I am totally unfamiliar with any type of coding so can't be of much help. If there is a way to let you test out a few things, let me know.

Thanks for your time.
Logged
Pages: 1 ... 6 7 8 9 [10] 11 12 13 14 ... 30   Go Up
 

Page created in 0.038 seconds with 21 queries.