BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: Organizer on August 04, 2009, 12:15:52 pm

Title: Change of table names with 6.4?
Post by: Organizer on August 04, 2009, 12:15:52 pm
Just to get it confirmed, did you guys change the table names since 6.1/2? When I recently upgraded to 6.4b rev 161 at the time) I ended up with tons of issues due to new tables with the prefix underscore (_) being created, so its now e.g. _users, _news, _city and so on. While it create these new tables it did as well not copy the content from the ones, so first thought it was a glitch but as far as I can see in the code you are using _ hardcoded and just confused to why, as the database looks messy like hell now :)

Maybe I did something wrong, sure looks like it except for the code fact. Comment welcome as I see some of my existing custom tables also got their twin brother _tablename created...

Organizer
Title: Re: Change of table names with 6.4?
Post by: Getrix on August 04, 2009, 12:36:38 pm
Probly the same bug reported here?:
https://bugs.launchpad.net/bebot/+bug/404606
Title: Re: Change of table names with 6.4?
Post by: Organizer on August 04, 2009, 01:30:40 pm
Yeah, looks like that is connected... so if I remove the // for $table_prefix to set it to ""; (empty) I guess it should fix that. For $nounderscore = FALSE; I'd say it's correct as it is already, unless the description is bad.

Will restart and test, but yeah it was highly annoying :)

Organizer
Title: Re: Change of table names with 6.4?
Post by: Khalem on August 04, 2009, 05:18:22 pm
At one stage there was a bug which would lead to issues with table names, but that should be resolved for 0.6.4 final.

However using no prefix at all is a special case that probably has not been tested much at all and i'm fairly certain that you could end up with an underscore if you use no prefix.

Please post a bug report on the issue or reopen the mentioned bug if you feel it pertains to the same issue.
Title: Re: Change of table names with 6.4?
Post by: Organizer on August 04, 2009, 06:11:34 pm
Just enabled that to default "" looks all good, had to manually rename delete and fix all my double tables and so on to clean up, but been using it like this for 1 year now so seems all fine... thanks for hinting me in the right direction :)
Title: Re: Change of table names with 6.4?
Post by: Khalem on August 04, 2009, 06:43:04 pm
There has to be some perils for running Bazaar snapshots ;)
SimplePortal 2.3.7 © 2008-2024, SimplePortal