Welcome Guest, Not a member yet? Register   Sign In
transaction problem
#1

[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
#2

[eluser]starenka[/eluser]
sorry for spamming AND for BLAMING CI. Damn those relations builders in phpmyadmin... Smile)

problem solved... can someone remove it? thx




Theme © iAndrew 2016 - Forum software by © MyBB