I have seen that some fellows have been having this same problem, but I could not find the solution.
My query seems ok until but it still return me this strange error
foreach ($file as $row) {
$query = query("INSERT INTO places (country_code, postal_code, place_name, admin_name1, admin_code1, admin_name2, admin_code2, admin_name3, admin_code3, latitude, longitude, accuracy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", $row[COUNTRY_CODE], $row[POSTAL_CODE], $row[PLACE_NAME], $row[ADMIN_NAME1], $row[ADMIN_CODE1], $row[ADMIN_NAME2], $row[ADMIN_CODE2], $row[ADMIN_NAME3], $row[ADMIN_CODE3], $row[LATITUDE], $row[LONGITUDE], $row[ACCURACY] );
PHP Fatal error: Column 'country_code' cannot be null in /home/jharvard/vhosts/pset8/includes/functions.php on line 57
Call Stack:
0.0003 126972 1. {main}() /home/jharvard/vhosts/pset8/bin/import:0
14.7066 55399132 2. query() /home/jharvard/vhosts/pset8/bin/import:45
14.7094 55403640 3. trigger_error() /home/jharvard/vhosts/pset8/includes/functions.php:57
At the same time it seems to break my phpAdmin not giving me access anymore to the data stored.
Fatal error: Maximum execution time of 30 seconds exceeded in /usr/share/phpmyadmin/libraries/DisplayResults.class.php on line 2959
Any help? Thank you!