SQL Database Problem...

[DJ_Guvana]

if you go to www.basslinehouse.info if you try and access the member list or read posts it says you cant. Why?

I GET THIS MESSAGE
​

-----------------------------------------------------------------------------


SQL Error : 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 'FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p

SELECT u.username, u.user_bhp, u.user_bhp, 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, u.user_items, u.user_privs, u.user_effects, u.user_custitle, FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 1 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 402
File : viewtopic.php

 

[aween]

user_allowsmile, p.*, pt.post_text, pt

p.* is not allowed. try to remove that one and then it should work.


also :

FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE

not allowed.


+ DJ can you resend the domain info, i cant remember where i put it ( for the sponsor thing )