Module: Shopping Basket and Paypal

I haven't updated the rest api but I have written more code for the WPG3 and worked with the rest api and rather than being read only its working fine on a test installation
see it working here http://www.halinasplace.net.au/wordpress/about/
I'm yet to update the info back to rest and the gallery - since I'm using the WP Simple Paypal Shopping cart to help with the basket - not sure how this will work with rest just yet but I'm getting there!

Solved but I don't know why. I just uninstalled all the modules I have from module page and reactivated all at the same time.
Now I have translated a little bit of the module in Italian but find that the confirm order page don't work. It seems a table in the database is missing... I search in the forum if I find something, if not I'll be back

Good, now the module work fine and I can also display waiting payments without errors. Why? I don't know, simply now it work.
Have a nice day.

I just installed the version you released on 8/30/10. I was able to activate and configure the module, however the "Add to Basket" button does not work. Also, when I logged in as an admin, the "View Orders" button took me to .../gallery3/basket/view_Orders and I got a 404 page not found error.

It will be highly appreciate if you can help me look into it!

I have a request when you get the time. I'd like an option to remove the Pay Off Line button. It would save me many headaches.

Thanks for the great work.

Is it possible to add the album name to the item when it goes to PayPal and/or is in the basket?
Many thanks, Matt

Just upgraded from win2k3 Gallery 2, to lamp Gallery3 and having trouble installing the basket module. Seems pretty clear it's a mysql error, but I'm not sure how to fix it. Also tried running the table creation code directly in mysql, but i get the same error.

...var/log error:
2011-02-27 13:49:57 -08:00 --- error: exception 'Database_Exception' with message '#1005: Can't create table 'gallery3.products' (errno: 121) [ CREATE TABLE IF NOT EXISTS products (^M
`id` int(9) NOT NULL auto_increment,^M
`name` TEXT NOT NULL,^M
`cost` DECIMAL(10,2) default 0,^M
`description` varchar(1024),^M
`postage_band_id` int(9) default 1,^M
PRIMARY KEY (`id`))^M
ENGINE=InnoDB DEFAULT CHARSET=utf8; ]' in /var/www/html/gallery3/system/libraries/Database_Mysqli_Result.php:27
Stack trace:
see attached txt

mysql error:
ERROR 1005 (HY000): Can't create table 'gallery3.products' (errno: 121)

Various different mysql forums seem to indicate the above error code indicates a foreign key problem or innodb tablespace problem, which means next to nothing to me. Any thoughts?

When I make a change to the price of a photo via edit photo, the new price is implemented. But when the product is added to the basket it takes up the default price. Is there a way to fix this issue?

Aha! A little debug and I solved my own problem.

It seems that an older version of the basket module came along with the 3nids theme. The first time I tried to install basket, there was a failure. However, it had already created some tables in my mysql database. I removed the old basket module and replaced it with the new one downloaded from this thread and tried installing again, which produced the error above.

Using phpMyAdmin, I removed the tables "item_product, product_override, product, postage_band, order". Then, I tried installing again using the admin panel and everything seems fine.

Hi Ben and others here,
I've been trying to get your G3 module up and running on my website and I am well surprised by how smoothly it works, thank you for all the developing!

I've got one question: I want to get the confirmation e-mail, sent to the customer out of the system. I want it to only send it to me, I've got a few reasons for that:
My website is hosted at a different server, then my domain is on. Hosting provider wants the email sender òr the receiver adres to be of the domain the site is hosted on (I host it on a subdomain. Otherwise tbe email sent will be ignored. The problem is I don't want these two sites to be associated. Because of the "from" adres is from a different site, people might get confused. Also because the adress the email is sent from, is called "WordPress". Besides that, one domain/site is strict private and my other site/domain/gallery is for ordering purposes etc.

Therefore, I'd like to remove the part in the code where a confirmation e-mail is sent to the customer. Instead, I want it to email the confirmation only to me, so that I can edit out the other domain and sent a neat e-mail to the customer manually. All the processing of payments and ordering prints already has to be done completely manual, so it is no problem for me to send a short mail manually.

I hope you can point me the lines in the code which sent out the email to the customer. You might even want to add this as a feature (to turn off that customer mail.) I tried looking for it, but I'm not exactly a php genius unfortunately!

Once again thank you very much again for the great system, it just needs some tweaking for my personal use..

Coupons? Possible in the future?

Great module. Flawless so far.

Great module. One issue that I can't see that's been covered here? Please correct me if I'm wrong.

Just upgraded to Gallery3.0.1 and while the basket is working in Firefox 4 and IE9, in IE8 the add to basket button is non-responsive. Has anyone come across this problem before?

I can't hope that my customers will be using IE9 (mostly I always hope they are using FF!) to prevent this.

Javascript is enabled.

I'm a designer rather than a developer so it's possible I broke something in the transfer of the modules when I upgraded but as it's just IE8 I didn't know if it was a bug or if it was me.

Any advice appreciated, I was really close to going live with my gallery!

If you need more info or links please let me know? Thanks

Serge,
THANK YOU!!!! I'm a total noob at code but I managed to figure out where to put the files and LOVE the add on.
For anyone else
/gallery3/modules/basket/views/basket_block.html_.php
/gallery3/modules/basket/helpers/basket_block.php
http://ourlocalphotographer.com promoting wedding and portrait photographers in Chattanooga

There are several posts with your problem and the fix:
use version 5 from www.gallerymodules.com.
This version also contains an option to use the sidebar.

About the translations: you can share your improvements via Admin > Settings > Languages. Help us improve the module (as I'm trying).

Jeroen
www.kidsfotos.nl

I have been told that this module calls the php mail function directly, instead of using the sendmail library? Could this possibly be changed? I cannot get php mail to work on my site, but have got the PHPMailer module up and running. WOuld like to use this if possible.

Great mod but I get a weird msg when adding items to the basket:
[img]https://lh4.googleusercontent.com/-6T3BQgvJs4g/TjwAaSSGmJI/AAAAAAAAB5M/-pdHjgJ3Bzk/Capture.JPG[/img]
Any ideas?

I fixed this by installing the latest version which is hidden someone where in this thread, page 3 I think.
It's crazy when you have to go through this entire thread looking to see if there is a newer version as the natural thing to do is download the one on page one - that's the one that is a beta and very old.
Why not overwrite the downloadable file with the latest, that way you don't need to keep posting the new URL for the latest version?

I apologize if I should have created a new post for this issue. I am having two serious issues with the Basket module.

1. Using Internet Explorer 8 when I click on +Add To Basket and then Add either A. nothing happens and the Add button becomes grayed out OR B. the page refreshes but nothing is added to the basket. I don't just have this problem on one machine either. I get the same results on three different PCs running Windows XP with IE8. This function works fine in both Firefox and Safari. When the Add button is grayed out the only thing that you can do is click on the X to close the popup window or click on Cancel.

2. The second issue is that after a visitor enters their contact information and clicks on the Pay with Credit Card or Paypal button you are directed to the Processing screen and then to blank screen. You are not directed to PayPal's website. Where it reads "If you are not automatically redirected to paypal within 5 seconds Click Here." you ARE directed to PayPal if you click on the Click Here link. However, again, if you just wait to be taken to PayPal you will get a blank white screen.

I have tried disabling all other non-core modules and nothing makes any difference. I am using Gallery 3.0.1 and Basket version 5.

The url of the site that I am referring to is gallery.forevermomentspa.com

Any ideas?

Hello,

i'm very new to G3 using&costomization (since yesterday)

i recognises that this great basket modul breakes the pages modul at the darkdragon theme
for me in the moment it is too complex to unterstand why

maybe its something in the theme, maybe this problem affairs other themes too
in my configuration the pages modul only works when i turnoff the basket modul

the pages modul only display the navigation links, this is working nice
but no content, title and body arn't displayed

I have some basket mods regarding only allowing registered users to place orders, enabling proper coding of the view order link, for normal registered users to just see their own orders, rather than admin-rated users who can see all orders. i'm pretty sure it does not work on the issued version.

While i can share the mods, is anyone there to help me sort out the modified module, and do the github side of things?
although i do php, the machinations of github are possibly beyond me if thats required.

And for instance, I'm using greydragon theme mostly, maybe other themes won't work.. so it needs some independent testing before letting it loose finally.

I'm not sure I want to take responsibility for publicising these mods long term, but they are useful in a site i'm creating with gallery 3.0.4, for a group of artists which includes me.

Please p.m me if it would bung up the thread with long discussions on this.

RECOMMENDED READING ABOUT BASKET
First I have to say how impressed I am with the work that that glooper has done on basket - Gallery3 is brilliant but a gallery without a shopping cart is pretty much like a Ferrari without wheels - still nice to look at but not much use!; and there are lots of very nice javascripts available to put an 'album' on a website. I personally believe that 'basket' should be part of the core functionality - which would have eliminated some of the problems I am seeing.
I have now read this thread completely from start to finish just to make sure I am not missing something
There appears to be a significant problem with version control for this module.
1.In the thread (on 30th August 2010) glooper includes a link to the release of Version 5 - checking the files in the zip (see the image basket_3.zip.jpg) the dates are correct so we can be fairly sure that this was basket version 5 as released.
2.On Gallery3:Modules:basket http://codex.gallery2.org/Gallery3:Modules:basket, under Installation there is the comment

(@rwatcher). This is the official documentation for basket? right? so is definitive? Well no - what the hell is the CURRENT VERSION? what version did the comment refer to? looking at the contents of the 'recommended' zip (see the image basket-rwedit.zip.jpg) we see that the creation/modification dates are all 2012-01-23 - almost 16 months after the apparent initial release of version 5 but it is still referred to as Version 5?
3. So, ignoring the note (since the file dates pre-date the release of 3.0.4) getting the module from Download: Via Gallery Modules ‎and certainly up to only a few days ago (I believe as recently as Thursday) the contents of the zip file were as the image basket.zip.jpg and all file dates are 2012-06-28. Completely coincidently I first downloaded THAT module on the same day it was released. As of this evening the file downloaded is dated 2012-11-27 and all create/modify dates are the same 2012-11-27 but it is still referred to as Version 5?

So over 27 months we have four different files - all identified as Version 5 - and we still have the comment to not use the Gallery3:Modules:basket which you might ignore based on dates - but who is to know what version was used for any updates in this release? I have tried, and failed, with all three of the earlier versions (they all install, but none run properly) but since I have only just seen the 27-Nov version I still have that to try!

@nivekiam made some comment in some post 'not to include links to modules in posts - this is critical and the practise should be absolutely banned.

it appears that @glooper is no longer around (his last post appears to be 17 December 2010 - does this mean that there is no further development on basket (and WHO did WHAT changes on 28 June 2012 and 27 November 2012???)...
...I can already hear the response to that comment - if you want some changes or support why not get involved - but I am a photographer not a programmer. I am technically competent (I was building computers [not pc's] before most of you were around - in fact some of the more elderly of you might have used the computers I built on your computer science degree course; I can read and understand HTML, javascript and PHP (and can build basic websites using HTML XHTML ASP javascript and CSS2/3. But I simply can't spend 18 months (@alecmyers) learning to program in PHP and learning how Kohana works - I simply want a shopping basket that works now.

What I'd like to do right now is clinically remove basket (so there is no trace of it whatsoever) and start again. As I said right at the top of this post basket is great (as is Gallery3) but the shopping cart should be part of core functionality. If I can't get a working solution I'll have to look for a different solution

Hi hareslade
Not much point in listing problems on the thread - I am using Windows!
Vista SP2; Apache 2.2.22(WIN32) SSL; PHP 5.2.17; MySql 5.5.23 - it all works but is not supported! My myphpadmin MySQL version (5.051a) does not match the standalone MySQL - but because it is windows it is difficult to bring them into sync - though I accept this disparity might be part of my problem (by updating config files from myphpadmin ). I am using an ampp for my webserver - but have replaced every component from the original (apart from the MySQL driver). All of this on a private server whilst I customise and check functionality before going live on my ISP's unix box. I don't have strong feelings about the lack of windows support - but it makes life interesting

Until sometime last week the file at http://codex.gallery2.org/Gallery3:Modules:basket, had dates of 28 June; that then changed to 27 November.
I am not really in a position to say what my problems are - all I have is the configuration screens - though, when adding ANY configuration detail, I get a dang page in a small non-resizeable/non-scrollable window so I can't see what the error is. I can do the configurations using MySQL myphpadmin - and the values then appear in the configuration screens. But I can't move beyond that - there is no 'add to basket' link! There is a basket heading in the sidebar - but nothing else.

I will try the new basket module (27 Nov) sometime this week - and update if I see a difference

If you are working privately on basket, here is a thought for you - I believe the ideal Gallery (any gallery) based shopping cart should allow you to add to cart, select options, manage the cart (remove items, change quantities)...
...but clicking on checkout should take you to a proper cart which uses REST to pull the data from the Gallery basket. Most Cart applications have already done the work on shipping, taxes etc (though OpenCart doesn't appear to do a great job on taxes) - so why re-invent the wheel? My reasoning - you can also use the other cart to sell services, goods, etc.
If you complete your modifications will you make your cart available as an alternative third-party module?

Duh! Yes I can see basket errors in the log file - don't know what they mean yet but since I have just removed basket (just before reading your post) I am not going to worry about it at the moment. I am now going to clear all caches, temp files, everything and install the 'new' basket - but only in a couple of days time.
Thanks for the tip about local.php - I'll look into that.

Hi,

As the postage cost are linked to a product, there is no easy way to do it with configuration only (unless you define 'German' and 'Austrian' products).
Also, the postage cost are displayed in the first checkout screen. Your customer hasn't filled in his address and country. Changing that would be a major (coding) change to the Basket module.

Alternatively, you could code an extra charge, in case the country is not Germany. The checkout screen would need a notification that the shown posting costs only apply to German orders.

Best, Jeroen
www.kidsfotos.nl

I'm not sure I understand what you have in mind: you could code a checkbox similar to the 'allow pickup' checkbox, to indicate a foreign address. If the customer checks it, you add a fixed amount to the order. This is not a 'product'.
To do that, you must edit the checkout screen (in views) and modify the basket fuctions (in helpers) to get the right amount.

Hope that helps.
Best, Jeroen