catwalk6004
Was able to replicate this. The issue is due to a security patch implemented not too long ago. You will need to do a couple of things. First, you will need to apply this patch:
diff --git a/include/mysqli.php b/include/mysqli.php
index 5e4a0417..460e0665 100644
--- a/include/mysqli.php
+++ b/include/mysqli.php
@@ -304,7 +304,7 @@ function db_real_escape($val, $quote=false) {
//Magic quotes crap is taken care of in main.inc.php
$val=$__db->real_escape_string($val);
- return ($quote)?"'$val'":$val;
+ return ($quote && !empty($val))?"'$val'":$val;
}
function db_input($var, $quote=true) {
Then you will need to either:
- Drop the
_ticket__cdata table and run cron manually until the table is fully repopulated with data (easiest method).
- You can write an SQL query to update the
_ticket__cdata table where if column_name = '' then update to NULL. (eg. UPDATE ost_ticket__cdata SET column_name = NULL WHERE column_name = '';) You must replace column_name with the Invoice # Field's Variable Name.
Once you do this all previous Tickets should work right and then new Tickets should too.
Cheers.
