Error inserting: Unknown column '0x' in 'field list'

Scriptcase 8 Discussion
#1

Good morning,

Last week I stopped MySql on my Windows machine, backed up my projects, and installed the latest Scriptcase with PHP 5.6. Then restored my backup and everything seemed fine. Then random weird things started being reported. I managed to find and fix some of the issues, but this one has me stumped. It’s a simple addition of ticket information into a form. In this form, we’re simply writing the new record ID, user name and issue they have, but when we click on the ‘add’ button, we get [Error inserting: Unknown column ‘0x’ in ‘field list’]

I thought it might have been related to the fact that the ‘Issue’ field was a medium blob, so I changed the MySql field type to Medium Text, and re-generated the application…but get the same problem. In comparing an older working version of the form to the new version, a lot of code is above me but the insert command is what stands out to me. In the new Insert command, the Issue and Resolution fields are not being referenced properly in the second portion of the command (both are just noted as ‘null’.

$comando = "INSERT INTO " . $this->Ini->nm_tabela . " (" . $NM_cmp_auto . "Account, DateAdded, name, Issue, Resolution, ResDate, Technician, Cost, IP_Address, Status, ScreenShot) VALUES (" . $NM_seq_auto . "$this->account, '$this->dateadded', '$this->name', null, null, '$this->resdate', '$this->technician', $this->cost, '$this->ip_address', '$this->status', null)";

I am assuming this is my problem…Does anyone have any idea how to fix this?

Thanks very much!

#2

I’m getting the same Error

I downloaded ‘Document Library’ application and followed the same rules, but still I’m getting exact same Error message you got.
I already talked to support, they said wait for our next update, developers are working on it. :(((

#3

[QUOTE=ahmeranis;39974]I’m getting the same Error

I downloaded ‘Document Library’ application and followed the same rules, but still I’m getting exact same Error message you got.
I already talked to support, they said wait for our next update, developers are working on it. :((([/QUOTE]

Ok great, thanks ahmeranis! I’ve been checking for updates all day - always indicates there are 5 updates but the error persists after each attempt to install them. Will stand by for further updates - glad I’m not the only one =)

Thanks again!

#4

if your blob field saving empty like NULL than that error display,

  • remove required on blob field
  • turn on Debug,
  • run the process,
    you will see the sql statement you are saving its different than the actual blob field table.

hope this will solve issue, same as I solved mine…
regards…