Attachment & swattachmentchunks

snook789 · **Attachment & swattachmentchunks -** 24-03-2006, 05:07 PM

We are having 2 problems, and not sure if they are releated.

1st, when we go to Tickets » Attachment Types, there is no option to add the attachment types to accept
(familar with the setting in Settings > Tickets > Attachment Settings)
I have that set to allow only the attachments set, but where do you add them ?

Also, we have a locked table that is causing problems.
Because of this locked table, it is not allowing the whole db size to be backed up, fails

Any help would be greatly appricated

***Varun Shoor*** · 24-03-2006, 06:11 PM

Hi,
There is an Insert link in the table in Attachment Types.

As for locked tables, Did you search google on how to unlock it?

Regards,

Varun Shoor

snook789 · 24-03-2006, 07:27 PM

Thanks on the incert button, I missed it

I sure did, and they still won't unlock (checked the suggestions on dev.mysql.com)

ever see them lock like this ?

***Varun Shoor*** · 24-03-2006, 07:28 PM

Quote:

Originally Posted by snook789

Thanks on the incert button, I missed it

I sure did, and they still won't unlock (checked the suggestions on dev.mysql.com)

ever see them lock like this ?

Nope, Never had any locking issues with tables.

Regards,

Varun Shoor

snook789 · 24-03-2006, 07:34 PM

sounds like it may be corrupt.
can we drop the table and just copy a blank table in from another copy of the db ?

(I don't care if the table is just for attachments, we don't have any needing saving)

***Varun Shoor*** · 24-03-2006, 08:06 PM

Yes you can, You will loose all attachment data. It is recommended you store attachments in files anyway, You can configure this under Admin CP > Settings > Tickets.

Regards,

Varun Shoor

snook789 · 24-03-2006, 08:09 PM

thanks, found the sql statement in the help files

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Move attachment form db to files	logicway	SupportSuite, eSupport and LiveResponse	1	22-01-2007 11:29 AM
Delete ticket = delete attachment file	Chuckler	SupportSuite, eSupport and LiveResponse	0	05-11-2006 01:47 PM
UNKNOWN System -> Attachment cleanup and attachment expiry	NC Software	Feature Requests	0	08-09-2006 08:12 PM
Solved! Eudora Attachment Issue - Needs fix!!	ilion	SupportSuite, eSupport and LiveResponse	4	09-02-2006 05:39 PM

snook789 Offline Member Posts: 45 Join Date: Feb 2005	24-03-2006, 07:27 PM Thanks on the incert button, I missed it I sure did, and they still won't unlock (checked the suggestions on dev.mysql.com) ever see them lock like this ?

snook789 Offline Member Posts: 45 Join Date: Feb 2005	24-03-2006, 07:34 PM sounds like it may be corrupt. can we drop the table and just copy a blank table in from another copy of the db ? (I don't care if the table is just for attachments, we don't have any needing saving)

snook789 Offline Member Posts: 45 Join Date: Feb 2005	24-03-2006, 08:09 PM thanks, found the sql statement in the help files