+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Oracle Error messages? (/showthread.php?tid=8150)
Oracle Error messages? - El Forum - 05-07-2008
[eluser]inari[/eluser]
When i'm using MySQL with CI I'm getting all errors if something gets wrong, but with Oracle, only message that I get is:
Quote:An Error Was Encountered
Error Number:
SELECT * FROM clients
No numbers, no messages.
Any ideas?
Oracle Error messages? - El Forum - 05-08-2008
[eluser]Derek Allard[/eluser]
I assume you do in fact have a table called clients? What happens if you run that query directly against the db (in other words, not through CI)?
Oracle Error messages? - El Forum - 05-08-2008
[eluser]inari[/eluser]
This is SQL called from CI:
Code:
SELECT * FROM clients where fgfg = 1Quote:An Error Was Encountered
Error Number:
SELECT * FROM clients WHERE fgfg = 1
This is SQL called from Oracle SQL Developer:
Code:
SELECT * FROM clients where fgfg = 1This is error message from Oracle SQL Developer:
Quote:SELECT * FROM clients where fgfg = 1
Error at Command Line:1 Column:28
Error report:
SQL Error: ORA-00904: "FGFG": invalid identifier
00904. 00000 - "%s: invalid identifier"
Table "clients" exist, field fgfg does not exist.
Oracle Error messages? - El Forum - 05-08-2008
[eluser]Derek Allard[/eluser]
So the error is getting thrown. The code in the Oracle driver is oci8. I know you're on a newer version. I don't use Oracle or have a test machine set up, so any insight you can provide would be helpful.
Oracle Error messages? - El Forum - 05-08-2008
[eluser]inari[/eluser]
I looked up oci8_driver and only clue I got when I tried to cause error is that method _error_message() at line 488 returns nothing, and $array array is just empty, no "message" key within.
Error reporting is very important to me because there is much bigger bug that is showing up randomly.
Once in a while 'select' operation fails and produces error message, but immediately after refreshing page it just past clearly like nothing happened. It scares me out and i can't catch even error message.
If I can help in any way, please just tell me, if required you can contact me at email for any further tests you need or just post it here.
Oracle Error messages? - El Forum - 07-20-2010
[eluser]fszostak[/eluser]
I have same problem with CI 1.7.3.
Anybody have can help me?