Shopping cart

[apd183]

I just wanted to post about a possible display bug with the latest version linked on the first post (1.3.6).  On my checkout page the total section was not right justified, and in the code it appeared that the table that contains most of the main content ended early.  On line 50 of photo_shop_checkout.php there is an endtable() that I commented out and it fixed the problem.

Code Select Expand

//start html output
pageheader($lang_photoshop['checkout']);
starttable('100%', $lang_photoshop['checkout'], 1);
//endtable();
//start all the if else

[Synthea]

I installed this on a client's website (http://www.cheastudio.com/client_proofs/index.php)
and when I go into the config and, for example, delete a line like the 4x6 photo, and hit "save new configuration"
it takes me to this page:
http://www.amywilliamsdesign.com/shoperror.jpg [Edit GauGau] Replaced hotlinked image with attachment [/Edit]
No content, just the top and bottom section is about the easiest way I can explain it.
When I click on shop, then config again, the change it made, but this kinda makes it a pain in the butt to work with.
What's going on? Thanks 

[Stramm]

Maybe the browser or the OS blocks meta refreshes??

[Synthea]

Maybe the browser or the OS blocks meta refreshes??

I have another one set up on another client's website (fullofgracephotography.com) and don't have this problem.

[Stramm]

issue with the theme?

[Synthea]

It must be, it works when I use a default theme, but I can't for the life of me figure out what the problem is (got a migraine though, so I should step away and come back). Any possible ideas?

[Stramm]

Maybe it's a good idea to attach your theme to your next post (zip).

[Synthea]

Sorry I didn't come back, it was my template not the theme. I fixed it. I have a new question, my client wants to offer free shipping if picked up at her studio or a shipping fee if the package is sent directly to the client. Is this possible?

[KimberlyMon]

Is it possible to place products from different providers?

[ib2loud]

you can place whatever products you want

[erika_conn]

http://ceconn.com/photo_gallery

I thought I was doing great and then this happened.  Following your instructions, I added {USER_NAME}
{SITE_ID}
{ORDER_ID}
{PRICE}
{ADMIN}

in the lang/english.pnp file.  Now I get this error when signing in:
Parse error: syntax error, unexpected '{', expecting ')' in /home/cecon46/public_html/photo_gallery/lang/english.php on line 1504

Also, the saved english.php file now reads in part: $lang_photoshop_email_admin = <<<EOT
Hello {ADMIN},

{USER_NAME} just made an order on your site {SITE_NAME}. The id of that order is {ORDER_ID} and the total value {PRICE}.
<a href="{LINK}index.php?file=photo_shop/photo_shop_admin">Click to go to the order manager</a>

This looks right to me but what do I know?  Now I can't even sign in to my site. 

What did I do wrong?

[Nibbler]

Attach the file to your next post and we can tell you.

[Stramm]

use the lang file in the plugins directory... plugins/photo_shop/lang/english.php and not lang/english.php

[erika_conn]

my url

Thank you for your quick response.

I also moved the files as per instructions "Finally move the images from the archive (folder images_to_move) to your themes images directory"

Just to let you know, I have the latest plugin and the latest Coppermine.
I'm not sure that link worked, so here is the file:

Code Select Expand

<?php
/**************************************************
  CPG Photo Shop Plugin for Coppermine Photo Gallery
  *************************************************
  Copyright (c) 2006 Thomas Lange <stramm@gmx.net>
  *************************************************
  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.
  *************************************************
  Coppermine version: 1.4.16
  Photo Shop version: 1.3.6
  $Revision: 1.0 $
  $Author: stramm $
***************************************************/
if (!defined('IN_COPPERMINE'))
{
die('Not in Coppermine...');
}


if (defined('PHOTOSHOP_ORDER_PHP'))
{
$lang_photoshop_email_order = <<<EOT
Hello {USER_NAME},

Thank you for your order at {SITE_NAME} with the order id {ORDER_ID}.
Please transfer USD {PRICE} as soon as possible.
A USD10.00 charge will be added for shipping and handling to Canada, USA and Mexico. Worldwide shipping and handling charge is USD15.00.  This price is per CD.
<a href="{LINK}">{LINK}</a>

{ADMIN}
EOT;


$lang_photoshop_email_admin = <<<EOT
Hello {ADMIN},

{USER_NAME} just made an order on your site {SITE_NAME}. The id of that order is {ORDER_ID} and the total value {PRICE}.
<a href="{LINK}index.php?file=photo_shop/photo_shop_admin">Click to go to the order manager</a>

Other placeholders you can use (blank if these user profile fields haven't been filled in):
user_profile1: {USER_NAME}
user_profile2: {USER_ADDRESS}
user_profile3: {USER_PHONE}
user_profile4: {USER_CELL}
user_profile5: {USER_EMAIL}
user_profile6: {USER_PROFILE6}

Best regards,
{ADMIN}
EOT;

$lang_photoshop_email_attach_header = <<<EOT


Here we can have the invoice header like address etc

FOTOS BY ERIKA
1300 Bloor St., SPH6
Mississauga, ON Canada
01-905-212-9111

EOT;
}

$lang_photoshop_register = array(
  'already_member' => 'Already a member',
);



$lang_photoshop_config = array(
  'save_cfg' => 'Save new configuration',
  'new_item' => 'Create new item',
  'title' => 'Shop configuration',
  'type' => 'Type',
  'price' => 'Price',
  'name' => 'Description',
  'max_items' => 'Max items on CD',
  'priority' => 'Priority',
  //new 1.3
  'update_alb' => 'Update album',
  'reset_alb' => 'Reset album',
  'select_alb' => '&nbsp;&nbsp; ** Choose an album ** ',
  //new 1.3.5
  'ship_item' => 'Shipping',
  'order' => 'Order',
  //new 1.3.6
  'shop_enabled' => 'Shop enabled for this album',
  'all_albs' => 'Set prices for all albums in the (sub)category of this album',
  'per_alb_settings' => 'Per Album Settings',


);

$lang_photoshop = array(
  'type_chckout' => 'Type',
  'item_id_checkout' => 'Item ID',
  'amount_checkout' => 'Amount',
  'total_checkout' => 'Price total',
  'admin_title' => 'Shop', // admin menu button title
  'uninstall' => 'Remove the table that was used to store shop data ?',
  'USD' => 'USD',
  'buy' => 'Add image to shopping basket:',
  'send' => 'Add',
  'CD' => 'Add to CD',
  'CD_price' => 'check basket',
  'added' => 'Item added',
  'cart' =>'Shopping cart',
  'boxcd' =>'Items on CD',
  'boxphoto' =>'Items for print',
  'go' =>'GO',
  'save_amounts' => 'Save new amounts',
  'empty_basket' => 'Empty basket',
  'each' => 'each',
  'title' => 'Title:',
  'filename' => 'Filename:',
  'size' => 'Size:',
  'amount' => 'Amount:',
  'total' => 'Total',
  'pics' => 'pics',
  'pricelist' => 'Pricelist',
  'photos' => 'Photos',
  'cds' => 'CDs',
  'to_many_pics' => 'You have too many pics on the CD, please remove some!',
  'on_cd' => 'On CD',
  'for_print' => 'For print',
  'send_order' => 'Confirm your order',
  'goto_cart_cd' => '<a href="index.php?file=photo_shop/photo_shop_cart&box=cd">Open shopping cart</a>',
  'email_subject_order' => 'Thanks for your order',
  'email_subject_order_admin' => 'You got a new order',
  'email_sent' => 'Thanks for your order.<br> We have sent you a confirmation email! <br>Your order will be processed after payment! <br>',
  'cart_empty' => 'Your shopping cart is empty.<br> Please add some items first!',
  'in_cart' => 'images in cart',
  'checkout' => 'Checkout',
  'to_go' => 'You can add %s more images to your CD till the next price level',
  'to_go_full' => 'The CD is full for this price level',
  'to_go_remove' => 'You have added too many images to your CD. Please remove at least %s item(s)!',
  'shipping' => 'Shipping',
  // gateway integration

  'account' => 'Account Number:',
  'routing' => 'ABA routing:',
  'swift' => 'Swift code:',
  'bank' => 'Bank:',
  'wire' => 'Pay by wire transfer:',

  'paypal' => 'Pay with Paypal:',
  'google' => 'Pay with Google Checkout:',
  'order_id' => 'Order ID:',

  // discount, invoice
  'discount' => 'Discount',
  'myorders' => 'My Orders',

  //1.3.6 continue button
  'continue' => 'Continue shopping',
  );

if (defined('PHOTOSHOP_ADMIN_PHP'))
{
$lang_photoshop_admin = array(
  'u_orders_on_p_pages' => '%d orders on %d page(s)',
  'otime_a' => 'Date ascending',
  'otime_d' => 'Date decending',
  'uid_a' => 'User ID ascending',
  'uid_d' => 'User ID decending',
  'oid_a' => 'Order ID ascending',
  'oid_d' => 'Order ID decending',
  'o_board_title' => 'Shop admin',
  'Active' => 'Active',
  'Archive' => 'Archive',
  'OrdersIn'=>  'Orders in',
  'managefolder' => 'Manage folder',
  'orders' => 'orders',
  'switch' => 'Switch to',
  'go' => 'Go',
  'Orders' => 'Orders',
  'mark_all' => 'Mark / unmark all orders',
  'NoOrders' => 'No orders',
  'SelectedOrders' => 'Selected orders',
  'markarchive' => 'Move to Archive',
  'markactive' => 'Move to Active',
  'delete' => 'Delete',
  'new' => 'New order',
  'viewed' => 'Viewed order',
  'processed' => 'Processed order',
  'order_id' => 'Order ID',
  'items' => 'Items',
  'usd_total' => 'USD total',
  'item_price' => 'Price total',
  'size' => 'Size',
  'config' => 'Config',
  'mark_unviewed' => 'Set unviewed',
  'mark_viewed' => 'Set viewed',
  'mark_payed' => 'Set paid',
  'mark_unpayed' => 'Set unpaid',
  'mark_sent' => 'Set sent',
  'mark_unsent' => 'Set unsent',
  'pos' => 'Paid/ sent',
  'neg' => 'Unpaid/ unsent',
  //new stuff 1.1
  'contains' => 'contains',
  'order_s' => 'order(s)',
  'in_total' => 'In total there are',
  'orders_stored' => 'orders stored',
  'stored_orders' => 'Stored orders in this folder',
  'total_orders' => 'Total orders',
  'noitems' => 'No. items',
  'volume' => 'Order volume',
  'user_id' => 'User ID',
  'sort_by' => 'Sort by',
  'amount' => 'Amount',
  'pid' => 'PID',
  'price_pi' => 'price per item',
  'usd' => 'USD',
  'incl_ship' => 'incl. shipping %discount',
  //1.3
  'filename' => 'Filename',
  //1.4
  'download_zip' => 'Download zip'
  );
}
?>

[Edit GauGau] Added readability of this thread by using the bbcode tags that you're suppossed to use [/Edit]

[erika_conn]

I'll remember that for next time.  Thanks.

[Stramm]

For me your lang file works without problems on my testbed

Hello Stramm,

Thank you for your order at Coppermine Photo Gallery with the order id 2.
Please transfer USD 6.00 as soon as possible.
A USD10.00 charge will be added for shipping and handling to Canada, USA and Mexico. Worldwide shipping and handling charge is USD15.00. This price is per CD.
http://testbed/cpg1418/

Coppermine Photo Gallery





Here we can have the invoice header like address etc



FOTOS BY ERIKA

1300 Bloor St., SPH6

Mississauga, ON Canada

01-905-212-9111





   Item ID              Type       Amount       Price total

         1               4x6            1          USD 2.00





                                                               



                                   For print: 1 pics :: 2.00USD

                                            Shipping :: 4.00USD

                                     --------------------------

                                                 Total: 6.00USD

[erika_conn]

So, what does that mean?  Where did I go wrong? What does the Parse error message mean?
Parse error: syntax error, unexpected '{', expecting ')' in /home/cecon46/public_html/photo_gallery/lang/english.php on line 1504

Should I uninstall the plugin and reinstall and then try again?  Do you think that would be the quickest way to get to the bottom of this?

[Stramm]

That won't help at all cause the error message means you do not have a problem in the photo shop plugin lang file but in your coppermine lang file. Most probably you've edited that one, too (as I already pointed out above). Undo the changes in the coppermine lang file or zip and attach it to your next post or replace it with a working one from the coppermine archive you've downloaded. 

Where to find the lang file you can see in the path within the error message photo_gallery/lang/english.php

[erika_conn]

Oh, how could I have been so stupid.  Thank you, thank you a million times.

Now, on to the next thing, when clicking on "Cart" I get the following error message with this headline:
There was an error while processing a database query.

followed by this note:

While executing query "SELECT * FROM cpg_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

Under that is the following: File: /home/cecon46/public_html/photo_gallery/include/functions.inc.php - Line: 249   Interestingly, there is nothing on that line.

I read some of the others who've received the same or similar error message and I tried the phpMyAdmin database repair but that did nothing.  There is a database in there called COPP1.  I have no idea how it got there.  Would that have been created by Coppermine?

I know I have to do quite a bit of work yet for this shopping cart to work properly.  I hope you don't mind showing me the error of my ways.



I'd start a new topic but I can't figure out when that tab is.  I don't seem to have one.

[Joachim Müller]

I'd start a new topic but I can't figure out when that tab is.  I don't seem to have one.

You can't tsart a new thread on this board, as it is only for valid plugin contributions, and not for support requests. Go one level up to the plugins board - this is where your individual questions should go into.