#Create postgres tables?

40 messages · Page 1 of 1 (latest)

dusk hawk
#

When attempting to run my bot, I get the error

line 245
  Exception data:
    Severity: ERROR
    SqlState: 42P01
    MessageText: relation "featured_logs" does not exist
    Position: 201
    File: parse_relation.c
    Line: 1381
    Routine: parserOpenTable
   --- End of inner exception stack trace ---

There are no tables in the fmbot database, how can I solve this?

clear river
#

It's a bit inconvenient right now, you need to manually run the migrations

dusk hawk
#

Oof yeah, I am running it in ptero so that is a bit inconvenient haha, I'll figure it out thanks!

clear river
#

What is ptero?

#

Pterodactyl?

dusk hawk
#

Yeah

clear river
#

Ah

dusk hawk
#

Actually seems to work pretty well, we'll see when I get the database up I guess

#

Does the bot need any privileged gateway intents btw?

clear river
#

You will probably not have the best experience trying to selfhost, the code is really only optimized for supporting the hosted instance

#

Yes, members and message content

dusk hawk
#

Did I miss that somewhere? Apologies if so

dusk hawk
clear river
#

No, there is a guide here but it is not complete I think https://fmbot.xyz/setup/

Development - .fmbot

Welcome to .fmbot! .fmbot is a social Discord bot that provides music statistics for you, your friends, and your fellow server members.

dusk hawk
#

Also hello fellow Bot Managers guild member haha, wasn't sure if you were there

clear river
#

Timescale is also no longer needed

dusk hawk
#

Oh really

clear river
#

Oh hey

dusk hawk
#

Well I'm sure I'll find a use for it haha

#

That's the guide I was following

dusk hawk
#

Apologies, I'm unfamiliar with dotnet

clear river
#

In the /src should work

dusk hawk
#

Unable to retrieve project metadata. Ensure it's an SDK-style project. If you're using a custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option.

clear river
#

Hmm, not familiar with that error

dusk hawk
#

Hmm

dusk hawk
#

So I got the command to run with no errors but it doesn't appear anything is being put into the database either, strange

dusk hawk
clear river
#

not sure

dusk hawk
#

think fresh install running the command doesnt create tables either

#

tried recreating database to no avail

ivory moat
# clear river Timescale is also no longer needed

Sorry to revive this thread but I'm trying to run fmbot locally and I'm getting Npgsql.PostgresException (0x80004005): 58P01: could not open extension control file "/opt/homebrew/share/postgresql@14/extension/timescaledb.control": No such file or directory on the dev branch when running migrations. I'm currently downloading an updated version of xcode in order to install timescaledb but am I supposed to be getting that message at all?

#

Actually I'll try just skipping that migration since it's removed later, duh

#

Had to comment out a few other migrations too regarding user_play_ts but after doing that migrations all worked. Sorry for the ping

clear river