Top Five
Geplaatst: 05 feb 2009, 18:34
Hallo allemaal,
Ik was net deze mod aan het instaleren, niet zo moeilijk alleen een paar dingetjes veranderen, maar nu ik dit gedaan heb en de buffer geleegd heb krijg ik deze foutmelding:
Algemene fout
SQL ERROR [ mysqli ]
Unknown column 'p.poster_id' in 'on clause' [1054]
SQL
SELECT MAX(p.post_time) as post_time, u.user_id, u.username, u.user_colour, t.topic_title, t.forum_id, t.topic_last_post_id FROM phpbb_posts p , phpbb_topics t LEFT JOIN phpbb_users u ON p.poster_id = u.user_id WHERE p.topic_id = t.topic_id AND p.post_approved = 1 AND t.topic_moved_id = 0 GROUP BY t.topic_id ORDER BY p.post_time DESC LIMIT 5
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: includes/top_five.php
LINE: 46
CALL: dbal->sql_query_limit()
FILE: index.php
LINE: 105
CALL: include('includes/top_five.php')
Ik gebruik versie 3.0.4 supported met de mod.
Er staat niks over SQL in de install?
Weet iemand hoe dit komt?
Groetjes
Ik was net deze mod aan het instaleren, niet zo moeilijk alleen een paar dingetjes veranderen, maar nu ik dit gedaan heb en de buffer geleegd heb krijg ik deze foutmelding:
Algemene fout
SQL ERROR [ mysqli ]
Unknown column 'p.poster_id' in 'on clause' [1054]
SQL
SELECT MAX(p.post_time) as post_time, u.user_id, u.username, u.user_colour, t.topic_title, t.forum_id, t.topic_last_post_id FROM phpbb_posts p , phpbb_topics t LEFT JOIN phpbb_users u ON p.poster_id = u.user_id WHERE p.topic_id = t.topic_id AND p.post_approved = 1 AND t.topic_moved_id = 0 GROUP BY t.topic_id ORDER BY p.post_time DESC LIMIT 5
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/db/mysqli.php
LINE: 205
CALL: dbal_mysqli->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()
FILE: includes/top_five.php
LINE: 46
CALL: dbal->sql_query_limit()
FILE: index.php
LINE: 105
CALL: include('includes/top_five.php')
Ik gebruik versie 3.0.4 supported met de mod.
Er staat niks over SQL in de install?
Weet iemand hoe dit komt?
Groetjes