PDA

View Full Version : VB3.8 Please help me i delete all attachment tables


panraf
07-09-2011, 03:47 PM
Recently accidently i dropped ALL the attachment tables (attacment, attachmentpermission, attachmenttype,attachmentviews)
I try to recreate them but now when i try to upload an attachment i am getting this error: invalidthread specified. If you followed a valid link please inform the administrator.
Please can you tell me the query that creates the 4 tables back and correctly?
Unfortunately i dont have a valid backup of my sql. I didnt have many atttachment stores in the database so i dont care if i loose them. I only want the attachments to work correctly.
Thank you very much

Lynne
07-09-2011, 04:02 PM
The queries to create those tables are in install/mysql-schema.php.

However, you may need to look up what the last attachmentid was that was used so you can change the auto_increment on those tables. If you don't, then you will probably have issues with two posts/threads using the same attachmentids.