Warning: Invalid argument /com_jshopping/tables/category.php on line 34

05.09.2013 17:10
#1
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Warning: Invalid argument /com_jshopping/tables/category.php on line 34

Hello,

I am trying to use this new version of joomshopping but I get the error you see in the subject line.

I checked the db and the categories and products look ok. In joomla back end the category also looks fine but when clicking on produts in joomla adminstrator I also see these errors:

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in administrator/components/com_jshopping/controllers/products.php on line 101

Warning: Invalid argument supplied for foreach() in libraries/joomla/html/html/select.php on line 504

Warning: Invalid argument supplied for foreach() in administrator/components/com_jshopping/controllers/products.php on line 111


Warning: Invalid argument supplied for foreach() in /home/goingnat/public_html/jfixel/components/com_jshopping/tables/category.php on line 34

Can you please help.

In the debug mode:

JDatabaseMySQLi::query: 1054 - Unknown column 'access' in 'where clause' SQL=SELECT `name_en-GB` as name,`description_en-GB` as description,`short_description_en-GB` as short_description, category_id, category_publish, ordering, category_image FROM `j25fx_jshopping_categories` WHERE category_parent_id = '' AND category_publish = '1' AND access IN (1,1) ORDER BY ordering asc


Joomla: 2.5.14
JoomShopping: 3.15.3
PHP: 5.3.24
MySQL: 5.1.70-cll
Website Url: http://going-natural.com/jfixel/index.php/shop/all-categories

Letzte Änderung: 05.09.2013 17:42
 
05.09.2013 18:58
#2
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Aw: Warning: Invalid argument /com_jshopping/tables/category.php on line 34

Debug mode now says this:
JDatabaseMySQLi::query: 1054 - Unknown column 'prod.currency_id' in 'field list' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_en-GB` as name, prod.`short_description_en-GB` as short_description, prod.product_ean, prod.product_thumb_image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices FROM `j25fx_jshopping_products` AS prod INNER JOIN `j25fx_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `j25fx_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1) AND cat.access IN (1,1) GROUP BY prod.product_id ORDER BY prod.average_rating desc LIMIT 3

 
05.09.2013 21:07
#3
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16472
Quote
Aw: Warning: Invalid argument /com_jshopping/tables/category.php on line 34

problem update.

need update step to step.

 
05.09.2013 21:46
#4
simplesite
Joomshopping forum user no avatar
Name: Mireille Liong
04.12.2011
Posts: 39
Quote
Aw: Warning: Invalid argument /com_jshopping/tables/category.php on line 34

What do you mean step by step? Can I just install the latest version or do I have to install every update one by one? Are there any instructions?
Ok. I searched and found the answer. Thank you.


Letzte Änderung: 05.09.2013 22:01
 
05.09.2013 21:47
#5
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16472
Quote
Aw: Warning: Invalid argument /com_jshopping/tables/category.php on line 34

install all version.

Or Try use "Check DB structure table shop"
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/addons.html?lang=en


Letzte Änderung: 06.09.2013 22:39
 
Copyrights MAXXmarketing GmbH. All Rights Reserved