Digging into this a bit further I decided to try exporting the attachments out of the DB and onto the FS.   I used the following command line.

perl.exe \OTRS\otrs-3.0.0\bin\otrs.ArticleStorageSwitch.pl  -s ArticleStorageDB -d ArticleStorageFS

This yielded many instances of this error message.

ERROR: OTRS-otrs.ArticleStorageSwitch.pl-10 Perl: 5.12.2 OS: MSWin32 Time: Wed Sep 29 01:20:21 2010

 Message: Need UserID!

 Traceback (3656):
   Module: Kernel::System::Ticket::Article::ArticleAttachmentIndex (v1.254) Line: 3129
   Module: \OTRS\otrs-3.0.0\bin\otrs.ArticleStorageSwitch.pl (v1.10) Line: 191


The folders were created on disk but they all appear to be empty, and I now have no inline images in my old articles.  New attachments show up.

Where should I be looking for clues?


On Tue, Sep 28, 2010 at 3:21 PM, Hugh Kelley <hugh.kelley@gmail.com> wrote:
A user sent a large screenshot into OTRS today (3.0 Beta 3) and it seems (based on the coincidental timing) to have caused an issue with the dashboard.

I now get these "Byte order is not compatible at ..\..\lib\Storable.pm " messages in the PerlEx logs (see further down).  The web server just returns a 500 error when I request /otrs/index.pl?Action=AgentDashboard

Strangely, I can navigate directly to the attachment via customer and agent interfaces and see the ticket and the attachment in the article.

Has anyone seen this before?

*** 'C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl' log message at: 2010/09/28 18:35:27
PerlEx: Executing script: C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl
Precompiler: Execute called for file [C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl]
Precompiler: Checking for existence of C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl in Cache
Precompiler: Script C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl is compiled and 848207 minutes old.
Precompiler: Executing
    Package:[PerlEx::Precompiler::c_::otrs::otrs2d3_0_0::bin::cgi2dbin::index_pl]
    Filename:[C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl]
    Params:[]
Precompiler: Execute Error:
    Filename:[C:\OTRS\otrs-3.0.0\bin\cgi-bin\index.pl]
    Package:[PerlEx::Precompiler::c_::otrs::otrs2d3_0_0::bin::cgi2dbin::index_pl]
Params[]
Byte order is not compatible at ..\..\lib\Storable.pm (autosplit into ..\..\lib\auto\Storable\thaw.al) line 415, at ../..//Kernel/System/Cache/FileStorable.pm line 128

PerlEx: Execute returned: -1


The only related looking message I see in the OTRS log is:

[Tue Sep 28 18:43:49 2010][Error][Kernel::System::Web::UploadCache::DB::FormIDAddFile][68] Need Content!