[eluser]starenka[/eluser]
hi! where's my problem?
Code:
public function edit($data,$page_id)
{
/* checks if the given uri is unique*/
$CI =& get_instance();
$CI->load->model('admin/generic_model','generic');
if(!$CI->generic->is_field_unique('uri',$data['page_uri'],'page')) $data['page_uri'].= '--d';
$this->db->trans_start();
$q = 'UPDATE page SET title = ?,keywords = ?,uri = ?,content = ? WHERE page_id = ?';
$bind = array(
$data['page_title'],
$data['page_keywords'],
$data['page_uri'],
$data['page_content'],
$page_id);
$this->db->query($q,$bind);
$q = 'UPDATE menu_item SET title = ?, language = ?, menu_id = ? WHERE menu_item_id = ?';
$bind = array(
$data['menu_item_title'],
$data['language'],
$data['pmenu'],
$data['menu_item_id']);
$this->db->query($q,$bind);
$this->db->trans_complete();
if ($this->db->trans_status() === FALSE)
{
log_message('error','Failed to update page');
return false;
}
else return true;
}
i allways got:
Code:
An Error Was Encountered
Error Number: 1205
Lock wait timeout exceeded; try restarting transaction
ci 1.6.1, php 5.2.x, mysql 5.1, innodb tables