Database access error |
[eluser]Perkin5[/eluser]
I've started following Jeffrey Way's Nettuts CodeIgniter video tutorials but although my code follows his exactly, I get an error at the line where the model function tries to 'get' a database table using active_record syntax. The code is Code: $q = $this->db->get('test'); I have the code on my website where you can see the problem: www.mikeheath.co.uk and I'm wondering if the codeigniter version I have (2.0.2) differs substantially from the one he was using (1.7.1). I've already noticed that the base classes are now called CI_model etc instead of just model and there may be other changes. Is the active_record syntax the same? By the way, I have checked the database config settings using a non-codeigniter file. Check it yourself at www.mikeheath.co.uk/dbtest.php Grateful for any suggestions as to what is wrong.
[eluser]gigas10[/eluser]
Code: Message: Undefined property: Site::$db Doesn't look like you put $this-> infront of db.
[eluser]Perkin5[/eluser]
I certainly did! I've since downloaded Jeffrey's code from Nettuts, ran it and it worked - remember that's with Codeigniter 1.7.1 I then cut and pasted his code into Codeigniter 2.0.2 and lo and behold I get exactly the same error as I've been getting. I think there's been some update to Codeigniter that's changed the syntax but despite hours of work and research on the web I've got nowhere. Arrgh!
[eluser]Iván Argulo[/eluser]
I'm getting the same error with every library I load, but only in some controllers... I'm stuck at this. I've been developing with CI for 3 years, versions from 1.3 to 1.7. Now I decided to move on to CI 2.0, but I'm not able to make it work...
[eluser]Perkin5[/eluser]
for Ivan: no I'm not using hooks - whatever they are. for Noctrum: I entered the necessary items in the database config file and then did an active record statement to get the table. Is there anything else I should have done to call the database? I know the database details are correct because I placed a file in the root called dbtest.php and if you go to http://www.mikeheath.co.uk/dbtest.php you can see the database contents echoed out as King and Queen. I haven't done anything like the autocomplete modification mentioned in your ref. In fact I haven't touched any file in the System folder. print_r produced no result. I don't know whether you are familiar with NettutsPlus and Jeffrey Way's video series "Codeigniter from Scratch" but I'm still on video 1 of 17! I merely copied his code, which works fine in 1.7.1 but doesn't in 2.0.2. I'm therefore assuming some change in syntax.
[eluser]Perkin5[/eluser]
Hi Noctrum, Whaddayaknow - you were right. I hadn't loaded the database. I failed to understand the autoload config file, which has changed since 1.7.1 - 'database' is now included counter-intuitively under 'libraries', unlike in the codeigniter video. Anyway I did that and now I get an output from the database. Many many thanks for your help - I can't tell you how much it means for a newb to have his hand held!!! |
Welcome Guest, Not a member yet? Register Sign In |