Maniaplanet Forum

Posted: **19 Aug 2011, 18:49**

We will upload a new .zip in the coming hours with the latest manialive and brand new fixes for the configuration... To see the fixes we made:

http://code.google.com/p/mlepp/source/list

Posted: **19 Aug 2011, 22:02**

Hmm, don't know why, but MLEPP isn't creating the database-tables automatically for me, and keeps throwing errors about how this and that table doesn't exist, even though it finds and successfully connects to the database, with all privileges

Code: Select all

Occured on 19.08.2011 at 22:57:44 at process with ID #5224
    ---------------------------------
 -> ManiaLive\Database\QueryException with code 1366
    Incorrect integer value: '' for column 'challenge_lapRace' at row 1
  - in C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Database\MySQL\Connection.php on line 150
  - Stack: #0 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Database\mleppDatabase.php(32): ManiaLive\Database\MySQL\Connection->query('INSERT INTO `ch...')
           #1 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Database\Database.php(976): ManiaLivePlugins\MLEPP\Database\mleppDatabase->query(Object(ManiaLivePlugins\MLEPP\Database\Structures\multiQuery))
           #2 [internal function]: ManiaLivePlugins\MLEPP\Database\Database->insertChallenge(Object(ManiaLive\DedicatedApi\Structures\Challenge), 'n/a', 'MLEPP\Jukebox')
           #3 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\PluginHandler\PluginHandler.php(347): ReflectionMethod->invokeArgs(Object(ManiaLivePlugins\MLEPP\Database\Database), Array)
           #4 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\PluginHandler\Plugin.php(279): ManiaLive\PluginHandler\PluginHandler->callPublicMethod(Object(ManiaLivePlugins\MLEPP\Jukebox\Jukebox), 'MLEPP\Database', 'insertChallenge', Array)
           #5 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Jukebox\Jukebox.php(980): ManiaLive\PluginHandler\Plugin->callPublicMethod('MLEPP\Database', 'insertChallenge', Object(ManiaLive\DedicatedApi\Structures\Challenge), 'n/a')
           #6 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Jukebox\Jukebox.php(961): ManiaLivePlugins\MLEPP\Jukebox\Jukebox->db_addTrack(Object(ManiaLive\DedicatedApi\Structures\Challenge))
           #7 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Jukebox\Jukebox.php(934): ManiaLivePlugins\MLEPP\Jukebox\Jukebox->db_populateDatabaseChallengeList()
           #8 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Jukebox\Jukebox.php(522): ManiaLivePlugins\MLEPP\Jukebox\Jukebox->db_checkNewTrack(Array)
           #9 [internal function]: ManiaLivePlugins\MLEPP\Jukebox\Jukebox->onBeginChallenge(Array, false, false)
           #10 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\DedicatedApi\Callback\Event.php(28): call_user_func_array(Array, Array)
           #11 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Event\Dispatcher.php(52): ManiaLive\DedicatedApi\Callback\Event->fireDo(Object(ManiaLivePlugins\MLEPP\Jukebox\Jukebox))
           #12 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\DedicatedApi\Connection.php(108): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\DedicatedApi\Callback\Event))
           #13 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Application\AbstractApplication.php(146): ManiaLive\DedicatedApi\Connection->executeCallbacks()
           #14 C:\Maniaplanet Server\plugins\ManiaLive2_r251\bootstrapper.php(81): ManiaLive\Application\AbstractApplication->run()
           #15 {main}
2011.08.19_22:57 
    

Occured on 19.08.2011 at 22:57:44 at process with ID #5224
    ---------------------------------
 -> ManiaLive\Database\QueryException with code 1146
    Table 'alakas.localrecords' doesn't exist
  - in C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Database\MySQL\Connection.php on line 150
  - Stack: #0 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\Database\mleppDatabase.php(32): ManiaLive\Database\MySQL\Connection->query('SELECT * FROM `...')
           #1 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords.php(864): ManiaLivePlugins\MLEPP\Database\mleppDatabase->query(Object(ManiaLivePlugins\MLEPP\Database\Structures\multiQuery))
           #2 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords.php(489): ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords->getPlayerRecord('alaka', 'Ly9FuR1LTBH5dGN...')
           #3 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords.php(340): ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords->buildConnectedPlayersRecord()
           #4 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords.php(202): ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords->updateCurrentChallengeRecords()
           #5 [internal function]: ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords->onBeginChallenge(Array, false, false)
           #6 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\DedicatedApi\Callback\Event.php(28): call_user_func_array(Array, Array)
           #7 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Event\Dispatcher.php(52): ManiaLive\DedicatedApi\Callback\Event->fireDo(Object(ManiaLivePlugins\MLEPP\LocalRecords\LocalRecords))
           #8 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\DedicatedApi\Connection.php(108): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\DedicatedApi\Callback\Event))
           #9 C:\Maniaplanet Server\plugins\ManiaLive2_r251\libraries\ManiaLive\Application\AbstractApplication.php(146): ManiaLive\DedicatedApi\Connection->executeCallbacks()
           #10 C:\Maniaplanet Server\plugins\ManiaLive2_r251\bootstrapper.php(81): ManiaLive\Application\AbstractApplication->run()
           #11 {main}

When I start it up it says this

Code: Select all

2011.08.19_22:54 [22:54:07] [MLEPP] [Database] Connecting to MYSQL database server . . .
2011.08.19_22:54 Connection succesfully established !
2011.08.19_22:54 [22:54:07] [MLEPP] [Database] Checking and creating tables if needed..

Posted: **20 Aug 2011, 07:27**

Hi, first I'd like to thank you for all the work put into this. MLEPP seems to be really good.

There is just one small problem that I'm having. While records for each track are being kept (I see the chat messages when records are being set), the widget on the right side that shows the local records that I've seen on a few other servers isn't being displayed.

I see the following printed out when I start Manialive:

Code: Select all

-> ErrorException with code 0
    parse_ini_file(config/config-mlepp-widgets.ini): failed to open
      stream: No such file or directory
  - in
      C:\tm2server\Manialive\libraries\ManiaLivePlugins\MLEPP\Widgets\Widgets.p
      hp on line 94
  - Stack: #0 [internal function]:
      ManiaLive\Application\ErrorHandling::createExceptionFromError(2,
      'parse_ini_file(...', 'C:\tm2server\Ma...', 94, Array)
           #1
      C:\tm2server\Manialive\libraries\ManiaLivePlugins\MLEPP\Widgets\Widgets.p
      hp(94): parse_ini_file('config/config-m...', true)
           #2
      C:\tm2server\Manialive\libraries\ManiaLivePlugins\MLEPP\Widgets\Widgets.p
      hp(74): ManiaLivePlugins\MLEPP\Widgets\Widgets->loadSettings()
           #3
      C:\tm2server\Manialive\libraries\ManiaLive\PluginHandler\PluginHandler.ph
      p(136): ManiaLivePlugins\MLEPP\Widgets\Widgets->onLoad()
           #4
      C:\tm2server\Manialive\libraries\ManiaLive\PluginHandler\PluginHandler.ph
      p(445): ManiaLive\PluginHandler\PluginHandler->loadPlugins()
           #5
      C:\tm2server\Manialive\libraries\ManiaLive\Application\Event.php(39):
      ManiaLive\PluginHandler\PluginHandler->onInit()
           #6
      C:\tm2server\Manialive\libraries\ManiaLive\Event\Dispatcher.php(52):
      ManiaLive\Application\Event->fireDo(Object(ManiaLive\PluginHandler\Plugin
      Handler))
           #7
      C:\tm2server\Manialive\libraries\ManiaLive\Application\AbstractApplicatio
      n.php(130):
      ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\Application\Event))
           #8
      C:\tm2server\Manialive\libraries\ManiaLiveApplication\Application.php(38)
      : ManiaLive\Application\AbstractApplication->init()
           #9
      C:\tm2server\Manialive\libraries\ManiaLive\Application\AbstractApplicatio
      n.php(137): ManiaLiveApplication\Application->init()
           #10 C:\tm2server\Manialive\bootstrapper.php(80):
      ManiaLive\Application\AbstractApplication->run()
           #11 {main}

The config-mlepp-widgets.ini file (renamed from config-mlepp-widgets-example.ini) does appear to be in the Manialive\config direcory.

I'm on Windows 2003, XAMPP 1.7.4, Manialive r251 and MLEPP r935.

Thanks for any help you can provide!

Posted: **20 Aug 2011, 08:14**

I think there is a problem with the add track command for maps with accented map name (I guess more generally speaking non UTF8 file names)... When we open the folder containing it, ManiaLive crashes completely with the following message:

Code: Select all

2011.08.19_22:24
    Occured on 19.08.2011 at 22:24:47 at process with ID #27899
    ---------------------------------
 -> ErrorException with code 0
    DOMElement::setAttribute(): string is not in UTF-8
  - in /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLib/Gui/Elements/Label.php on line 156
  - Stack: #0 [internal function]: ManiaLive\Application\ErrorHandling::createExceptionFromError(2, 'DOMElement::set...', '/var/www/vhosts...', 156, Array)
           #1 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLib/Gui/Elements/Label.php(156): DOMElement->setAttribute('text', '$eeePetite bouc...')
           #2 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLib/Gui/Element.php(592): ManiaLib\Gui\Elements\Label->postFilter()
           #3 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Windowing/Control.php(345): ManiaLib\Gui\Element->save()
           #4 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Windowing/Control.php(333): ManiaLive\Gui\Windowing\Control->save()
           #5 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Windowing/Control.php(333): ManiaLive\Gui\Windowing\Control->save()
           #6 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Windowing/WindowDisplayable.php(44): ManiaLive\Gui\Windowing\Control->save()
           #7 /var/www/vhosts/druffin.fr/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Handler/DisplayableGroup.php(85): ManiaLive\Gui\Windowing\WindowDisplayable->display(Array)
           #8 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Handler/Group.php(42): ManiaLive\Gui\Handler\DisplayableGroup->getXml(Array)
           #9 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Handler/GuiHandler.php(114): ManiaLive\Gui\Handler\Group->send()
           #10 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Application/AbstractApplication.php(147): ManiaLive\Gui\Handler\GuiHandler->sendAll()
           #11 /var/www/vhosts/xxx/httpdocs/ManiaLive/bootstrapper.php(80): ManiaLive\Application\AbstractApplication->run()
           #12 {main}

If we removed the accent that was in the file name, then all is ok. - Note that in that case, the widget that displays the next track actually displays the name with the accent...
I guess you need to parse / UTF8 encode the directory listing before displaying it in the mania link...

Posted: **20 Aug 2011, 08:26**

Also noticed this:

Code: Select all

2011.08.19_18:29
    Occured on 19.08.2011 at 18:29:44 at process with ID #7190
    ---------------------------------
 -> Exception with code 401
    API error. Check the HTTP error code.
  - in /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/MLEPP/Statistics/Rest.php on line 158
  - Stack: #0 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/MLEPP/Statistics/Statistics.php(215): ManiaLivePlugins\MLEPP\Statistics\Rest->execute('POST', '/mlepp/server/i...', Array)
           #1 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/MLEPP/Statistics/Statistics.php(101): ManiaLivePlugins\MLEPP\Statistics\Statistics->giveInformation()
           #2 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/PluginHandler/PluginHandler.php(375): ManiaLivePlugins\MLEPP\Statistics\Statistics->onReady()
           #3 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/Standard/PluginManager/PluginManager.php(92): ManiaLive\PluginHandler\PluginHandler->addPlugin('\ManiaLivePlugi...')
           #4 [internal function]: ManiaLivePlugins\Standard\PluginManager\PluginManager->loadPlugin('lolo-the-gourou', '\ManiaLivePlugi...')
           #5 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/Standard/PluginManager/Gui/Controls/Plugin.php(100): call_user_func(Array, 'lolo-the-gourou', '\ManiaLivePlugi...')
           #6 [internal function]: ManiaLivePlugins\Standard\PluginManager\Gui\Controls\Plugin->onLoad('lolo-the-gourou')
           #7 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Windowing/Window.php(485): call_user_func_array(Array, Array)
           #8 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Handler/Event.php(31): ManiaLive\Gui\Windowing\Window->onActionClick('lolo-the-gourou', '1849688088', Array)
           #9 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Event/Dispatcher.php(52): ManiaLive\Gui\Handler\Event->fireDo(Object(ManiaLivePlugins\Standard\PluginManager\Gui\Windows\Manager))
           #10 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Gui/Handler/GuiHandler.php(46): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\Gui\Handler\Event))
           #11 [internal function]: ManiaLive\Gui\Handler\GuiHandler->onPlayerManialinkPageAnswer(199, 'lolo-the-gourou', '1849688088', Array)
           #12 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/DedicatedApi/Callback/Event.php(28): call_user_func_array(Array, Array)
           #13 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Event/Dispatcher.php(52): ManiaLive\DedicatedApi\Callback\Event->fireDo(Object(ManiaLive\Gui\Handler\GuiHandler))
           #14 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/DedicatedApi/Connection.php(108): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\DedicatedApi\Callback\Event))
           #15 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Application/AbstractApplication.php(146): ManiaLive\DedicatedApi\Connection->executeCallbacks()
           #16 /var/www/vhosts/xxx/httpdocs/ManiaLive/bootstrapper.php(80): ManiaLive\Application\AbstractApplication->run()
           #17 {main}
2011.08.19_18:34
    Occured on 19.08.2011 at 18:34:24 at process with ID #7190
    ---------------------------------
 -> ErrorException with code 0
    Undefined index: lolo-the-gourou
  - in /var/www/vhosts/druffin.fr/xxx/ManiaLive/libraries/ManiaLivePlugins/MLEPP/Statistics/Statistics.php on line 152
  - Stack: #0 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLivePlugins/MLEPP/Statistics/Statistics.php(152): ManiaLive\Application\ErrorHandling::createExceptionFromError(8, 'Undefined index...', '/var/www/vhosts...', 152, Array)
           #1 [internal function]: ManiaLivePlugins\MLEPP\Statistics\Statistics->onPlayerInfoChanged(Array)
           #2 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/DedicatedApi/Callback/Event.php(28): call_user_func_array(Array, Array)
           #3 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Event/Dispatcher.php(52): ManiaLive\DedicatedApi\Callback\Event->fireDo(Object(ManiaLivePlugins\MLEPP\Statistics\Statistics))
           #4 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/DedicatedApi/Connection.php(108): ManiaLive\Event\Dispatcher::dispatch(Object(ManiaLive\DedicatedApi\Callback\Event))
           #5 /var/www/vhosts/xxx/httpdocs/ManiaLive/libraries/ManiaLive/Application/AbstractApplication.php(146): ManiaLive\DedicatedApi\Connection->executeCallbacks()
           #6 /var/www/vhosts/xxx/httpdocs/ManiaLive/bootstrapper.php(80): ManiaLive\Application\AbstractApplication->run()
           #7 {main}

I've had a look into the code, there is a usr /pwd that could be setup, but I have not seen anything regarding conf about this plugin (may it was too late when I did the conf)

BTW, and just to be clear, using the ML2-r251 / MLEPP-r395...

Posted: **20 Aug 2011, 10:29**

Hi, where can i download MLEPP r949 ? or how update it? Now is see only r935..

Posted: **20 Aug 2011, 11:59**

Alaka wrote:Hmm, don't know why, but MLEPP isn't creating the database-tables automatically for me, and keeps throwing errors about how this and that table doesn't exist, even though it finds and successfully connects to the database, with all privileges

Problem might be, that mlepp was successful the first time to connect, but something else went wrong and the creating of the databases were interupted or other guess is that your database username doesn't have enough privileges to create new tables on the database.

So solution:

Try with to connect to your database with phpmyadmin and see if the database has any tables.

* If there are none: to create a table, let's say named test. if it works, ok, problem is somewhere else.
* If there is, then just delete those (there should be 9 tables) and try creating the databases again. Something has went wrong in creation then.

Posted: **20 Aug 2011, 12:14**

TroZ wrote:Hi, first I'd like to thank you for all the work put into this. MLEPP seems to be really good.

Thanks, it's been already a half years of coding, testing and more coding to get this into this point!

TroZ wrote: The config-mlepp-widgets.ini file (renamed from config-mlepp-widgets-example.ini) does appear to be in the Manialive\config direcory. I'm on Windows 2003, XAMPP 1.7.4, Manialive r251 and MLEPP r935.

Do you use "show file extensions" in windows explorer and did you edit the file after renaming ?
Only thing i can think of is that the file is named with double extension like "file.ini.ini", since it shows in the folder.

Posted: **20 Aug 2011, 12:22**

corto-72 wrote:I think there is a problem with the add track command for maps with accented map name (I guess more generally speaking non UTF8 file names)... When we open the folder containing it, ManiaLive crashes completely with the following message
....
If we removed the accent that was in the file name, then all is ok. - Note that in that case, the widget that displays the next track actually displays the name with the accent...
I guess you need to parse / UTF8 encode the directory listing before displaying it in the mania link...

This was /admin add track local, ok.. So looks like the linux filesystem itself or php readdir doesn't return a UTF8 string of the files. As I write here, I added encoding the UTF8 of the filenames to the manialink, needs to testing though, will do it today.

Thanks for pointing this out!

Maniaplanet Forum

Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...

Re: Manialive Extending Plugin Pack R935 Public Beta...