dockers/pixelfed
3
1
Fork 2
Code Issues 6 Pull requests Releases Activity

Database key issue #19

New issue
Open
opened 2024-08-18 19:07:40 +00:00 by catpawz · 0 comments
catpawz commented 2024-08-18 19:07:40 +00:00
Copy link

Haii haii, I've been trying to install pixelfed using the documentaion at https://blog.pixelfed.de/2020/05/29/pixelfed-in-docker/ and I keep running into this issue with my DB (full log)

 2018_08_27_004653_update_media_table_add_alt_text ............. 33.42ms DONE
  2018_09_02_042235_create_follow_requests_table ................ 14.59ms DONE
  2018_09_02_043240_update_profile_table_add_ap_urls ............ 17.28ms DONE
  2018_09_02_043609_create_instances_table ...................... 10.43ms DONE
  2018_09_10_024252_update_import_datas_table ................... 14.77ms DONE
  2018_09_11_202435_create_activities_table ...................... 6.71ms DONE
  2018_09_18_043334_add_cw_desc_to_status ........................ 2.82ms DONE
  2018_09_19_060554_create_stories_table ......................... 5.45ms DONE
  2018_09_19_060611_create_story_reactions_table ................. 8.48ms DONE
  2018_09_27_040314_create_collections_table ..................... 9.70ms DONE
  2018_09_30_051108_create_direct_messages_table ................ 21.79ms DONE
  2018_10_02_040917_create_collection_items_table ............... 23.12ms DONE
  2018_10_09_043717_update_status_visibility_defaults ............ 2.73ms DONE
  2018_10_17_033327_update_status_add_scope_column .............. 10.08ms DONE
  2018_10_17_233623_update_follower_table_add_remote_flags ...... 14.73ms DONE
  2018_10_18_035552_update_media_add_alt_text ................... 17.85ms DONE
  2018_10_25_030944_update_profile_table ......................... 7.88ms DONE
  2018_12_01_020238_add_type_to_status_table ..................... 9.12ms DONE
  2018_12_22_055940_add_account_status_to_profiles_table ........ 27.76ms DONE
  2018_12_24_032921_add_delete_after_to_user_table ............... 7.13ms DONE
  2018_12_30_065102_update_profiles_table_use_text_for_bio ...... 19.55ms DONE
  2019_01_11_005556_update_profiles_table ....................... 26.94ms DONE
  2019_01_12_054413_stories ..................................... 63.18ms DONE
  2019_01_22_030129_create_pages_table .......................... 72.15ms DONE
  2019_02_01_023357_add_remote_to_avatars_table ................. 15.18ms DONE
  2019_02_07_004642_create_discover_categories_table ............ 20.11ms DONE
  2019_02_07_021214_create_discover_category_hashtags_table ..... 22.66ms DONE
  2019_02_08_192219_create_websockets_statistics_entries_table ... 6.68ms DONE
  2019_02_09_045935_create_circles_table ........................ 16.69ms DONE
  2019_02_09_045956_create_circle_profiles_table ................ 27.32ms DONE
  2019_02_13_195702_add_indexes ................................. 68.08ms DONE
  2019_02_13_221138_add_soft_delete_indexes ..................... 39.68ms DONE
  2019_02_15_033323_create_user_invites_table ................... 24.46ms DONE
  2019_03_02_023245_add_profile_id_to_status_hashtags_table ...... 8.96ms DONE
  2019_03_06_065528_create_user_devices_table ................... 25.14ms DONE
  2019_03_12_043935_add_snowflakeids_to_users_table .............. 1.88ms FAIL
[2024-08-18 19:02:59] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (Connection: mysql, SQL: alter table `statuses` drop primary key) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (Connection: mysql, SQL: alter table `statuses` drop primary key) at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:813)
[stacktrace]
#0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(117): Illuminate\\Database\\Connection->statement()
#3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#4 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()

#5 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(357): Illuminate\\Database\\Schema\\Builder->table()
#6 /var/www/database/migrations/2019_03_12_043935_add_snowflakeids_to_users_table.php(16): Illuminate\\Support\\Facades\\Facade::__callStatic()
#7 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(475): AddSnowflakeidsToUsersTable->up()
#8 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#9 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#10 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#11 /var/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#12 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(736): Illuminate\\Console\\View\\Components\\Task->render()
#13 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->write()
#14 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(179): Illuminate\\Database\\Migrations\\Migrator->runUp()
#15 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(122): Illuminate\\Database\\Migrations\\Migrator->runPending()
#16 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()
#17 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(615): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#18 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#19 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#20 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#21 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#22 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#23 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#24 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#25 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#26 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#27 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#28 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
#29 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand()
#30 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/FreshCommand.php(82): Illuminate\\Console\\Command->call()
#31 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\FreshCommand->handle()
#32 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#33 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#34 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#35 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#36 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#37 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#38 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#39 /var/www/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()
#40 /var/www/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()
#41 /var/www/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()
#42 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run()
#43 /var/www/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#44 {main}

[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571)
[stacktrace]
#0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(800): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#4 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(117): Illuminate\\Database\\Connection->statement()
#5 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#7 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(357): Illuminate\\Database\\Schema\\Builder->table()
#8 /var/www/database/migrations/2019_03_12_043935_add_snowflakeids_to_users_table.php(16): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(475): AddSnowflakeidsToUsersTable->up()
#10 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#12 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /var/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#14 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(736): Illuminate\\Console\\View\\Components\\Task->render()
#15 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(179): Illuminate\\Database\\Migrations\\Migrator->runUp()
#17 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(122): Illuminate\\Database\\Migrations\\Migrator->runPending()
#18 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()
#19 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(615): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#20 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#21 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#22 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#23 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#24 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#27 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#28 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#29 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#30 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
#31 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand()
#32 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/FreshCommand.php(82): Illuminate\\Console\\Command->call()
#33 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\FreshCommand->handle()
#34 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#35 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#36 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#37 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()
#38 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#39 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#40 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#41 /var/www/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()
#42 /var/www/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()
#43 /var/www/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()
#44 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run()
#45 /var/www/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#46 {main}
"} 
In Connection.php line 813:
                                                                               
  SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def  
  inition; there can be only one auto column and it must be defined as a key   
  (Connection: mysql, SQL: alter table `statuses` drop primary key)            
                                                                               

In Connection.php line 571:
                                                                               
  SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def  
  inition; there can be only one auto column and it must be defined as a key
Haii haii, I've been trying to install pixelfed using the documentaion at https://blog.pixelfed.de/2020/05/29/pixelfed-in-docker/ and I keep running into this issue with my DB (full log) ``` 2018_08_27_004653_update_media_table_add_alt_text ............. 33.42ms DONE 2018_09_02_042235_create_follow_requests_table ................ 14.59ms DONE 2018_09_02_043240_update_profile_table_add_ap_urls ............ 17.28ms DONE 2018_09_02_043609_create_instances_table ...................... 10.43ms DONE 2018_09_10_024252_update_import_datas_table ................... 14.77ms DONE 2018_09_11_202435_create_activities_table ...................... 6.71ms DONE 2018_09_18_043334_add_cw_desc_to_status ........................ 2.82ms DONE 2018_09_19_060554_create_stories_table ......................... 5.45ms DONE 2018_09_19_060611_create_story_reactions_table ................. 8.48ms DONE 2018_09_27_040314_create_collections_table ..................... 9.70ms DONE 2018_09_30_051108_create_direct_messages_table ................ 21.79ms DONE 2018_10_02_040917_create_collection_items_table ............... 23.12ms DONE 2018_10_09_043717_update_status_visibility_defaults ............ 2.73ms DONE 2018_10_17_033327_update_status_add_scope_column .............. 10.08ms DONE 2018_10_17_233623_update_follower_table_add_remote_flags ...... 14.73ms DONE 2018_10_18_035552_update_media_add_alt_text ................... 17.85ms DONE 2018_10_25_030944_update_profile_table ......................... 7.88ms DONE 2018_12_01_020238_add_type_to_status_table ..................... 9.12ms DONE 2018_12_22_055940_add_account_status_to_profiles_table ........ 27.76ms DONE 2018_12_24_032921_add_delete_after_to_user_table ............... 7.13ms DONE 2018_12_30_065102_update_profiles_table_use_text_for_bio ...... 19.55ms DONE 2019_01_11_005556_update_profiles_table ....................... 26.94ms DONE 2019_01_12_054413_stories ..................................... 63.18ms DONE 2019_01_22_030129_create_pages_table .......................... 72.15ms DONE 2019_02_01_023357_add_remote_to_avatars_table ................. 15.18ms DONE 2019_02_07_004642_create_discover_categories_table ............ 20.11ms DONE 2019_02_07_021214_create_discover_category_hashtags_table ..... 22.66ms DONE 2019_02_08_192219_create_websockets_statistics_entries_table ... 6.68ms DONE 2019_02_09_045935_create_circles_table ........................ 16.69ms DONE 2019_02_09_045956_create_circle_profiles_table ................ 27.32ms DONE 2019_02_13_195702_add_indexes ................................. 68.08ms DONE 2019_02_13_221138_add_soft_delete_indexes ..................... 39.68ms DONE 2019_02_15_033323_create_user_invites_table ................... 24.46ms DONE 2019_03_02_023245_add_profile_id_to_status_hashtags_table ...... 8.96ms DONE 2019_03_06_065528_create_user_devices_table ................... 25.14ms DONE 2019_03_12_043935_add_snowflakeids_to_users_table .............. 1.88ms FAIL [2024-08-18 19:02:59] production.ERROR: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (Connection: mysql, SQL: alter table `statuses` drop primary key) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (Connection: mysql, SQL: alter table `statuses` drop primary key) at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:813) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\\Database\\Connection->runQueryCallback() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(117): Illuminate\\Database\\Connection->statement() #3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build() #4 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build() #5 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(357): Illuminate\\Database\\Schema\\Builder->table() #6 /var/www/database/migrations/2019_03_12_043935_add_snowflakeids_to_users_table.php(16): Illuminate\\Support\\Facades\\Facade::__callStatic() #7 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(475): AddSnowflakeidsToUsersTable->up() #8 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400): Illuminate\\Database\\Migrations\\Migrator->runMethod() #9 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #10 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->runMigration() #11 /var/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #12 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(736): Illuminate\\Console\\View\\Components\\Task->render() #13 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->write() #14 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(179): Illuminate\\Database\\Migrations\\Migrator->runUp() #15 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(122): Illuminate\\Database\\Migrations\\Migrator->runPending() #16 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run() #17 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(615): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #18 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection() #19 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations() #20 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #21 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #22 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #23 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod() #24 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call() #25 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call() #26 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute() #27 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run() #28 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run() #29 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand() #30 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/FreshCommand.php(82): Illuminate\\Console\\Command->call() #31 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\FreshCommand->handle() #32 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #33 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #34 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod() #35 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call() #36 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call() #37 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute() #38 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run() #39 /var/www/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run() #40 /var/www/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand() #41 /var/www/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun() #42 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run() #43 /var/www/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle() #44 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key at /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571) [stacktrace] #0 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute() #1 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(800): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}() #2 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): Illuminate\\Database\\Connection->runQueryCallback() #3 /var/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run() #4 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(117): Illuminate\\Database\\Connection->statement() #5 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build() #6 /var/www/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build() #7 /var/www/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(357): Illuminate\\Database\\Schema\\Builder->table() #8 /var/www/database/migrations/2019_03_12_043935_add_snowflakeids_to_users_table.php(16): Illuminate\\Support\\Facades\\Facade::__callStatic() #9 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(475): AddSnowflakeidsToUsersTable->up() #10 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(400): Illuminate\\Database\\Migrations\\Migrator->runMethod() #11 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #12 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->runMigration() #13 /var/www/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}() #14 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(736): Illuminate\\Console\\View\\Components\\Task->render() #15 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(212): Illuminate\\Database\\Migrations\\Migrator->write() #16 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(179): Illuminate\\Database\\Migrations\\Migrator->runUp() #17 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(122): Illuminate\\Database\\Migrations\\Migrator->runPending() #18 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run() #19 /var/www/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(615): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}() #20 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection() #21 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations() #22 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle() #23 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #24 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #25 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod() #26 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call() #27 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call() #28 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute() #29 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run() #30 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run() #31 /var/www/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand() #32 /var/www/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/FreshCommand.php(82): Illuminate\\Console\\Command->call() #33 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\FreshCommand->handle() #34 /var/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}() #35 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure() #36 /var/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod() #37 /var/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call() #38 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call() #39 /var/www/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute() #40 /var/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run() #41 /var/www/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run() #42 /var/www/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand() #43 /var/www/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun() #44 /var/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run() #45 /var/www/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle() #46 {main} "} In Connection.php line 813: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key (Connection: mysql, SQL: alter table `statuses` drop primary key) In Connection.php line 571: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key ```
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: dockers/pixelfed#19
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?