Jump to content
Mumble forums

Mysql 5.5.8 and murmur problem


bagu
 Share

Recommended Posts

Hello,

I upgrade mysql 5.1.54 to mysql 5.5.8 and i got an error message witch say me that there is a mysql syntaxt error...

 

Prepare Error [CREATE TABLE IF NOT EXISTS `murmur_meta`(`keystring` varchar(255) PRIMARY KEY, `value` varchar(255)) Type=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]: You have an error in your SQL syntax;

 

I've tried murmur 1.2.2 and murmur 1.2.3 : same problem... So, how can i make it working ? Thanks

Link to comment
Share on other sites

  • Administrators

Please also paste the next line as it points to where the syntax error supposedly actually is.


Upgrading mysql alone shouldn't update the db structure. Did you also update murmur?

Did you restart murmur?

Does the mysql update also clone the databses, or sth?

Link to comment
Share on other sites

With the new version, it work without error.


But there is a small question. With php 5.2, ice 3.3 and mumble 1.2, i use to get the list of mumble users by using this :

function loadUser($iceUser)
{
$user = array();
$user['session']     = $iceUser->session;
//$user['id']          = $iceUser->playerid;
$user['mute']        = $iceUser->mute;
$user['deaf']        = $iceUser->deaf;
//$user['suppressed']  = $iceUser->suppressed;
$user['selfMute']    = $iceUser->selfMute;
$user['selfDeaf']    = $iceUser->selfDeaf;
$user['channel']     = $iceUser->channel;
$user['name']        = $iceUser->name;
$user['onlinesecs']  = $iceUser->onlinesecs;
$user['bytespersec'] = $iceUser->bytespersec;
return $user;
}

function get_mumble_users()
{
$tableau=array();
Ice_loadProfile();
global $ICE;
try
{
	$base = $ICE->stringToProxy("Meta:tcp -h 127.0.0.1 -p 6502");
	$meta = $base->ice_checkedCast("::Murmur::Meta");
	$servers = $meta->getBootedServers();
	$players = $servers[0]->getUsers();
	foreach($players as $player)
	{
		$tableau[]=loadUser($player);
	}
}
catch (Ice_Exception $ex)
{
	echo $lang_index['noone'];
}
return $tableau;
}

 

I have read that there is a new method to make the same thing with php 5.3 + ice 3.4 and mumble 1.2.3...

I have generate Murmur.php and put ice.php and others lib in my php path.

I have make the folowing modification :

function loadUser($iceUser)
{
$user = array();
$user['session']     = $iceUser->session;
$user['id']          = $iceUser->playerid;
$user['mute']        = $iceUser->mute;
$user['deaf']        = $iceUser->deaf;
$user['suppressed']  = $iceUser->suppressed;
$user['selfMute']    = $iceUser->selfMute;
$user['selfDeaf']    = $iceUser->selfDeaf;
$user['channel']     = $iceUser->channel;
$user['name']        = $iceUser->name;
$user['onlinesecs']  = $iceUser->onlinesecs;
$user['bytespersec'] = $iceUser->bytespersec;
return $user;
}

function get_mumble_users()
{
$tableau=array();
try
{
	require_once 'Ice.php';
	require_once 'Murmur.php';
	$ICE = Ice_initialize();
	$meta = Murmur_MetaPrxHelper::checkedCast($ICE->stringToProxy('Meta:tcp -h 127.0.0.1 -p 6502'));
	$servers = $meta->getBootedServers();
	$players = $servers[0]->getUsers();
	foreach($players as $player)
	{
		$tableau[]=loadUser($player);
	}
}
catch (Ice_Exception $ex)
{
	echo 'Erreur : '.$e->getMessage().'<br />';
	echo 'N° : '.$e->getCode();
	die();
}
return $tableau;
}

 

But $tableau is always empty (and php error logs too)...Where is my mistake ?

Can you help me please ?

Link to comment
Share on other sites

I use the 1.2.3 slice...So there is no exception...I really don't understand...

And MUMPI work well and show my users...So it's not the mumble installation :S


EDIT : i have now many error message since i don't forget to call the function (don't laught too high please ^^)


Here are the error messages :

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 24

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 29

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 34

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 39

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 44

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 49

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 54

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 59

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 24

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 29

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 34

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 39

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 44

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 49

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 54

[29-Dec-2010 00:56:42] PHP Warning:  IcePHP_defineSequence() expects parameter 2 to be object, null given in D:\Ice\php\Ice\BuiltinSequences.php on line 59

[29-Dec-2010 00:56:42] PHP Fatal error:  Uncaught exception 'RuntimeException' with message 'no object found in IcePHP_defineStruct()' in D:\Ice\php\Ice\Identity.php:44
Stack trace:
#0 D:\Ice\php\Ice\Identity.php(44): IcePHP_defineStruct('::Ice::Identity', 'Ice_Identity', Array)
#1 D:\Ice\php\Ice\LocalException.php(21): require('D:\Ice\php\Ice\...')
#2 D:\Ice\php\Ice.php(108): require('D:\Ice\php\Ice\...')
#3 E:\www\wwwbagubiz\html\test\index.php(30): require_once('D:\Ice\php\Ice....')
#4 E:\www\wwwbagubiz\html\test\index.php(53): get_mumble_users()
#5 {main}

Next exception 'RuntimeException' in D:\Ice\php\Ice\Identity.php:44
Stack trace:
#0 D:\Ice\php\Ice\Identity.php(0): IcePHP_defineStruct()
#1 D:\Ice\php\Ice\LocalException.php(21): require('D:\Ice\php\Ice\...')
#2 D:\Ice\php\Ice.php(108): require('D:\Ice\php\Ice\...')
#3 E:\www\wwwbagubiz\html\test\index.php(30): require_once('D:\Ice\php\Ice....')
#4 E:\www\wwwbagubiz\html\test\index.php(53): get_mumble_users()
#5 {main}
 thrown in D:\Ice\php\Ice\Identity.php on line 44

 

EDIT2 : PROBLEM SOLVED !


require_once 'Ice.php';

require_once 'Murmur.php';


Must be out of the function (please don't throw me stones ;) )


Everything work fine now : Long life to mumble !

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...