Thread Details
  • State Verified Answer
  • Replies 8 replies
  • Subscribers 353 subscribers
  • Views 2864 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

    I would take a step back, is there a particular reason you are using the developer release of Sugar 11 instead of the full release which is now available? 

    In general the .dev versions are pre-releases for developers to prepare for upgrades, but you can't upgrade any further from those releases. I would recommend using the latest general release for your development instance, and only using dev releases for future-release testing.

    As for the error, I am not sure why the table would be missing, but I would start with reviewing the requirements and making sure your installation meets them, perhaps if you MySQL is not the right version you are missing something the steps that create the database:

    support.sugarcrm.com/.../

Reply
  • 0

    I would take a step back, is there a particular reason you are using the developer release of Sugar 11 instead of the full release which is now available? 

    In general the .dev versions are pre-releases for developers to prepare for upgrades, but you can't upgrade any further from those releases. I would recommend using the latest general release for your development instance, and only using dev releases for future-release testing.

    As for the error, I am not sure why the table would be missing, but I would start with reviewing the requirements and making sure your installation meets them, perhaps if you MySQL is not the right version you are missing something the steps that create the database:

    support.sugarcrm.com/.../

Children
  • 0 in reply to Francesca Shiekh

    Hi Francesca. Thank you for your response.

    I've been using the 10.3 developer version with Vagrant, I picked the latest developer version to download and attempt the WAMP install with essentially to match our cloud version number.

    The reason I'm trying to use a developer release is because the full version isn't listed for me in the downloads on the support site, I've logged a ticket with support about this.

    I was using PHP 7.3.21, MySQL 5.7.31, Apache 2.4.46, Elasticsearch 7.13.2. which I believe met the requirements. I've since updated WAMP to the latest version and tried again with MySQL 8.0.25 but still had the same "Database failure" message at the end of the install. In both cases sugarcrm database is created, its just empty.