Database access error - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21) +--- Thread: Database access error (/showthread.php?tid=41800) |
Database access error - El Forum - 05-17-2011 [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. Database access error - El Forum - 05-17-2011 [eluser]gigas10[/eluser] Code: Message: Undefined property: Site::$db Doesn't look like you put $this-> infront of db. Database access error - El Forum - 05-17-2011 [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! Database access error - El Forum - 05-18-2011 [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... Database access error - El Forum - 05-18-2011 [eluser]Perkin5[/eluser] We must pray for a guru! Database access error - El Forum - 05-18-2011 [eluser]Iván Argulo[/eluser] Are you using hooks? Database access error - El Forum - 05-18-2011 [eluser]danmontgomery[/eluser] Hate to ask, but you are loading the database, yes? You didn't happen to do something like this, did you? What do you see when you print_r() on $this in the model? Database access error - El Forum - 05-18-2011 [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. Database access error - El Forum - 05-18-2011 [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!!! |