Forum

Thread tagged as: Addons, Shop

perch shop error

Installing perch shop and all seems correct but when I try and set the currencies and save I get a blank page. There doesn't seem to be any dropdown options as suggested and not in shipping either.

diagnostics:

Perch Runway: 2.8.32, PHP: 5.6.17, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (2.8.32), assets (2.8.32), categories (2.8.32), perch_blog (4.6), perch_forms (1.8.3), perch_gallery (2.8.6), perch_shop_orders (PERCH_SHOP_VERSION), collection_3 (2.8.32), perch_shop_products (1.0.9), perch_shop (1.0.9), perch_shop_paypal (1.2.1), perch_members (1.5)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_gallery', 'perch_members', 'perch_shop', 'perch_blog', 'perch_forms', 'perch_shop_paypal', ); ?>
PERCH_LOGINPATH: /perch
PERCH_PATH: /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com/perch
PERCH_CORE: /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com/perch/core
PERCH_RESFILEPATH: /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com/perch/resources
Image manipulation: GD
PHP limits: Max upload 80M, Max POST 80M, Memory: 128M, Total max file upload: 80M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: www.nickoakleyphotography.com
DOCUMENT_ROOT: /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com
REQUEST_URI: /perch/core/settings/diagnostics/
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php

debug:

Debug Message
[1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='2157fef80294505b2e4c328736f72025' LIMIT 1
UPDATE perch2_users SET userHash='f7271f0397fdb1e091d4bf52ab5c990f' WHERE userID='1'
[45] SELECT p.privKey FROM perch2_user_privileges p
[45] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[1] SELECT collectionID, collectionKey, collectionEditRoles FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
Using template: /addons/apps/perch_shop/templates/shop/currencies/currency.html
Queries: 6
Memory: 4.8244
Array
(
    [type] => 8
    [message] => Use of undefined constant PERCH_SHOP_VERSION - assumed 'PERCH_SHOP_VERSION'
    [file] => /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com/perch/addons/apps/perch_shop_orders/admin.php
    [line] => 3
)
Denise Courtney

Denise Courtney 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Have you checked your error log?


Debug Message [1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='9f52e440c9a908d6363cf6b92aa0ca97' LIMIT 1 UPDATE perch2_users SET userHash='5ca3dee10a3fc9436a2f4422b20e4a89' WHERE userID='1' [45] SELECT p.privKey FROM perch2_user_privileges p [45] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID [1] SELECT collectionID, collectionKey, collectionEditRoles FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_currencies ORDER BY currencyActive DESC, currencyIsCommon DESC, currencyCode ASC LIMIT 0, 24 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_currencies' doesn't exist [1] SELECT FOUND_ROWS() AS `count` SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_currencies ORDER BY currencyActive DESC, currencyIsCommon DESC, currencyCode ASC LIMIT 0, 24 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_currencies' doesn't exist [1] SELECT FOUND_ROWS() AS `count` Queries: 8 Memory: 4.2364 Array ( [type] => 8 [message] => Use of undefined constant PERCH_SHOP_VERSION - assumed 'PERCH_SHOP_VERSION' [file] => /var/sentora/hostdata/nickoakley/public_html/nickoakleyphotography_com/perch/addons/apps/perch_shop_orders/admin.php [line] => 3 )

Hello Is this the correct error log?

Thank you.

Drew McLellan

Drew McLellan 2638 points
Perch Support

It's not, but that's helpful. I'm working on a release to address this and similar issues. It's a server configuration problem.

How do I correct it then?

Drew McLellan

Drew McLellan 2638 points
Perch Support

I'm working on a release to address this and similar issues.

So is there no way I can get it working at the moment? Any idea when this update will be. Sorry to sound impatient by client has already had to wait for me to fit this job in and I will need to try and offer some idea of timescale. Also, what exactly is the problem with my server config that means it work for me? Thank you

Drew McLellan

Drew McLellan 2638 points
Perch Support

The problem is strict mode in MySQL. The release would have been out yesterday, but the high volume of posts here keeps preventing me from getting to it.

Hi Drew Don't want to hassle you but is that release complete yet?

Thanks

Drew McLellan

Drew McLellan 2638 points
Perch Support

Yes, it was out 4 days ago: https://grabaperch.com/news

Thanks Drew but I have downloaded the latest version and I am still getting the same error. Set up works ok until I start adding currency and then get a blank screen,


Debug Message [1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=1 AND u.userHash='b5d2318120d45862fce02ffddfa50354' LIMIT 1 UPDATE perch2_users SET userHash='0dbb712f799a6f42eba0d305ac9c69ab' WHERE userID='1' [45] SELECT p.privKey FROM perch2_user_privileges p [45] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID [1] SELECT collectionID, collectionKey, collectionEditRoles FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_products WHERE 1=1 AND productDeleted IS NULL ORDER BY title ASC LIMIT 0, 1 Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'productDeleted' in 'where clause' [1] SELECT FOUND_ROWS() AS `count` Attempting app installation: perch_shop [1] SHOW TABLES LIKE "perch2_shop_products" [1] SELECT * FROM perch2_category_sets WHERE setSlug='products' LIMIT 1 SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=0 DESC, currencyCode Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_currencies' doesn't exist SELECT * FROM perch2_shop_tax_locations WHERE locationIsHome='1' AND locationDeleted IS NULL LIMIT 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_tax_locations' doesn't exist SELECT * FROM perch2_shop_tax_locations WHERE locationIsDefault='1' AND locationDeleted IS NULL LIMIT 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_tax_locations' doesn't exist SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_tax_groups WHERE 1=1 AND groupDeleted IS NULL ORDER BY groupTitle ASC LIMIT 0, 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_tax_groups' doesn't exist [1] SELECT FOUND_ROWS() AS `count` SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_shipping_zones ORDER BY zoneTitle ASC LIMIT 0, 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_shipping_zones' doesn't exist [1] SELECT FOUND_ROWS() AS `count` SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_shippings WHERE 1=1 AND shippingDeleted IS NULL ORDER BY shippingOrder ASC LIMIT 0, 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_shippings' doesn't exist [1] SELECT FOUND_ROWS() AS `count` SELECT SQL_CALC_FOUND_ROWS DISTINCT * FROM perch2_shop_brands WHERE 1=1 AND brandDeleted IS NULL ORDER BY brandTitle ASC LIMIT 0, 1 Invalid query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nickoakley.perch2_shop_brands' doesn't exist [1] SELECT FOUND_ROWS() AS `count` Queries: 13 Memory: 4.6777
Drew McLellan

Drew McLellan 2638 points
Perch Support

What steps have you followed?

I have followed these steps from installation

Step 1. Add the Shop Files {#files}

Step 2. Edit your apps.php config file {#appsconfig}

Step 3. Create Categories {#categories}

...and thats as far as I can get.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Was this on a clean installation, or an existing one?

I had PayPal shop installed previously.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Have you removed it?

I hadn't completely but have now and the issue the same.

Do you think I should try reloading the new shop from scratch again to make sure all tables etc are created?

That didn't work, error still the same!

Rachel Andrew

Rachel Andrew 394 points
Perch Support

I think you must still have some stuff from the PayPal Shop kicking around. Drop all of the tables (or start in a new install).

This is the same error I am running into, yet I cannot get past creating a category.

Its a fresh, clean install. Yet I get a blank page when trying to make a category in Step 3 of installing shop.

There is also no php error, I even had my VPS support check my logs...nothing.

Yet..blank page.

Any ideas?