Last page of particular topic causing SQL error

[Eelke]

Hi all,

Edit: had to change description, because going to unread posts of other topics works fine.

It appears that when I try to get to the last page of the topic What happened to the forum today?, I get a SQL error:

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'u, phpbb_posts p WHERE p.poster_id = u.user_id' at line 2 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

This is regardless of how I try to get there (unread posts, go to the last post, go to the last page from pagination links.

I considered actually "contacting the board administrator", but I guess this will be a generic problem, so posting it here may prevent others from also doing that and causing a lot of duplicate reports.

[Eelke]

Edit: changed above description.

[motokochan]

There are comments on that issue here. Apparently, it is something to do with that exact page. Better an error like that than a db crash, however.

[diri]

Apparently, it is something to do with that exact page. Better an error like that than a db crash, however.

I don't believe it is something related to this very page. It can be displayed choosing some option.

There are problems with DB and phpBB at this very server at least (time outs, server not responding, ...). I wish Joomla! devs would be able to concentrate on their product and not starting adventure tours which force them to fix "foreign" products.

[Eelke]

There are comments on that issue here.

I know. That topic was opened after I opened mine, though

[brad]

Ok, been working on this today. Fixed up something in the only 3rd party mod we had installed and also migrated some db tables to innodb.

Let's see how this goes now.