Unable to load an article

[HervE]

Hello,

It happens from time to time that a particular article cannot be loaded!

The other articles of the same ticket can be loaded, but not this one: it keeps on trying to transfer the data from the server but never succeeds... the article body zone remains empty!

Has anybody already expreienced that problem?
Is there an explanation, and a solution?

Any help will be very appreciated.

Regards,
HervE

[crythias]

It could be a problem rendering (iframe) the html body.

[HervE]

Could be. Thanks for your answer.
What can I do to prevent that please?

HervE

[crythias]

Unfortunately, the best answer I have is not a good one -- find the article in the db and adjust/delete it.

[HervE]

I've already looked for it in the database.
Delete I can do... but I would lose it!
"Adjust"... what's your idea?

HervE

[crythias]

Zoom the ticket, click history.
Observe the Zoom link for the article id.
verify with sqlbox:
select * from article where id=numberfromlink

This is the article. You can't delete from SQL Box, but you can get an idea what it means.

Chances are, the title-popup has the valuable information. Among other things you can do is to grab the title tag from View Source and repopulate the entry via database backend. or export to CSV and work with it there.

Admittedly, this is not recommended without backups, etc., but we're talking about how to get past this for this entry.

[HervE]

Zoom the ticket, click history.
Observe the Zoom link for the article id.
verify with sqlbox:
select * from article where id=numberfromlink

That's exactly what I did already - and I feel happy to have that knowledge by myself
Unfortunately, the SQL Box cuts every field at n character and puts "[..]" at the end.
You can have them a bit longer in the hint popup when you mouse over. But still this is not enough.

Another idea I just had is to Print the article. Now I can read it.

Oh... and guess what? I even can reply to it! And now I can see the entire body, including how it was formatted and the included images.

By the way, this problem happened to me several times, and I think it has something to do with too many included images, too big.
Your opinion?

Of course, I am still looking for a remedy which could prevent us from such a misadventure.

HervE

[crythias]

the csv export won't necessarily chop off, if I recall correctly, but I'm not sure about too big.

[HervE]

Export to CSV from where?

Thanks and Regards,
HervE

[crythias]

SQL Box (change HTML to CSV).

[HervE]

Oh yes, I never payed attention to this option.

It works, and - you were right - the CSV export doesn't chop off.

By the way, is there a possibility to have column headers in the query results of the SQL Box?

Regards,
HervE

[crythias]

Not directly from sqlbox, but I suppose you could tweak the Kernel/Modules/AdminSelectBox.pm for it.

[HervE]

To separate topics I opened a new post about Column headers in SQL Box.

I still have no solution for my initial problem here: unable to load an article.
I still think it has something to do with too many included images, too big.

Any help from anyone is welcome

HervE