perch shop error

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.

How do I correct it then?

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

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

Thanks

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

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.

I had PayPal shop installed previously.

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!

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?