VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: tazcabe on April 29, 2014, 19:00:49 PM

Title: 500 - JDatabaseMySQLi::query: 1146
Post by: tazcabe on April 29, 2014, 19:00:49 PM
Good afternoon

I am working in a store which uses virtuemart shopping enable debug mode and I came out the following error:

500 - JDatabaseMySQLi::query: 1146 - Table 'newredno_joomla.dr5bo_virtuemart_product_custom_plg_param' doesn't exist SQL=SELECT `id` FROM `dr5bo_virtuemart_product_custom_plg_param` WHERE `virtuemart_product_id`=xxxxx and `virtuemart_custom_id`=xx

Can you help me please to identify this error referred to, or re address where I can help.

ADD screenshot of what throws me Joomla console, the debug mode.

thanks for your support


Greetings...


[attachment cleanup by admin]
Title: Re: 500 - JDatabaseMySQLi::query: 1146
Post by: GJC Web Design on April 29, 2014, 20:05:32 PM
What if you unpublish the plugins/vmcustom/params plugin?
Title: Re: 500 - JDatabaseMySQLi::query: 1146
Post by: tazcabe on April 30, 2014, 23:10:38 PM
Hi thanks for yor support


Pluging study it for?

Refers to the one shown in the picture?

If I just disable that , and when I enter the product no longer shows me the error 500 , however I make an account I try print_r ( $ cart ) to cart , I realize that many consultations throws me to the Base data that did not cast me are queries like the following :

[99 ] = > SELECT ` ` FROM ` virtuemart_media_id dr5bo_virtuemart_product_medias virtuemart_product_id ` WHERE ` ` = " 49105 " ORDER BY ` ordering `
                            [100 ] = > SELECT ` ` FROM ` virtuemart_shoppergroup_id dr5bo_virtuemart_product_shoppergroups virtuemart_product_id ` WHERE ` ` = " 49105 "
                            [101 ] = > SELECT * FROM ` dr5bo_virtuemart_product_prices virtuemart_product_id ` WHERE ` ` = " 49105 " AND ( ` virtuemart_shoppergroup_id ` = "1 " OR virtuemart_shoppergroup_id ` ` ` IS NULL OR virtuemart_shoppergroup_id ` = " 0") AND ( ( ` IS ` product_price_publish_up product_price_publish_up NULL OR ` ` = " 0000-00-00 00:00:00" OR product_price_publish_up ` ` < = " 2014-04-30 20:55:23 " )
AND ( ` ` IS NULL OR product_price_publish_down product_price_publish_down ` ` = " 0000-00-00 00:00:00" OR product_price_publish_down > = " 2014-04-30 20:55:23 ")) AND ( ( ` IS NULL ` price_quantity_start price_quantity_start ` OR ` = " 0" OR price_quantity_start ` ` < = 1) AND ( ` ` IS NULL OR price_quantity_end price_quantity_end ` ` = " 0" OR ` price_quantity_end `> = 1) ) Hi Thanks for answer

Refers to the one shown in the picture?

If I just disable that , and when I enter the product no longer shows me the error 500 , however I make an account I try print_r ( $ cart ) to cart , I realize that many consultations throws me to the Base data that did not cast me are queries like the following :

[99 ] = > SELECT ` ` FROM ` virtuemart_media_id dr5bo_virtuemart_product_medias virtuemart_product_id ` WHERE ` ` = " 49105 " ORDER BY ` ordering `
                            [100 ] = > SELECT ` ` FROM ` virtuemart_shoppergroup_id dr5bo_virtuemart_product_shoppergroups virtuemart_product_id ` WHERE ` ` = " 49105 "
                            [101 ] = > SELECT * FROM ` dr5bo_virtuemart_product_prices virtuemart_product_id ` WHERE ` ` = " 49105 " AND ( ` virtuemart_shoppergroup_id ` = "1 " OR virtuemart_shoppergroup_id ` ` ` IS NULL OR virtuemart_shoppergroup_id ` = " 0") AND ( ( ` IS ` product_price_publish_up product_price_publish_up NULL OR ` ` = " 0000-00-00 00:00:00" OR product_price_publish_up ` ` < = " 2014-04-30 20:55:23 " )
AND ( ` ` IS NULL OR product_price_publish_down product_price_publish_down ` ` = " 0000-00-00 00:00:00" OR product_price_publish_down > = " 2014-04-30 20:55:23 ")) AND ( ( ` IS NULL ` price_quantity_start price_quantity_start ` OR ` = " 0" OR price_quantity_start ` ` < = 1) AND ( ` ` IS NULL OR price_quantity_end price_quantity_end ` ` = " 0" OR ` price_quantity_end `> = 1) )



[attachment cleanup by admin]
Title: Re: 500 - JDatabaseMySQLi::query: 1146
Post by: tazcabe on May 01, 2014, 00:32:40 AM
Sorry for the previous answer, there was realized I was still active debugger.

Thanks for your support because after pluging off and then re-activate the bug disappeared.