Database error - my little forum

Edit: English translation added (Alex):

Hello, I get an error when clicking on entries, the message is:

Database error
Column 'cache_id' in on clause is ambiguous

The entries are not accessible anymore.
Is this a known problem or does anybody have an idea why this occurs?

Thanks Osiris

Original message: (German)

Hallo, ich bekomme, wenn ich BeitrÃ¤ge anklicke, die Meldung:

Datenbank Fehler
Column 'cache_id' in on clause is ambiguous

Die BeitrÃ¤ge sind nicht mehr aufrufbar.
Ist das ein bekanntes Problem, oder hat jemand Ahnung, warum es auftritt.

Danke Osiris

I've got exactly this same error on my NearlyFreeSpeech hosting account. A local copy of the system (on XAMPP running on Windows XP) works perfectly.

I've taken the "complete thread" icon off the site for now - but it would be nice to solve it and keep the functionality

Is this a known problem or does anybody have an idea why this occurs?

I'm afraid this is caused by the new (since v. 2 beta 11) MySQL query with LEFT JOINs and an old MySQL version. Which version do you use?

Alex

NearlyFreeSpeech.com run mySQL version 4.1.21
Can the queries be modified to work with this at all?

I had a rummage, and editing the file forumincludesthread.inc.php sorts it.

Change line 60 from:

LEFT JOIN ".$db_settings['entry_cache_table']." ON cache_id=id

LEFT JOIN ".$db_settings['entry_cache_table']." ON ".$db_settings['entry_cache_table'].".cache_id=id

Hi,

I have the same problem.

I had a rummage, and editing the file forumincludesthread.inc.php sorts it.

Change line 60 from:

LEFT JOIN ".$db_settings['entry_cache_table']." ON cache_id=id

to

LEFT JOIN ".$db_settings['entry_cache_table']." ON ".$db_settings['entry_cache_table'].".cache_id=id

It works! Thx.

Micha

--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences