unable to create new products

[181trv]

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

[svenna]

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.

[181trv]

 
Yup.  That fixed it. 

Thank you VERY much for the quick reply and the detailed steps.

Dan

[Milbo]

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

[thehitechpanky]

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:

[thehitechpanky]

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