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

Last change: 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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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.


Last change: 05.09.2013 22:01
 
05.09.2013 21:47
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25853
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


Last change: 06.09.2013 22:39
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.