Welcome Guest, Not a member yet? Register   Sign In
Database error #1066
#1

guys please help me with this error:

A Database Error Occurred
Error Number: 1066
Not unique table/alias: 'ms_sms'
SELECT *, `ms_tags`.`id` as `tag_ids` FROM `ms_sms` LEFT JOIN `ms_sms` ON `ms_sms`.`id` = `ms_tags_meta`.`sms_id` LEFT JOIN `ms_tags_meta` ON `ms_tags_meta`.`tag_id` = `ms_tags`.`id` GROUP BY `id` ORDER BY `id` DESC
Filename: controllers/me/do.php
Line Number: 70
 --------------------------------------------
and here is my code


$this->db->from('sms');
        
        $this->db->select('tags.id as tag_ids', 'tags.name as tag_names');
        $this->db->join('sms', 'sms.id = tags_meta.sms_id', 'left');
        $this->db->join('tags_meta', 'tags_meta.tag_id = tags.id', 'left');
        $this->db->order_by('id', 'DESC');
        $this->db->group_by('id');

    //$sms = $this->db->get();
        $pages =  new Paginator(SETTING_SMS_PER_PAGE, 'page');
    $pages->setTotal(count($this->db->count_all()));
    $data['pageLinks'] = $pages->pageLinks();
        $data['smss'] = $this->db->get()->result();
Be Simple Angel
Reply


Messages In This Thread
Database error #1066 - by waptik - 05-10-2016, 11:12 AM
RE: Database error #1066 - by Narf - 05-10-2016, 11:49 AM
RE: Database error #1066 - by waptik - 05-10-2016, 02:39 PM
RE: Database error #1066 - by Narf - 05-10-2016, 03:48 PM
RE: Database error #1066 - by waptik - 05-10-2016, 10:37 PM
RE: Database error #1066 - by salain - 05-11-2016, 12:21 AM
RE: Database error #1066 - by waptik - 05-11-2016, 03:20 PM



Theme © iAndrew 2016 - Forum software by © MyBB