bagu Posted December 23, 2010 Share Posted December 23, 2010 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 Quote Link to comment Share on other sites More sharing options...
Administrators kissaki Posted December 26, 2010 Administrators Share Posted December 26, 2010 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? Quote Link to comment Share on other sites More sharing options...
Administrators hacst Posted December 27, 2010 Administrators Share Posted December 27, 2010 This issue has been fixed in the repository (Type=InnoDB has to be ENGINE=InnoDB iirc for newer mysqls). Don't know if there's a new server snapshot for linux yet though. Quote Link to comment Share on other sites More sharing options...
bagu Posted December 27, 2010 Author Share Posted December 27, 2010 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 ? Quote Link to comment Share on other sites More sharing options...
Moderators pcgod Posted December 28, 2010 Moderators Share Posted December 28, 2010 Make sure that you're using the 1.2.3 slice file on the client otherwise it won't work, but it should throw an exception somewhere if it's the wrong slice file... Quote Link to comment Share on other sites More sharing options...
bagu Posted December 28, 2010 Author Share Posted December 28, 2010 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 :SEDIT : 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 ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.