Database did not build correctly -- Here's the manual SQL commands to fix it

[chemputer]

When I tried setting it up, the database did not build itself correctly, as in there was no users table or guilds table in the .db, so I had to do it manually with sqlite3. I'm good now, but I figured the code I used to fix it might help another person, so perhaps it could go on the Wiki? I dunno. I also have no idea why it didn't build, I couldn't narrow that down, sadly.

Here's the code:

First I cd'd to the ~/track/assets/private/ directory, then ran sqlite3 bot.db, putting me into the sqlite3 interface. I then typed these in several times before coming to my senses and typing them in VSCODE first and then fixing the errors as I went. These both work perfectly, as does the bot once set up.

    CREATE TABLE users (
        id INTEGER PRIMARY KEY,
        guess_count INTEGER DEFAULT 0,
        guess_record FLOAT,
        wg_region INTEGER,
        wg_id INTEGER,
        wg_ac STRING,
        background STRING,
        locale STRING,
        is_blacklisted BOOLEAN DEFAULT False,
        is_premium BOOLEAN DEFAULT False
        );

    CREATE TABLE guilds (
        id INTEGER PRIMARY KEY,
        disabled JSON DEFAULT "{}",
        wg_region INTEGER,
        locale STRING,
        is_blacklisted BOOLEAN DEFAULT False,
        is_premium BOOLEAN DEFAULT False
        );

[padtrack]

I was unable to reproduce this. Could you perhaps provide the contents of pip freeze?

[chemputer]

Unfortunately, I don't have this setup anymore as it's a Proxmox server, and I was running it from the host, rather than a VM, and I ran out of space on /root and had to delete crap I didn't need, and that was one of the things, then I realized I could expand the partition... I can't reproduce it either (well I thought I couldn't, but I just did, by accident, see next post), and I have no idea how it happened. I was hoping that if anyone got into the same situation that it might be useful if it was put in the wiki section. I dunno. Sorry for the late response.

There is another, minor issue, that I don't think deserves an actual issue, but if you wan't I'll make one. Figured it was worth mentioning.

ERROR: Cannot install -r requirements.txt (line 1) and Pillow>=9.4.0 because these package versions have conflicting dependencies.

The conflict is caused by:
    The user requested Pillow>=9.4.0
    minimap-renderer 0.11.8.1 depends on Pillow==9.2.0

To fix this you could try to:
1. loosen the range of package versions you've specified
2. remove package versions to allow pip attempt to solve the dependency conflict

ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/topics/dependency-resolution/#dealing-with-dependency-conflicts

Is there a reason it needs to be Pillow=>9.4.0? I just changed it to 9.2.0 and it worked fine, though I have not exhaustively tested it.

[chemputer]

Okay just as I say I can't reproduce it, it happens. How strange.

Here's the pip freeze, along with some of the error. I should stress that I have this running fine on a Ubuntu VPS, and this was just me trying it on a local machine. Yeah, same issue, same machine. Likely a configuration issue with my machine.

~/repos/track$ tmux a -t track_bot
    result = function()
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: users
[SQL: SELECT users.id, users.guess_count, users.guess_record, users.wg_region, users.wg_id, users.wg_ac, users.background, users.locale, users.is_blacklisted, users.is_premium
FROM users
WHERE users.id = ?]
[parameters: (<my_Discord_user_id>,)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^C(venv) turnerb@pve4:~/repos/track$ pip freeze
aiohttp==3.8.4
aiolimiter==1.1.0
aioredis==2.0.1
aiosignal==1.3.1
aiosqlite==0.19.0
astunparse==1.6.3
async-timeout==4.0.2
attrs==23.1.0
beautifulsoup4==4.12.2
black==23.3.0
braceexpand==0.1.7
cachetools==5.3.1
certifi==2023.5.7
charset-normalizer==2.1.1
click==8.1.3
dacite==1.8.1
Deprecated==1.2.14
discord==2.2.3
discord.py==2.3.0
environ==1.0
environ-config==23.2.0
frozenlist==1.3.3
greenlet==2.0.2
idna==3.4
imageio-ffmpeg==0.4.7
import-expression==1.1.4
jishaku==2.5.1
line-profiler==4.0.3
lxml==4.9.1
minimap-renderer @ git+https://github.com/WoWs-Builder-Team/minimap_renderer.git@43ae473aa8d954d5570e9a6fb3491630c8a92189
multidict==6.0.4
mypy-extensions==1.0.0
numpy==1.23.2
oauthlib==3.2.2
packaging==23.1
pathspec==0.11.1
Pillow==9.2.0
platformdirs==3.5.1
polib==1.2.0
psutil==5.9.5
pycryptodomex==3.15.0
redis==4.6.0
requests==2.31.0
requests-oauthlib==1.3.1
rq==1.15.1
six==1.16.0
soupsieve==2.4.1
SQLAlchemy==2.0.17
tabulate==0.9.0
toml==0.10.2
tomli==2.0.1
tqdm==4.64.0
tweepy==4.14.0
typing_extensions==4.6.3
Unidecode==1.3.6
urllib3==1.26.16
wrapt==1.15.0
yarl==1.9.2