Base table or view already exists: Table 'banned_ips'

Question

Base table or view already exists: Table 'banned_ips'

Closed this issue 2 years ago · 1 comments

iPurpl3x commented 3 years ago

Bug Report

Current Behavior
PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'banned_ips'

Steps to Reproduce

Initially I don't know but the extension was disabled
Activate the extension from the admin panel

Expected Behavior
No error

Environment

Flarum version: 1.0.4
Extension version: 1.0.0
Hosting environment: local

Possible solution(s)

Adjust the code of the migration where this table is created to handle situations where the DB already contains the table.

Answer 1 · 2021-09-14T12:12:44.000Z

The migration should not need to account for existing table because it should only run once on an installation... This issue sometimes pops up on other exts as well so it might be a core issues but i don't think we have enough info to figure out what the root cause is.