Hello,
I got follwin error
Fatal error: Uncaught exception 'Zend_Db_Statement_Exception' with
message 'SQLSTATE[HY093]: Invalid parameter number: mixed named and
positional parameters' in /web/ugame/root/libs/Zend/Db/Statement/Pdo.php:227
Stack trace: #0 /web/ugame/root/libs/Zend/Db/Statement.php(279):
Zend_Db_Statement_Pdo->_execute(Array)
#1 /web/ugame/root/libs/Zend/Db/Adapter/Abstract.php(396):
Zend_Db_Statement->execute(Array)
#2 /web/ugame/root/libs/Zend/Db/Adapter/Pdo/Abstract.php(206):
Zend_Db_Adapter_Abstract->query('UPDATE `ugml_un...', Array)
#3 /web/ugame/root/libs/Zend/Db/Adapter/Abstract.php(517):
Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `ugml_un...', Array)
#4 /web/ugame/root/libs/class.bu_game.php(349):
Zend_Db_Adapter_Abstract->update('ugml_universe', Array, Array)
#5 /web/ugame/root/page.register.php(158): Bu_Game->putPlanet(Array)
#6 /web/ugame/root/libs/class.page_render.php(125):
require('/web/ugame/root...')
#7 /web/ugame/root/libs/class.page_render.php(111):
Bu_Page->getInclude(Array) #8 /web/ugame/root/libs/class.page_ren
in /web/ugame/root/libs/Zend/Db/Statement/Pdo.php on line 227
when I was try to do this
$_aPUpdate = array();
$_aPUpdate['some_fields'] = $some_data;
$_aWhere[] = "planet_id = ".$_aPlanet['planet_id'];
$_aWhere[] = "planet_location = ".$_aPlanet['planet_location'];
$resPlanet = $this->db->update($this->prefix."universe", $_aPUpdate,
$_aWhere);
when I was remove the
$_aWhere[] = "planet_location = ".$_aPlanet['planet_location'];
it works
$_aPlanet['planet_location'] contains someting like
1:300:23 or someting like that.
Regards
Sancar
