Managed the migration but I have a problem

After long and tiring struggles (lol) I finally managed to do the migration from 6.1.6 to 7.

I do have some hiccups.

The most major one is at "join" or when I try to save a profile with new information (mine), I get a database error. At "join" it gives the database but the member actually had joined. The same for saving, I get the screen with the error but the information was saved.

The error email is huge, but anyway, the main part of it is

Database error in

Query:

SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != 2095 AND `` = '1-0'

Mysql error: Unknown column '' in 'where clause'

Found error in the file '/home/xxxxxx/public_html/yyyyyy/inc/match.inc.php' at line 57.
Called 'getAllWithKey' function with erroneous argument #0.

The line 57 in match.inc.php is

$aMathFields[$sKey]['profiles'] = $oDb->getAllWithKey("SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND `ID` != $iProfileId AND $sCond", 'ID');

....I'm lost....

Day, look at both your profiles and profile fields table to see if there is anything weird there.  This happened to me also and for the life of me I can't remember how I fixed it.  Clear your cache and turn all cache settings off - also turn off matching.   Send Boonex tech support a message on this one.   I'm thinking...

Rob

I've been checking the profile fields for the last hour and a half. I noticed here it's not like the 6.1.6, if you change a field it changes in all the other pages - you have to go in each and every one of them. I'll keep checking until I fall asleep with the head on the keyboard - like THAT would be a first, lol.

If I disable the matchmaking won't it make people not be able to find other people?

Another thing I can't find is how to make the site run in free mode - without that "promotion" membership. It's like it was designed only for paid membership sites.

Thank you, Caltrade, you're my saving angel as usual.

I know that moving the fields won't work because I remember trying it and it just changes the field that is the "unknown column".  Turn off matching just to identify if it is the problem, then try a join.  Do you have profiler installed?  If so uninstall it.  Hop up and down on one foot while signing "my way" by Frank Sinatra.   Just kidding about that last part.

UPDATE: also write member "blaine69" and ask how he fixed it.

Ok, it worked. I had to do a "riverdance" though, wearing pink fuzzy slippers.

Removing the match fixed temporarily the problem, then I was able to go in and check manually each field in each view. Why couldn't this be done like the 6 version? If you change one in let's say "edit profile" and admin view, to change it all over the place?

Thank you again, Caltrade!