MYSQL edit profile HELP? please?


I get the following error on editing my profile data in D7B6

Warning: Invalid argument supplied for foreach() in D:\WEBSITE\indigoampp\apache-2.2.11\htdocs\inc\classes\BxDolDb.php on line 372
Error
Database query error
Query:
INSERT INTO `bx_wall_events`(`owner_id`, `object_id`, `type`, `action`, `content`, `title`, `description`, `date`) VALUES('1', '1', 'profile', 'edit', 'a:1:{s:14:"OldProfileInfo";a:122:{i:0;s:1:"1";s:2:"ID";s:1:"1";i:1;s:3:"MaX";s:8:"NickName";s:3:"MaX";i:2;s:18:"roaringbiz@live.ca";s:5:"Email";s:18:"roaringbiz@live.ca";i:3;s:32:"0258abbbfd8fae8acf9a44b1c3040cde";s:8:"Password";s:32:"0258abbbfd8fae8acf9a44b1c3040cde";i:4;s:6:"Active";s:6:"Status";s:6:"Active";i:5;s:1:"3";s:4:"Role";s:1:"3";i:6;s:1:"0";s:6:"Couple";s:1:"0";i:7;s:4:"male";s:3:"Sex";s:4:"male";i:8;s:6:"female";s:10:"LookingFor";s:6:"female";i:9;s:24:"I use To Be A RockStar!!";s:8:"Headline";s:24:"I use To Be A RockStar!!";i:10;s:296:"

I Haven't done music since before 2000.. I use the name M.A.X. now for my band name. the copyrights are way back to 1987. I've been on MVT and the radio with my music. I like coffee/drinks and watching good theater movies on my 109 inch tv. if interested in hanging out leave me some mail!
";s:13:"DescriptionMe";s:296:"

I Haven't done music since before 2000.. I use the name M.A.X. now for my band name. the copyrights are way back to 1987. I've been on MVT and the radio with my music. I like coffee/drinks and watching good theater movies on my 109 inch tv. if interested in hanging out leave me some mail!
";i:11;s:2:"CA";s:7:"Country";s:2:"CA";i:12;s:7:"Ka";s:4:"City";s:7:"Ka";i:13;s:10:"000-00-00";s:11:"DateOfBirth";s:10:"000-00-00";i:14;s:1:"1";s:8:"Featured";s:1:"1";i:15;s:19:"2009-10-10 01:18:54";s:7:"DateReg";s:19:"2009-10-10 01:18:54";i:16;s:19:"2009-10-11 23:48:50";s:12:"DateLastEdit";s:19:"2009-10-11 23:48:50";i:17;s:19:"2009-10-11 23:41:55";s:13:"DateLastLogin";s:19:"2009-10-11 23:41:55";i:18;s:19:"2009-10-11 23:50:36";s:11:"DateLastNav";s:19:"2009-10-11 23:50:36";i:19;s:1:"0";s:7:"aff_num";s:1:"0";i:20;s:3:"max";s:4:"Tags";s:3:"max";i:21;s:6:"v1y8m5";s:3:"zip";s:6:"v1y8m5";i:22;s:1:"1";s:11:"EmailNotify";s:1:"1";i:23;s:1:"1";s:6:"LangID";s:1:"1";i:24;s:1:"0";s:11:"UpdateMatch";s:1:"0";i:25;s:1:"5";s:5:"Views";s:1:"5";i:26;s:1:"0";s:4:"Rate";s:1:"0";i:27;s:1:"0";s:9:"RateCount";s:1:"0";i:28;s:1:"0";s:13:"CommentsCount";s:1:"0";i:29;s:1:"3";s:19:"PrivacyDefaultGroup";s:1:"3";i:30;s:6:"online";s:10:"UserStatus";s:6:"online";i:31;s:78:"working on the website.. lost everything. harddrive got destroyed. no backups!";s:17:"UserStatusMessage";s:78:"working on the website.. lost everything. harddrive got destroyed. no backups!";i:32;s:10:"1255194158";s:21:"UserStatusMessageWhen";s:10:"1255194158";i:33;s:1:"2";s:6:"Avatar";s:1:"2";i:34;s:4:"5'6"";s:6:"Height";s:4:"0'0"";i:35;s:3:"100";s:6:"Weight";s:3:"100";i:36;s:18:"$00,001 to $00,000";s:6:"Income";s:18:"$00,001 to $00,000";i:37;s:34:"t";s:10:"Occupation";s:34:"t";i:38;s:5:"Other";s:8:"Religion";s:5:"Other";i:39;s:15:"Some University";s:9:"Education";s:15:"Some University";i:40;s:6:"Single";s:18:"RelationshipStatus";s:6:"Single";i:41;s:161:

DATA REMOVED HERE BECUASE PERSONAL


Mysql error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't done music since before 2000.. I use the name M.A.X. now for my band name. the' at line 1
Found error in the file 'D:\WEBSITE\indigoampp\apache-2.2.11\htdocs\modules\boonex\wall\classes\BxWallDb.php' at line 60.
Called 'query' function with erroneous argument #0.

Debug backtrace:

Array
(
[1] => Array
(
[file] => D:\WEBSITE\indigoampp\apache-2.2.11\htdocs\inc\classes\BxDolDb.php
[line] => 236
[function] => error
[class] => BxDolDb
[object] => BxWallDb Object

can anyone tell me why it won't go through to the mysql on the main editing SAVE??

It seems to bypass it for new fields past that though so I gues the data for the profile is getting through, just something else screwing up pretty badly. maybe wall? I dunno.

Quote · 12 Oct 2009

http://www.boonex.com/trac/dolphin/ticket/1286

Rules → http://www.boonex.com/terms
Quote · 12 Oct 2009

ok alex.. being a coer. I should have realized that a '  would conflict with the mysql code.. we need some sort of wall converter (maybe even a global one for all mysql entries) that can handle the "'" issue.. simple enough to code.. now just where to put it in d7 so it hits all entries of the dreaded ' mysql data error...

Quote · 12 Oct 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.