Tag Archives: SQL

LOAD DATA INFILE and FILE Permissions on MySQL

By Donnie Bachan | Published: June 22, 2009
I ran into an issue running the LOAD DATA INFILE command from a PHP script the other day. When I logged in as ROOT and executed the script on MySQL Query Browser it worked like a charm. However, when I executed the script from PHP as another use with only SELECT, INSERT, UPDATE and DELETE [...]
Posted in Databases, MySQL | Also tagged , | Leave a comment

MySQL 5 timestamp error in ColdFusion 8

By Donnie Bachan | Published: February 6, 2009
Scenario: Query grabs user data from MySQL 5 database using the built in MySQL 4/5 driver in ColdFusion 8 on a Windows 2003 Server.   Problem: Cannot convert value ‘0000-00-00 00:00:00′ from column 10 to TIMESTAMP error returned on execution.   Analysis: After a quick search on Google, it appears that the default behaviour for the Connector J MySQL driver is to [...]
Posted in ColdFusion, Databases, MySQL, Programming | Also tagged , | Leave a comment

  • Subscribe to my feed Subscriber via Email Follow Me on Twitter! Check me out on Facebook! Check me out on LinkedIn!