Author Topic: unable to create new products  (Read 3106 times)

181trv

  • Beginner
  • *
  • Posts: 2
unable to create new products
« on: December 05, 2011, 04:40:13 am »
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

  • Beginner
  • *
  • Posts: 1
Re: unable to create new products
« Reply #1 on: December 05, 2011, 14:45:15 pm »
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

  • Beginner
  • *
  • Posts: 2
Re: unable to create new products
« Reply #2 on: December 05, 2011, 17:06:01 pm »
 ;D
Yup.  That fixed it. 

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

Dan

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9800
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: unable to create new products
« Reply #3 on: December 05, 2011, 17:36:13 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 should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

thehitechpanky

  • Beginner
  • *
  • Posts: 7
Re: unable to create new products
« Reply #4 on: December 06, 2011, 07:42:25 am »
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

  • Beginner
  • *
  • Posts: 7
Re: unable to create new products
« Reply #5 on: December 06, 2011, 07:43:35 am »
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