Thema: Brauch mal Hilfe bei DB function failed with error number 1054

hi!

würde mich auch interessieren wie man das problem löst, weil bei mir kommt auch folgende meldung wenn ich die content items und news gehen will...

DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10


lg,
miri

...ja, leider.. :( ...aber vielleicht mag er (oder gerne auch ein anderer helfer in der not) uns doch verraten, wie man dieses problem lösen kann

http://forum.mamboserver.com/showthr...t=65411&page=2

Quote:
The problem is in the file /administrator/components/com_content/admin.content.php
Modify, line 201 und 312
"\n FROM #__categories AS cc, #__sections AS s, #__content AS c"

Supergenial,

hat auch bei mir geholfen. Hab nicht schlecht gestaunt als ich das sah, meine Seite läuft schon fast 2 Jahre völlig problemlos. Und dann sowas. KAnn mir jemand sagen, woher die Fehlermeldung stammt??

Herzlichen Dank

Jürgen

Kann mir jemanden Schreiben was Ihr genau gemacht habt. Habe selbes Problem.
Und auf dem Lösungslink verstehe ich nicht viel.

Dankö

Hab das selbe Problem! Habs so geändert wie Oben beschrieben aber keine Änderung.
Hier der Debug Auszug:

Notice: 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 'LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_user in /home/www/web8/html/mambo/includes/database.php on line 184

SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name
FROM mos_categories AS cc, mos_sections AS s, # content AS c
LEFT JOIN mos_groups AS g ON g.id = c.access
LEFT JOIN mos_users AS u ON u.id = c.checked_out
LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id
WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' AND c.sectionid='1'
ORDER BY cc.ordering, cc.title, c.ordering
LIMIT 0,30


/home/www/web8/html/mambo/includes/database.php:348
/home/www/web8/html/mambo/administrator/components/com_content/admin.content.php:204
/home/www/web8/html/mambo/administrator/components/com_content/admin.content.php:122
/home/www/web8/html/mambo/administrator/templates/mambo_admin_blue/index.php:84
/home/www/web8/html/mambo/administrator/index2.php:110DB function failed with error number 1064
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 'LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_user SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name FROM mos_categories AS cc, mos_sections AS s, # content AS c LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' AND c.sectionid='1' ORDER BY cc.ordering, cc.title, c.ordering LIMIT 0,30

Hier die Versionen:
Linux legolas 2.4.21-273-smp4G #1 SMP Mon Jan 17 13:19:07 UTC 2005 i686
Database Version: 5.0.27-standard
PHP Version: 4.3.3
Web Server: Apache/2.0.48 (Linux/SuSE)
WebServer to PHP interface: apache2handler
Mambo Version: Version: Mambo 4.5.1a Stable [Three For Rum] 29/09/2004 20:11 GMT


Hilfeee