Welcome Guest, Not a member yet? Register   Sign In
Strange problem in active records

Hi all And sorry for my English.
Yesterday I had the strange problem:
It worked fine (bottom my code) but then I started getting the error.

function get_last_vacancies()
    $this->db->join('job_specialty', 'job_vacanсies.v_specialty_id = job_specialty.specialty_id', 'left');
    return $this->db->get()->result_array();

active record generate a wrong string:

Quote:SELECT * FROM (`job_vacanсies`) LEFT JOIN `job_specialty` ON `job_vacan`с`ies`.`v_specialty_id` = job_specialty.specialty_id

Have a look at `job_vacan`с`ies`.

Then I renamed the table name into "job_vac" and it started working fine.
Then I return the old name and it works fine again.

Question: How I can reproduce the error again?
what is reason of emergence of a mistake?


Maybe was a quirk, you say it working now and you can't replicate the error again so don't worry about it ;-)

it's very interesting why I got the error )

Theme © iAndrew 2016 - Forum software by © MyBB