Hi i've download the template and i'm trying to install with the quickstart mode. When i click on the buttom to "install the sample data" it gives me an error. How can i fix it? Thanks

Error

Se ha producido algún error mientras se cumplimentaba la base de datos: Table 'wirtex.obxws_weblinks' doesn't exist SQL=INSERT INTO `obxws_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES (1, 32, 0, 'Joomla!', 'joomla', 'www.joomla.org', '

Home of Joomla!
', '0000-00-00 00:00:00', 3, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 33, 0, 'php.net', 'php', 'www.php.net', '

The language that Joomla! is developed in
', '0000-00-00 00:00:00', 6, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 1, '{"target":"","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 33, 0, 'MySQL', 'mysql', 'www.mysql.com', '

The database that Joomla! uses
', '0000-00-00 00:00:00', 1, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 1, '{"target":"","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (4, 32, 0, 'OpenSourceMatters', 'opensourcematters', 'www.opensourcematters.org', '

Home of OSM
', '0000-00-00 00:00:00', 11, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (5, 32, 0, 'Joomla! - Forums', 'joomla-forums', 'forum.joomla.org', '

Joomla! Forums
', '0000-00-00 00:00:00', 4, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (6, 33, 0, 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'www.ohloh.net/projects/20', '

Objective reports from Ohloh about Joomla''s development activity. Joomla! has some star developers with serious kudos.
', '0000-00-00 00:00:00', 1, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (7, 31, 0, 'Baw Baw National Park', 'baw-baw-national-park', 'www.parkweb.vic.gov.au/1park_display.cfm?park=44', '

Park of the Austalian Alps National Parks system, Baw Baw features sub alpine vegetation, beautiful views, and opportunities for hiking, skiing and other outdoor activities.
', '0000-00-00 00:00:00', 0, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (8, 31, 0, 'Kakadu', 'kakadu', 'www.environment.gov.au/parks/kakadu/index.html', '

Kakadu is known for both its cultural heritage and its natural features. It is one of a small number of places listed as World Heritage Places for both reasons. Extensive rock art is found there.
', '0000-00-00 00:00:00', 0, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (9, 31, 0, 'Pulu Keeling', 'pulu-keeling', 'www.environment.gov.au/parks/cocos/index.html', '

Located on an atoll 2000 kilometers north of Perth, Pulu Keeling is Australia''s smallest national park.
', '0000-00-00 00:00:00', 0, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, 1, '{"target":"0","count_clicks":""}', 'en-GB', '2011-01-01 00:00:01', 0, '', '2011-01-01 00:00:01', 42, '', '', '{"robots":"","author":"","rights":""}', 0, '', '2010-07-10 23:44:03', '0000-00-00 00:00:00')

Dear Faustino Márquez!
- Please try to do the following: change

to

in file installation\sql\mysql\sample_data.sql. Please do a search and replace all then reinstall quickstart package.

Thanks, it works.

HI,

I have the same problem, I make the changes you suggested, but now send me the follow error:

Error
Some errors occurred while populating the database: Variable 'character_set_client' can't be set to the value of 'NULL' SQL=/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */

Can you please help me.

Thanks in advance.

Cecilia Cota wrote:


Hi me too facing the same error, any help please!!!!!

Thanks and Regards,
Ganesamoorthy

Dear Cecilia Cota and Ganesamoorthy,

Please try to change TYPE=MEMORY to ENGINE=MEMORY in the sample_data.sql file

Thanks