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','blank@gavick.com','$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','blank2@gavick.com','$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,'')