thankyou
Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
In our support boards we aim to provide support for the B3 core in its current state. Older releases of B3 are NOT supported. Check our front page for the latest version. You may post feature requests in our General Discussion board. Modifications and Hacks of the core B3 code are NOT supported.
Before you ask for support: [ Read the Support Instructions ] - More info: [ Full Support Disclaimer ]

Author Topic: Help Upgrading 1.9.2 Python to v1.10.0  (Read 2350 times)

Offline dude4him

  • Newbie
  • *
  • Posts: 7
Help Upgrading 1.9.2 Python to v1.10.0
« on: August 06, 2014, 03:15:49 PM »
What is the best way to upgrade an existing working install of v1.9.2 Python version on Win2003?

There is no upgrade path  available via command line (console just says no update available) so what is the correct method to upgrade? I have the B3 v1.10 .zip off github

We are looking forward to using the !xlrid command with our xlrstats v3 installation that is working great but xlrid is a B3 v1.10 command.


Offline Fenix

  • Dev. Team
  • Hero Member
  • *
  • Posts: 999
    • GitHub
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #1 on: August 06, 2014, 04:11:05 PM »
1)
Backup your configuration files (both b3.xml and plugin configuration files). unpack the b3 1.10dev build into a directory and restore your configuration files. Look that in b3 1.10 some configuration files changed format from .xml to .ini, so you will probably have duplicated config files for plugins (not an issue anyway if you use the same b3.xml file). Also some new configuration values have been added to the admin plugin which you may need to port to your config file.

2)
Second option is to make a clean install of b3 1.10 dev and edit manually all the configuration file (porting your settings).

I was working on an updater solution for B3 but at the moment I'm focusing on something else. I will try to finish it so it can be released with B3 1.10 stable

Offline dude4him

  • Newbie
  • *
  • Posts: 7
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #2 on: August 06, 2014, 05:31:07 PM »
Thank you - option 1 worked fine and B3 is running v1.10.0. However, the xlrstats plugin is giving us fits. While xlrstatus says its running other xlr commands error out. For instance, !xlrtopstats works but not !xlrstats.

So I wonder, In the \b3\sql folder there is: b3-update-1.10.0.sql

Is it necessary to run this to add new tables or is the table structure the same?

Commands run:

« Last Edit: August 06, 2014, 05:51:27 PM by dude4him »

Offline dude4him

  • Newbie
  • *
  • Posts: 7
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #3 on: August 06, 2014, 06:42:34 PM »
In the b3.log I see the xlrstats plugin complaining about not being able to find a table named playerstats but in MySQL Workbench I only see table named xlr_playerstats:

140806 11:02:29   DEBUG   "XlrstatsPlugin: No option 'playerstats' in section: 'tables'"
140806 11:02:29   INFO   'XlrstatsPlugin: Using value "playerstats_table" for tables::playerstats'
140806 11:02:29   DEBUG   "XlrstatsPlugin: No option 'actionstats' in section: 'tables'"
140806 11:02:29   INFO   'XlrstatsPlugin: Using value "actionstats_table" for tables::actionstats'
140806 11:02:29   DEBUG   "XlrstatsPlugin: No option 'weaponstats' in section: 'tables'"
140806 11:02:29   INFO   'XlrstatsPlugin: Using value "weaponstats_table" for tables::weaponstats'



Offline Fenix

  • Dev. Team
  • Hero Member
  • *
  • Posts: 999
    • GitHub
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #4 on: August 06, 2014, 09:26:33 PM »
Those are not warnings, just debug messages. The XLRstats plugin allow you to customize the name of the tables. If no name is specified in the configuration file the default one is used.
As for the update, you need to execute the following SQL queries:

https://github.com/BigBrotherBot/big-brother-bot/blob/release-1.10/b3/sql/b3-update-1.10.0.sql

Offline dude4him

  • Newbie
  • *
  • Posts: 7
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #5 on: August 06, 2014, 09:49:30 PM »
Great, thank you it worked perfectly. I wanted to check first before running the 1.10.0 query not wanting to chance a db corruption. Thanks! The xlrid is awesome and working on our CoD2 :)

Offline Fenix

  • Dev. Team
  • Hero Member
  • *
  • Posts: 999
    • GitHub
Re: Help Upgrading 1.9.2 Python to v1.10.0
« Reply #6 on: August 06, 2014, 09:54:35 PM »
I wanted to check first before running the 1.10.0 query not wanting to chance a db corruption
Always make backups ^_^

 


Rate this page +1 at Google Search