finding attachment

[squidsk]

if you also had a db backup then yes. Restore everything to how it was before the upgrade then run a query to correct the ref counts, then upgrade again.

[chikuru]

Originally Posted by squidsk

if you also had a db backup then yes. Restore everything to how it was before the upgrade then run a query to correct the ref counts, then upgrade again.

You know the query to run the refs counts? or where can I find it?

[squidsk]

Originally Posted by chikuru

You know the query to run the refs counts? or where can I find it?

[sql]UPDATE filedata
LEFT JOIN (
SELECT filedataid, COUNT(attachmentid) AS actual
FROM attachment
GROUP BY filedataid
) list USING (filedataid)
SET refcount = IFNULL(actual, 0)
WHERE refcount <> IFNULL(actual, 0)[/sql]

You'll need to add the table prefix to the table names if your setup uses them. Also as I noted for this query to work the filedata and attachment tables need to be in their pre-upgraded state. Your other option is to reset to 4.2.2 and wait for the 4.2.4 upgrade which includes the above query in the upgrade process.

The query was posted at http://www.vbulletin.com/forum/forum...17#post4330417

[chikuru]

We already upgraded to vb 4.2.3 a month ago..
We have pre upgrade backup. But too old to restore to live site.

What action would you suggest to perform? Should I restore the backup then run this query and merge the database table/s to the live site? If yes, which table/s?

Thank You!

---
Edit:
I guess we will proceed with Paul's suggestion here:
http://www.vbulletin.com/forum/forum...22#post4330622

[squidsk]

You could just restore the attachment and filedata tables to a temporary db, run the query to fix the filedata. Run insert ignore queries on the live database using the content of the temp db tables as the source to restore the lost filedata and attachment data. Once that's done merge a restored copy of the attachment folder with the live copy of the attachment folder.

Take a backup before attempting any of this.

[r5mjh]

ok looks like this is my problem too as im upgrading to 423 too

so correct me if im wrong i need to run the query in my 371 duplicate first then upgrade to 423?

and is it the query above, dave supplied me another query setting it to 1

help appreciated guys as aways