+- 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: $this->db->query() and LOAD DATA INFILE (/showthread.php?tid=32614)
$this->db->query() and LOAD DATA INFILE - El Forum - 07-28-2010
[eluser]RockerBoy402[/eluser]
I've tried to load data into my database. The only thing is I get a pure white page on the browser, and nothing loaded into the database. I've included a pastebin link to my methods and such, but don't have much more to give except that I've got a blank page when I view it:
http://pastebin.com/NqKcDae6
Lines 1, 58 and 76 are the different classes.
Thanks in advanced!
$this->db->query() and LOAD DATA INFILE - El Forum - 07-28-2010
[eluser]danmontgomery[/eluser]
white page means PHP error, check your CI log (if enabled) or apache log for details.
$this->db->query() and LOAD DATA INFILE - El Forum - 07-28-2010
[eluser]RockerBoy402[/eluser]
Shouldn't it be showing some type of error on the page?
$this->db->query() and LOAD DATA INFILE - El Forum - 07-29-2010
[eluser]RockerBoy402[/eluser]
This is what my error log shows:
Code:
DEBUG - 2010-07-29 11:20:36 --> Config Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Hooks Class Initialized
DEBUG - 2010-07-29 11:20:36 --> URI Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Router Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Output Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Input Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Global POST and COOKIE data sanitized
DEBUG - 2010-07-29 11:20:36 --> Language Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Loader Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Database Driver Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Session Class Initialized
DEBUG - 2010-07-29 11:20:36 --> Helper loaded: string_helper
DEBUG - 2010-07-29 11:20:36 --> A session cookie was not found.
DEBUG - 2010-07-29 11:20:36 --> Session routines successfully run
DEBUG - 2010-07-29 11:20:36 --> Controller Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Config Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Hooks Class Initialized
DEBUG - 2010-07-29 11:20:38 --> URI Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Router Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Output Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Input Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Global POST and COOKIE data sanitized
DEBUG - 2010-07-29 11:20:38 --> Language Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Loader Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Database Driver Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Session Class Initialized
DEBUG - 2010-07-29 11:20:38 --> Helper loaded: string_helper
DEBUG - 2010-07-29 11:20:38 --> Session routines successfully run
DEBUG - 2010-07-29 11:20:38 --> Controller Class Initialized$this->db->query() and LOAD DATA INFILE - El Forum - 07-29-2010
[eluser]RockerBoy402[/eluser]
Still seeking an answer. Can't get any errors to show up, but still get a blank page and no data inserted into the DB.
$this->db->query() and LOAD DATA INFILE - El Forum - 07-29-2010
[eluser]Prophet[/eluser]
Make sure in application/config/config.php you set:
Code:
$config['log_threshold'] = 2;This will force CodeIgniter to log errors and debugging messages. If CodeIgniter isn't logging anything, then it's fairly safe to assume that nothing is going wrong.
Throw a few echos and/or die()s in there to check that your script is actually being executed.