Database error (General)

by Osiris, Friday, May 25, 2007, 19:30 (5230 days ago)

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

Database error

by MGP @, Monday, May 28, 2007, 14:40 (5227 days ago) @ 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

Avatar

Database error

by Alex ⌂ @, Monday, May 28, 2007, 15:43 (5227 days ago) @ Osiris

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

Database error

by MGP, Wednesday, May 30, 2007, 12:00 (5225 days ago) @ Alex

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

Database error

by MGP, Thursday, May 31, 2007, 08:00 (5224 days ago) @ MGP

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

Avatar

Database error

by Micha ⌂, Sunday, June 03, 2007, 17:23 (5221 days ago) @ MGP

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

RSS Feed of thread

powered by my little forum