Unexpected Error adding an attachment

Submitted by mkager on 2012-10-24

Hi, greetings form Spain!

I'm new to WebIssues.
I 'm getting an Unexpected Error upon addition of a PDF file (80kb size) as an attachment.

WebIssues Server and WebClient running on the same machine. Operating System: Windows XP.
Apache/2.2.22, PHP/5.2.17, PostgreSQL 8.4 (database created with UTF-8 encoding).
Attachment Storage set to "Always" on Server Settings.
Webissues 1.0.3.

I'm getting the message:

"The following error(s) occured while processing the request:

Unhandled System_Db_Exception: invalid byte sequence for encoding "UTF8": 0xc7ec in C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\db\pgsql\engine.inc.php on line 226
Stack trace:
#0 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\db\pgsql\engine.inc.php(86): System_Db_Pgsql_Engine->sendQuery('INSERT INTO fil...', Array)
#1 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\db\pgsql\engine.inc.php(71): System_Db_Pgsql_Engine->executeQuery('INSERT INTO fil...', Array)
#2 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\db\connection.inc.php(207): System_Db_Pgsql_Engine->execute('INSERT INTO fil...', Array)
#3 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\db\connection.inc.php(178): System_Db_Connection->executeArgs('INSERT INTO {fi...', Array)
#4 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\api\issuemanager.inc.php(582): System_Db_Connection->execute('INSERT INTO {fi...', '162', 'Copia de 200522...', 102877, Object(System_Core_Attachment), '', 0)
#5 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\client\issues\addattachment.php(97): System_Api_IssueManager->addFile(Array, Object(System_Core_Attachment), 'Copia de 200522...', '')
#6 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\client\issues\addattachment.php(59): Client_Issues_AddAttachment->submit()
#7 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\web\component.inc.php(100): Client_Issues_AddAttachment->execute()
#8 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\web\application.inc.php(77): System_Web_Component->run()
#9 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\core\application.inc.php(210): System_Web_Application->execute()
#10 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\system\bootstrap.inc.php(124): System_Core_Application->run()
#11 C:\Archivos de programa\Apache Software Foundation\Apache2.2\htdocs\client\issues\addattachment.php(101): System_Bootstrap::run('Common_Applicat...', 'Client_Issues_A...')"
#12 {main} "

Thanks in advance.
Miguel Angel

I can confirm that this is a bug. I will try to fix it; for now the workaround is to store attachments in the file system when using Postgres.

Regards,
Michał

Hi Michal.

Storing attachments in the file system works fine.

I think I may have found another bug related to attachments. I'll post it on a new topic.

You are doing an excellent job! I think Webissues it's a great application, easy to install, easy to configure and with a great usability.

Thanks for the answer.

Regards,
Miguel Angel