SQL Error When Upgrading To OctoberCMS 3.1

responsive · October 7, 2022, 12:12am

Hi there,

When upgrading from OctoberCMS v3.0 to 3.1 I am getting an SQL error.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.system_site_definitions' doesnt exist

So a DB table is missing. Is there the schema for this table somewhere so I can manually create it? Or does anyone k now of another fix?

Thanks in advance,

Cy

daft · October 7, 2022, 12:23am

Hey Cy

This table should be created by running

php artisan october:migrate

responsive · October 7, 2022, 12:54am

Thanks for coming back so quickly Sam.

The migration step is where it initially failed, so re-running october:migrate is throwing the same error.

I ran a seperate fresh install of v3.1, grabbed the missing DB table and imported it into the installation I’m trying to upgrade. This time it complained the ‘system_site_definitions’ table already existed. When I remove the table it complains the table is missing.

By reimporting the ‘system_site_definitions’ table at least the admin dashboard is reachable, just october:migrate or october:update fail.

Any thoughts?

daft · October 7, 2022, 1:06am

I cannot replicate this problem by renaming the site definitions table. All artisan commands are running normally when the table does not exist.

We need to find the code that is requesting the table before the migration, do you see a complete stack trace in the system log?

responsive · October 7, 2022, 2:03am

Hey Sam,

See stack trace.

TABLE ALREADY EXISTS:

PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'system_site_definitions' already exists in /Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117):
PDOStatement->execute(NULL)
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(544):
Doctrine\DBAL\Driver\PDOStatement->execute()
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752):
Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `s...', Array)
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545):
Illuminate\Database\Connection->run('create table `s...', Array, Object(Closure))
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(109):
Illuminate\Database\Connection->statement('create table `s...')
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(404):
Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(267):
Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
Illuminate\Database\Schema\Builder->create('system_site_def...', Object(Closure))
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/database/migrations/2022_10_01_000026_Db_System_Site_Definitions.php(37):
Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(482):
DbSystemSiteDefinitions->up()
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400):
Illuminate\Database\Migrations\Migrator->runMethod(Object(October\Rain\Database\Connections\MySqlConnection), Object(DbSystemSiteDefinitions), 'up')
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->runMigration(Object(DbSystemSiteDefinitions), 'up')
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(36):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(740):
Illuminate\Console\View\Components\Task->render('2022_10_01_0000...', Object(Closure))
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->write('Illuminate\\Cons...', '2022_10_01_0000...', Object(Closure))
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(175):
Illuminate\Database\Migrations\Migrator->runUp('/Users/responsi...', 6, false)
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(118):
Illuminate\Database\Migrations\Migrator->runPending(Array, Array)
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/updatemanager/ManagesModules.php(36):
Illuminate\Database\Migrations\Migrator->run('/Users/responsi...')
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/UpdateManager.php(119):
System\Classes\UpdateManager->migrateModule('System')
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/console/OctoberMigrate.php(40):
System\Classes\UpdateManager->update()
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\Console\OctoberMigrate->handle()
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(144):
Illuminate\Container\Container->call(Array)
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Command/Command.php(291):
Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(126):
Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(1002):
Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(299):
Symfony\Component\Console\Application->doRunCommand(Object(System\Console\OctoberMigrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(171):
Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Application.php(102):
Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(151):
Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#35
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#36
{main}
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119):
Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(544):
Doctrine\DBAL\Driver\PDOStatement->execute()
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752):
Illuminate\Database\Connection->Illuminate\Database\{closure}('create table `s...', Array)
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545):
Illuminate\Database\Connection->run('create table `s...', Array, Object(Closure))
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(109):
Illuminate\Database\Connection->statement('create table `s...')
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(404):
Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(267):
Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
Illuminate\Database\Schema\Builder->create('system_site_def...', Object(Closure))
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/database/migrations/2022_10_01_000026_Db_System_Site_Definitions.php(37):
Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(482):
DbSystemSiteDefinitions->up()
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400):
Illuminate\Database\Migrations\Migrator->runMethod(Object(October\Rain\Database\Connections\MySqlConnection), Object(DbSystemSiteDefinitions), 'up')
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->runMigration(Object(DbSystemSiteDefinitions), 'up')
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(36):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(740):
Illuminate\Console\View\Components\Task->render('2022_10_01_0000...', Object(Closure))
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->write('Illuminate\\Cons...', '2022_10_01_0000...', Object(Closure))
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(175):
Illuminate\Database\Migrations\Migrator->runUp('/Users/responsi...', 6, false)
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(118):
Illuminate\Database\Migrations\Migrator->runPending(Array, Array)
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/updatemanager/ManagesModules.php(36):
Illuminate\Database\Migrations\Migrator->run('/Users/responsi...')
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/UpdateManager.php(119):
System\Classes\UpdateManager->migrateModule('System')
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/console/OctoberMigrate.php(40):
System\Classes\UpdateManager->update()
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\Console\OctoberMigrate->handle()
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(144):
Illuminate\Container\Container->call(Array)
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Command/Command.php(291):
Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(126):
Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(1002):
Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(299):
Symfony\Component\Console\Application->doRunCommand(Object(System\Console\OctoberMigrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(171):
Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Application.php(102):
Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(151):
Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#35
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#36
{main}
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('create table `s...', Array, Object(Closure))
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(545):
Illuminate\Database\Connection->run('create table `s...', Array, Object(Closure))
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(109):
Illuminate\Database\Connection->statement('create table `s...')
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(404):
Illuminate\Database\Schema\Blueprint->build(Object(October\Rain\Database\Connections\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(267):
Illuminate\Database\Schema\Builder->build(Object(October\Rain\Database\Schema\Blueprint))
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
Illuminate\Database\Schema\Builder->create('system_site_def...', Object(Closure))
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/database/migrations/2022_10_01_000026_Db_System_Site_Definitions.php(37):
Illuminate\Support\Facades\Facade::__callStatic('create', Array)
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(482):
DbSystemSiteDefinitions->up()
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400):
Illuminate\Database\Migrations\Migrator->runMethod(Object(October\Rain\Database\Connections\MySqlConnection), Object(DbSystemSiteDefinitions), 'up')
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->runMigration(Object(DbSystemSiteDefinitions), 'up')
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(36):
Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(740):
Illuminate\Console\View\Components\Task->render('2022_10_01_0000...', Object(Closure))
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(210):
Illuminate\Database\Migrations\Migrator->write('Illuminate\\Cons...', '2022_10_01_0000...', Object(Closure))
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(175):
Illuminate\Database\Migrations\Migrator->runUp('/Users/responsi...', 6, false)
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(118):
Illuminate\Database\Migrations\Migrator->runPending(Array, Array)
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/updatemanager/ManagesModules.php(36):
Illuminate\Database\Migrations\Migrator->run('/Users/responsi...')
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/UpdateManager.php(119):
System\Classes\UpdateManager->migrateModule('System')
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/console/OctoberMigrate.php(40):
System\Classes\UpdateManager->update()
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\Console\OctoberMigrate->handle()
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(144):
Illuminate\Container\Container->call(Array)
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Command/Command.php(291):
Illuminate\Console\Command->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Command.php(126):
Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Illuminate\Console\OutputStyle))
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(1002):
Illuminate\Console\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(299):
Symfony\Component\Console\Application->doRunCommand(Object(System\Console\OctoberMigrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/symfony/console/Application.php(171):
Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Console/Application.php(102):
Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(151):
Illuminate\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33
{main}

Thanks.

responsive · October 7, 2022, 2:04am

TABLE DOESN’T EXIST

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ngatipukenga_db_dev.system_site_definitions' doesn't exist in /Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(82):
PDO->prepare('select * from `...', Array)
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(413):
Doctrine\DBAL\Driver\PDOConnection->prepare('select * from `...')
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752):
Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421):
Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2636):
Illuminate\Database\Connection->select('select * from `...', Array, true)
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2624):
Illuminate\Database\Query\Builder->runSelect()
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3160):
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2625):
Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/QueryBuilder.php(90):
Illuminate\Database\Query\Builder->get(Array)
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(699):
October\Rain\Database\QueryBuilder->get(Array)
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(683):
Illuminate\Database\Eloquent\Builder->getModels(Array)
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597):
Illuminate\Database\Eloquent\Builder->get(Array)
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(145):
Illuminate\Database\Eloquent\Model::all()
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(87):
System\Classes\SiteManager->listSites()
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
System\Classes\SiteManager->getPrimarySite()
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Locale.php(44):
Illuminate\Support\Facades\Facade::__callStatic('getPrimarySite', Array)
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Translator.php(45):
RainLab\Translate\Classes\Locale::getDefaultSiteLocale()
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(40):
RainLab\Translate\Classes\Translator->init()
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(24):
RainLab\Translate\Classes\Translator->__construct()
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(94):
RainLab\Translate\Classes\Translator::instance()
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(59):
RainLab\Translate\Classes\TranslatableBehavior->initTranslatableContext()
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/behaviors/TranslatableModel.php(23):
RainLab\Translate\Classes\TranslatableBehavior->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(235):
RainLab\Translate\Behaviors\TranslatableModel->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(81):
October\Rain\Database\Model->extendClassWith('RainLab\\Transla...')
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/Model.php(62):
October\Rain\Database\Model->extendableConstruct()
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2242):
October\Rain\Database\Model->__construct()
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/janvince/smallextensions/Plugin.php(996):
Illuminate\Database\Eloquent\Model::__callStatic('get', Array)
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(307):
JanVince\SmallExtensions\Plugin->boot()
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(286):
System\Classes\PluginManager->bootPlugin(Object(JanVince\SmallExtensions\Plugin), 'JanVince.SmallE...')
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(273):
System\Classes\PluginManager->bootAll()
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/ServiceProvider.php(97):
System\Classes\PluginManager->bootFromProvider()
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\ServiceProvider->boot()
#33
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#35
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#36
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#37
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933):
Illuminate\Container\Container->call(Array)
#38
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(914):
Illuminate\Foundation\Application->bootProvider(Object(System\ServiceProvider))
#39
[internal function]:
Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(System\ServiceProvider), 28)
#40
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(915):
array_walk(Array, Object(Closure))
#41
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17):
Illuminate\Foundation\Application->boot()
#42
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(242):
Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))
#43
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(375):
Illuminate\Foundation\Application->bootstrapWith(Array)
#44
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(149):
Illuminate\Foundation\Console\Kernel->bootstrap()
#45
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#46
{main}
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(87):
Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(413):
Doctrine\DBAL\Driver\PDOConnection->prepare('select * from `...')
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(752):
Illuminate\Database\Connection->Illuminate\Database\{closure}('select * from `...', Array)
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421):
Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2636):
Illuminate\Database\Connection->select('select * from `...', Array, true)
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2624):
Illuminate\Database\Query\Builder->runSelect()
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3160):
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2625):
Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/QueryBuilder.php(90):
Illuminate\Database\Query\Builder->get(Array)
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(699):
October\Rain\Database\QueryBuilder->get(Array)
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(683):
Illuminate\Database\Eloquent\Builder->getModels(Array)
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597):
Illuminate\Database\Eloquent\Builder->get(Array)
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(145):
Illuminate\Database\Eloquent\Model::all()
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(87):
System\Classes\SiteManager->listSites()
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
System\Classes\SiteManager->getPrimarySite()
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Locale.php(44):
Illuminate\Support\Facades\Facade::__callStatic('getPrimarySite', Array)
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Translator.php(45):
RainLab\Translate\Classes\Locale::getDefaultSiteLocale()
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(40):
RainLab\Translate\Classes\Translator->init()
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(24):
RainLab\Translate\Classes\Translator->__construct()
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(94):
RainLab\Translate\Classes\Translator::instance()
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(59):
RainLab\Translate\Classes\TranslatableBehavior->initTranslatableContext()
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/behaviors/TranslatableModel.php(23):
RainLab\Translate\Classes\TranslatableBehavior->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(235):
RainLab\Translate\Behaviors\TranslatableModel->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(81):
October\Rain\Database\Model->extendClassWith('RainLab\\Transla...')
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/Model.php(62):
October\Rain\Database\Model->extendableConstruct()
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2242):
October\Rain\Database\Model->__construct()
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/janvince/smallextensions/Plugin.php(996):
Illuminate\Database\Eloquent\Model::__callStatic('get', Array)
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(307):
JanVince\SmallExtensions\Plugin->boot()
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(286):
System\Classes\PluginManager->bootPlugin(Object(JanVince\SmallExtensions\Plugin), 'JanVince.SmallE...')
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(273):
System\Classes\PluginManager->bootAll()
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/ServiceProvider.php(97):
System\Classes\PluginManager->bootFromProvider()
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\ServiceProvider->boot()
#33
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#34
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#35
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#36
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#37
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933):
Illuminate\Container\Container->call(Array)
#38
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(914):
Illuminate\Foundation\Application->bootProvider(Object(System\ServiceProvider))
#39
[internal function]:
Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(System\ServiceProvider), 28)
#40
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(915):
array_walk(Array, Object(Closure))
#41
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17):
Illuminate\Foundation\Application->boot()
#42
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(242):
Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))
#43
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(375):
Illuminate\Foundation\Application->bootstrapWith(Array)
#44
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(149):
Illuminate\Foundation\Console\Kernel->bootstrap()
#45
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#46
{main}
#0
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(719):
Illuminate\Database\Connection->runQueryCallback('select * from `...', Array, Object(Closure))
#1
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Connection.php(421):
Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure))
#2
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2636):
Illuminate\Database\Connection->select('select * from `...', Array, true)
#3
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2624):
Illuminate\Database\Query\Builder->runSelect()
#4
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3160):
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()
#5
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2625):
Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure))
#6
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/QueryBuilder.php(90):
Illuminate\Database\Query\Builder->get(Array)
#7
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(699):
October\Rain\Database\QueryBuilder->get(Array)
#8
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(683):
Illuminate\Database\Eloquent\Builder->getModels(Array)
#9
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597):
Illuminate\Database\Eloquent\Builder->get(Array)
#10
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(145):
Illuminate\Database\Eloquent\Model::all()
#11
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/SiteManager.php(87):
System\Classes\SiteManager->listSites()
#12
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338):
System\Classes\SiteManager->getPrimarySite()
#13
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Locale.php(44):
Illuminate\Support\Facades\Facade::__callStatic('getPrimarySite', Array)
#14
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/Translator.php(45):
RainLab\Translate\Classes\Locale::getDefaultSiteLocale()
#15
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(40):
RainLab\Translate\Classes\Translator->init()
#16
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Support/Traits/Singleton.php(24):
RainLab\Translate\Classes\Translator->__construct()
#17
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(94):
RainLab\Translate\Classes\Translator::instance()
#18
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/classes/TranslatableBehavior.php(59):
RainLab\Translate\Classes\TranslatableBehavior->initTranslatableContext()
#19
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/rainlab/translate/behaviors/TranslatableModel.php(23):
RainLab\Translate\Classes\TranslatableBehavior->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#20
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(235):
RainLab\Translate\Behaviors\TranslatableModel->__construct(Object(JanVince\SmallExtensions\Models\Settings))
#21
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Extension/ExtendableTrait.php(81):
October\Rain\Database\Model->extendClassWith('RainLab\\Transla...')
#22
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/october/rain/src/Database/Model.php(62):
October\Rain\Database\Model->extendableConstruct()
#23
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(2242):
October\Rain\Database\Model->__construct()
#24
/Users/responsive/Documents/Valet-Sites/ngatipukenga/plugins/janvince/smallextensions/Plugin.php(996):
Illuminate\Database\Eloquent\Model::__callStatic('get', Array)
#25
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(307):
JanVince\SmallExtensions\Plugin->boot()
#26
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(286):
System\Classes\PluginManager->bootPlugin(Object(JanVince\SmallExtensions\Plugin), 'JanVince.SmallE...')
#27
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/classes/PluginManager.php(273):
System\Classes\PluginManager->bootAll()
#28
/Users/responsive/Documents/Valet-Sites/ngatipukenga/modules/system/ServiceProvider.php(97):
System\Classes\PluginManager->bootFromProvider()
#29
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36):
System\ServiceProvider->boot()
#30
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Util.php(41):
Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#31
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93):
Illuminate\Container\Util::unwrapIfClosure(Object(Closure))
#32
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37):
Illuminate\Container\BoundMethod::callBoundMethod(Object(October\Rain\Foundation\Application), Array, Object(Closure))
#33
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Container/Container.php(651):
Illuminate\Container\BoundMethod::call(Object(October\Rain\Foundation\Application), Array, Array, NULL)
#34
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(933):
Illuminate\Container\Container->call(Array)
#35
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(914):
Illuminate\Foundation\Application->bootProvider(Object(System\ServiceProvider))
#36
[internal function]:
Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(System\ServiceProvider), 28)
#37
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(915):
array_walk(Array, Object(Closure))
#38
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/BootProviders.php(17):
Illuminate\Foundation\Application->boot()
#39
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(242):
Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(October\Rain\Foundation\Application))
#40
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(375):
Illuminate\Foundation\Application->bootstrapWith(Array)
#41
/Users/responsive/Documents/Valet-Sites/ngatipukenga/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(149):
Illuminate\Foundation\Console\Kernel->bootstrap()
#42
/Users/responsive/Documents/Valet-Sites/ngatipukenga/artisan(35):
Illuminate\Foundation\Console\Kernel->handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#43
{main}

daft · October 7, 2022, 2:21am

Thanks. This appears to be caused by the JanVince\SmallExtensions plugin that requests the table during the boot process. We will look at putting protections in place to stop it from blocking the entire system.

responsive · October 7, 2022, 3:22am

Thanks Sam.

I remove JanVince\SmallExtensions, removed the system_site_definitions table and re-ran october:update and all is good in the world.

Thanks for your help!