Main Menu

shop problems

Started by BPP, 07 January, 2012, 03:36:39 PM

Previous topic - Next topic

Cactus

I'm seeing this error on the graphic novels tab in the shop:

DBException 'Subquery returns more than 1 row' in /var/www/vhosts/shop.2000adonline.com/httpdocs/includes/classes/pdo_db.php (90) #0 /var/www/vhosts/shop.2000adonline.com/httpdocs/includes/classes/pdo_db.php(186): pdo_db->execute('SELECT NULL FRO...', Array, false) #1 /var/www/vhosts/shop.2000adonline.com/httpdocs/includes/classes/pagination.php(42): shop_db->fetchAll('SELECT NULL FRO...', Array) #2 /var/www/vhosts/shop.2000adonline.com/httpdocs/includes/modules/product_listing.php(22): pagination->paginateQuery() #3 /var/www/vhosts/shop.2000adonline.com/httpdocs/templates/2000AD/content/index_products.tpl.php(3): include('/var/www/vhosts...') #4 /var/www/vhosts/shop.2000adonline.com/httpdocs/templates/2000AD/main_page.tpl.php(180): require('/var/www/vhosts...') #5 /var/www/vhosts/shop.2000adonline.com/httpdocs/index.php(268): include('/var/www/vhosts...') #6 {main}
No Results


Clothing and merchandise have something similar, but the comics tab seems ok.
I'm a tucker hot seat trucker and I'm voking cheerio, ten-ten!

w3bz

Why those errors have started showing up outside development is something I'm going to look into tomorrow. Thanks for the heads up, will get it sorted! ;)

W. R. Logan

Off to camp with Cadets next week so thought I'd treat myself to three new T-shirts.
Shop down so spent my money somewhere else.

w3bz

Fixed - always a pleasure Logan.

Dandontdare

It's probably just as well as it stopped me from a drunken impulse buy, but... I followed the link from latest thrill e-mail but when trying to buy a Nemesis the "add to basket" button doesn't seem to work.

a chosen rider

Quote from: Dandontdare on 14 December, 2012, 11:02:20 PM
It's probably just as well as it stopped me from a drunken impulse buy, but... I followed the link from latest thrill e-mail but when trying to buy a Nemesis the "add to basket" button doesn't seem to work.

I've had this bug buying the digital progs: the "add to basket" buttons on the main index pages give me a 404 error, but if you click the image link to go through to the page for a specific item, the "add" button on there seems to work.  (It also seems that you can't remove things from the basket via the x in the sidebar, only if you click through to the actual basket page and do it from there.)
On Twitter @devilsfootsteps

w3bz

Quote from: a chosen rider on 15 December, 2012, 02:58:59 PM
Quote from: Dandontdare on 14 December, 2012, 11:02:20 PM
It's probably just as well as it stopped me from a drunken impulse buy, but... I followed the link from latest thrill e-mail but when trying to buy a Nemesis the "add to basket" button doesn't seem to work.

I've had this bug buying the digital progs: the "add to basket" buttons on the main index pages give me a 404 error, but if you click the image link to go through to the page for a specific item, the "add" button on there seems to work.  (It also seems that you can't remove things from the basket via the x in the sidebar, only if you click through to the actual basket page and do it from there.)

I'm assuming you're using Internet Explorer? There's a bug since they last updated which has been causing a lot of 404 issues with the store. We've got a fix for it pending but it probably won't be until first thing New Year now :|

500

Quote from: w3bz on 17 December, 2012, 03:35:18 PM
Quote from: a chosen rider on 15 December, 2012, 02:58:59 PM
Quote from: Dandontdare on 14 December, 2012, 11:02:20 PM
It's probably just as well as it stopped me from a drunken impulse buy, but... I followed the link from latest thrill e-mail but when trying to buy a Nemesis the "add to basket" button doesn't seem to work.

I've had this bug buying the digital progs: the "add to basket" buttons on the main index pages give me a 404 error, but if you click the image link to go through to the page for a specific item, the "add" button on there seems to work.  (It also seems that you can't remove things from the basket via the x in the sidebar, only if you click through to the actual basket page and do it from there.)

I'm assuming you're using Internet Explorer? There's a bug since they last updated which has been causing a lot of 404 issues with the store. We've got a fix for it pending but it probably won't be until first thing New Year now :|

*cough* use a better browser *cough*

Dandontdare

How very dare you! I use firefox!

it's okay though, in the cold light of day I've decided I can't justify the cost of this lovely little beasty.

500

Quote from: Dandontdare on 17 December, 2012, 04:41:05 PM
How very dare you! I use firefox!

it's okay though, in the cold light of day I've decided I can't justify the cost of this lovely little beasty.

Hmmmm, I haven't come across this issue in Firefox, will see if I can hunt it down!

Goosegash

Is anyone else having trouble placing orders in the shop? I get as far as the "Confirm Order" button, but absolutely nothing happens when I click it. I've tried in three browsers(Chrome, IE, Opera) and it's the same in all of them.

strontium71

Just been to order the 37th anniversary tee in the shop , and upon checkout a completely different name and address pop up! I haven't used this person for delivery for many years , and have ordered very recently quite a few times with my own name and address. Why they have popped up again is a mystery , but I had to go through and delete them from all the defaults which it has re-put them under.
...because I hate you.