BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Anarchy Online Archive => BeBot 0.5 support => Topic started by: taconis on August 29, 2008, 05:42:56 am

Title: Auto reinvite not setting (MySQL error)
Post by: taconis on August 29, 2008, 05:42:56 am

MySQL error (# 0) on query: UPDATE online SET reinvite = '0' WHERE nickname = 'toon name' AND botname = 'bot name'
Unknown column 'reinvite' in 'field list'

would this be in table botname_users?

Title: Re: Auto reinvite not setting (MySQL error)
Post by: Temar on August 29, 2008, 10:58:36 am

no reinvite should be online table, this is reinvite for bot restart/crashes
Yours online table should have the field reinvite no idea why it doesnt, i have checked the code and it seems fine

Title: Re: Auto reinvite not setting (MySQL error)
Post by: Nytridr on August 29, 2008, 08:01:53 pm

drop your online table and restart your bot.  Let the bot rebuild it and see if you still get the same message

Title: Re: Auto reinvite not setting (MySQL error)
Post by: Temar on August 29, 2008, 09:12:59 pm

or prevent any messing up of online bots, edit the table_version table and change the online version to 3 and restart 1 bot

Title: Re: Auto reinvite not setting (MySQL error)
Post by: taconis on August 30, 2008, 04:10:50 pm

Dropping table online and restarting worked.  Odd how the column was never created in the table on first run.