I'm using Joomla! 1.7 and with VM2 I'm hoping to set up a 'catalog only' system. I created a menu item that displays allthe product categories I created but I'm unable to create any products to populate those categories. From the "Product
" page, I click "New" which directs to an HTTP500 error page.
Suggestions would be greatly appreciated!
Dan
Looks like å bug. With php debugging enabled I got an error message about usage of a undefined object called config.
I found that in the file:
administrator/components/com_virtuemart/views/product/view.html.php
the error happed at line 153(?).
$config is defined later at around line 200. So I just moved the line:
$config = JFactory::getConfig();
up above the error line, to line 151.
Now everything is working. I guess devs will fix this in an upcoming build.
The version i tested was Dec 4th.
;D
Yup. That fixed it.
Thank you VERY much for the quick reply and the detailed steps.
Dan
Quote from: svenna on December 05, 2011, 14:45:15 PM
administrator/components/com_virtuemart/views/product/view.html.php
the error happed at line 153(?).
$config is defined later at around line 200. So I just moved the line:
$config = JFactory::getConfig();
up above the error line, to line 151.
Now everything is working. I guess devs will fix this in an upcoming build.
The version i tested was Dec 4th.
ah thanks
in fact it is wrong to user getConfig and use the config dynamically, because static calls already use the dynamic one,.. (yeah sounds crazy). The getConfig at line 199 is for the joomla config, the vm config is used with VmConfig::get
I got this error...plz help
500 - An error has occurred.
JDatabaseMySQL::query: 1054 - Unknown column 'c.category_description' in 'field list' SQL=SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id` WHERE c.`published` = 1 AND cx.`category_parent_id` = 0 ORDER BY c.category_name ASC
Return to Control Panel
Call stack
# Function Location
1 JAdministrator->dispatch() /home/smilyo/public_html/saini/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/smilyo/public_html/saini/administrator/includes/application.php:153
3 require_once() /home/smilyo/public_html/saini/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/admin.virtuemart.php:61
5 VirtuemartControllerProduct->Product() /home/smilyo/public_html/saini/libraries/joomla/application/component/controller.php:684
6 VirtuemartViewProduct->display() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/controllers/product.php:68
7 ShopFunctions->categoryListTree() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/views/product/view.html.php:257
8 ShopFunctions->categoryListTreeLoop() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:628
9 VirtueMartModelCategory->getCategories() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:657
10 VmModel->exeSortSearchListQuery() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/models/category.php:288
11 JDatabase->loadObjectList() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/vmmodel.php:376
12 JDatabaseMySQLi->query() /home/smilyo/public_html/saini/libraries/joomla/database/database.php:975
13 JError::raiseError() /home/smilyo/public_html/saini/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home/smilyo/public_html/saini/libraries/joomla/error/error.php:250
Errors
JDatabaseMySQL::query: 1054 - Unknown column 'c.category_description' in 'field list' SQL=SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id` WHERE c.`published` = 1 AND cx.`category_parent_id` = 0 ORDER BY c.category_name ASC
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home/smilyo/public_html/saini/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/smilyo/public_html/saini/administrator/includes/application.php:153
3 require_once() /home/smilyo/public_html/saini/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/admin.virtuemart.php:61
5 VirtuemartControllerProduct->Product() /home/smilyo/public_html/saini/libraries/joomla/application/component/controller.php:684
6 VirtuemartViewProduct->display() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/controllers/product.php:68
7 ShopFunctions->categoryListTree() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/views/product/view.html.php:257
8 ShopFunctions->categoryListTreeLoop() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:628
9 VirtueMartModelCategory->getCategories() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:657
10 VmModel->exeSortSearchListQuery() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/models/category.php:288
11 JDatabase->loadObjectList() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/vmmodel.php:376
12 JDatabaseMySQLi->query() /home/smilyo/public_html/saini/libraries/joomla/database/database.php:975
13 JError::raiseError() /home/smilyo/public_html/saini/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home/smilyo/public_html/saini/libraries/joomla/error/error.php:250
Profile Information
Application 0.001 seconds (+0.001); 0.51 MB (+0.515) - afterLoad
Application 0.044 seconds (+0.042); 3.30 MB (+2.789) - afterInitialise
Application 0.044 seconds (+0.000); 3.30 MB (+0.000) - afterRoute
Memory Usage
7.48 MB (7,840,140 Bytes)
17 Queries Logged
SELECT `data`
FROM `z2re8_session`
WHERE `session_id` = '483f5b6e8baa294df133ac87ce7088ac'
SELECT extension_id AS "id", element AS "option", params, enabled
FROM z2re8_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM z2re8_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM z2re8_template_styles as s
LEFT JOIN z2re8_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT extension_id AS "id", element AS "option", params, enabled
FROM z2re8_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT `config`
FROM `z2re8_virtuemart_configs`
WHERE `virtuemart_config_id` = "1"
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_products`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_medias`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_ratings`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_categories`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_vendors`
SELECT SQL_CALC_FOUND_ROWS *
FROM `z2re8_virtuemart_products` AS p
ORDER BY p.virtuemart_product_id
LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `z2re8_virtuemart_permgroups`
ORDER BY `group_level`
SELECT `perms`
FROM z2re8_virtuemart_vmusers
WHERE virtuemart_user_id="42"
SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `z2re8_virtuemart_categories` AS c
LEFT JOIN `z2re8_virtuemart_category_categories` AS cx
ON c.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 0
ORDER BY c.category_name ASC
UPDATE `z2re8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:130;s:19:\"session.timer.start\";i:1323149931;s:18:\"session.timer.last\";i:1323153629;s:17:\"session.timer.now\";i:1323153636;s:22:\"session.client.browser\";s:99:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":10:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:6:{s:6:\"search\";s:0:\"\";s:13:\"hideprotected\";s:1:\"1\";s:9:\"client_id\";s:0:\"\";s:7:\"enabled\";s:0:\"\";s:4:\"type\";s:8:\"template\";s:5:\"
group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:11:\"com_content\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"article\";O:8:\"stdClass\":2:{s:4:\"data\";N;s:2:\"id\";a:0:{}}}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:0:{}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:10;}}s:22:\"com_virtuemartcategory\";O:8:\"stdClass\":3:{s:10:\"limitstart\";i:0;s:12:\"filter_order\";s:24:\"c.virtuemart_category_id\";s:16:\"filter_order_Dir\";s:0:\"\";}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:9:\"templates\";O:8:\"stdClass\":3:{s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:9:\"a.element\";s:9:\"orderdirn\";s:0:\"\";}}s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"
limit\";i:10;s:10:\"limitstart\";i:0;}}s:21:\"com_virtuemartproduct\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:11:\"Pankaj Jain\";s:8:\"username\";s:14:\"thehitechpanky\";s:5:\"email\";s:27:\"best.adminwebsite@gmail.com\";s:8:\"password\";s:65:\"6e7a626a3f917a2c5a10027a5986b067:rzXQNmnZIUzJSDojRUE93h3EvQPFqEGX\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-03 15:06:25\";s:13:\"lastvisitDate\";s:19:\"2011-12-03 17:30:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7ae2f2b16ac242aeb30557ca4681779c\";}__vm|a:1:{s:8:\"vmconfig\";s:5952:\"a:152:{s:15:\"shop_is_offline\";s:1:\"0\";s:15:\"offline_message\";s:100:\"T3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLg==\";s:14:\"use_as_catalog\";s:1:\"0\";s:25:\"currency_converter_module\";s:14:\"convertECB.php\";s:15:\"order_mail_html\";s:1:\"1\";s:10:\"dateformat\";s:12:\"JW0vJWQvJXk=\";s:6:\"useSSL\";s:1:\"0\";s:14:\"dangeroustools\";i:0;s:12:\"debug_enable\";s:4:\"none\";s:13:\"google_jquery\";s:1:\"1\";s:6:\"multix\";s:4:\"none\";s:17:\"pdf_button_enable\";s:1:\"1\";s:16:\"show_emailfriend\";s:1:\"1\";s:14:\"show_printicon\";s:1:\"0\";s:26:\"show_out_of_stock_products\";s:1:\"1\";s:14:\"coupons_enable\";s:1:\"0\";s:22:\"coupons_default_expire\";s:3:\"1,D\";s:19:\"weight_unit_default\";s:2:\"KG\";s:16:\"lwh_unit_default\";s:1:\"m\";s:10:\"list_limit\";s:2:\"10\";s:13:\"showReviewFor\";s:3:\"all\";s:10:\"reviewMode\";s:10:\"registered\";s:13:\"showRatingFor\";s:3:\"all\";s:10:\"ratingMode\";s:10:\"registered\";s:19:\"reviews_autopublish\";s:1:\"1\";s:30:\"reviews_minimum_comment_length\";s:3:\"100\";s:30:\"reviews_maximum_comment_length\";s:4:\"2000\";s:10:\"vmtemplate\";s:7:\"default\";s:16:\"categorytemplate\";s:7:\"default\";s:12:\"showCategory\";s:1:\"1\";s:14:\"categorylayout\";s:7:\"default\";s:18:\"categories_per_row\";s:1:\"3\";s:13:\"productlayout\";s:7:\"default\";s:16:\"products_per_row\";s:1:\"3\";s:8:\"vmlayout\";s:7:\"default\";s:13:\"show_featured\";s:1:\"1\";s:25:\"featured_products_per_row\";s:1:\"3\";s:11:\"show_topTen\";s:1:\"1\";s:23:\"topten_products_per_row\";s:1:\"3\";s:11:\"show_recent\";s:1:\"1\";s:11:\"show_latest\";s:1:\"1\";s:19:\"assets_general_path\";s:33:\"components/com_virtuemart/assets/\";s:19:\"media_category_path\";s:35:\"images/stories/virtuemart/category/\";s:18:\"media_product_path\";s:34:\"images/stories/virtuemart/product/\";s:23:\"media_manufacturer_path\";s:39:\"images/stories/virtuemart/manufacturer/\";s:17:\"media_vendor_path\";s:33:\"images/stories/virtuemart/vendor/\";s:17:\"img_resize_enable\";s:1:\"1\";s:9:\"img_width\";s:2:\"90\";s:10:\"img_height\";s:2:\"90\";s:12:\"no_image_set\";s:11:\"noimage.gif\";s:14:\"no_image_found\";s:11:\"warning.png\";s:20:\"browse_orderby_field\";s:23:\"p.virtuemart_product_id\";s:21:\"browse_orderby_fields\";a:4:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:9:\"m.mf_name\";i:3;s:14:\"p.product_name\";}s:20:\"browse_search_fields\";a:6:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:22:\"c.category_description\";i:3;s:9:\"m.mf_name\";i:4;s:14:\"p.product_name\";i:5;s:16:\"p.product_s_desc\";}s:11:\"show_prices\";s:1:\"1\";s:28:\"price_access_level_published\";s:1:\"0\";s:31:\"price_show_packaging_pricelabel\";s:1:\"0\";s:8:\"show_tax\";s:1:\"1\";s:9:\"basePrice\";s:1:\"1\";s:13:\"basePriceText\";s:1:\"1\";s:17:\"basePriceRounding\";s:1:\"2\";s:19:\"variantModification\";s:1:\"1\";s:23:\"variantModificationText\";s:1:\"1\";s:27:\"variantModificationRounding\";s:1:\"2\";s:16:\"basePriceVariant\";s:1:\"1\";s:20:\"basePriceVariantText\";s:1:\"1\";s:24:\"basePriceVariantRounding\";s:1:\"2\";s:16:\"basePriceWithTax\";s:1:\"1\";s:20:\"basePriceWithTaxText\";s:1:\"1\";s:24:\"basePriceWithTaxRounding\";s:1:\"2\";s:25:\"discountedPriceWithoutTax\";s:1:\"1\";s:29:\"discountedPriceWithoutTaxText\";s:1:\"1\";s:33:\"discountedPriceWithoutTaxRounding\";s:1:\"2\";s:22:\"salesPriceWithDiscount\";s:1:\"1\";s:26:\"salesPriceWithDiscountText\";s:1:\"1\";s:30:\"salesPriceWithDiscountRounding\";s:1:\"2\";s:10:\"salesPrice\";s:1:\"1\";s:14:\"salesPriceText\";s:1:\"1\";s:18:\"salesPriceRounding\";s:1:\"2\";s:15:\"priceWithoutTax\";s:1:\"1\";s:19:\"priceWithoutTaxText\";s:1:\"1\";s:23:\"priceWithoutTaxRounding\";s:1:\"2\";s:14:\"discountAmount\";s:1:\"1\";s:18:\"discountAmountText\";s:1:\"1\";s:22:\"discountAmountRounding\";s:1:\"2\";s:9:\"taxAmount\";s:1:\"1\";s:13:\"taxAmountText\";s:1:\"1\";s:17:\"taxAmountRounding\";s:1:\"2\";s:11:\"check_stock\";s:1:\"0\";s:17:\"automatic_payment\";s:1:\"1\";s:18:\"automatic_shipping\";s:1:\"1\";s:20:\"agree_to_tos_onorder\";s:1:\"0\";s:26:\"oncheckout_show_legal_info\";s:1:\"1\";s:24:\"oncheckout_show_register\";s:1:\"1\";s:21:\"oncheckout_show_steps\";s:1:\"0\";s:29:\"oncheckout_show_register_text\";s:47:\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\";s:12:\"seo_disabled\";s:1:\"0\";s:13:\"seo_translate\";s:1:\"0\";s:10:\"seo_use_id\";s:1:\"0\";s:14:\"soap_ws_cat_on\";s:1:\"0\";s:20:\"soap_ws_cat_cache_on\";s:1:\"1\";s:16:\"soap_auth_getcat\";s:1:\"1\";s:16:\"soap_auth_addcat\";s:1:\"1\";s:15:\"soap_auth_upcat\";s:1:\"1\";s:16:\"soap_auth_delcat\";s:1:\"1\";s:22:\"soap_auth_cat_otherget\";s:1:\"1\";s:22:\"soap_auth_cat_otheradd\";s:1:\"1\";s:25:\"soap_auth_cat_otherupdate\";s:1:\"1\";s:25:\"soap_auth_cat_otherdelete\";s:1:\"1\";s:15:\"soap_ws_user_on\";s:1:\"0\";s:21:\"soap_ws_user_cache_on\";s:1:\"1\";s:17:\"soap_auth_getuser\";s:1:\"1\";s:17:\"soap_auth_adduser\";s:1:\"1\";s:16:\"soap_auth_upuser\";s:1:\"1\";s:17:\"soap_auth_deluser\";s:1:\"1\";s:23:\"soap_auth_user_otherget\";s:1:\"1\";s:23:\"soap_auth_user_otheradd\";s:1:\"1\";s:26:\"soap_auth_user_otherupdate\";s:1:\"1\";s:26:\"soap_auth_user_otherdelete\";s:1:\"1\";s:15:\"soap_ws_prod_on\";s:1:\"0\";s:21:\"soap_ws_prod_cache_on\";s:1:\"1\";s:17:\"soap_auth_getprod\";s:1:\"1\";s:17:\"soap_auth_addprod\";s:1:\"1\";s:16:\"soap_auth_upprod\";s:1:\"1\";s:17:\"soap_auth_delprod\";s:1:\"1\";s:23:\"soap_auth_prod_otherget\";s:1:\"1\";s:23:\"soap_auth_prod_otheradd\";s:1:\"1\";s:26:\"soap_auth_prod_otherupdate\";s:1:\"1\";s:26:\"soap_auth_prod_otherdelete\";s:1:\"1\";s:16:\"soap_ws_order_on\";s:1:\"0\";s:22:\"soap_ws_order_cache_on\";s:1:\"1\";s:18:\"soap_auth_getorder\";s:1:\"1\";s:18:\"soap_auth_addorder\";s:1:\"1\";s:17:\"soap_auth_uporder\";s:1:\"1\";s:18:\"soap_auth_delorder\";s:1:\"1\";s:24:\"soap_auth_order_otherget\";s:1:\"1\";s:24:\"soap_auth_order_otheradd\";s:1:\"1\";s:27:\"soap_auth_order_otherupdate\";s:1:\"1\";s:27:\"soap_auth_order_otherdelete\";s:1:\"1\";s:14:\"soap_ws_sql_on\";s:1:\"0\";s:20:\"soap_ws_sql_cache_on\";s:1:\"1\";s:17:\"soap_auth_execsql\";s:1:\"1\";s:24:\"soap_auth_execsql_select\";s:1:\"1\";s:24:\"soap_auth_execsql_insert\";s:1:\"1\";s:24:\"soap_auth_execsql_update\";s:1:\"1\";s:17:\"soap_ws_custom_on\";s:1:\"0\";s:23:\"soap_ws_custom_cache_on\";s:1:\"1\";s:14:\"soap_EP_custom\";s:24:\"VM_CustomizedService.php\";s:16:\"soap_wsdl_custom\";s:18:\"VM_Customized.wsdl\";s:6:\"sctime\";d:1323150358.0862081050872802734375;s:6:\"vmlang\";s:5:\"en_gb\";s:20:\"virtuemart_config_id\";i:1;}\";}__liveupdate|a:0:{}', `time` = 1323153636
WHERE `session_id` = '483f5b6e8baa294df133ac87ce7088ac'
16 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM z2re8_extensions
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level` FROM `z2re8_virtuemart_permgroups`
1 × SELECT `perms` FROM z2re8_virtuemart_vmusers
1 × SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT FOUND_ROWS(
1 × SELECT `config` FROM `z2re8_virtuemart_configs`
1 × SELECT folder AS type, element AS name, params FROM z2re8_extensions
1 × SELECT template, s.params FROM z2re8_template_styles as s LEFT JOIN z2re8_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT `data` FROM `z2re8_session`
1 × SELECT SQL_CALC_FOUND_ROWS * FROM `z2re8_virtuemart_products` AS p
OTHER Tables:
Further
1 × SHOW FULL COLUMNS FROM `z2re8_virtuemart_vendors
1 × UPDATE `z2re8_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:130;s:19:\"session.timer.start\";i:1323149931;s:18:\"session.timer.last\";i:1323153629;s:17:\"session.timer.now\";i:1323153636;s:22:\"session.client.browser\";s:99:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":10:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:6:{s:6:\"search\";s:0:\"\";s:13:\"hideprotected\";s:1:\"1\";s:9:\"client_id\";s:0:\"\";s:7:\"enabled\";s:0:\"\";s:4:\"type\";s:8:\"template\";s:5:\"group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:11:\"com_content\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"article\";O:8:\"stdClass\":2:{s:4:\"data\";N;s:2:\"id\";a:0:{}}}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:0:{}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}s:22:\"com_virtuemartcategory\";O:8:\"stdClass\":3:{s:10:\"limitstart\";i:0;s:12:\"filter_order\";s:24:\"c.virtuemart_category_id\";s:16:\"filter_order_Dir\";s:0:\"\";}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:9:\"templates\";O:8:\"stdClass\":3:{s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:9:\"a.element\";s:9:\"orderdirn\";s:0:\"\";}}s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"limit\";i:10;s:10:\"limitstart\";i:0;}}s:21:\"com_virtuemartproduct\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:11:\"Pankaj Jain\";s:8:\"username\";s:14:\"thehitechpanky\";s:5:\"email\";s:27:\"best.adminwebsite@gmail.com\";s:8:\"password\";s:65:\"6e7a626a3f917a2c5a10027a5986b067:rzXQNmnZIUzJSDojRUE93h3EvQPFqEGX\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-03 15:06:25\";s:13:\"lastvisitDate\";s:19:\"2011-12-03 17:30:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7ae2f2b16ac242aeb30557ca4681779c\";}__vm|a:1:{s:8:\"vmconfig\";s:5952:\"a:152:{s:15:\"shop_is_offline\";s:1:\"0\";s:15:\"offline_message\";s:100:\"T3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLg==\";s:14:\"use_as_catalog\";s:1:\"0\";s:25:\"currency_converter_module\";s:14:\"convertECB.php\";s:15:\"order_mail_html\";s:1:\"1\";s:10:\"dateformat\";s:12:\"JW0vJWQvJXk=\";s:6:\"useSSL\";s:1:\"0\";s:14:\"dangeroustools\";i:0;s:12:\"debug_enable\";s:4:\"none\";s:13:\"google_jquery\";s:1:\"1\";s:6:\"multix\";s:4:\"none\";s:17:\"pdf_button_enable\";s:1:\"1\";s:16:\"show_emailfriend\";s:1:\"1\";s:14:\"show_printicon\";s:1:\"0\";s:26:\"show_out_of_stock_products\";s:1:\"1\";s:14:\"coupons_enable\";s:1:\"0\";s:22:\"coupons_default_expire\";s:3:\"1,D\";s:19:\"weight_unit_default\";s:2:\"KG\";s:16:\"lwh_unit_default\";s:1:\"m\";s:10:\"list_limit\";s:2:\"10\";s:13:\"showReviewFor\";s:3:\"all\";s:10:\"reviewMode\";s:10:\"registered\";s:13:\"showRatingFor\";s:3:\"all\";s:10:\"ratingMode\";s:10:\"registered\";s:19:\"reviews_autopublish\";s:1:\"1\";s:30:\"reviews_minimum_comment_length\";s:3:\"100\";s:30:\"reviews_maximum_comment_length\";s:4:\"2000\";s:10:\"vmtemplate\";s:7:\"default\";s:16:\"categorytemplate\";s:7:\"default\";s:12:\"showCategory\";s:1:\"1\";s:14:\"categorylayout\";s:7:\"default\";s:18:\"categories_per_row\";s:1:\"3\";s:13:\"productlayout\";s:7:\"default\";s:16:\"products_per_row\";s:1:\"3\";s:8:\"vmlayout\";s:7:\"default\";s:13:\"show_featured\";s:1:\"1\";s:25:\"featured_products_per_row\";s:1:\"3\";s:11:\"show_topTen\";s:1:\"1\";s:23:\"topten_products_per_row\";s:1:\"3\";s:11:\"show_recent\";s:1:\"1\";s:11:\"show_latest\";s:1:\"1\";s:19:\"assets_general_path\";s:33:\"components/com_virtuemart/assets/\";s:19:\"media_category_path\";s:35:\"images/stories/virtuemart/category/\";s:18:\"media_product_path\";s:34:\"images/stories/virtuemart/product/\";s:23:\"media_manufacturer_path\";s:39:\"images/stories/virtuemart/manufacturer/\";s:17:\"media_vendor_path\";s:33:\"images/stories/virtuemart/vendor/\";s:17:\"img_resize_enable\";s:1:\"1\";s:9:\"img_width\";s:2:\"90\";s:10:\"img_height\";s:2:\"90\";s:12:\"no_image_set\";s:11:\"noimage.gif\";s:14:\"no_image_found\";s:11:\"warning.png\";s:20:\"browse_orderby_field\";s:23:\"p.virtuemart_product_id\";s:21:\"browse_orderby_fields\";a:4:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:9:\"m.mf_name\";i:3;s:14:\"p.product_name\";}s:20:\"browse_search_fields\";a:6:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:22:\"c.category_description\";i:3;s:9:\"m.mf_name\";i:4;s:14:\"p.product_name\";i:5;s:16:\"p.product_s_desc\";}s:11:\"show_prices\";s:1:\"1\";s:28:\"price_access_level_published\";s:1:\"0\";s:31:\"price_show_packaging_pricelabel\";s:1:\"0\";s:8:\"show_tax\";s:1:\"1\";s:9:\"basePrice\";s:1:\"1\";s:13:\"basePriceText\";s:1:\"1\";s:17:\"basePriceRounding\";s:1:\"2\";s:19:\"variantModification\";s:1:\"1\";s:23:\"variantModificationText\";s:1:\"1\";s:27:\"variantModificationRounding\";s:1:\"2\";s:16:\"basePriceVariant\";s:1:\"1\";s:20:\"basePriceVariantText\";s:1:\"1\";s:24:\"basePriceVariantRounding\";s:1:\"2\";s:16:\"basePriceWithTax\";s:1:\"1\";s:20:\"basePriceWithTaxText\";s:1:\"1\";s:24:\"basePriceWithTaxRounding\";s:1:\"2\";s:25:\"discountedPriceWithoutTax\";s:1:\"1\";s:29:\"discountedPriceWithoutTaxText\";s:1:\"1\";s:33:\"discountedPriceWithoutTaxRounding\";s:1:\"2\";s:22:\"salesPriceWithDiscount\";s:1:\"1\";s:26:\"salesPriceWithDiscountText\";s:1:\"1\";s:30:\"salesPriceWithDiscountRounding\";s:1:\"2\";s:10:\"salesPrice\";s:1:\"1\";s:14:\"salesPriceText\";s:1:\"1\";s:18:\"salesPriceRounding\";s:1:\"2\";s:15:\"priceWithoutTax\";s:1:\"1\";s:19:\"priceWithoutTaxText\";s:1:\"1\";s:23:\"priceWithoutTaxRounding\";s:1:\"2\";s:14:\"discountAmount\";s:1:\"1\";s:18:\"discountAmountText\";s:1:\"1\";s:22:\"discountAmountRounding\";s:1:\"2\";s:9:\"taxAmount\";s:1:\"1\";s:13:\"taxAmountText\";s:1:\"1\";s:17:\"taxAmountRounding\";s:1:\"2\";s:11:\"check_stock\";s:1:\"0\";s:17:\"automatic_payment\";s:1:\"1\";s:18:\"automatic_shipping\";s:1:\"1\";s:20:\"agree_to_tos_onorder\";s:1:\"0\";s:26:\"oncheckout_show_legal_info\";s:1:\"1\";s:24:\"oncheckout_show_register\";s:1:\"1\";s:21:\"oncheckout_show_steps\";s:1:\"0\";s:29:\"oncheckout_show_register_text\";s:47:\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\";s:12:\"seo_disabled\";s:1:\"0\";s:13:\"seo_translate\";s:1:\"0\";s:10:\"seo_use_id\";s:1:\"0\";s:14:\"soap_ws_cat_on\";s:1:\"0\";s:20:\"soap_ws_cat_cache_on\";s:1:\"1\";s:16:\"soap_auth_getcat\";s:1:\"1\";s:16:\"soap_auth_addcat\";s:1:\"1\";s:15:\"soap_auth_upcat\";s:1:\"1\";s:16:\"soap_auth_delcat\";s:1:\"1\";s:22:\"soap_auth_cat_otherget\";s:1:\"1\";s:22:\"soap_auth_cat_otheradd\";s:1:\"1\";s:25:\"soap_auth_cat_otherupdate\";s:1:\"1\";s:25:\"soap_auth_cat_otherdelete\";s:1:\"1\";s:15:\"soap_ws_user_on\";s:1:\"0\";s:21:\"soap_ws_user_cache_on\";s:1:\"1\";s:17:\"soap_auth_getuser\";s:1:\"1\";s:17:\"soap_auth_adduser\";s:1:\"1\";s:16:\"soap_auth_upuser\";s:1:\"1\";s:17:\"soap_auth_deluser\";s:1:\"1\";s:23:\"soap_auth_user_otherget\";s:1:\"1\";s:23:\"soap_auth_user_otheradd\";s:1:\"1\";s:26:\"soap_auth_user_otherupdate\";s:1:\"1\";s:26:\"soap_auth_user_otherdelete\";s:1:\"1\";s:15:\"soap_ws_prod_on\";s:1:\"0\";s:21:\"soap_ws_prod_cache_on\";s:1:\"1\";s:17:\"soap_auth_getprod\";s:1:\"1\";s:17:\"soap_auth_addprod\";s:1:\"1\";s:16:\"soap_auth_upprod\";s:1:\"1\";s:17:\"soap_auth_delprod\";s:1:\"1\";s:23:\"soap_auth_prod_otherget\";s:1:\"1\";s:23:\"soap_auth_prod_otheradd\";s:1:\"1\";s:26:\"soap_auth_prod_otherupdate\";s:1:\"1\";s:26:\"soap_auth_prod_otherdelete\";s:1:\"1\";s:16:\"soap_ws_order_on\";s:1:\"0\";s:22:\"soap_ws_order_cache_on\";s:1:\"1\";s:18:\"soap_auth_getorder\";s:1:\"1\";s:18:\"soap_auth_addorder\";s:1:\"1\";s:17:\"soap_auth_uporder\";s:1:\"1\";s:18:\"soap_auth_delorder\";s:1:\"1\";s:24:\"soap_auth_order_otherget\";s:1:\"1\";s:24:\"soap_auth_order_otheradd\";s:1:\"1\";s:27:\"soap_auth_order_otherupdate\";s:1:\"1\";s:27:\"soap_auth_order_otherdelete\";s:1:\"1\";s:14:\"soap_ws_sql_on\";s:1:\"0\";s:20:\"soap_ws_sql_cache_on\";s:1:\"1\";s:17:\"soap_auth_execsql\";s:1:\"1\";s:24:\"soap_auth_execsql_select\";s:1:\"1\";s:24:\"soap_auth_execsql_insert\";s:1:\"1\";s:24:\"soap_auth_execsql_update\";s:1:\"1\";s:17:\"soap_ws_custom_on\";s:1:\"0\";s:23:\"soap_ws_custom_cache_on\";s:1:\"1\";s:14:\"soap_EP_custom\";s:24:\"VM_CustomizedService.php\";s:16:\"soap_wsdl_custom\";s:18:\"VM_Customized.wsdl\";s:6:\"sctime\";d:1323150358.0862081050872802734375;s:6:\"vmlang\";s:5:\"en_gb\";s:20:\"virtuemart_config_id\";i:1;}\";}__liveupdate|a:0:{}', `time` = 1323153636
1 × SHOW FULL COLUMNS FROM `z2re8_virtuemart_categories
1 × SHOW FULL COLUMNS FROM `z2re8_virtuemart_ratings
1 × SHOW FULL COLUMNS FROM `z2re8_virtuemart_medias
1 × SHOW FULL COLUMNS FROM `z2re8_virtuemart_products