Try emptying your template cache under maintainance.
Cheers,
Andreas
Troxy
Joined: 2007-09-03
Posts: 4
Posted: Sun, 2007-09-16 16:04
Quote:
Error (ERROR_BAD_PARAMETER) : Smarty error: unable to read resource: "gallery:modules/checkout/templates/SelectProducts.tpl"
in modules/core/classes/GallerySmarty.class at line 76 (gallerycoreapi::error)
in lib/smarty/Smarty.class.php at line 1591 (gallerysmarty::trigger_error)
in lib/smarty/Smarty.class.php at line 1417 (gallerysmarty::_fetch_resource_info)
in lib/smarty/Smarty.class.php at line 1869 (gallerysmarty::_compile_resource)
in gal1erry/smarty/templates_c/%%507148240/%%11^11D^11DAE665%%module.tpl.php at line 13 (gallerysmarty::_smarty_include)
in lib/smarty/Smarty.class.php at line 1871
in modules/core/classes/GalleryTemplateAdapter.class at line 747 (gallerysmarty::_smarty_include)
in gal1erry/smarty/templates_c/%%507148240/%%C7^C79^C790B080%%theme.tpl.php at line 55 (gallerytemplateadapter::theme)
in lib/smarty/Smarty.class.php at line 1265
in modules/core/classes/GallerySmarty.class at line 61 (smarty::fetch)
in modules/core/classes/GalleryTemplate.class at line 186 (gallerysmarty::fetch)
in main.php at line 479 (gallerytemplate::fetch)
in main.php at line 94
in main.php at line 83
Anyone has answer for this one ?
I did the maintance tasks before but nothing helped .
I'm willing to upload the proper files again just give me a properly working version of the whole gallery without the errors
GeeWiz
Joined: 2007-09-16
Posts: 5
Posted: Mon, 2007-09-17 06:12
Quote:
For the download link, yes you just need to tick the admin check box 'Display download link after purchase' or 'Display download button after purchase', whichever you prefer. The email confirmation is optional, it's to provide the user with a download link that he/she can refer to after the purchase.
I seem to be having trouble getting a download link or button to show. I thought it might have been the ppsandbox, but I just tried w/my own cc and well... The cart and pay worked fine, just NO download button or email. I've checked "Use Unique zip", "Display Download button", "Display Download Link", and "Email Link".
I never saw a button, link or email.. Anyone see what piece I'm missing.
Thanks
eelkcin
Joined: 2007-09-07
Posts: 8
Posted: Mon, 2007-09-17 08:17
I've done all the maintenance - and the problem is still there....
Gallery all works fine - I can add items to the cart - I can complete the order - transfer to paypal - make payment all fine - but when it tries to return to gallery - I get the security violation.....AARRGGHH!
jmcross3
Joined: 2004-10-19
Posts: 9
Posted: Mon, 2007-09-17 14:42
Love the module.
I do have one question. Is there way that you can look at the complete order history for your site?
Thanks in advance.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Mon, 2007-09-17 15:36
jmcross3 wrote:
Is there way that you can look at the complete order history for your site?
Jmcross,
Not at this point. A few users have stated working on an order admin module for Checkout, but so far they have not materialized.
Cheers,
Andreas
Grinch2171
Joined: 2007-09-17
Posts: 8
Posted: Mon, 2007-09-17 16:47
This is a great module and so far it works as expected. However, I was wondering if a feature is available? My client would like his clients to be able to select multiple sizes of the same picture. Currently this is not possible without making multiple orders. Is this a feature currently in development or is this something that needs to be turned on? Any help would be appreciated. Thanks.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Wed, 2007-09-19 09:09
Grinch2171,
You could use different products with different prices in the Cherckout setup to allow different sizes.
Additional logic would be needed to download the correct image if you enable downloading. If you handle it manually with the email option, it should do the job.
Cheers,
Andreas
Grinch2171
Joined: 2007-09-17
Posts: 8
Posted: Wed, 2007-09-19 11:56
Thanks for the response but maybe I wasn't clear.
Downloading is not enabled. He is not using the pay by e-mail. He is using the PayPal module though. He currently has different sizes for his products. 4x6, 5x7, and so on. A client cannot select a 4x6 and a 5x7 of the same picture. I need to know if this is possible or if it is a feature being developed. My client is a wedding photographer and is hoping to use gallery for selling reprints. The ability to select multiple sizes for the same picture is kind of crucial.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Wed, 2007-09-19 16:21
Post removed because of error.
Grinch2171
Joined: 2007-09-17
Posts: 8
Posted: Wed, 2007-09-19 13:25
I was afraid of that. I'll have a look at those files but doubt I will be able to do much with them. Hopefully this will be implemented in the next release.
Dayo
Joined: 2005-11-04
Posts: 1555
Posted: Wed, 2007-09-19 15:00
The Checkout Module has had some awesome work done on it but in your clients case at this time, you might want to be taking a look at zencart.
.
Gallery version = 2.2.2
Default theme = PGtheme 1.3.0
Web Site: dakanji.com
jayhen
Joined: 2007-02-12
Posts: 159
Posted: Wed, 2007-09-19 15:58
Grinch2171 - not sure I've understood. Can't you create Products for each size and select 'Table' for 'Product selection display type'?
jay
Grinch2171
Joined: 2007-09-17
Posts: 8
Posted: Wed, 2007-09-19 16:14
That worked. I didn't know the table layout would give that option. Maybe you should make that more clear in your documentation. It would be nice if the drop-down would work the same way.
Thanks.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Wed, 2007-09-19 16:17
I actually assumed you had tested that option (I don't use it myself) and that it did not allow more than one selection. I should have tested it myself, so sorry for the added confusion.
Cheers,
Andreas
Grinch2171
Joined: 2007-09-17
Posts: 8
Posted: Wed, 2007-09-19 16:27
No problem Andreas. I would prefer to use the drop-down but the table is fine. He only has 7 options at the moment so it isn't that bad looking.
Thanks again for the help.
jayhen
Joined: 2007-02-12
Posts: 159
Posted: Wed, 2007-09-19 17:44
Grinch2171 wrote:
Maybe you should make that more clear in your documentation.
Grinch2171, please feel free to update the documentation. Your contributions are welcomed.
a2zcs
Joined: 2007-07-13
Posts: 15
Posted: Sat, 2007-09-22 13:23
Hi,
Just downloaded the newest versions from the plugins, installed and configured the checkout and the checkout by paypal and just like a couple of other folks I have no pay by paypal button or continue checking out button on the second page of the checkout process. I only have a modify order button and a continue shopping button. No one replied to the others but I'm still hoping someone can help.
don't know where exactly to post this question, but this seems to be the most recently active thread for checkout.
What is the status of the order management or order admin portion? I have read that someone else is working on it, but the last mention I see of that is July 10th. I'd be willing to help out but I wonder what the status is. (granted I have no experience coding for gallery, but I do have experience in php based web application coding)
checkout rocks and helped me set up an e-commerce site for my photographer sister in less than a day. the only thing that it seems to be missing is order management.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Sat, 2007-09-22 18:53
A2zcs,
Have you made sure that both the Paypal and the Email plugin are checked on in the Checkout configuration?
It looks to me as if they may be turned off.
Cheers,
Andreas
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Sat, 2007-09-22 19:00
drjoeward,
Yeah, a few have talked about doing such a module, but so far nothing.
If you have the time, I don't think it is very hard at all to do it, as just about everything is already in the database and you basically just need an interface to the data and a few utility functions.
I should think the API would offer most of the functions needed.
I can't make the time to do it myself now, at least not until a client needs it.
Maybe Jay has some insight to offer if you want to have a go at making such a module.
Cheers,
Andreas
sparkey2006
Joined: 2006-05-16
Posts: 24
Posted: Sun, 2007-09-23 00:34
Jayhen,
I love this module as it has helped me out of a few sticky situations. I noticed early on in the thread you were looking at getting help with documentation? Are you still looking for help with this? As I would like to help if I can! Where might I be able to find it to look through, if you would like some help please let me know or drop a PM with details! Thanks for your efforts!
I built a quick php page that bypasses gallery and just lets me see the orders in the database. (honestly it has more to do with the fact I have no time to learn the gallery api's to code it to exist in the admin pages) nothing too fancy, but it works as a viewer for now. however that's all messed up because of all the dead transactions in the database. I was reading the changelog about running a HouseKeeper to purge the dead transactions, but I cant get that to work since gallery blocks any attempt to directly enter the URL. (makes sense to block hacker attempts)
Anyway, any ides on how to run the purgeDeadTransactions function? I almost wish it ran every time someone started to check out.
Also, on a related topic, I was in the databse and tried to link the transaction to the Paypal IPN data and I cannot seem to find a link between the two. How is it supposed to be linked? or is it?
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Sun, 2007-09-23 13:48
drjoeward wrote:
Anyway, any ides on how to run the purgeDeadTransactions function? I almost wish it ran every time someone started to check out.
Glad to see that you are working on this as many have requested such a module.
As far as I can tell, the purgeDeadTransactions function should in fact run on every checkout, the code is at line 94 in Confirm.inc in the Checkout module.
The actual function is at line 98 in CheckoutTransactionHelper.class and looks straightforward enough.
You could try including this in your script, it should enable you to make use of the API functions, but it might need some more work. It may give you some pointers anyway.
Thanks for the tips. I worked my way through it all this morning. I tried quite a bit to get the API's to work, I think I just need to read more (are there any documents on how to get started writing a plugin?)
Anyway, all of that playing around did result in one thing, and your note saying they should purge automatically. I found a bug in the dpurgeDeadTransactions function. I made the fix and now the dead transactions are purged every time someone enters the checkout. (just as you indicated they should)
Also, if you could post your bugfix here for inclusion in a later version of Checkout, it would be great.
Cheers,
Andreas
drjoeward
Joined: 2007-09-22
Posts: 10
Posted: Sun, 2007-09-23 17:12
Here ya go:
debugging the SQL query I found that the flagPaid check does not seem to work. the flag is NULL in the database for any unpaid transaction and apparently that is not false. So I changed the Query to use a Null Save Equal to look for the 1 (see code snippet below).
function purgeDeadTransactions() {
global $gallery;
$query = '
SELECT
[GalleryCheckoutTransaction::id]
FROM
[GalleryCheckoutTransaction]
WHERE
[GalleryCheckoutTransaction::date] < ?
AND
NOT [GalleryCheckoutTransaction::flagPaid] <=> 1
';
...
and now it does run every time someone enters the checkout.
I'm not able to test it on a different version of Mysql so it may have something to do with my specific install. Here are what versions I'm running.
Gallery version = 2.2.3 core 1.2.0.5
PHP version = 5.1.6 cgi-fcgi
Webserver = Apache/2.2.3 (CentOS)
Database = mysqli 5.0.22, lock.system=flock
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Sun, 2007-09-23 22:03
Excellent, drjoeward.
I hope you will share your work on an orders admin module with us when you feel it is appropriate.
Cheers,
Andreas
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Sun, 2007-09-23 23:08
drjoeward,
I tried your solution, but I could not make it work right away. Also, I think we need to limit the cleanup so that it does not clear entries from other plugins such as the email plugin.
I made the following modifications and it works for me:
$query = '
SELECT
[GalleryCheckoutTransaction::id]
FROM
[GalleryCheckoutTransaction]
WHERE
[GalleryCheckoutTransaction::date] < ?
AND
[GalleryCheckoutTransaction::flagPaid] IS NULL
AND
[GalleryCheckoutTransaction::paymentPlugin] IS NULL
';
Cheers,
Andreas
jayhen
Joined: 2007-02-12
Posts: 159
Posted: Mon, 2007-09-24 09:22
Hi All,
Nice to see this thread active with some useful discussions. And all credit to And_Thy for keeping the thread alive in general!
drjoeward/And_Thy - you're on the right lines, and you were right, And_Thy, with your modification to the SQL query. The only change I would make is to remove the test on the paid flag, it's redundant, you only need to check the paymentPlugin flag. I would like to mention that this bug exists since before I got involved... I'm glad someone took the time to fix it, although in order to integrate it into checkout, I would prefer to move it into the Admin panel as a maintenance action, since it is useful to have a record of empty shopping carts. So unless you really need to purge the empty transactions, drjoeward, I suggest you filter them out when you display them in your order manager instead. You just need to test whether the paymentPlugin has been set for each transaction you display.
sparkey2006 - YES help is needed with documentation! This is the page that needs rewriting : http://codex.gallery2.org/Gallery2:Modules:checkout. If you feel you know the modules sufficiently well, you could edit the page directly, otherwise post a doc here and I, or perhaps And_Thy would also be willing to review it first. The first thing to mention is that people need to tick the payment plugins to be displayed in checkout Admin. Although this, and the permissions to add items to checkout, are two things I'm planning to automate in the next version of checkout. But I'm not sure how long that will be so in the meantime docs relevant to the current version would save a lot of unnecessary problems for people.
jay
sparkey2006
Joined: 2006-05-16
Posts: 24
Posted: Mon, 2007-09-24 12:48
jayhen,
OK Not a problem I will take a look though what is there already and then try to put some text together. Until I get the hang of it I think I may well write out some docs and post them for review. I wouldn't want to have anything in there that was incorrect. Its the least I can do in the circumstances. it might take me some time but if I can help I will.
sparkey2006 - thanks a lot. It's a relief to have some volunteered help, I'm sure if a few people were willing to put a little time into this we could move it forward a lot quicker and waste a lot less time. I'm attaching a doc I wrote for the 0.15 version of checkout, which may help. You can probably just copy and paste parts into your doc, although if you have the time to test and understand them, and improve the doc, that would be even better. But concentrate on getting the basic information across, that would already be a great step forward.
I am going to start a new thread to discuss the order management (that way this can be for help with checkout itself)
on the dead transactions purge, I'll make the change on my setup to purge based on a null plugin type (looking for the null is doing the same thing as the Not <=> 1, since I do not have a complete understanding of the code I just made the smallest change to make it work the way it appeared to be designed to (check for a 1) just in case something else puts in a 0 or some other non-null data that does not match what we were looking for.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Mon, 2007-09-24 17:41
drjoeward, good idea with a new thread.
BTW, the reason I changed your query was because it did not work for me. It returned zero rows.
Following Jayhen's suggestion to limit the search to the paymentPlugin flag, and testing against NULL should give us the stale transaction data we are interested in.
EDIT: Or better yet, as Jeyhen stated. Make this cleanup a maintainance task and remove it from checkout altogether.
Cheers,
Andreas
hagcin
Joined: 2007-09-26
Posts: 4
Posted: Wed, 2007-09-26 01:21
This is an awesome module clean and beautiful.
This module seems as though it could easily be expanded to work with tangible products and thus be a full e-commerce solution. By that I mean, if it is possible to have a custom price for each picture in gallery (added by custom fields or other method) then Gallery can be used to sell any product. For example a can of Tuna could be shipped to a customer by using a picture of a can of Tuna + Description of the Tuna + Price info for a Can of Tuna = E-commerce solution goes beyond ordering prints. while the module can already do this, the matching of the custom field list with check out is problematic for large number of products. Is there a work around for this? or plans to develop it?
Thanks, Checkout Teem
wildguy
Joined: 2007-09-04
Posts: 42
Posted: Wed, 2007-09-26 16:23
Hi all...
I'm using checkout 0.1.18, with checkout by email...
I will be adding our price codes to the checkout module under Products and Prices, instead of trying to list our actual products (we have over 200,000 products). So, the price code will go under Internal Reference, and the Product Name Displayed will list the default size for that price code....
P1 10x13 0.40
P2 11x12 0.56
P3 19x16 1.02
etc.
However, many of our products share the same price code, but deviate from the default size, so is there a way to use the CheckoutPricing custom field (or any other method) to change the display name as well as the price, just for that item?
Thanks in advance for your help!
Gallery version = 2.2.3 core 1.2.0.5
PHP version = 4.4.4 cgi
Webserver = Rapidsite/Apa/1.3.31 (Unix) FrontPage/5.0.2.2510 mod_ssl/2.8.17 OpenSSL/0.9.7c
Database = mysqlt 4.0.27-log, lock.system=flock
Toolkits = ArchiveUpload, LinkItemToolkit, Thumbnail, Gd
Acceleration = none, none
Operating system = IRIX64 www1118 6.5 04091957 IP27
Default theme = wildside
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7
Rows in GalleryAccessMap table = 19
Rows in GalleryAccessSubscriberMap table = 60
Rows in GalleryUser table = 2
Rows in GalleryItem table = 58
Rows in GalleryAlbumItem table = 32
Rows in GalleryCacheMap table = 0
jayhen
Joined: 2007-02-12
Posts: 159
Posted: Wed, 2007-09-26 20:09
hagcin/wildguy - funny that you should both ask more or less the same question at the same time. The use of Custom Fields by checkout is both horrible to use and very limited. I appreciate the compliment about checkout's commercial features, but in reality it is far from being as solid or feature-rich as a decent e-commerce system. Far far from it.
wildguy - no you can't change the product name for individual items.
Development plans are limited basically by funding. Since funding is zero, it's a case of praying that someone sponsors/develops new features, or that I win the lottery and still feel like carrying on development from an island in the Caribbean. checkout will keep moving forward - I'm working on the next release - but slowly for the moment.
wildguy
Joined: 2007-09-04
Posts: 42
Posted: Thu, 2007-09-27 14:24
jayhen
understandable, thanks for your response
hagcin
Joined: 2007-09-26
Posts: 4
Posted: Thu, 2007-09-27 14:53
Thanks for the info. I appreciate the answer. I am not able to donate a house in the Carabean at this time ;-), and cash is not exactly my strong point right now, but if you have a page of requested donations (IE, Hard drives, 1976 poster The Great full dead, Cuban Rum, etc)...You might be surprised what shows up when you put it out there. Thanks, again. Peace.
I've just upgraded my gallery from 2.0 beta to 2.2.3.
I have installed the latest verision of checkout (with the paypal as well) to my server. I just did it again for the 5th time - I downloaded the version 1.18 at the beginning of this thread.
However - it doesn't work. "Checkout" wants an upgrade on my plugins page. I installed version 1.18, but it thinks it has version 1.1 installed. I have permissions wide open on both checkout and checkout wiht paypal on my server. "Cart" is disabled.
When I go to "upgrade" (the only choice it gives me on the plugins page) I get this error:
rror Detail -
Error (ERROR_COLLISION) : Duplicate permission id: checkout.purchase
in modules/core/classes/helpers/GalleryPermissionHelper_advanced.class at line 751 (gallerycoreapi::error)
in modules/core/classes/GalleryCoreApi.class at line 846 (gallerypermissionhelper_advanced::registerpermission)
in modules/checkout/module.inc at line 106 (gallerycoreapi::registerpermission)
in modules/core/classes/GalleryModule.class at line 160 (checkoutmodule::upgrade)
in modules/core/PluginCallback.inc at line 236 (checkoutmodule::installorupgrade)
in modules/core/PluginCallback.inc at line 73 (plugincallbackview::handlecallback)
in main.php at line 433 (plugincallbackview::renderimmediate)
in main.php at line 94
in main.php at line 83
System Information
Gallery version 2.2.3
PHP version 4.4.4 cgi
Webserver Apache/1.3.37 (Unix) mod_jk/1.2.14 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
Database mysql 4.1.22-standard
Toolkits Thumbnail, SquareThumb, Gd
Operating system Linux srv04.allenhost.com 2.6.9-42.ELsmp #1 SMP Tue Aug 15 10:35:26 BST 2006 x86_64
Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/419.3 (KHTML, like Gecko) Safari/419.3
Please help! This is the only bug keeping me from opening my site!
cloustalot
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Fri, 2007-09-28 08:58
cloustalot,
Have you tried a complete uninstall of the checkout modules followed by a manual install?
Cheers,
Andreas
gwc1023
Joined: 2007-09-27
Posts: 2
Posted: Fri, 2007-09-28 10:08
I am interested in the Checkout module but have one question - after a customer has chosen their order and is ready to check out, is there an option to pay either by credit card or to still forward the order but pay by other method (i.e. cash/cheque)? My customers often would be just friends that live nearby and although they would appreciate viewing on the web, would rather give me a cheque next time they see me than use their credit card.
Possible? Thanks.
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Fri, 2007-09-28 10:41
gwc1023,
Yes, this is possible by enabling both the CheckoutPaypal and CheckoutEmail plugins in addition to Checkout itself.
That way the customer would choose how to "pay" in part 2 of the checkout process.
Using PayPal he can pay by Paypal account or credit card and receive the images after payment has cleared.
Using email he can either get the images in an email/download or after you verify payment manually, depending on your configuration.
These settings will apply to all your customers and all checkout enabled items, there is no option atm. to enable specific checkout modules just for specific user groups and/or items.
I have even gone so far as to completely wipe the modules off my server - then reinstall them. I get the same result and error.
Is this a Gallery 2.2.3 glitch?
cloustalot
drjoeward
Joined: 2007-09-22
Posts: 10
Posted: Fri, 2007-09-28 12:49
looking at a few other instances of this it looks like the upgrade broke your installation of checkout (uninstalled most things, but left some parts in the database) removing the code from the server probably isn't going to help. uninstall the plugin (if possible on the plugin page) and then check out this thread. it talks about editing the g2_PermissionSetMap (would be much easier to do with the myphpadmin application if you have access to it.
I don't pretend to know exactly what I'm doing with this, but it looks like a similar error and makes sesnse based on the duplicate permission ID error (checkout is trying to use a permission ID that is already in the permissionSetMap table and thus it is colliding)
-Joe
And_Thy
Joined: 2007-09-12
Posts: 90
Posted: Fri, 2007-09-28 12:59
cloustalot,
No such glitch is known AFAIK.
It is unclear if you have tried this; you could try removing all checkout and cart permissions from your gallery items.
The reason for the error is apparently that the upgrader is trying to make the privilege checkout.purchase, which apparently already exist in the database.
I suppose it could be possible to remove the existing privilege using PHPMyAdmin, but I would suggest caution as it may have unforeseen side effects. Make a backup first if you decide to try it.
Maybe someone else can offer an alternative suggestion?
EDIT: ok, Joe, you beat me to it;) Looks like your suggestion could be it.
Cheers,
Andreas
cloustalot
Joined: 2004-12-14
Posts: 30
Posted: Fri, 2007-09-28 14:36
Using PHPMYAdmin is not going to work for me unless someone with knowledge of the correct values that I am supposed to enter helps me. I am not a programmer and I have no idea how all this works. I looked at the link, but I can't use those values because it is for something completely different.
I can get into PHPMYAdmin and find the database - but from there I am afraid to go further.
Is there anyone who can help? I just want to be able to use checkout from my site like I did before I upgraded 2 days ago.
Please keep in mind that I am not taking responsibility if it blows up. make a backup.
If you have gotten into phpmyadmin and gotten into the database I am also assuming the following
* you were able to find the table.
*you have uninstalled the checkout plugin via the plugins admin page.
if you look in the g2_PermissionSetMap table in phpmyadmin you will see something like the attached image.
By the sounds of your issue it is a problem installing the checkout plugin is that checkout.purchase already exists. In my version of phpmyadmin there is a little red x. clicking that will delete the row and the permission. hopefully this will free up that permission and let you go back and reinstall checkout. it is very important that you have backup, you could use the phpmyadmin export function to do a backup, but with such a simple table you could just use a screenshot. Instructions for screenshot: http://www.wikihow.com/Take-a-Screenshot-in-Microsoft-Windows.
if the fix should fail and you need to add the line back you would have the values to type back in.
If you want, before starting this, you can send me a screen shot of that table (similar to the one I sent you) and I'll gladly look and see if there is any other ideas I have. you can send it to jward at joseph-ward dot info (translate that into an e-mail address). I will be in and out of the office all day so if you send it I can't say I'll get back to you right away, but definitely tonight. I know it seems all convoluted and it really shouldn't happen, but alas these thing do occur. Hopefully we can help you get back up and running.
I can't uninstall Checkout from the plugins page - the only option it gives me is "upgrade" and nothing more...I can only just delete the module directly from my server.
I am in the Middle East, so it's bedtime here. I will try this tomorrow....
upgrade is on the "get more plugins tab" the uninstall is on the "plugins" if checkout does not appear on the plugins tab then just go with the database change.
Posts: 90
Louise,
Try emptying your template cache under maintainance.
Cheers,
Andreas
Posts: 4
Anyone has answer for this one ?
I did the maintance tasks before but nothing helped .
I'm willing to upload the proper files again just give me a properly working version of the whole gallery without the errors
Posts: 5
I seem to be having trouble getting a download link or button to show. I thought it might have been the ppsandbox, but I just tried w/my own cc and well... The cart and pay worked fine, just NO download button or email. I've checked "Use Unique zip", "Display Download button", "Display Download Link", and "Email Link".
I never saw a button, link or email.. Anyone see what piece I'm missing.
Thanks
Posts: 8
I've done all the maintenance - and the problem is still there....
Gallery all works fine - I can add items to the cart - I can complete the order - transfer to paypal - make payment all fine - but when it tries to return to gallery - I get the security violation.....AARRGGHH!
Posts: 9
Love the module.
I do have one question. Is there way that you can look at the complete order history for your site?
Thanks in advance.
Posts: 90
Jmcross,
Not at this point. A few users have stated working on an order admin module for Checkout, but so far they have not materialized.
Cheers,
Andreas
Posts: 8
This is a great module and so far it works as expected. However, I was wondering if a feature is available? My client would like his clients to be able to select multiple sizes of the same picture. Currently this is not possible without making multiple orders. Is this a feature currently in development or is this something that needs to be turned on? Any help would be appreciated. Thanks.
Posts: 90
Grinch2171,
You could use different products with different prices in the Cherckout setup to allow different sizes.
Additional logic would be needed to download the correct image if you enable downloading. If you handle it manually with the email option, it should do the job.
Cheers,
Andreas
Posts: 8
Thanks for the response but maybe I wasn't clear.
Downloading is not enabled. He is not using the pay by e-mail. He is using the PayPal module though. He currently has different sizes for his products. 4x6, 5x7, and so on. A client cannot select a 4x6 and a 5x7 of the same picture. I need to know if this is possible or if it is a feature being developed. My client is a wedding photographer and is hoping to use gallery for selling reprints. The ability to select multiple sizes for the same picture is kind of crucial.
Posts: 90
Post removed because of error.
Posts: 8
I was afraid of that. I'll have a look at those files but doubt I will be able to do much with them. Hopefully this will be implemented in the next release.
Posts: 1555
The Checkout Module has had some awesome work done on it but in your clients case at this time, you might want to be taking a look at zencart.
.
Gallery version = 2.2.2
Default theme = PGtheme 1.3.0
Web Site: dakanji.com
Posts: 159
Grinch2171 - not sure I've understood. Can't you create Products for each size and select 'Table' for 'Product selection display type'?
jay
Posts: 8
That worked. I didn't know the table layout would give that option. Maybe you should make that more clear in your documentation. It would be nice if the drop-down would work the same way.
Thanks.
Posts: 90
I actually assumed you had tested that option (I don't use it myself) and that it did not allow more than one selection. I should have tested it myself, so sorry for the added confusion.
Cheers,
Andreas
Posts: 8
No problem Andreas. I would prefer to use the drop-down but the table is fine. He only has 7 options at the moment so it isn't that bad looking.
Thanks again for the help.
Posts: 159
Grinch2171, please feel free to update the documentation. Your contributions are welcomed.
Posts: 15
Hi,
Just downloaded the newest versions from the plugins, installed and configured the checkout and the checkout by paypal and just like a couple of other folks I have no pay by paypal button or continue checking out button on the second page of the checkout process. I only have a modify order button and a continue shopping button. No one replied to the others but I'm still hoping someone can help.
Any thoughts?
This is the only place I have the permissions allowing the checkout for now, until done testing: http://www.hometownusa.com/gallery2/main.php/v/Stock/Animals/Pekinese
Thanks in advance.
Matt
Posts: 10
don't know where exactly to post this question, but this seems to be the most recently active thread for checkout.
What is the status of the order management or order admin portion? I have read that someone else is working on it, but the last mention I see of that is July 10th. I'd be willing to help out but I wonder what the status is. (granted I have no experience coding for gallery, but I do have experience in php based web application coding)
checkout rocks and helped me set up an e-commerce site for my photographer sister in less than a day. the only thing that it seems to be missing is order management.
Posts: 90
A2zcs,
Have you made sure that both the Paypal and the Email plugin are checked on in the Checkout configuration?
It looks to me as if they may be turned off.
Cheers,
Andreas
Posts: 90
drjoeward,
Yeah, a few have talked about doing such a module, but so far nothing.
If you have the time, I don't think it is very hard at all to do it, as just about everything is already in the database and you basically just need an interface to the data and a few utility functions.
I should think the API would offer most of the functions needed.
I can't make the time to do it myself now, at least not until a client needs it.
Maybe Jay has some insight to offer if you want to have a go at making such a module.
Cheers,
Andreas
Posts: 24
Jayhen,
I love this module as it has helped me out of a few sticky situations. I noticed early on in the thread you were looking at getting help with documentation? Are you still looking for help with this? As I would like to help if I can! Where might I be able to find it to look through, if you would like some help please let me know or drop a PM with details! Thanks for your efforts!
Sparkey.
Gallery successfully used at;
www.photosfromourwedding.co.uk
Posts: 10
I built a quick php page that bypasses gallery and just lets me see the orders in the database. (honestly it has more to do with the fact I have no time to learn the gallery api's to code it to exist in the admin pages) nothing too fancy, but it works as a viewer for now. however that's all messed up because of all the dead transactions in the database. I was reading the changelog about running a HouseKeeper to purge the dead transactions, but I cant get that to work since gallery blocks any attempt to directly enter the URL. (makes sense to block hacker attempts)
Anyway, any ides on how to run the purgeDeadTransactions function? I almost wish it ran every time someone started to check out.
Also, on a related topic, I was in the databse and tried to link the transaction to the Paypal IPN data and I cannot seem to find a link between the two. How is it supposed to be linked? or is it?
Posts: 90
Glad to see that you are working on this as many have requested such a module.
As far as I can tell, the purgeDeadTransactions function should in fact run on every checkout, the code is at line 94 in Confirm.inc in the Checkout module.
The actual function is at line 98 in CheckoutTransactionHelper.class and looks straightforward enough.
You could try including this in your script, it should enable you to make use of the API functions, but it might need some more work. It may give you some pointers anyway.
require_once(modules/core/classes/GalleryCoreApi.class');
require_once(modules/core/classes/GallerySession.class');
GalleryCoreApi::requireOnce('modules/checkout/classes/CheckoutHelper.class');
GalleryCoreApi::requireOnce('modules/checkout/classes/CheckoutItemHelper.class');
GalleryCoreApi::requireOnce('modules/checkout/classes/CheckoutTransactionHelper.class');
Cheers,
Andreas
Posts: 10
Andreas,
Thanks for the tips. I worked my way through it all this morning. I tried quite a bit to get the API's to work, I think I just need to read more (are there any documents on how to get started writing a plugin?)
Anyway, all of that playing around did result in one thing, and your note saying they should purge automatically. I found a bug in the dpurgeDeadTransactions function. I made the fix and now the dead transactions are purged every time someone enters the checkout. (just as you indicated they should)
Posts: 90
Good work, drjoeward.
You should check out the Gallery Codex for tips on writing modules/plugins.
http://codex.gallery2.org/Main_Page
I found this post very enlightning as it explains a lot about G2:
http://gallery.menalto.com/node/36885#comment-134279
These are also useful:
http://codex.gallery2.org/Gallery2:How_To_Write_Scripts
http://codex.gallery2.org/Gallery2:Themes:Reference:Tags
http://codex.gallery2.org/Gallery2:Themes:Reference:Variables
http://gallery.menalto.com/apidoc/index.html
Also, if you could post your bugfix here for inclusion in a later version of Checkout, it would be great.
Cheers,
Andreas
Posts: 10
Here ya go:
debugging the SQL query I found that the flagPaid check does not seem to work. the flag is NULL in the database for any unpaid transaction and apparently that is not false. So I changed the Query to use a Null Save Equal to look for the 1 (see code snippet below).
function purgeDeadTransactions() { global $gallery; $query = ' SELECT [GalleryCheckoutTransaction::id] FROM [GalleryCheckoutTransaction] WHERE [GalleryCheckoutTransaction::date] < ? AND NOT [GalleryCheckoutTransaction::flagPaid] <=> 1 '; ...and now it does run every time someone enters the checkout.
I'm not able to test it on a different version of Mysql so it may have something to do with my specific install. Here are what versions I'm running.
Gallery version = 2.2.3 core 1.2.0.5
PHP version = 5.1.6 cgi-fcgi
Webserver = Apache/2.2.3 (CentOS)
Database = mysqli 5.0.22, lock.system=flock
Posts: 90
Excellent, drjoeward.
I hope you will share your work on an orders admin module with us when you feel it is appropriate.
Cheers,
Andreas
Posts: 90
drjoeward,
I tried your solution, but I could not make it work right away. Also, I think we need to limit the cleanup so that it does not clear entries from other plugins such as the email plugin.
I made the following modifications and it works for me:
$query = ' SELECT [GalleryCheckoutTransaction::id] FROM [GalleryCheckoutTransaction] WHERE [GalleryCheckoutTransaction::date] < ? AND [GalleryCheckoutTransaction::flagPaid] IS NULL AND [GalleryCheckoutTransaction::paymentPlugin] IS NULL ';Cheers,
Andreas
Posts: 159
Hi All,
Nice to see this thread active with some useful discussions. And all credit to And_Thy for keeping the thread alive in general!
drjoeward/And_Thy - you're on the right lines, and you were right, And_Thy, with your modification to the SQL query. The only change I would make is to remove the test on the paid flag, it's redundant, you only need to check the paymentPlugin flag. I would like to mention that this bug exists since before I got involved... I'm glad someone took the time to fix it, although in order to integrate it into checkout, I would prefer to move it into the Admin panel as a maintenance action, since it is useful to have a record of empty shopping carts. So unless you really need to purge the empty transactions, drjoeward, I suggest you filter them out when you display them in your order manager instead. You just need to test whether the paymentPlugin has been set for each transaction you display.
sparkey2006 - YES help is needed with documentation! This is the page that needs rewriting : http://codex.gallery2.org/Gallery2:Modules:checkout. If you feel you know the modules sufficiently well, you could edit the page directly, otherwise post a doc here and I, or perhaps And_Thy would also be willing to review it first. The first thing to mention is that people need to tick the payment plugins to be displayed in checkout Admin. Although this, and the permissions to add items to checkout, are two things I'm planning to automate in the next version of checkout. But I'm not sure how long that will be so in the meantime docs relevant to the current version would save a lot of unnecessary problems for people.
jay
Posts: 24
jayhen,
OK Not a problem I will take a look though what is there already and then try to put some text together. Until I get the hang of it I think I may well write out some docs and post them for review. I wouldn't want to have anything in there that was incorrect. Its the least I can do in the circumstances. it might take me some time but if I can help I will.
Thanks
Sparkey
Gallery successfully used at;
www.photosfromourwedding.co.uk
Posts: 159
sparkey2006 - thanks a lot. It's a relief to have some volunteered help, I'm sure if a few people were willing to put a little time into this we could move it forward a lot quicker and waste a lot less time. I'm attaching a doc I wrote for the 0.15 version of checkout, which may help. You can probably just copy and paste parts into your doc, although if you have the time to test and understand them, and improve the doc, that would be even better. But concentrate on getting the basic information across, that would already be a great step forward.
Posts: 10
I am going to start a new thread to discuss the order management (that way this can be for help with checkout itself)
on the dead transactions purge, I'll make the change on my setup to purge based on a null plugin type (looking for the null is doing the same thing as the Not <=> 1, since I do not have a complete understanding of the code I just made the smallest change to make it work the way it appeared to be designed to (check for a 1) just in case something else puts in a 0 or some other non-null data that does not match what we were looking for.
Posts: 90
drjoeward, good idea with a new thread.
BTW, the reason I changed your query was because it did not work for me. It returned zero rows.
Following Jayhen's suggestion to limit the search to the paymentPlugin flag, and testing against NULL should give us the stale transaction data we are interested in.
EDIT: Or better yet, as Jeyhen stated. Make this cleanup a maintainance task and remove it from checkout altogether.
Cheers,
Andreas
Posts: 4
This is an awesome module clean and beautiful.
This module seems as though it could easily be expanded to work with tangible products and thus be a full e-commerce solution. By that I mean, if it is possible to have a custom price for each picture in gallery (added by custom fields or other method) then Gallery can be used to sell any product. For example a can of Tuna could be shipped to a customer by using a picture of a can of Tuna + Description of the Tuna + Price info for a Can of Tuna = E-commerce solution goes beyond ordering prints. while the module can already do this, the matching of the custom field list with check out is problematic for large number of products. Is there a work around for this? or plans to develop it?
Thanks, Checkout Teem
Posts: 42
Hi all...
I'm using checkout 0.1.18, with checkout by email...
I will be adding our price codes to the checkout module under Products and Prices, instead of trying to list our actual products (we have over 200,000 products). So, the price code will go under Internal Reference, and the Product Name Displayed will list the default size for that price code....
P1 10x13 0.40
P2 11x12 0.56
P3 19x16 1.02
etc.
However, many of our products share the same price code, but deviate from the default size, so is there a way to use the CheckoutPricing custom field (or any other method) to change the display name as well as the price, just for that item?
Thanks in advance for your help!
Gallery version = 2.2.3 core 1.2.0.5
PHP version = 4.4.4 cgi
Webserver = Rapidsite/Apa/1.3.31 (Unix) FrontPage/5.0.2.2510 mod_ssl/2.8.17 OpenSSL/0.9.7c
Database = mysqlt 4.0.27-log, lock.system=flock
Toolkits = ArchiveUpload, LinkItemToolkit, Thumbnail, Gd
Acceleration = none, none
Operating system = IRIX64 www1118 6.5 04091957 IP27
Default theme = wildside
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7
Rows in GalleryAccessMap table = 19
Rows in GalleryAccessSubscriberMap table = 60
Rows in GalleryUser table = 2
Rows in GalleryItem table = 58
Rows in GalleryAlbumItem table = 32
Rows in GalleryCacheMap table = 0
Posts: 159
hagcin/wildguy - funny that you should both ask more or less the same question at the same time. The use of Custom Fields by checkout is both horrible to use and very limited. I appreciate the compliment about checkout's commercial features, but in reality it is far from being as solid or feature-rich as a decent e-commerce system. Far far from it.
wildguy - no you can't change the product name for individual items.
Development plans are limited basically by funding. Since funding is zero, it's a case of praying that someone sponsors/develops new features, or that I win the lottery and still feel like carrying on development from an island in the Caribbean.
checkout will keep moving forward - I'm working on the next release - but slowly for the moment.
Posts: 42
jayhen
understandable, thanks for your response
Posts: 4
Thanks for the info. I appreciate the answer. I am not able to donate a house in the Carabean at this time ;-), and cash is not exactly my strong point right now, but if you have a page of requested donations (IE, Hard drives, 1976 poster The Great full dead, Cuban Rum, etc)...You might be surprised what shows up when you put it out there. Thanks, again. Peace.
Posts: 30
http://www.photograsea.com
Hi
I've just upgraded my gallery from 2.0 beta to 2.2.3.
I have installed the latest verision of checkout (with the paypal as well) to my server. I just did it again for the 5th time - I downloaded the version 1.18 at the beginning of this thread.
However - it doesn't work. "Checkout" wants an upgrade on my plugins page. I installed version 1.18, but it thinks it has version 1.1 installed. I have permissions wide open on both checkout and checkout wiht paypal on my server. "Cart" is disabled.
When I go to "upgrade" (the only choice it gives me on the plugins page) I get this error:
rror Detail -
Error (ERROR_COLLISION) : Duplicate permission id: checkout.purchase
in modules/core/classes/helpers/GalleryPermissionHelper_advanced.class at line 751 (gallerycoreapi::error)
in modules/core/classes/GalleryCoreApi.class at line 846 (gallerypermissionhelper_advanced::registerpermission)
in modules/checkout/module.inc at line 106 (gallerycoreapi::registerpermission)
in modules/core/classes/GalleryModule.class at line 160 (checkoutmodule::upgrade)
in modules/core/PluginCallback.inc at line 236 (checkoutmodule::installorupgrade)
in modules/core/PluginCallback.inc at line 73 (plugincallbackview::handlecallback)
in main.php at line 433 (plugincallbackview::renderimmediate)
in main.php at line 94
in main.php at line 83
System Information
Gallery version 2.2.3
PHP version 4.4.4 cgi
Webserver Apache/1.3.37 (Unix) mod_jk/1.2.14 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
Database mysql 4.1.22-standard
Toolkits Thumbnail, SquareThumb, Gd
Operating system Linux srv04.allenhost.com 2.6.9-42.ELsmp #1 SMP Tue Aug 15 10:35:26 BST 2006 x86_64
Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en) AppleWebKit/419.3 (KHTML, like Gecko) Safari/419.3
Please help! This is the only bug keeping me from opening my site!
cloustalot
Posts: 90
cloustalot,
Have you tried a complete uninstall of the checkout modules followed by a manual install?
Cheers,
Andreas
Posts: 2
I am interested in the Checkout module but have one question - after a customer has chosen their order and is ready to check out, is there an option to pay either by credit card or to still forward the order but pay by other method (i.e. cash/cheque)? My customers often would be just friends that live nearby and although they would appreciate viewing on the web, would rather give me a cheque next time they see me than use their credit card.
Possible? Thanks.
Posts: 90
gwc1023,
Yes, this is possible by enabling both the CheckoutPaypal and CheckoutEmail plugins in addition to Checkout itself.
That way the customer would choose how to "pay" in part 2 of the checkout process.
Using PayPal he can pay by Paypal account or credit card and receive the images after payment has cleared.
Using email he can either get the images in an email/download or after you verify payment manually, depending on your configuration.
These settings will apply to all your customers and all checkout enabled items, there is no option atm. to enable specific checkout modules just for specific user groups and/or items.
Cheers,
Andreas
Posts: 30
http://www.photograsea.com
And_Thy
I have even gone so far as to completely wipe the modules off my server - then reinstall them. I get the same result and error.
Is this a Gallery 2.2.3 glitch?
cloustalot
Posts: 10
looking at a few other instances of this it looks like the upgrade broke your installation of checkout (uninstalled most things, but left some parts in the database) removing the code from the server probably isn't going to help. uninstall the plugin (if possible on the plugin page) and then check out this thread. it talks about editing the g2_PermissionSetMap (would be much easier to do with the myphpadmin application if you have access to it.
http://gallery.menalto.com/node/39993#comment-150055
I don't pretend to know exactly what I'm doing with this, but it looks like a similar error and makes sesnse based on the duplicate permission ID error (checkout is trying to use a permission ID that is already in the permissionSetMap table and thus it is colliding)
-Joe
Posts: 90
cloustalot,
No such glitch is known AFAIK.
It is unclear if you have tried this; you could try removing all checkout and cart permissions from your gallery items.
The reason for the error is apparently that the upgrader is trying to make the privilege checkout.purchase, which apparently already exist in the database.
I suppose it could be possible to remove the existing privilege using PHPMyAdmin, but I would suggest caution as it may have unforeseen side effects. Make a backup first if you decide to try it.
Maybe someone else can offer an alternative suggestion?
EDIT: ok, Joe, you beat me to it;) Looks like your suggestion could be it.
Cheers,
Andreas
Posts: 30
Using PHPMYAdmin is not going to work for me unless someone with knowledge of the correct values that I am supposed to enter helps me. I am not a programmer and I have no idea how all this works. I looked at the link, but I can't use those values because it is for something completely different.
I can get into PHPMYAdmin and find the database - but from there I am afraid to go further.
Is there anyone who can help? I just want to be able to use checkout from my site like I did before I upgraded 2 days ago.
cloustalot
http://www.photograsea.com
Posts: 10
Please keep in mind that I am not taking responsibility if it blows up. make a backup.
If you have gotten into phpmyadmin and gotten into the database I am also assuming the following
* you were able to find the table.
*you have uninstalled the checkout plugin via the plugins admin page.
if you look in the g2_PermissionSetMap table in phpmyadmin you will see something like the attached image.
By the sounds of your issue it is a problem installing the checkout plugin is that checkout.purchase already exists. In my version of phpmyadmin there is a little red x. clicking that will delete the row and the permission. hopefully this will free up that permission and let you go back and reinstall checkout. it is very important that you have backup, you could use the phpmyadmin export function to do a backup, but with such a simple table you could just use a screenshot. Instructions for screenshot: http://www.wikihow.com/Take-a-Screenshot-in-Microsoft-Windows.
if the fix should fail and you need to add the line back you would have the values to type back in.
If you want, before starting this, you can send me a screen shot of that table (similar to the one I sent you) and I'll gladly look and see if there is any other ideas I have. you can send it to jward at joseph-ward dot info (translate that into an e-mail address). I will be in and out of the office all day so if you send it I can't say I'll get back to you right away, but definitely tonight. I know it seems all convoluted and it really shouldn't happen, but alas these thing do occur. Hopefully we can help you get back up and running.
-Joe
Posts: 30
I can't uninstall Checkout from the plugins page - the only option it gives me is "upgrade" and nothing more...I can only just delete the module directly from my server.
I am in the Middle East, so it's bedtime here. I will try this tomorrow....
cloustalot
http://www.photograsea.com
Posts: 10
upgrade is on the "get more plugins tab" the uninstall is on the "plugins" if checkout does not appear on the plugins tab then just go with the database change.