Scratch

12three wrote:

It did the same thing to me, but it still posted the comment.
-12three-

it did post the comment, yet it gave me the error...

recycle49 wrote:

O_O Iv never seen one of those before

Code:

Warning (512): SQL Error: 1064: 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[ \t\n\r\f\v]*know...' AND Pcomment`.`created > now() - interval 3  day AND Pco' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]
Code | Context$sql    =    "SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`)  WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`content` RLIKE 'satan:*shrugs*[ \t\n\r\f\v]*I[ \t\n\r\f\v]*don't[ \t\n\r\f\v]*know...' AND Pcomment`.`created > now() - interval 3  day AND Pcomment`.`user_id = 447920   "
$error    =    "1064: 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[ \t\n\r\f\v]*know...' AND Pcomment`.`created > now() - interval 3  day AND Pco' at line 1"
$out    =    null            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 627
Model::find() - CORE/cake/libs/model/model.php, line 1795
Pcomment::find() - APP/models/pcomment.php, line 12
Model::findAll() - CORE/cake/libs/model/model.php, line 2631
Pcomment::findAll() - APP/models/pcomment.php, line 23
ProjectsController::comment_reply() - APP/controllers/projects_controller.php, line 2735
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 91
Query: SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Pcomment`.`content` RLIKE 'satan:*shrugs*[ \t\n\r\f\v]*I[ \t\n\r\f\v]*don't[ \t\n\r\f\v]*know...' AND Pcomment`.`created > now() - interval 3 day AND Pcomment`.`user_id = 447920 

Warning (512): SQL Error: 1064: 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 know...' AND Pcomment`.`reply_to!= -100    LIMIT 1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 512]
Code | Context$sql    =    "SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`)  WHERE `Pcomment`.`project_id` = 1265906 AND `Pcomment`.`user_id` = 447920 AND `Pcomment`.`content` = 'satan:*shrugs* I don't know...' AND Pcomment`.`reply_to!= -100    LIMIT 1"
$error    =    "1064: 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 know...' AND Pcomment`.`reply_to!= -100    LIMIT 1' at line 1"
$out    =    null            $out = null;
            if ($error) {
                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 512
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 627
Model::find() - CORE/cake/libs/model/model.php, line 1795
Pcomment::find() - APP/models/pcomment.php, line 12
ProjectsController::comment_reply() - APP/controllers/projects_controller.php, line 2785
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 256
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 91
Query: SELECT `Pcomment`.`id`, `Pcomment`.`project_id`, `Pcomment`.`user_id`, `Pcomment`.`content`, `Pcomment`.`visibility`, `Pcomment`.`timestamp`, `Pcomment`.`reply_to_id`, `Pcomment`.`created`, `Pcomment`.`reply_to`, `Pcomment`.`comment_visibility`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`country`, `Project`.`scratch_version_date` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User` ON (`Pcomment`.`user_id` = `User`.`id`) LEFT JOIN `projects` AS `Project` ON (`Pcomment`.`project_id` = `Project`.`id`) WHERE `Pcomment`.`project_id` = 1265906 AND `Pcomment`.`user_id` = 447920 AND `Pcomment`.`content` = 'satan:*shrugs* I don't know...' AND Pcomment`.`reply_to!= -100 LIMIT 1

pika100chu wrote:

This seems like a duplicate thread, but wow! Did it post the comment?

yeah, it was epic failed though, I thought it didn't post, oh well, I'm leaving to forums now I guess