Recurrence error

[elricho]

Another bug in Recurrences,
when I save a new one, the sql instruction is formed incorrectly by adding an invalid character / which causes the insert to fail
Thanks for your help.

[28-Nov-2019 07:38:56 America/Los_Angeles] PdoDb – debugger(): INSERT INTO si_cron (domain_id, invoice_id, start_date, end_date, recurrence, recurrence_type, email_biller, email_customer) VALUES (‘1/’, 2, ‘2019-09-01’, ‘2030-01-01’, 3, ‘month’, 1, 1)
[28-Nov-2019 07:38:56 America/Los_Angeles] PdoDb – query(): Execute error.Array
(
[0] => 01000
[1] => 1265
[2] => Data truncated for column ‘domain_id’ at row 1
)

[28-Nov-2019 07:38:56 America/Los_Angeles] PdoDb – backtrace: Array
(
[0] => Array
(
[file] => /home/rizzi/domains/rizzi.ml/public_html/si/Inc/Claz/PdoDb.php
[line] => 1174
[function] => query
[class] => Inc\Claz\PdoDb
[object] => Inc\Claz\PdoDb Object
(
[caseStmts:Inc\Claz\PdoDb:private] =>
[debug:Inc\Claz\PdoDb:private] =>
[debug_label:Inc\Claz\PdoDb:private] =>
[debug_microtime:Inc\Claz\PdoDb:private] => 0
[distinct:Inc\Claz\PdoDb:private] =>
[excludedFields:Inc\Claz\PdoDb:private] => Array
(
[id] => 1
)

[fauxPost:Inc\Claz\PdoDb:private] =>
[fieldPrefix:Inc\Claz\PdoDb:private] =>
[functions:Inc\Claz\PdoDb:private] =>
[groupBy:Inc\Claz\PdoDb:private] =>
[havings:Inc\Claz\PdoDb:private] =>
[joinStmts:Inc\Claz\PdoDb:private] =>
[keyPairs:Inc\Claz\PdoDb:private] => Array
(
[:domain_id_000] => 1/
[:invoice_id_001] => 2
[:start_date_002] => 2019-09-01
[:end_date_003] => 2030-01-01
[:recurrence_004] => 3
[:recurrence_type_005] => month
[:email_biller_006] => 1
[:email_customer_007] => 1
)

[lastCommand:Inc\Claz\PdoDb:private] =>
[limit:Inc\Claz\PdoDb:private] => 0
[noErrorLog:Inc\Claz\PdoDb:private] =>
[onDuplicateKey:Inc\Claz\PdoDb:private] =>
[orderBy:Inc\Claz\PdoDb:private] =>
[pdoDb:Inc\Claz\PdoDb:private] => PDO Object
(
)

[pdoDb2:Inc\Claz\PdoDb:private] => PDO Object
(
)

[saveLastCommand:Inc\Claz\PdoDb:private] =>
[selectAll:Inc\Claz\PdoDb:private] =>
[selectList:Inc\Claz\PdoDb:private] =>
[selectStmts:Inc\Claz\PdoDb:private] =>
[table_columns:Inc\Claz\PdoDb:private] =>
[table_constraints:Inc\Claz\PdoDb:private] =>
[table_engine:Inc\Claz\PdoDb:private] =>
[table_schema:Inc\Claz\PdoDb:private] => rizzi_si
[transaction:Inc\Claz\PdoDb:private] =>
[usePost:Inc\Claz\PdoDb:private] => 1
[whereClause:Inc\Claz\PdoDb:private] =>
)

[type] => ->
[args] => Array
(
[0] => INSERT INTO si_cron
(domain_id, invoice_id, start_date, end_date, recurrence,
recurrence_type, email_biller, email_customer)
VALUES (:domain_id_000, :invoice_id_001, :start_date_002, :end_date_003, :recurrence_004,
:recurrence_type_005, :email_biller_006, :email_customer_007)

[1] => Array
(
[:domain_id_000] => 1/
[:invoice_id_001] => 2
[:start_date_002] => 2019-09-01
[:end_date_003] => 2030-01-01
[:recurrence_004] => 3
[:recurrence_type_005] => month
[:email_biller_006] => 1
[:email_customer_007] => 1
)

)

)

[1] => Array
(
[file] => /home/rizzi/domains/rizzi.ml/public_html/si/Inc/Claz/Cron.php
[line] => 108
[function] => request
[class] => Inc\Claz\PdoDb
[object] => Inc\Claz\PdoDb Object
(
[caseStmts:Inc\Claz\PdoDb:private] =>
[debug:Inc\Claz\PdoDb:private] =>
[debug_label:Inc\Claz\PdoDb:private] =>
[debug_microtime:Inc\Claz\PdoDb:private] => 0
[distinct:Inc\Claz\PdoDb:private] =>
[excludedFields:Inc\Claz\PdoDb:private] => Array
(
[id] => 1
)

[fauxPost:Inc\Claz\PdoDb:private] =>
[fieldPrefix:Inc\Claz\PdoDb:private] =>
[functions:Inc\Claz\PdoDb:private] =>
[groupBy:Inc\Claz\PdoDb:private] =>
[havings:Inc\Claz\PdoDb:private] =>
[joinStmts:Inc\Claz\PdoDb:private] =>
[keyPairs:Inc\Claz\PdoDb:private] => Array
(
[:domain_id_000] => 1/
[:invoice_id_001] => 2
[:start_date_002] => 2019-09-01
[:end_date_003] => 2030-01-01
[:recurrence_004] => 3
[:recurrence_type_005] => month
[:email_biller_006] => 1
[:email_customer_007] => 1
)

[lastCommand:Inc\Claz\PdoDb:private] =>
[limit:Inc\Claz\PdoDb:private] => 0
[noErrorLog:Inc\Claz\PdoDb:private] =>
[onDuplicateKey:Inc\Claz\PdoDb:private] =>
[orderBy:Inc\Claz\PdoDb:private] =>
[pdoDb:Inc\Claz\PdoDb:private] => PDO Object
(
)

[pdoDb2:Inc\Claz\PdoDb:private] => PDO Object
(
)

[saveLastCommand:Inc\Claz\PdoDb:private] =>
[selectAll:Inc\Claz\PdoDb:private] =>
[selectList:Inc\Claz\PdoDb:private] =>
[selectStmts:Inc\Claz\PdoDb:private] =>
[table_columns:Inc\Claz\PdoDb:private] =>
[table_constraints:Inc\Claz\PdoDb:private] =>
[table_engine:Inc\Claz\PdoDb:private] =>
[table_schema:Inc\Claz\PdoDb:private] => rizzi_si
[transaction:Inc\Claz\PdoDb:private] =>
[usePost:Inc\Claz\PdoDb:private] => 1
[whereClause:Inc\Claz\PdoDb:private] =>
)

[type] => ->
[args] => Array
(
[0] => INSERT
[1] => si_cron
)

)

[2] => Array
(
[file] => /home/rizzi/domains/rizzi.ml/public_html/si/modules/cron/save.php
[line] => 32
[function] => insert
[class] => Inc\Claz\Cron
[type] => ::
[args] => Array
(
)

)

[3] => Array
(
[file] => /home/rizzi/domains/rizzi.ml/public_html/si/modules/cron/add.php
[line] => 9
[args] => Array
(
[0] => /home/rizzi/domains/rizzi.ml/public_html/si/modules/cron/save.php
)

[function] => include
)

[4] => Array
(
[file] => /home/rizzi/domains/rizzi.ml/public_html/si/index.php
[line] => 375
[args] => Array
(
[0] => /home/rizzi/domains/rizzi.ml/public_html/si/modules/cron/add.php
)

[function] => include
)

)

[28-Nov-2019 07:38:56 America/Los_Angeles] Cron insert error – PdoDb – query(): Execute error. See error_log.

[RRowley]

In the templates/default/cron/add.tpl file on line 114. Remove the “/” before the terminating “>” sign. So this:
<input type=”hidden” name=”domain_id” value={if isset($domain_id)}{$domain_id}{/if}/>
becomes this:
<input type=”hidden” name=”domain_id” value={if isset($domain_id)}{$domain_id}{/if}>

[Author]

Posts