Installation Error

More
6 years 3 weeks ago - 6 years 3 weeks ago #4132 by kabogojn
kabogojn created the topic: Installation Error
Dear JM Ieam,

I am getting the error below when I try to install sample data for JM-Free-eBooks template on WAMP.

Some errors occurred while populating the database: Table 'v8taf_usergroups' doesn't exist SQL=INSERT INTO `v8taf_usergroups` VALUES (1,0,1,22,'Public'), (2,1,8,19,'Registered'), (3,2,9,16,'Author'), (4,3,10,13,'Editor'), (5,4,11,12,'Publisher'), (6,1,4,7,'Manager'), (7,6,5,6,'Administrator'), (8,1,20,21,'Super Users'), (12,2,17,18,'Customer Group (Example)'), (10,3,14,15,'Shop Suppliers (Example)'), (13,1,2,3,'Guest')


John
Last Edit: 6 years 3 weeks ago by kabogojn.

Please Log in or Create an account to join the conversation.

More
6 years 3 weeks ago #4135 by marcin
marcin replied the topic: Imstallation Error
Hello,

This issue seems to be related to the MySQL version.
Please edit the sample_jm_demo.sql file located in installation/sql/mysql/ directory and find this line:
KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`)

Now replace the above line with this one:
  KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE

Please let us know if this helped you!

Regards,
Marcin

Please Log in or Create an account to join the conversation.

More
6 years 3 weeks ago #4140 by kabogojn
kabogojn replied the topic: Installation Error
Dear Marcin,

Thank you for your reply.

In the sample_jm_demo.sql file located in installation/sql/mysql/ directory, the line you suggest I edit is already like this;

KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE

However, you gave me an idea and I tried it; the line above is both in sample_jm_demo.sql file as well as in the joomla.sql

I removed the phrase 'USING BTREE' in the two files, after which I installed sample database successfully without the error.

I hope that the deletion of the above phrase in the code has no adverse effect on the database working and execution.

Regards,

John

Please Log in or Create an account to join the conversation.

More
6 years 3 weeks ago #4144 by marcin
marcin replied the topic: Installation Error
Hello,

Great you solved that issue :)
Thanks for the details!

Regards,
Marcin

Please Log in or Create an account to join the conversation.

Time to create page: 0.244 seconds

INDICO S.C.

ul. Wałowa 10/3, 84-200 Wejherowo, registered in Centralna Ewidencja i Informacja o Działalnosci Gospodarczej
NIP/VATID: PL5882424318

Copyright © 2009-2018 Joomla-Monster.com All rights reserved.

Joomla-Monster.com and this site is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.