JDatabaseMySQLi query error

Rate this topic: Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.Evaluations: 1, 1.00 on the average.1.00 out of 6 based on 1 vote(s)
GK User
Wed May 21, 2014 11:23 pm
Reply with quote
Report this post
Hello,

I got the following error in the Module News Show Pro GK4 :

JDatabaseMySQLi::query: 1146 - Table 'db.prefix_redshop_category' doesn't exist SQL=SELECT c.category_name AS name, c.category_id AS id, cxref.category_parent_id AS parent FROM hx9f2_redshop_category AS c LEFT JOIN hx9f2_redshop_category_xref AS cxref ON c.category_id = cxref.category_child_id WHERE c.published = 1 ORDER BY c.category_name, cxref.category_parent_id ASC
JDatabaseMySQLi::query: 1146 - Table 'db.prefix_virtuemart_categories_en_gb' doesn't exist SQL=SELECT c.category_name AS name, c.virtuemart_category_id AS id, x.category_parent_id AS parent FROM hx9f2_virtuemart_categories_en_gb AS c LEFT JOIN hx9f2_virtuemart_category_categories AS x ON x.category_child_id = c.virtuemart_category_id LEFT JOIN hx9f2_virtuemart_categories AS cr ON cr.virtuemart_category_id = c.virtuemart_category_id WHERE cr.published = '1' ORDER BY c.category_name, x.category_parent_id ASC
JDatabaseMySQLi::query: 1146 - Table 'db.prefix_virtuemart_shoppergroups' doesn't exist SQL=SELECT sg.shopper_group_name AS name, sg.virtuemart_shoppergroup_id AS id FROM hx9f2_virtuemart_shoppergroups AS sg ORDER BY sg.shopper_group_name ASC

I have never installed redshop or virtuemart. I started my site from the news quick start package for Joomla! 2.5.x.

If help, I uninstalled and installed the template and then found this problem.

Any suggestion ?
User avatar
Junior Boarder

GK User
Thu May 22, 2014 9:36 am
Reply with quote
Report this post
Do you use redSHOP as a data source? It is the latest News Show Pro GK4 version?
User avatar
Platinum Boarder

GK User
Thu May 22, 2014 11:55 am
Reply with quote
Report this post
bkrztuk wrote:Do you use redSHOP as a data source?


Hello,

No, redSHOP is not set as a data source. The data source is set to K2 Categories. In fact, the module work! :) but the error message appears each time I open the module for edit any parameter.

bkrztuk wrote:It is the latest News Show Pro GK4 version?


It is the News Show Pro GK4 ver. 3.3.5. The News Show Pro GK4 installed is the one shipped with the quick start package.

In the module administrator ,when trying to retrieve the update information, it stalls in 'Loading update data from GavicPro Update service...' but nothing is loading.

In the download Joomla! 2.5 extensions area I dont find the version of the module. Only mod_news_pro_gk4_for_responsive_templates.zip and mod_news_pro_gk4_J!25.zip files to download.

How can I know if I have the last version ?

Best,
Pablo.
User avatar
Junior Boarder

GK User
Thu May 22, 2014 12:13 pm
Reply with quote
Report this post
Oh, I found it :)

The last version es News Show Pro GK4 for J!2.5 and responsive templates. Version: 3.3.8 Date released: 03-07-2013

Should I update to that version? Or should I move to the News Show Pro GK5 for J!2.5. Version: 1.5.0 Date released: 19-05-2014

Best,
Pablo.
User avatar
Junior Boarder

GK User
Tue May 27, 2014 7:55 am
Reply with quote
Report this post
If you use News template you should use News Show Pro for non-responsive templates and latest version you will find in our updates area - please try to reinstall module because it looks like something is wrong with detection whether the redSHOP is installed or not.
User avatar
Platinum Boarder

GK User
Tue May 27, 2014 12:00 pm
Reply with quote
Report this post
Hello,

I reinstalled the mod_news_pro_gk4_J!25.zip (File size: 144.53 Kb) module available at https://www.gavick.com/download/joomla- ... owpro.html. I downloaded it from News Show Pro GK4 for J!2.5 and non-responsive templates ( https://www.gavick.com/updates.html?tas ... 40&catid=6 )

According to the extension manager information I have : GK4 3.1.4 07/01/2013

The problem persists. :huh:

Best,
Pablo.
User avatar
Junior Boarder

GK User
Wed May 28, 2014 8:06 am
Reply with quote
Report this post
Could you provide me details to your administrator area via PM ? Please remember to include link to this forum thread in message.
User avatar
Platinum Boarder


cron