Shopping cart

[colin911]

Here is what i got:

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:

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?

[affeee]

Another great mod /plugin from Straam 

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://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fwww.smileonthetiles.com%2Fimages%2Fphoto_shop_bug.jpg&hash=2bd5766f7711143469e324b8045d178ec9750d36)

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.

[Stramm]

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]

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]

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.

[Stramm]

easy, in photo_shop_admin.php find

Code Select Expand

{$lang_photoshop_admin['size']}: {$size[$k]}<br />
below add

Code Select Expand

<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 Expand

$select_columns = 'filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title';
replace with

Code Select Expand

$select_columns = 'filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, title, owner_name, owner_id';

[colin911]

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.  :-)

[Jeremy Rasmussen]

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!

[affeee]

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/

[Stramm]

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

[affeee]

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!

[angeldevil]

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

[Stramm]

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]

Many thanks Stramm!

[shayphoto]

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

[Stramm]

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 Expand

  'CD' => 'Add to CD',
to

Code Select Expand

  'CD' => 'Add to other',

[shayphoto]

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

[Photocumbria]

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.

[Stramm]

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 Expand

       else if(photoshop_deep_in_array($value, $value2, $item)) return true;
and comment that line out

Code Select Expand

       //else if(photoshop_deep_in_array($value, $value2, $item)) return true;

please tell me if that helped

[shayphoto]

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.