<div>
If I understood your question: <br />
Try opening the zip file and can you rename the filenames from within it and save the zip file? then try to extract it.<br />

</div>


<div>
Open the database, edit there and save <br />
Use the way shown in: <a href="http://kingpintech.com/?p=127" rel="ugc">http://kingpintech.com/?p=127</a>&nbsp;
</div>


<div>
marahman3001 Thanks for your response!<br />
<br />
That is just it. I can't locate or do not know where they are in the DB. I already use SQLite for DB mods but under Attachments Table i don's see any of the attachments but rather just system attachments needed for operations.
</div>


<div>
I figured out the solution myself.<br />
<br />
I ended up re-creating the tickets that had long file names attached. :(
</div>


<div>
<div class="content wysiwyg-content">
There is one ticket in particular that has 7-8 images with very long names. I was trying to restore the DB and when I extracted the zip it gave me errors referring to the image file lengths being too long. How can i shorten them...i looked everywhere in sqlite. Couldn't find where.<br />
<br />
Thanks!
</div>
</div>


There is one ticket in particular that has 7-8 images with very long names. I was trying to restore the DB and when I extracted the zip it gave me errors referring to the image file lengths being too long. How can i shorten them...i looked everywhere in sqlite. Couldn't find where.

Thanks!

If I understood your question: 
Try opening the zip file and can you rename the filenames from within it and save the zip file? then try to extract it.


Open the database, edit there and save 
Use the way shown in: http://kingpintech.com/?p=127 

marahman3001 Thanks for your response!

That is just it. I can&#39;t locate or do not know where they are in the DB. I already use SQLite for DB mods but under Attachments Table i don&#39;s see any of the attachments but rather just system attachments needed for operations.

I figured out the solution myself.

I ended up re-creating the tickets that had long file names attached. :(

Modify Spiceworks DB to shorten an attached image&#39;s name

There is one ticket in particular that has 7-8 images with very long names. I was trying to restore the DB and when I extracted the zip it gave me errors referring to the image file lengths being too long. How can i shorten them...i looked everywhere in sqlite. Couldn&#39;t find where.

Thanks!

Modify Spiceworks DB to shorten an attached image's name

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.

IT Administration

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.