problem installation instyle quickstart_J3

I´ve got problem with the installation of this template. The server is ok with joomla3.
I try a lot of times and in diferent server..., but allways the same code.
It s very long, but here i copy a little part
Thanks

Code: Select all

Table 'joomla10.#__users' doesn't exist SQL=UPDATE `#__users` SET block=1 WHERE block=0

Table 'joomla10.#__viewlevels' doesn't exist SQL=INSERT INTO `#__viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES (1,'Public',0,'[1]'),(2,'Registered',1,'[6,2,8]'),(3,'Special',2,'[6,3,8]')

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__viewlevels` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `ordering` int(11) NOT NULL DEFAULT '0', `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_assetgroup_title_lookup` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Table 'joomla10.#__utf8_conversion' doesn't exist SQL=INSERT INTO `#__utf8_conversion` (`converted`) VALUES (2)

Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__utf8_conversion` ( `converted` tinyint(4) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Table 'joomla10.#__users' doesn't exist SQL=INSERT INTO `#__users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (880,'Super User','gkadmin','[email protected]','$2y$10$jhyD86vKG7Pw7OBY/0aTX.A7RGiRsK/sQKHEoybIZ46InVuKHE3xe',0,1,'2015-01-09 12:46:11','2016-03-30 07:59:34','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(981,'Saul Bellow','gkadmin2','[email protected]','$2y$10$M3lu3MGXH5blBnGGBsruB.AqhN/WXfLuE9VYax.5CRWvamRlt/M0e',1,1,'2013-11-18 14:00:02','2014-12-01 08:50:31','0','{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"none\",\"helpsite\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0)

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `block` tinyint(4) NOT NULL DEFAULT '0', `sendEmail` tinyint(4) DEFAULT '0', `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `activation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `params` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset', `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime', `otpKey` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys', `otep` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords', `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login', PRIMARY KEY (`id`), KEY `idx_name` (`name`(191)), KEY `idx_block` (`block`), KEY `username` (`username`), KEY `email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=982 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Table 'joomla10.#__usergroups' doesn't exist SQL=INSERT INTO `#__usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1,0,1,20,'Public'),(2,1,6,17,'Registered'),(3,2,7,14,'Author'),(4,3,8,11,'Editor'),(5,4,9,10,'Publisher'),(6,1,2,5,'Manager'),(7,6,3,4,'Administrator'),(8,1,18,19,'Super Users')

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__usergroups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`), KEY `idx_usergroup_title_lookup` (`title`), KEY `idx_usergroup_adjacency_lookup` (`parent_id`), KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Table 'joomla10.#__user_usergroup_map' doesn't exist SQL=INSERT INTO `#__user_usergroup_map` (`user_id`, `group_id`) VALUES (1,1),(45,2),(880,8),(981,8)

Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__user_usergroup_map` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id', `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id', PRIMARY KEY (`user_id`,`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_profiles` ( `user_id` int(11) NOT NULL, `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `profile_value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table'

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_notes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `catid` int(10) unsigned NOT NULL DEFAULT '0', `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `body` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `state` tinyint(3) NOT NULL DEFAULT '0', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_user_id` int(10) unsigned NOT NULL, `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_category_id` (`catid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__user_keys` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `series` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `invalid` tinyint(4) NOT NULL, `time` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `uastring` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `series` (`series`), UNIQUE KEY `series_2` (`series`), UNIQUE KEY `series_3` (`series`), KEY `user_id` (`user_id`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Table 'joomla10.#__updates' doesn't exist SQL=INSERT INTO `#__updates` (`update_id`, `update_site_id`, `extension_id`, `name`, `description`, `element`, `type`, `folder`, `client_id`, `version`, `data`, `detailsurl`, `infourl`, `extra_query`) VALUES (1,39,10138,'VirtueMart AIO','VirtueMart AIO Component','com_virtuemart_allinone','component','',1,'3.0.14','','http://virtuemart.net/releases/vm3/virtuemart_aio_update.xml','http://virtuemart.net/news/latest-news/476-virtuemart-releases-vm3-0-14-and-announces-a-new-collaboration-with-2checkout-to-provide-seamless-international-payments-for-online-retailers','')

Unknown collation: 'utf8mb4_unicode_ci' SQL=CREATE TABLE `#__updates` ( `update_id` int(11) NOT NULL AUTO_INCREMENT, `update_site_id` int(11) DEFAULT '0', `extension_id` int(11) DEFAULT '0', `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '', `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `element` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '', `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '', `folder` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '', `client_id` tinyint(3) DEFAULT '0', `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '', `data` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `detailsurl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `infourl` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`update_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates'

Table 'joomla10.#__update_sites_extensions' doesn't exist SQL=INSERT INTO `#__update_sites_extensions` (`update_site_id`, `extension_id`) VALUES (1,700),(2,700),(3,10021),(6,600),(9,10076),(10,10076),(11,10109),(12,28),(13,10137),(14,10139),(15,10140),(16,10141),(17,10142),(18,10143),(19,10144),(20,10145),(21,10146),(22,10147),(23,10148),(24,10149),(25,10150),(26,10151),(27,10152),(28,10153),(29,10154),(30,10155),(31,10156),(32,10157),(33,10158),(34,10159),(35,10160),(36,10161),(37,10162),(38,10163),(39,10138),(41,10164),(42,10165),(43,10021)

Unknown character set: 'utf8mb4' SQL=CREATE TABLE `#__update_sites_extensions` ( `update_site_id` int(11) NOT NULL DEFAULT '0', `extension_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`update_site_id`,`extension_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites'

Table 'joomla10.#__update_sites' doesn't exist SQL=INSERT INTO `#__update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`, `extra_query`) VALUES (1,'Joomla Core','collection','http://update.joomla.org/core/sts/list_sts.xml',1,1459324773,''),(2,'Joomla Extension Directory','collection','http://update.joomla.org/jed/list.xml',1,1459324773,''),(3,'K2 Updates','extension','http://getk2.org/update.xml',1,0,''),(6,'Accredited Joomla! Translations','collection','http://update.joomla.org/language/translationlist_3.xml',1,0,''),(9,'News Show Pro GK5 Updates','extension','https://www.gavick.com/update_server/joomla25/nsp_gk5.xml',0,0,''),(10,'News Show Pro GK5 Updates','extension','https://www.gavick.com/update_server/joomla30/nsp_gk5.xml',1,0,''),(11,'Image Show GK4 Updates','extension','https://www.gavick.com/update_server/joomla30/image_show_gk4.xml',1,0,''),(12,'Joomla! Update Component Update Site','extension','http://update.joomla.org/core/extensions/com_joomlaupdate.xml',1,0,''),(13,'VirtueMart3 Update Site','extension','http://virtuemart.net/releases/vm3/virtuemart_update.xml',1,0,''),(14,'VirtueMart plg_vmpayment_standard Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_standard_update.xml',1,0,''),(15,'VirtueMart plg_vmpayment_klarna Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_klarna_update.xml',1,0,''),(16,'VirtueMart plg_vmpayment_klarnacheckout Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_klarnacheckout_update.xml',1,0,''),(17,'VirtueMart plg_vmpayment_sofort Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_sofort_update.xml',1,0,''),(18,'VirtueMart plg_vmpayment_paypal Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_paypal_update.xml',1,0,''),(19,'VirtueMart plg_vmpayment_heidelpay Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_heidelpay_update.xml',1,1459324771,''),(20,'VirtueMart plg_vmpayment_paybox Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_paybox_update.xml',1,1459324771,''),(21,'VirtueMart plg_vmpayment_realex_hpp_api Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_realex_hpp_api_update.xml',1,1459324771,''),(22,'VirtueMart plg_vmuserfield_realex_hpp_api Update Site','extension','\n http://virtuemart.net/releases/vm3/plg_vmuserfield_realex_hpp_api_update.xml',1,1459324771,''),(23,'VirtueMart3 plg_vmpayment_skrill Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_skrill_update.xml',0,0,''),(24,'VirtueMart plg_vmpayment_authorizenet Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_authorisenet_update.xml',1,1459324771,''),(25,'VirtueMart plg_vmpayment_sofort_ideal Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_sofort_ideal_update.xml',1,1459324771,''),(26,'VirtueMart plg_vmpayment_klickandpay Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_klikandpay_update.xml',1,1459324771,''),(27,'VirtueMart3 plg_vmshipment_weight_countries Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmshipment_weight_countries_update.xml',1,1459324771,''),(28,'VirtueMart3 plg_vmcustom_textinput Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcustom_textinput_update.xml',1,1459324771,''),(29,'VirtueMart3 plg_vmcustom_specification Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcustom_specification_update.xml',1,1459324771,''),(30,'VirtueMart3 plg_vmcalculation_avalara Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmcalculation_avalara_update.xml',1,1459324771,''),(31,'VirtueMart3 plg_search_virtuemart Update Site','extension','http://virtuemart.net/releases/vm3/plg_search_virtuemart_update.xml',1,1459324771,''),(32,'VirtueMart3 MOD_VMENU Update Site','extension','http://virtuemart.net/releases/vm3/mod_vmmenu_update.xml',1,1459324771,''),(33,'VirtueMart3 mod_virtuemart_currencies Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_currencies_update.xml',1,1459324771,''),(34,'VirtueMart3 mod_virtuemart_product Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_product_update.xml',1,1459324771,''),(35,'VirtueMart3 mod_virtuemart_search Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_search_update.xml',1,1459324771,''),(36,'VirtueMart3 mod_virtuemart_manufacturer Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_manufacturer_update.xml',1,1459324771,''),(37,'VirtueMart3 mod_virtuemart_cart Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_cart_update.xml',1,1459324771,''),(38,'VirtueMart3 mod_virtuemart_category Update Site','extension','http://virtuemart.net/releases/vm3/mod_virtuemart_category_update.xml',1,1459324771,''),(39,'VirtueMart3 AIO Update Site','extension','http://virtuemart.net/releases/vm3/virtuemart_aio_update.xml',1,1459324771,''),(41,'VirtueMart plg_vmpayment_amazon Update Site','extension','http://virtuemart.net/releases/vm3/plg_vmpayment_amazon_update.xml',1,1459324771,''),(42,'VirtueMart plg_system_amazon Update Site','extension','http://virtuemart.net/releases/vm3/plg_system_amazon_update.xml',1,1459324771,''),(43,'K2 Updates','extension','http://getk2.org/app/update.xml',1,1459324771,'')

I've had exactly the same issue when trying to install Quickstart packages for Quark and Creativity, yesterday and last week. I get the same code?

Would appreciate any assistance or suggestions. Have gone ahead and installed the template only, which is fine, but I usually install the Quickstart version.

Hi

Please try solution proposed in this thread: https://www.gavick.com/forums/storefron ... b4#p256457

Hello,
I have same problem and tried the solution of changing to tuf8.
but then I got below error:

you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1641,'these changes it','these changes it',0,1,1.5333,'T2523',31,''),(21642,'tim' at line 5 SQL=INSERT INTO `#__finder_terms` (`term_id`, `term`, `stem`, `common`, `phrase`, `weight`, `soundex`, `links`, `language`) VALUES (15950,'never baulked at','never baulked at',0,1,1.5333,'N161423',9,''),(15951,'oscar','oscar',0,0,0.3333,'O260',17,''),.....

please help

I visit this post yet, but dont work, its make this error:

Thanks!

Code: Select all

Table 'joomla11.#__assets' doesn't exist SQL=INSERT INTO `#__assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES (1,0,1,528,0,'root.1','Root Asset','{\"core.login.site\":{\"6\":1,\"2\":1},\"core.login.admin\":{\"6\":1},\"core.login.offline\":[],\"core.admin\":{\"8\":1},\"core.manage\":{\"7\":1},\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(2,1,1,2,1,'com_admin','com_admin','{}'),(3,1,3,8,1,'com_banners','com_banners','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(4,1,9,10,1,'com_cache','com_cache','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(5,1,11,12,1,'com_checkin','com_checkin','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(6,1,13,14,1,'com_config','com_config','{}'),(7,1,15,22,1,'com_contact','com_contact','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(8,1,23,70,1,'com_content','com_content','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":[],\"core.edit\":{\"4\":1},\"core.edit.state\":{\"5\":1},\"core.edit.own\":[]}'),(9,1,71,72,1,'com_cpanel','com_cpanel','{}'),(10,1,73,74,1,'com_installer','com_installer','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1},\"core.delete\":[],\"core.edit.state\":[]}'),(11,1,75,76,1,'com_languages','com_languages','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(12,1,77,78,1,'com_login','com_login','{}'),(13,1,79,80,1,'com_mailto','com_mailto','{}'),(14,1,81,82,1,'com_massmail','com_massmail','{}'),(15,1,83,84,1,'com_media','com_media','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":{\"5\":1}}'),(16,1,85,86,1,'com_menus','com_menus','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(17,1,87,88,1,'com_messages','com_messages','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(18,1,89,130,1,'com_modules','com_modules','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(19,1,131,138,1,'com_newsfeeds','com_newsfeeds','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(20,1,139,140,1,'com_plugins','com_plugins','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(21,1,141,142,1,'com_redirect','com_redirect','{\"core.admin\":{\"7\":1},\"core.manage\":[]}'),(22,1,143,144,1,'com_search','com_search','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1}}'),(23,1,145,146,1,'com_templates','com_templates','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(24,1,147,148,1,'com_users','com_users','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(26,1,149,150,1,'com_wrapper','com_wrapper','{}'),(27,8,24,31,2,'com_content.category.2','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(28,3,4,5,2,'com_banners.category.3','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(29,7,16,17,2,'com_contact.category.4','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(30,19,132,133,2,'com_newsfeeds.category.5','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(32,33,33,34,3,'com_content.article.1','Typography','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(33,8,32,49,2,'com_content.category.7','Template articles','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(34,33,35,36,3,'com_content.article.2','Module positions','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(35,33,37,38,3,'com_content.article.3','Messages','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(39,8,50,51,2,'com_content.category.9','Layouts','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(52,33,39,40,3,'com_content.article.18','Module variations','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(53,7,18,19,2,'com_contact.category.10','Sample category I','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(54,7,20,21,2,'com_contact.category.11','Sample category II','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(57,19,134,135,2,'com_newsfeeds.category.14','GavickPro','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(58,19,136,137,2,'com_newsfeeds.category.15','Joomla!','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(59,27,25,26,3,'com_content.article.19','Archive article I','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(60,27,27,28,3,'com_content.article.20','Archive article II','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(61,27,29,30,3,'com_content.article.21','Archive article III','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(115,33,41,42,3,'com_content.article.56','Page break example','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(116,33,43,44,3,'com_content.article.57','Page Break','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(127,8,52,69,2,'com_content.category.32','Demo content','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(128,127,53,54,3,'com_content.category.33','Subcategory I','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(129,127,55,56,3,'com_content.category.34','Subcategory II','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(141,3,6,7,2,'com_banners.category.35','Demo','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(142,1,506,507,1,'com_k2','com_k2','{\"core.admin\":[],\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(144,1,508,509,1,'com_joomlaupdate','com_joomlaupdate','{\"core.admin\":[],\"core.manage\":[],\"core.delete\":[],\"core.edit.state\":[]}'),(154,33,45,46,3,'com_content.article.74','Frontpage elements','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(155,157,58,59,4,'com_content.article.75','F.A.Q.','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(157,127,57,60,3,'com_content.category.36','FAQ','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(171,33,47,48,3,'com_content.article.90','Custom HTML elements','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(174,127,61,62,3,'com_content.article.91','Save Up To 25% on Brands','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(175,127,63,64,3,'com_content.article.92','Popular Jeans New Collection','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(176,127,65,66,3,'com_content.article.93','Weatherproof Vintage Sweater','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(177,127,67,68,3,'com_content.article.94','The Buff - Men\'s Contemporary shoes','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(178,1,510,511,1,'com_finder','com_finder','{}'),(179,1,512,513,1,'com_tags','com_tags','{\"core.admin\":[],\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(180,1,514,515,1,'com_contenthistory','com_contenthistory','{}'),(181,1,516,517,1,'com_ajax','com_ajax','{}'),(182,1,518,519,1,'com_postinstall','com_postinstall','{}'),(183,18,90,91,2,'com_modules.module.669','Most Popular','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(184,18,92,93,2,'com_modules.module.684','Best __Sellers__','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(185,18,94,95,2,'com_modules.module.633','NSP GK5','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(186,18,96,97,2,'com_modules.module.681','Blog__Also this week__','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(187,18,98,99,2,'com_modules.module.696','Rotate Products - Men','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(188,18,100,101,2,'com_modules.module.695','Rotate Products - Women','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(189,18,102,103,2,'com_modules.module.632','Beautiful featured products','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(190,18,104,105,2,'com_modules.module.656','Recently Added Articles','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(191,18,106,107,2,'com_modules.module.657','Popular Articles','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(192,18,108,109,2,'com_modules.module.697','Women\'s Brands','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(193,18,110,111,2,'com_modules.module.698','Search','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(194,1,520,521,1,'#__ucm_content.1','#__ucm_content.1','[]'),(195,1,522,523,1,'#__ucm_content.2','#__ucm_content.2','[]'),(197,18,112,113,2,'com_modules.module.699','My cart','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(198,18,114,115,2,'com_modules.module.700','K2Store Currency',''),(199,1,524,525,1,'com_virtuemart','virtuemart','{}'),(200,1,526,527,1,'com_virtuemart_allinone','virtuemart_allinone','{}'),(201,18,116,117,2,'com_modules.module.701','VM - Administrator Module',''),(202,18,118,119,2,'com_modules.module.702','VM - Currencies Selector',''),(203,18,120,121,2,'com_modules.module.703','VM - Featured products',''),(204,18,122,123,2,'com_modules.module.704','VM - Search in Shop',''),(205,18,124,125,2,'com_modules.module.705','VM - Manufacturer',''),(206,18,126,127,2,'com_modules.module.706','VM - Shopping cart','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(207,18,128,129,2,'com_modules.module.707','VM - Category','')

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- MySQL dump 10.13 Distrib 5.5.48, for Linux (x86_64) CREATE' at line 1 SQL=-- MySQL dump 10.13 Distrib 5.5.48, for Linux (x86_64) CREATE TABLE `#__assets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`,`rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Hi

I've just tried and had no problems installing it. Maybe some files broke during download or indeed Your msql version does not support utf8mb4. If You will have this problem still try asking Your host provider to update mysql version.

Just had the same problem with Events and University quickstart... but no problem installing Joomla 3

Hi
I've downloaded twice and with both i have the same problem. I try also in two different hosts, and also the same problem. In this two hosts i've installed a lot of joomla3 and gavick templates, its works perfect.....

Need help!

Hi,

I finnaly find the solution. In my case, the solution was asked at the host to create mysql 5.5

I hope this helps you

Hi

I think yes. Newest joomla requires mysql 5.5. I have it on my server, so issues were not showing.

For those who cannot update there is a way to revert mysql code back to older version by renaming all occurrences of "utf8mb4" to "utf8" in file /installation/sql/mysql/joomla.sql

My problem is other with Instyle Quickstart J3 in Spanish.
The install finished well, but failed when I click in the "Add more languages" button. The message is: "Could not connect to MySQL" (see attached image)

Then in Joomla admin I installed Spanish language (front and back).
In VM there was several messages, then I installed the spanish language as "Content Language", too I downloaded and installed the TCPDF library but still stay the messages.

My site:
-Versión de la base de datos 10.0.25-MariaDB
-Cotejamiento de la base de datos utf8_general_ci
-Cotejamiento de la conexión de la base de datos utf8mb4_general_ci
-Versión de PHP 5.4.45
-Servidor web LiteSpeed
-Interfaz de PHP litespeed
-Versión de Joomla! Joomla! 3.5.1 Stable [ Unicorn ] 05-April-2016 22:45 GMT
-Versión de la plataforma de Joomla! Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
-Agente del usuario Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36

Hi

I think permissions on Your server may not allow creation of configuration.php file where access informations to database are stored. Please check that.

If it does, just pass this and try add languages in joomla panel after installation.