Fixed Clarification on how Xenforo handles attachment

[g0rn]

Its a simple error - the function logAttachmentView() is using a Delayed Insert - but the dastabase table is a Memory table which doesnt support them.

DELAYED does work with MEMORY tables, as well as with MyISAM and ARCHIVE tables.

 

[Paul B]

Not such a simple error after all then, it would seem.

 

[Paul M]

DELAYED does work with MEMORY tables, as well as with MyISAM and ARCHIVE tables.

Indeed, looking at the MySQL manual, it would appear you are correct. I always thought only MyISAM supported it.

However the fact remains that the error is

Mysqli prepare error: DELAYED option not supported for table 'xf_attachment_view'

Which seems pretty clear - I can only guess his table is some other engine, its MEMORY on my installation.

Otherwise its a very strange error.

 

[Blandt]

Actually This is error has nothing to do with the broken images (As to not confuse the dev)

I was screwing around with my db earlier that day .... that's probably how I got the error in my log.

I have installed xF on every server imaginable (well the common ones )

IIS and IISExpress are the only 2 with this issue.

 

[z3r010]

So there is no simple fix then?

 

[Blandt]

Not yet ... but I'm still looking