search

zeropingheroes / lancache-autofill

Automatically fill a Lancache with content
GNU General Public License v3.0
132 stars 24 forks source link

Connection.php SQL errors #43

Closed mcwildcard closed 3 years ago

mcwildcard commented 3 years ago

when attempting to initialise the database I get errors:

Creating empty database tables

In Connection.php line 664:

  SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (SQL: create table "steam_apps" ("id" integer not null, "name" va  
  rchar not null))                                                                                                                          

In Connection.php line 458:

  SQLSTATE[HY000]: General error: 8 attempt to write a readonly database

verbose output shows : 

Creating empty database tables

In Connection.php line 664:

  [Illuminate\Database\QueryException (HY000)]                                                                                              
  SQLSTATE[HY000]: General error: 8 attempt to write a readonly database (SQL: create table "steam_apps" ("id" integer not null, "name" va  
  rchar not null))                                                                                                                          

Exception trace:
  at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
 Illuminate\Database\Connection->runQueryCallback() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
 Illuminate\Database\Connection->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:459
 Illuminate\Database\Connection->statement() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:86
 Illuminate\Database\Schema\Blueprint->build() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:252
 Illuminate\Database\Schema\Builder->build() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:165
 Illuminate\Database\Schema\Builder->create() at /home/wildestcard/servers/autofill/lancache-autofill/src/Commands/App/InitialiseDatabase.php:49
 Zeropingheroes\LancacheAutofill\Commands\App\InitialiseDatabase->handle() at n/a:n/a
 call_user_func_array() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29
 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:87
 Illuminate\Container\BoundMethod::callBoundMethod() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:31
 Illuminate\Container\BoundMethod::call() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/Container.php:549
 Illuminate\Container\Container->call() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Command.php:183
 Illuminate\Console\Command->execute() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Command/Command.php:255 Symfony\Component\Console\Command\Command->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Command.php:170
 Illuminate\Console\Command->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:987
 Symfony\Component\Console\Application->doRunCommand() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:255
 Symfony\Component\Console\Application->doRun() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Application.php:88
 Illuminate\Console\Application->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121
 Illuminate\Foundation\Console\Kernel->handle() at /home/wildestcard/servers/autofill/lancache-autofill/lancache-autofill:44

In Connection.php line 458:

  [PDOException (HY000)]                                                  
  SQLSTATE[HY000]: General error: 8 attempt to write a readonly database  

Exception trace:
  at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458
 PDOStatement->execute() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458
 Illuminate\Database\Connection->Illuminate\Database\{closure}() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:657
 Illuminate\Database\Connection->runQueryCallback() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:624
 Illuminate\Database\Connection->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Connection.php:459
 Illuminate\Database\Connection->statement() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php:86
 Illuminate\Database\Schema\Blueprint->build() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:252
 Illuminate\Database\Schema\Builder->build() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:165
 Illuminate\Database\Schema\Builder->create() at /home/wildestcard/servers/autofill/lancache-autofill/src/Commands/App/InitialiseDatabase.php:49
 Zeropingheroes\LancacheAutofill\Commands\App\InitialiseDatabase->handle() at n/a:n/a
 call_user_func_array() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:29
 Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:87
 Illuminate\Container\BoundMethod::callBoundMethod() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:31
 Illuminate\Container\BoundMethod::call() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Container/Container.php:549
 Illuminate\Container\Container->call() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Command.php:183
 Illuminate\Console\Command->execute() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Command/Command.php:255 Symfony\Component\Console\Command\Command->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Command.php:170
 Illuminate\Console\Command->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:987
 Symfony\Component\Console\Application->doRunCommand() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:255
 Symfony\Component\Console\Application->doRun() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/symfony/console/Application.php:148
 Symfony\Component\Console\Application->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Console/Application.php:88
 Illuminate\Console\Application->run() at /home/wildestcard/servers/autofill/lancache-autofill/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121
 Illuminate\Foundation\Console\Kernel->handle() at /home/wildestcard/servers/autofill/lancache-autofill/lancache-autofill:44

I had some issues when installing dependencies so it could be caused by something on my end however i'm pretty new to linux and am not sure where to look to troubleshoot :P. any help would be appriciated

ilumos commented 3 years ago

What are the permissions of database.sqlite? Looks like the file is read only.

Try running chmod +w database.sqlite

mcwildcard commented 3 years ago

must have been an issue with the permissions of the folder I was using, just set the whole folder to 777 and it seems to be working now, thanks for your help 👍