Can anyone decipher this cryptic error message?

Database access error. Description: Unknown column 'Status' in 'where clause'

That's it I'm afraid. No more, no less. I am trying to go from 6.1.6 to D7 so could be either database in some column called 'Status' apparently, oh yes.....in a 'where clause'.

Someone please tell me you know where it is.

Does this happen when you try to run the migration tool for Profiles or for something else?

Chris

I honestly can't say when it starts though I think it starts before migration. What I can say is that it did once upon a time tell me that the D7 database couldn't find the tables RayVideoTokens, RayVideoFiles and RayMP3Tokens in the 6.1.6 database. So I inserted them in the 6.1.6 database to try and stop that error message, which it did.

Out of those 3 tables, Only the RayVideoFiles has a field called "Status". Im not sure how you lost these 3 tables from your existing 6.1.6 since the RayVideoFiles actually holds the videos from your site.

In order to migrate your site from 6.1.6 to 7, you have to have the Migration module installed, 6.1.6 site path configured, then start by moving the Profiles first, then any other components your wish to move (photos, videos, music, etc.).

Where exactly are you seeing this error? Is it when you try to perform the migration or are you seeing this on a specific page?

Chris

Yes I noticed that the table RayVideoFiles had a column by the name of Status. Could you please post or PM me the correct sql data for those three tables so I can insert them in my 6.1.6 database?

I did do the upgrade from 6.1.4 to 6.1.5 then to 6.1.6 so I have no idea why those tables were not created.

Here is the SQL for creating those tables:

CREATE TABLE `RayMp3Tokens` (
`ID` int(11) NOT NULL default '0',
`Token` varchar(32) NOT NULL default '',
`Date` int(20) NOT NULL default '0',
PRIMARY KEY `TokenId` (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `RayVideoFiles` (
`ID` int(11) NOT NULL auto_increment,
`Categories` text NOT NULL,
`Title` varchar(255) NOT NULL default '',
`Uri` varchar(255) NOT NULL default '',
`Tags` text NOT NULL,
`Description` text NOT NULL,
`Time` int(11) NOT NULL default '0',
`Date` int(20) NOT NULL default '0',
`Owner` varchar(64) NOT NULL default '',
`Views` int(12) default '0',
`Rate` float NOT NULL,
`RateCount` int(11) NOT NULL,
`CommentsCount` int(11) NOT NULL,
`Featured` tinyint(4) NOT NULL,
`Status` enum('approved','disapproved','pending','processing','failed') NOT NULL default 'pending',
`Source` varchar(20) NOT NULL default '',
`Video` varchar(32) NOT NULL default '',
PRIMARY KEY  (`ID`),
KEY (`Owner`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE `RayVideoTokens` (
`ID` int(11) NOT NULL default '0',
`Token` varchar(32) NOT NULL default '',
`Date` int(20) NOT NULL default '0',
PRIMARY KEY `TokenId` (`ID`,`Token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Chris < -- Not part of the code..haha