Public Forums 71,145 posts

[connectjunction Friend connectjunctionJoin date: July 2009Posts: 2Downloads:14Uploads:0 Thanks: 2 Thanked: 3 times in 1 posts]

#159551

When using the quickstart installs for Jomla 1.6 if you are using a newer version of MySql you will encounter an error “Some errors occurred while populating the database”

To fix it you need to change the installationsqlmysqlsample_data file – do a search and replace – changing TYPE=MYISAM to ENGINE=MYISAM

This is a problem in the actual joomla code (nothing to do with Joomlart) and has been fixed in the nightly build so when Joomlart updates their quickstart files it will be fixed – but you have a work around for the time being.

Hope this is helpful for some of you 🙂

3 users say Thank You to connectjunction for this useful post

1. Arvind Chauhan
2. Phill
3. Paul Massell

[ahooker Friend ahookerJoin date: March 2011Posts: 1Downloads:0Uploads:0]

#379301

Hi and thanks for the info, it got me past most of the errors. However one error still remained, and it has made both sides of the site not function (back and front) after the finish of install.

Copy of the install error below. (Appears after demo data is loaded)

Some errors occurred while populating the database: 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 ‘– phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — ‘ at line 1 SQL=– phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Jan 28, 2011 at 06:18 PM — Server version: 5.1.36 — PHP Version: 5.2.11 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

CAUSE: Installation of Purity ii Template on J1.6 on xampp (localhost) WITH DEMO DATA OPTION SELECTED ONLY.
FAULT LOCATION: Error messages on install on quickstart with demo data. (See error msg above)

It may be an easy and obvious fix :-[, but have only just switched to JA templates from Rocket Theme and I have only soo much I can pickup without the brain overload, still trying to get my head around the framework etc.:confused:

Any help is much appreciated.
Thanks!

[dunglq Friend dunglqJoin date: March 2010Posts: 108Downloads:0Uploads:0 Thanks: 6 Thanked: 12 times in 13 posts]

#379424

Hi,

Could you give me version of your mysql server? I installed and it works well at my side.

[rajeshkumar15 Friend rajeshkumar15Join date: March 2011Posts: 4Downloads:0Uploads:0 Thanks: 2]

#379764

Hi – I m trying to install the Droid Template and getting the exact same error message. My Server version: 5.5.8.

The changes in sample_data file removes most of the errors except the one mentioned in the post above and is throwing the entire admin screen and everything else off so much that I am stalled and unable to proceed.

Your help would be highly appreciated.

Thx

[stefan111 Friend stefan111Join date: March 2011Posts: 1Downloads:0Uploads:0]

#380979

Same error here, this solution worked for me, so thanks !

[rajeshkumar15 Friend rajeshkumar15Join date: March 2011Posts: 4Downloads:0Uploads:0 Thanks: 2]

#381053

Workaround Solution: Well, replacing TYPE=MYISAM to ENGINE=MYISAM does remove almost all the errors except one which still remains. And this one guy would fill your screen (both the admin screen and the localhost if youare using one) with error messages.

I un-installed the latest version of XAMPP 1.7.4 and went back to installing XAMPP 1.7.3. Now it would be hard to get the older version from http://www.apachefriends.org. But you can still get it from downloads.com or other websites who provide previous versions.

Once reverting to previous version, the site works as a charm.

[dunglq Friend dunglqJoin date: March 2010Posts: 108Downloads:0Uploads:0 Thanks: 6 Thanked: 12 times in 13 posts]

#381227

Hi Guys,

To work with latest mysql version (5.5.8) we need to change TYPE=MYISAM to ENGINE=MYISAM in file installationsqlmysqlsample_data.sql. Please do a search and replace all then reinstall quickstart package.

1 user says Thank You to dunglq for this useful post

1. Paul Massell

[ugarc Friend ugarcJoin date: February 2011Posts: 1Downloads:0Uploads:0 Thanked: 1 times in 2 posts]

#382000

<em>@ahooker 224967 wrote:</em><blockquote>Hi and thanks for the info, it got me past most of the errors. However one error still remained, and it has made both sides of the site not function (back and front) after the finish of install.

Copy of the install error below. (Appears after demo data is loaded)

Some errors occurred while populating the database: 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 ‘– phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — ‘ at line 1 SQL=– phpMyAdmin SQL Dump — version 3.2.0.1 — http://www.phpmyadmin.net — — Host: localhost — Generation Time: Jan 28, 2011 at 06:18 PM — Server version: 5.1.36 — PHP Version: 5.2.11 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */

CAUSE: Installation of Purity ii Template on J1.6 on xampp (localhost) WITH DEMO DATA OPTION SELECTED ONLY.
FAULT LOCATION: Error messages on install on quickstart with demo data. (See error msg above)

It may be an easy and obvious fix :-[, but have only just switched to JA templates from Rocket Theme and I have only soo much I can pickup without the brain overload, still trying to get my head around the framework etc.:confused:

Any help is much appreciated.
Thanks!</blockquote>

After following the previous advice to change TYPE=MYISAM to ENGINE=MYISAM I encountered the error you describe. As I was installing the quick start on WAMP I used notepad’s find and replace feature. Being such, I wondered if notepad had injected some hidden data into the file that caused issue with the script. Since I was using a 32-bit version of windows, I typed edit into the run menu and did a replace using that editor and it worked.

1 user says Thank You to ugarc for this useful post

1. Paul Massell

[Paul Massell Friend Paul MassellJoin date: May 2013Posts: 96Downloads:2Uploads:6 Thanks: 13 Thanked: 9 times in 1 posts]

#382281

Using the latest MAMP I had this issue. The only fix that worked for me was a slight variation on the above. I’m putting this in code in case the forum is changing the display in html:

ENGINE = MYISAM

Note the space before and after the ” = “

If anyone is working on a Mac and want a great text editor with excellent Search & Replace checkout:
Text Wrangler by barebones. (Also makers of BBEdit) TW is Free & I have no association with the company:

http://www.barebones.com/products/textwrangler/

<em>@ugarc 228508 wrote:</em><blockquote>After following the previous advice to change TYPE=MYISAM to ENGINE=MYISAM I encountered the error you describe. As I was installing the quick start on WAMP I used notepad’s find and replace feature. Being such, I wondered if notepad had injected some hidden data into the file that caused issue with the script. Since I was using a 32-bit version of windows, I typed edit into the run menu and did a replace using that editor and it worked.</blockquote>

[sashika Friend sashikaJoin date: February 2013Posts: 1Downloads:0Uploads:0]

#484909

hi when i install my joomla template (CleanOut template) and i get the following error at the step number 6. Configuration after click “install sample data”

Some errors occurred while populating the database: Table ‘aaa.bndxl_usergroups’ doesn’t exist SQL=– — Dumping data for table `bndxl_usergroups` — INSERT INTO `bndxl_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1, 0, 1, 16, ‘Public’), (2, 1, 6, 13, ‘Registered’), (3, 2, 7, 12, ‘Author’), (4, 3, 8, 11, ‘Editor’), (5, 4, 9, 10, ‘Publisher’), (6, 1, 2, 5, ‘Manager’), (7, 6, 3, 4, ‘Administrator’), (8, 1, 14, 15, ‘Super Users’)

Please help me to solve it.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#484992

Hi sashika,

Which JA template are you facing this problem with?

[Author]

Posts