500 - JDatabaseMySQLi::query: 1146

[tazcabe]

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]

[GJC Web Design]

What if you unpublish the plugins/vmcustom/params plugin?

[tazcabe]

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]

[tazcabe]

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.