Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Connection.php SQL errors #43

Closed
mcwildcard opened this issue Oct 25, 2020 · 2 comments
Closed

Connection.php SQL errors #43

mcwildcard opened this issue Oct 25, 2020 · 2 comments

Comments

@mcwildcard
Copy link

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
Copy link
Contributor

ilumos commented Nov 11, 2020

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

Try running chmod +w database.sqlite

@mcwildcard
Copy link
Author

mcwildcard commented Nov 11, 2020 •
edited
Loading

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 👍

@ilumos ilumos closed this as completed Nov 12, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@ilumos @mcwildcard