Problem when upgrading to MySql 5

Ok, I had several databases on v4.1.17 that were working fine. I wanted to upgrade to v5 to work with stored procedures and triggers a little.

I removed the instance of 4.1.17, and installed v5.

I backed up my tables using the MySql administrator. When I tried to import the back up, it failed.

I tried recreating one of the smaller tables as shown below:

CREATE TABLE `class_review` (

`Rev_ID` bigint(20) NOT NULL auto_increment,
`Rev_Class_Date` date NOT NULL default '0000-00-00',
`Rev_Class_Instructor` varchar(10) NOT NULL default '',
`Rev_Class_Knowledge` int(10) unsigned NOT NULL default '0',
`Rev_Part` int(10) unsigned NOT NULL default '0',
`Rev_Friend` int(10) unsigned NOT NULL default '0',
`Rev_Prep` int(10) NOT NULL default '0',
`Rev_Expect` int(10) unsigned NOT NULL default '0',
`Rev_Cont` int(10) unsigned NOT NULL default '0',
`Rev_Enjoy` int(10) unsigned NOT NULL default '0',
`Rev_Comments` text NOT NULL,

   PRIMARY KEY (`Rev_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I have the following Coldfusion code that was inserting the data: <cfquery name="AddReview" datasource="SalleBoise"> insert into class_review
(Rev_Class_Date, Rev_Class_Instructor, Rev_Knowledge, Rev_Part, Rev_Friend, Rev_Prep, Rev_Expect, Rev_Cont, Rev_Enjoy, Rev_Comments) values
(

'#form.ClassDate#',
'#form.Instructor#',
'#form.Knowledge#',
'#form.Part#',
'#form.FR#',
'#form.Prep#',
'#form.Expect#',
'#form.Continue#',
'#form.OA#',
'#form.Comments#');

But now I'm getting a message that says:

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Error Executing Database Query.
Unknown column &apos;Rev_Knowledge&apos; in &apos;field list&apos;

The error occurred in C:\Inetpub\wwwroot\SalleBoise\CF\add_review.cfm: line 17

15 : '#form.Continue#',
16 : '#form.OA#',
17 : '#form.Comments#');
18 : 
19 :



--------------------------------------------------------------------------------

SQL insert into class_review (Rev_Class_Date, Rev_Class_Instructor, Rev_Knowledge, Rev_Part, Rev_Friend, Rev_Prep, Rev_Expect, Rev_Cont, Rev_Enjoy, Rev_Comments) values ( '2006-10-23', 'Steve Grosz', '5', '5', '5', '5', '4', '4', '5', '<p>test</p>');

If anyone has any ideas on what has changed from MySql 4.1.17 to v5 and can point me in the direction I need to go, I would appreciate it!!

Thanks!
Steve

-- 
MySQL Windows Mailing List
For list archives: 
http://lists.mysql.com/win32
To unsubscribe:    
http://lists.mysql.com/win32?unsub=lists@pantek.com