Taki blad jak probuje nacisnac ostrzezenie.
SQL Error : 1054 Unknown column 'p.post_plusp' in 'field list'
SELECT p.poster_id, u.username, u.user_rank, u.user_posts, p.post_plusp, p.post_minusp FROM (phpbb_alkomatposts p LEFT JOIN phpbb_alkomatusers u ON p.poster_id=u.user_id) WHERE p.post_id=297
Line : 524
File : plusminus.php
[ Dodano: 29 Paź 2005 14:00 ]
No i drugi blad wyskakuje mi on jak w viewtopic.php jak wykonam:
#
#--[ FIND ]--
# full text: $sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
#
$sql = "SELECT u.username, u.user_id
#
#--[ IN-LINE FIND ]--
#
u.user_allowsmile
#
#--[ IN-LINE AFTER, ADD ]--
#
, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id
SQL Error : 1054 Unknown column 'u.user_plusp' in 'field list'
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, b.ban_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_alkomatposts p, phpbb_alkomatposts_text pt LEFT JOIN phpbb_alkomatbanlist b ON u.user_id=b.ban_userid, phpbb_alkomatusers u WHERE p.topic_id = 117 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15
Line : 399
File : viewtopic.php
Administratr Underground Music Forum