News:

Support the VirtueMart project and become a member

Main Menu

Major errors with update/fresh install....

Started by Wicked69ng, February 16, 2012, 22:20:48 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

Wicked69ng

February 16, 2012, 22:20:48 PM
PHP Version:    5.2.17
Web Server:    Apache
Web Server to PHP interface:    cgi-fcgi
Joomla! Version:    Joomla! 1.5.14 Stable [ Wojmamni Ama Naiki ] 30-July-2009 23:00 GMT
VirtueMart Version: 1.1.8 (was installed)

I deleted the component, deleted all databases via phpMyAdmin that had extension _vm_ or _vitruemart_, browsed all folders via ftp checking for vm or virtuemart and found none... Attempted to install Virtue Mart 2.0.0 and I get a HUGE list of errors.... What am I missing.... Also notice at the end it says "Update Successful" Im not TRYing to update, screw what I had in the store Im prepared to completely rebuild it... no I dont have a backup of the site prior to store development.....here is the error listing....

Code Select

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
JInstaller::install: /home/content/49/8419449/html/administrator/components/com_virtuemart/install/install.sql COM_VIRTUEMART_SQL_ERROR DB function failed with error number 1074
Column length too big for column 'vendor_accepted_currencies' (max = 255); use BLOB or TEXT instead SQL=-- -------------------------------------------------------- -- -- Table structure for table `jos_virtuemart_vendors` -- CREATE TABLE IF NOT EXISTS `jos_virtuemart_vendors` ( `virtuemart_vendor_id` smallint(1) UNSIGNED NOT NULL AUTO_INCREMENT, `vendor_name` char(64), `vendor_currency` int(11), `vendor_accepted_currencies` varchar(1024) NOT NULL DEFAULT '', `vendor_params` text, `created_on` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) NOT NULL DEFAULT '0', `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(11) NOT NULL DEFAULT '0', `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `locked_by` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`virtuemart_vendor_id`), KEY `idx_vendor_name` (`vendor_name`) -- KEY `idx_vendor_category_id` (`vendor_category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Vendors manage their products in your store' AUTO_INCREMENT=1 ;
SQL =
-- --------------------------------------------------------

--
-- Table structure for table `jos_virtuemart_vendors`
--

CREATE TABLE IF NOT EXISTS `jos_virtuemart_vendors` (
  `virtuemart_vendor_id` smallint(1) UNSIGNED NOT NULL AUTO_INCREMENT,
  `vendor_name` char(64),
  `vendor_currency` int(11),
  `vendor_accepted_currencies` varchar(1024) NOT NULL DEFAULT '',
  `vendor_params` text,
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by` int(11) NOT NULL DEFAULT '0',
  `modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(11) NOT NULL DEFAULT '0',
  `locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `locked_by` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`virtuemart_vendor_id`),
  KEY `idx_vendor_name` (`vendor_name`)
--  KEY `idx_vendor_category_id` (`vendor_category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Vendors manage their products in your store' AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'category_description' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_category_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'product_s_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'vendor_store_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'payment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'shipment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'category_description' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_category_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'product_s_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'vendor_store_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'payment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'shipment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Wicked69ng

#1
February 16, 2012, 22:21:32 PM
Then....

Code Select


Tablename jos_virtuemart_adminmenuentries dropped: 0 altered: 8 added: 0
Tablename jos_virtuemart_calcs dropped: 0 altered: 22 added: 0
Tablename jos_virtuemart_calc_categories dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_calc_shoppergroups dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_calc_countries dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_calc_states dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_categories dropped: 0 altered: 14 added: 0
Tablename jos_virtuemart_category_categories dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_category_medias dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_countries dropped: 0 altered: 10 added: 0
Tablename jos_virtuemart_coupons dropped: 0 altered: 13 added: 0
Tablename jos_virtuemart_currencies dropped: 0 altered: 11 added: 0
Tablename jos_virtuemart_customs dropped: 0 altered: 23 added: 0
Tablename jos_virtuemart_manufacturers dropped: 0 altered: 9 added: 0
Tablename jos_virtuemart_manufacturer_medias dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_manufacturercategories dropped: 0 altered: 8 added: 0
Tablename jos_virtuemart_medias dropped: 0 altered: 20 added: 0
Tablename jos_virtuemart_migration_oldtonew_ids dropped: 0 altered: 1 added: 0
Tablename jos_virtuemart_modules dropped: 0 altered: 6 added: 0
Tablename jos_virtuemart_orders dropped: 0 altered: 18 added: 0
Tablename jos_virtuemart_order_histories dropped: 0 altered: 11 added: 0
Tablename jos_virtuemart_order_items dropped: 0 altered: 11 added: 0
Tablename jos_virtuemart_orderstates dropped: 0 altered: 12 added: 0
Tablename jos_virtuemart_order_userinfos dropped: 0 altered: 15 added: 0
Tablename jos_virtuemart_paymentmethods dropped: 0 altered: 14 added: 0
Tablename jos_virtuemart_paymentmethod_shoppergroups dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_products dropped: 0 altered: 17 added: 0
Tablename jos_virtuemart_product_categories dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_product_shoppergroups dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_product_customfields dropped: 0 altered: 13 added: 0
Tablename jos_virtuemart_product_downloads dropped: 0 altered: 14 added: 0
Tablename jos_virtuemart_product_medias dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_product_manufacturers dropped: 0 altered: 1 added: 0
Tablename jos_virtuemart_product_prices dropped: 0 altered: 8 added: 0
Tablename jos_virtuemart_product_relations dropped: 0 altered: 2 added: 0
Tablename jos_virtuemart_rating_reviews dropped: 0 altered: 15 added: 0
Tablename jos_virtuemart_ratings dropped: 0 altered: 10 added: 0
Tablename jos_virtuemart_rating_votes dropped: 0 altered: 8 added: 0
Tablename jos_virtuemart_shipmentmethods dropped: 0 altered: 14 added: 0
Tablename jos_virtuemart_shipmentmethod_shoppergroups dropped: 0 altered: 2 added: 0
Tablename jos_virtuemart_shoppergroups dropped: 0 altered: 15 added: 0
Tablename jos_virtuemart_states dropped: 0 altered: 13 added: 0
Tablename jos_virtuemart_vmusers dropped: 0 altered: 11 added: 0
Tablename jos_virtuemart_vmuser_shoppergroups dropped: 0 altered: 3 added: 0
Tablename jos_virtuemart_permgroups dropped: 0 altered: 11 added: 0
Tablename jos_virtuemart_userfields dropped: 0 altered: 22 added: 0
Tablename jos_virtuemart_userfield_values dropped: 0 altered: 12 added: 0
Tablename jos_virtuemart_userinfos dropped: 0 altered: 15 added: 0
createTable ERROR :Query was empty SQL=
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='' AUTO_INCREMENT=1 ;
Tablename jos_virtuemart_vendor_medias dropped: 0 altered: 4 added: 0
Tablename jos_virtuemart_waitingusers dropped: 0 altered: 13 added: 0
Tablename jos_virtuemart_worldzones dropped: 0 altered: 12 added: 0
Install Component Success


Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/content/49/8419449/html/administrator/components/com_virtuemart/install/script.virtuemart.php on line 348

Warning: array_intersect() [function.array-intersect]: Argument #2 is not an array in /home/content/49/8419449/html/administrator/components/com_virtuemart/helpers/tableupdater.php on line 179



The Update was SUCCESSFUL
Reminder! Also update your extensions with the AIO installer

Wicked69ng

#2
February 16, 2012, 22:23:08 PM
When I click "go to store" I have this error at the top of the items...

Code Select

vmError: createLanguageTables Column length too big for column 'category_description' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_categories_en_gb (`virtuemart_category_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`category_name` char(180) NOT NULL DEFAULT "" ,`category_description` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_category_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for categories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturers_en_gb (`virtuemart_manufacturer_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_name` char(180) NOT NULL DEFAULT "" ,`mf_email` char(255) NOT NULL DEFAULT "" ,`mf_desc` varchar(19000) NOT NULL DEFAULT "" ,`mf_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturer_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturers" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'mf_category_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_manufacturercategories_en_gb (`virtuemart_manufacturercategories_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`mf_category_name` char(180) NOT NULL DEFAULT "" ,`mf_category_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_manufacturercategories_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for manufacturercategories" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'product_s_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_products_en_gb (`virtuemart_product_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`product_name` char(180) NOT NULL DEFAULT "" ,`product_s_desc` varchar(2048) NOT NULL DEFAULT "" ,`product_desc` varchar(19000) NOT NULL DEFAULT "" ,`metadesc` char(128) NOT NULL DEFAULT "" ,`metakey` char(128) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_product_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for products" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'vendor_store_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_vendors_en_gb (`virtuemart_vendor_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`vendor_store_name` char(180) NOT NULL DEFAULT "" ,`vendor_phone` char(24) NOT NULL DEFAULT "" ,`vendor_store_desc` varchar(10500) NOT NULL DEFAULT "" ,`vendor_terms_of_service` varchar(10500) NOT NULL DEFAULT "" ,`vendor_url` char(255) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_vendor_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for vendors" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'payment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_paymentmethods_en_gb (`virtuemart_paymentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`payment_name` char(180) NOT NULL DEFAULT "" ,`payment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_paymentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for paymentmethods" AUTO_INCREMENT=1 ;
vmError: createLanguageTables Column length too big for column 'shipment_desc' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS jos_virtuemart_shipmentmethods_en_gb (`virtuemart_shipmentmethod_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT ,`shipment_name` char(180) NOT NULL DEFAULT "" ,`shipment_desc` varchar(19000) NOT NULL DEFAULT "" ,`slug` char(192) NOT NULL DEFAULT "" ,PRIMARY KEY (`virtuemart_shipmentmethod_id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT="Language en_gb for shipmentmethods" AUTO_INCREMENT=1 ;

maze

#3
February 26, 2012, 00:05:19 AM

Hi

I have exactly the same problem! I have been trying to install it for 2 days now, but I have to give up.
First time user of VirtueMart and and what a disappointment so far.  :(

Can some VirtueMart guru please help here

maze

#4
February 26, 2012, 16:46:17 PM
Still waiting for a response on this topic.

jenkinhill

#5
February 26, 2012, 17:51:03 PM
Exactly the same problem? Did you at all follow the migration instructions in http://forum.virtuemart.net/index.php?topic=95236.0

In Wicked69ng's posts referring to vmError: createLanguageTables  the most likely scenario is that he did not set the default joomla frontend language to the one used in the description of  products. This is important. However, also a possible issue is the use of PHP5.2.17 which is very old and insecure now, VM2 is designed to use PHP5.3, as is Joomla 2.5 - it is possible that an older version of MySQL was also used, it should be 5.0.4 or better.

If you are making a brand new site then use Joomla 2.5.1 and install VirtueMart 2.0.2
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Milbo

#6
February 27, 2012, 01:43:07 AM
There is a solution for you, I think it is connected to your mysql version/setting, whatever.

search for the virtuemart.cfg, when it is not there, then copy the virtuemart_defaults.cfg-dist and rename it

add in this files in some new beyond line the line [config] this: dblayoutstrict=FALSE

Then use /administrator/index.php?option=com_virtuemart&view=updatesmigration there use the updates config by file (overwrites with the values from virtuemart.cfg your virtuemart config), after that use the "Install tables or if necessary update them".

This should use for your language tables the loose format, that means i uses instead varchars, just text.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/
Print
Go Up Pages1
User actions