I was hoping I could actually get a record into this thing, but no such luck. First record I tried blew up with SQL errors because of my field "COMPANY" with an unknown column error. Good enough, I thought, I will just delete it, then reenter a new field with the same name. The second time, however, a different field blue it up - my "JTITLE" (job title) field. Sql error message, and the first part of the data dump follows. Can anyone give me a clue as to what might be going on?
------------
Query:
INSERT INTO `Profiles` SET `NickName` = 'robg', `Password` = 'samplepw', `Email` = 'rob@mysite.com', `DateReg` = '2009-08-31 01:50:13', `DateLastEdit` = '0000-00-00', `Status` = 'Active', `DateLastLogin` = '0000-00-00', `Featured` = 0, `Sex` = 'male', `LookingFor` = '', `DescriptionMe` = '
Own and operate the California Trade Network
', `DateOfBirth` = '', `Headline` = '', `Country` = 'US', `City` = 'San Diego', `Couple` = 0, `Tags` = 'social networks', `zip` = '92109', `Height` = '', `Weight` = '', `Income` = '', `Occupation` = '', `Religion` = '', `Education` = '', `RelationshipStatus` = '', `Hobbies` = '', `Interests` = '', `Ethnicity` = '', `FavoriteSites` = '', `FavoriteMusic` = '', `FavoriteFilms` = '', `FavoriteBooks` = '', `FirstName` = 'Rob', `LastName` = 'G', `JTITLE` = 'CEO', `PHONE` = '858-483-xxxx', `STATE` = 'CA', `METRO` = 'San Diego', `Industries` = 'Internet', `SKYPE` = '', `GMAIL1` = '', `YAHOO` = '', `Languages` = '0', `COMPANY` = 'CalTrade'
Mysql error:
Unknown column 'JTITLE' in 'field list'
-------
first part of debug
Found error in the file '/var/www/vhosts/mysite.com/httpdocs/inc/classes/BxDolProfilesController.php' at line 116.
Called 'db_res' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /var/www/vhosts/c
UPDATE: I just found out my gmail account started putting my database errors into my spam folder - I have been getting them for half the day. It is a good thing there are no rafters here.