Zuluru3 icon indicating copy to clipboard operation
Zuluru3 copied to clipboard

Table 'zuluru.countries' doesn't exist

Open mmerry opened this issue 1 year ago • 1 comments

From the latest cakephp4 branch, install and config both run ok, but when I browse to the site, it looks like countries table does not exist. I verified that its missing using Sequel Ace to browse the tables in the Zuluru database:

2024-12-03 07:15:10 error: [Cake\Database\Exception\DatabaseException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zuluru.countries' doesn't exist in /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/Collection.php on line 142 Stack Trace:

  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:100
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php:84
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:513
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Query.php:290
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Query.php:184
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:1702
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:1263
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Model/Table/ConfigurationTable.php:59
  • call_user_func - [internal], line ??- /Users/matthewmerry/newZuluru/Zuluru3/src/Cache/Cache.php:44
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Model/Table/ConfigurationTable.php:56
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Middleware/ConfigurationLoader.php:27
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Middleware/ConfigurationLoader.php:17
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:77
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:126
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:58
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Server.php:90
  • /Users/matthewmerry/newZuluru/Zuluru3/webroot/index.php:37

Caused by: [PDOException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zuluru.countries' doesn't exist in /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 39 Stack Trace:

  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php:39
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Connection.php:306
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php:70
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Connection.php:309
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:140
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/Collection.php:100
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php:84
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:513
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Query.php:290
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Query.php:184
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:1702
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/ORM/Table.php:1263
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Model/Table/ConfigurationTable.php:59
  • call_user_func - [internal], line ??- /Users/matthewmerry/newZuluru/Zuluru3/src/Cache/Cache.php:44
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Model/Table/ConfigurationTable.php:56
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Middleware/ConfigurationLoader.php:27
  • /Users/matthewmerry/newZuluru/Zuluru3/src/Middleware/ConfigurationLoader.php:17
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php:77
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php:126
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:73
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Runner.php:58
  • /Users/matthewmerry/newZuluru/Zuluru3/vendor/cakephp/cakephp/src/Http/Server.php:90
  • /Users/matthewmerry/newZuluru/Zuluru3/webroot/index.php:37

mmerry avatar Dec 04 '24 06:12 mmerry

The CakePHP 4 branch has (finally!) been finalized and merged to master. I'm hoping that this will finally clear up all these installation issues. I have successfully run installations of this using PHP 7.4 and MySQL 8.0.

Zuluru avatar Feb 27 '25 17:02 Zuluru