Thread Details
  • State Verified Answer
  • Replies 8 replies
  • Subscribers 353 subscribers
  • Views 2865 views
  • Users 0 members are here
Forum Actions
Related

Database failure creating local sugar with WAMP and SugarEnt-11.0.0-dev.1.zip

James Kinnersley

Hello!  

I'm trying to get a local development environment setup with WAMP and I'm using the SugarEnt-11.0.0-dev.1.zip.  After a couple of initial issues got ironed out I've got to the point where the installer ends with this message:-

Creating Sugar configuration file (config.php)

Creating Sugar application tables, audit tables and relationship metadata
Creating the database sugarcrm on localhost...done
Database failure. Please refer to sugarcrm.log for details.

http://localhost/phpmyadmin/ shows the "sugarcrm" database has been created but there are no tables.  When I try http://localhost/SugarDev11.0/ I get the following:- 

Fatal error: Uncaught Doctrine\DBAL\Driver\Mysqli\Exception\ConnectionError: Table 'sugarcrm.tracker_tracker_queries' doesn't exist in C:\Users\jk20120\Documents\GitHub\SugarEnt-11.0.0-dev.1\SugarEnt-Full-11.0.0-dev.1\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 61
( ! ) Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing 'INSERT INTO tracker_tracker_queries (monitor_id, query_id, date_modified) VALUES(?, ?, ?)' with params ["9db2859c-d5ac-11eb-9707-0a002700000a", "9db332ee-d5ac-11eb-aa92-0a002700000a", "2021-06-25 11:58:11"]: Table 'sugarcrm.tracker_tracker_queries' doesn't exist in C:\Users\jk20120\Documents\GitHub\SugarEnt-11.0.0-dev.1\SugarEnt-Full-11.0.0-dev.1\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 61
Call Stack
# Time Memory Function Location
1 0.3414 3764080 sugar_cleanup( ) ...\utils.php:0
2 0.3426 3775472 TrackerManager->saveMonitor( ) ...\utils.php:3194
3 0.3426 3775472 tracker_queries_monitor->save( ) ...\TrackerManager.php:172
4 0.3437 3783400 Monitor->save( ) ...\tracker_queries_monitor.php:80
5 0.3440 3784464 DatabaseStore->flush( ) ...\Monitor.php:135
6 0.3441 3785216 MysqliManager->insertParams( ) ...\DatabaseStore.php:41
7 0.3442 3788016 Sugarcrm\Sugarcrm\Dbal\Query\QueryBuilder->execute( ) ...\DBManager.php:876
8 0.3443 3788144 Sugarcrm\Sugarcrm\Dbal\Connection->executeStatement( ) ...\QueryBuilder.php:213
9 0.3447 3806536 Sugarcrm\Sugarcrm\Dbal\Connection->handleExceptionDuringQuery( ) ...\Connection.php:1463
10 0.3447 3816648 Sugarcrm\Sugarcrm\Dbal\Connection->throw( ) ...\Connection.php:2121

Does anyone have any idea what I can do to resolve this or spot what I've missed please?

Many thanks

James

Parents
  • 0

    Hi.  I've tried this again with the a new full release copy of Sugar 11 which was provided by support as suggested by Francesca but have had the same result, if anyone who uses WAMP can point me in the right direction to get a local version running, I'd really appreciate it.

    The sugarcrm.log file is:-

    Wed Jun 30 13:10:01 2021 [13520][-none-][ALERT] Error creating table: acl_actions: Query Failed: CREATE TABLE acl_actions (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,name varchar(150) NULL ,category varchar(100) NULL ,acltype varchar(100) NULL ,aclaccess int(3) NULL ,deleted bool DEFAULT 0 NULL , PRIMARY KEY (id), KEY idx_aclaction_id_del (id, deleted), KEY idx_category_name (category, name), KEY idx_del_category_name (deleted, category, name), KEY idx_del_category_name_acltype_aclaccess (deleted, category, name, acltype, aclaccess)) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
    Wed Jun 30 13:10:01 2021 [13520][-none-][FATAL] died with message: Database failure. Please refer to sugarcrm.log for details.

    Thanks again

Reply
  • 0

    Hi.  I've tried this again with the a new full release copy of Sugar 11 which was provided by support as suggested by Francesca but have had the same result, if anyone who uses WAMP can point me in the right direction to get a local version running, I'd really appreciate it.

    The sugarcrm.log file is:-

    Wed Jun 30 13:10:01 2021 [13520][-none-][ALERT] Error creating table: acl_actions: Query Failed: CREATE TABLE acl_actions (id char(36) NOT NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,name varchar(150) NULL ,category varchar(100) NULL ,acltype varchar(100) NULL ,aclaccess int(3) NULL ,deleted bool DEFAULT 0 NULL , PRIMARY KEY (id), KEY idx_aclaction_id_del (id, deleted), KEY idx_category_name (category, name), KEY idx_del_category_name (deleted, category, name), KEY idx_del_category_name_acltype_aclaccess (deleted, category, name, acltype, aclaccess)) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
    Wed Jun 30 13:10:01 2021 [13520][-none-][FATAL] died with message: Database failure. Please refer to sugarcrm.log for details.

    Thanks again

Children
  • 0 in reply to James Kinnersley

    OK, I know I had this exact same problem when I loaded v10.  But that was a while ago and I cant remember how I solved it.  I do know that I have loaded lots of v10+ instances on XAMPP which has a windows version.  It seems to me that the problem came down to some settings in mySQL.  A google search makes it seem like the issue was in myISAM vs InnoDB tables but I dont think that was my problem.

    Can you post your my.ini (or whatever windows uses for a MySQL config file)?