Author Topic: Error uploading PDF files  (Read 2849 times)

ed.aldridge

  • Freshman
  • *
  • Posts: 16
    • View Profile
Error uploading PDF files
« on: August 20, 2012, 07:48:20 am »
On some PDF files when I try to upload them I get the error

Query failed with message "Incorrect string value" \xB5\xB5\xB5\xB5\x0D\x0A 'for column 'content' at row 1

I think it is something to do with the file encoding, what can I change to fix this?

Regards
Ed

ed.aldridge

  • Freshman
  • *
  • Posts: 16
    • View Profile
Re: Error uploading PDF files
« Reply #1 on: August 20, 2012, 08:09:35 am »
This seems to happen on any PDF that has a PDF version of 1.5 or lower, PDF's with PDF version 1.6 seem to be ok.

ed.aldridge

  • Freshman
  • *
  • Posts: 16
    • View Profile
Re: Error uploading PDF files
« Reply #2 on: August 20, 2012, 08:32:44 am »
Also get the same error with a different string code when trying to upload docx files....

Jacky

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: Error uploading PDF files
« Reply #3 on: August 28, 2012, 08:26:24 am »
You have to disable searchable these files. The error is caused by inserting query into table "fo_searchable_objects"

To disable these files for searchable is to change the records in table "fo_file_types": change from 1 to 0 in column 'is_searchable'