PDA

View Full Version : Shop not working?


GoWhere?
20th May 2008, 09:09 AM
Is it just me or is the shop not working?

Here is what I get when I ask for a product listing

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '159'

Also can't get to the user CP....

darylr
20th May 2008, 09:18 AM
Hi GoWhere?

Go into the "Forums" Button and the Select the Shop. It works OK

regards

Darylr

GoWhere?
20th May 2008, 09:25 AM
I click on "Go here to our online shop" that works,
Click on say "Handheld GPS" works,
Click on "All Garmin GPS" and I get the error and the same applies to all lower categories. Must just be me...

I tried it in IE (normally use FireFox) and same deal. Strange hey.

darylr
20th May 2008, 10:18 AM
Hi GoWhere?,

Yes, now mine is doing it. It happening in some areas as I tried the free maps and it did the same but in Accessories its OK.

maybe Nick lost something in the Server changeover or updating database or just those pesky little trolls.

regards

DarylR

GoWhere?
20th May 2008, 10:56 AM
Maybe...

PITA becuase I can't get to the info I need so no buying! :-(

Hopefully he'll sort it out soon hey?

Nicko
20th May 2008, 02:57 PM
Hi guys, yes there appears to be a few problems. If there is anything you want from the shop give me a call on the free call number (excludes calls from mobiles) located in the shop.

I will update this thread when it is back to normal.

Nicko
20th May 2008, 08:35 PM
You can access my other online shop www.octapc.com.au

TheGapRovers
20th May 2008, 08:57 PM
So that's the online shop problem sorted but what about the UserCP. I cannot access it either, is anyone else have this problem

Nicko
20th May 2008, 09:30 PM
Yes, changing servers is not an easy task.