webtrees icon indicating copy to clipboard operation
webtrees copied to clipboard

Published 20 hours ago • verified publisher icon fisharebest

Base table or view already exists on fresh db

Open abdullahaaf opened this issue 1 year ago • 2 comments

I just deploy webtrees 2.1.20 on https://www.koyeb.com/ and use my hosting as database provider. When initial setup I got error message like below picture : image

I already did some check that database that I use is completely fresh (no table created before)

does anyone ever face similar problem when setup webtrees on the first time?

Thanks before for the help.

abdullahaaf avatar May 05 '24 07:05 abdullahaaf

What tables do you have in the DB?

fisharebest avatar May 05 '24 07:05 fisharebest

image

currently after error raised, those tables exist on my DB

abdullahaaf avatar May 05 '24 07:05 abdullahaaf

These are the first 4 tables that are created. I guess that the installation failed or was interrupted at this point, and the subsequent tables were not created.

The code assumes that all ~30 tables will be created together.

Delete (DROP) these four tables and try again. If the same occurs, then it suggests an error creating the next table (wt_user_setting). Look closely in case any error messages are displayed.

fisharebest avatar May 29 '24 15:05 fisharebest