Problem with ColdFusion communicating with MySQL database

Posted by Greg on Stack Overflow See other posts from Stack Overflow or by Greg
Published on 2010-03-25T02:27:22Z Indexed on 2010/03/25 2:33 UTC
Read the original article Hit count: 414

Filed under:
|

Hi,

I have been working to migrate a non-profit website from a local server (running Windows XP) to a GoDaddy hosting account (running Linux). Most of the pages are written in ColdFusion. Things have gone smoothly, up until this point. There is a flash form within the site (see this page: http://www.preservenet.cornell.edu/employ/submitjob.cfm) which, when completed, takes the visitor to this page: submitjobaction.cfm . I'm not quite sure what to make of this error, since I copied exactly what had been in the old MySQL database, and the .cfm files are exactly as they had been when they worked on the old server. Am I missing something?

Below is the code from the database that the error seems to be referring to. When I change "Positionlat" to some default value in the database as it suggests in the error, it says that another field needs a default value, and it's a neverending chain of errors as I try to correct it.

This is probably a stupid error that I'm missing, but I've been working at it for days and can't find what I'm missing. I would really appreciate any help.

Thanks!

-Greg


DROP TABLE IF EXISTS employopp;

CREATE TABLE employopp (

POSTID int(10) NOT NULL auto_increment,

USERID varchar(10) collate latin1_general_ci default NULL,

STATUS varchar(10) collate latin1_general_ci NOT NULL default 'ACTIVE',

TYPE varchar(50) collate latin1_general_ci default 'professional',

JOBTITLE varchar(70) collate latin1_general_ci default NULL,

NUMBER varchar(30) collate latin1_general_ci default NULL,

SALARY varchar(40) collate latin1_general_ci default NULL,

ORGNAME varchar(70) collate latin1_general_ci default NULL,

DEPTNAME varchar(70) collate latin1_general_ci default NULL,

ORGDETAILS mediumtext character set utf8 collate utf8_unicode_ci,

ORGWEBSITE varchar(200) collate latin1_general_ci default NULL,

ADDRESS varchar(60) collate latin1_general_ci default 'none given',

ADDRESS2 varchar(60) collate latin1_general_ci default NULL,

CITY varchar(30) collate latin1_general_ci default NULL,

STATE varchar(30) collate latin1_general_ci default NULL,

COUNTRY varchar(3) collate latin1_general_ci default 'USA',

POSTALCODE varchar(10) collate latin1_general_ci default NULL,

EMAIL varchar(75) collate latin1_general_ci default NULL,

NOMAIL varchar(5) collate latin1_general_ci default NULL,

PHONE varchar(20) collate latin1_general_ci default NULL,

FAX varchar(20) collate latin1_general_ci default NULL,

WEBSITE varchar(200) collate latin1_general_ci default NULL,

POSTDATE varchar(10) collate latin1_general_ci default NULL,

POSTUNTIL varchar(20) collate latin1_general_ci default 'select date',

POSTUNTILFILLED varchar(20) collate latin1_general_ci NOT NULL default 'until filled',

texteHTML mediumtext character set utf8 collate utf8_unicode_ci,

HOWTOAPPLY mediumtext character set utf8 collate utf8_unicode_ci,

CONFIRSTNM varchar(30) collate latin1_general_ci default NULL,

CONLASTNM varchar(60) collate latin1_general_ci default NULL,

POSITIONCITY varchar(30) collate latin1_general_ci default NULL,

POSITIONSTATE varchar(30) collate latin1_general_ci default NULL,

POSITIONCOUNTRY varchar(3) collate latin1_general_ci default 'USA',

POSITIONLAT varchar(50) collate latin1_general_ci NOT NULL,

POSITIONLNG varchar(50) collate latin1_general_ci NOT NULL,

PRIMARY KEY (POSTID)

) ENGINE=MyISAM AUTO_INCREMENT=2007 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

© Stack Overflow or respective owner

Related posts about coldfusion

Related posts about mysql