[programerboy]

Hi,

I've written a trigger with the following content:

<?php
$query = 'UPDATE `my_table` SET `search`=\'a:2:{i:0;a:6:{s:5:"field";s:10:"APP_NUMBER";s:5:"label";s:10:"APP NUMBER";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}i:1;a:6:{s:5:"field";s:9:"APP_TITLE";s:5:"label";s:9:"APP TITLE";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}}\' WHERE `id`=\'1\';';
executeQuery($query);
?>

When I run it, my apache server stops!
I check executeQuery function and I found the problem is for PHPSQLParser class.

What is the problem?!
Thanks

[amosbatto]

For some reason, it can't handle the "`" (backticks). Also, don't include the ";" (semicolon) in the SQL statement.

Try it this way:

Code: Select all

$query = 'UPDATE my_table SET search=\'a:2:{i:0;a:6:{s:5:"field";s:10:"APP_NUMBER";s:5:"label";s:10:"APP NUMBER";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}i:1;a:6:{s:5:"field";s:9:"APP_TITLE";s:5:"label";s:9:"APP TITLE";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}}\' WHERE id=\'1\'';

[programerboy]

Hi,
Thanks for your answer, But I tested it and it didn't execute.

I write this trigger:

Code: Select all

$con = Propel::getConnection( 'workflow' );
$con->executeUpdate( $my_query );

But I think this error should be corrected and I can run it directly.
Thanks