Buy One OpenCart Theme, Download One for Free!
0
Your Cart is currently empty!
Product update
Coupon
add
Coupon code invalid! Please re-enter!
AJAX loader
You are here: HomeForum

We are here to serve :)

Our support team is currently online to solve your issues.

Our support team is currently offline

Our support heroes might not be around this hour. Please expect some delays.

Our support is available from

Monday - Friday 8am - 5:30pm GMT+7

Your time: 00:00:00
Our time: 00:00:00

Welcome, Guest

Unable to install sample data
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Unable to install sample data

Unable to install sample data 8 years, 1 month ago #565

  • xeroxarc
I'm unable to install sample data during installation & gives error like
Table 'db1.jos_session' doesn't exist SQL=INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('v1j6q88bv4p8j3ug4teud8qre0', 0, 1310968515)

&

Error
Some errors occurred while populating the database: Table 'data.josa_weblinks' doesn't exist SQL=-- -- Dumping data for table `josa_weblinks` -- INSERT INTO `josa_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')


or
if directly click on next button then this error is displayed
Table 'data.josa_users' doesn't exist SQL=REPLACE INTO josa_users SET id = 42, name = 'Super User', username = 'admin', email = 'admin@example.com', password = 'fee3b93b886858105f21fe24e60749ba:xsyM78pcgQHS2liX9cj4MfeaESYzHvSP', usertype = 'deprecated', block = 0, sendEmail = 1, registerDate = '2011-07-18 05:59:01', lastvisitDate = '0000-00-00 00:00:00', activation = '', params = ''
Last Edit: 8 years, 1 month ago by .

Re: Unable to install sample data 7 years, 8 months ago #1472

  • amadjer
Hello,
Plz i have the same problem somebody has fixed it and share the methods with me here
?

Re: Unable to install sample data 7 years, 8 months ago #1487

Dear amadjer, xeroxarc
Please try to do the following: change
TYPE=MYISAM

to
ENGINE=MYISAM

in file installation\sql\mysql\sample_data.sql. Please do a search and replace all then reinstall quickstart package.
To submit a ticket, please click here. Join our Clubs to have all extensions
  • Page:
  • 1
Time to create page: 0.43 seconds

Notification

Please find your issue via Suggested Posts before submitting your question. We have solved the most of issues and maybe your issue was solved before.

Suggested Posts

(/)
Result not found!

Latest My Topics

No posts to display.

Love all our templates?

Join our membership clubs starting at $49 only for access to all of our templates

Join Now
Magento Themes Magento Extensions Free Magento Extensions Prestashop Themes Prestashop Modules Magento 2 Themes