[eluser]Gyzm[/eluser]
Hello there community.
I have an interesting and possibly challenging issue on my hands and I'm hoping that somebody out there will be able to help me out. As per the title of this post the issue involves method chaining.
I use Method Chaining on everything I do. I LOVE IT! So obviously, every environment that I work in is a PHP 5 environment. When I'm developing I develop locally and then upload the project to the server upon completion. I realize that this isn't an ideal way of doing things and, in the future, I will probably stop. haha. But for now I'm stuck with this issue:
Uploaded project to server
Server is running PHP 5.2.6 (my local dev server is running 5.2.4)
Both are running MySQL
Just to be clear, chaining works on my dev server and doesn't work on the production server.
When I method chain i.e.:
$this->db->select('stuff')->from('here')->where('id', $id)... and so on, I get this error:
___________________________________
| A Database Error Occurred
|
| Error Number: 1096
|
| No tables used
|
| SELECT column_name
___________________________________
If I break up the chain like this:
$this->db->select('stuff');
$this->db->from('here');
$this->db->where('id', $id);
It works and I get what I'm asking for. This is the first time out of at least a dozen servers that I've used CI on that I've encountered this issue. I've tried re-uploading the active record class but the problem persists.
The only prerequisite in the manual for method chaining is PHP 5 which, again, the server is running.
Any takers?
Thanks ahead.