(Help) Database Error

[gbml4u]

I got this problem on my site and i dont know how to fix it...if anybody knows how to fix them pls needing ur helps..

Invalid SQL:

		SELECT
			user.username, (user.options & 512) AS invisible, user.usergroupid,
			session.userid, session.inforum, session.lastactivity,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS 
displaygroupid, infractiongroupid
		FROM session AS session
		LEFT JOIN user AS user ON(user.userid = session.userid)
		WHERE session.lastactivity > 1169626756
		ORDER BY username ASC;

MySQL Error  : Unknown column 'user.username' in 'field list'
Error Number : 1054

thanks in advanced

[webmazter]

ORDER BY user.username ASC;

[gbml4u]

what the f**kin gonna in here ? i asked a firm to build for me a site and paid them the money for this and lisence, so i got this one, thanks for the information, now im trying to get back the money

[webmazter]

Originally Posted by gbml4u

what the f**kin gonna in here ? i asked a firm to build for me a site and paid them the money for this and lisence, so i got this one, thanks for the information, now im trying to get back the money

chill out, have you tried my suggestion above?

[gbml4u]

but i dont know how to fix it or try to reinstall the Vbb ?

[webmazter]

Originally Posted by gbml4u

but i dont know how to fix it or try to reinstall the Vbb ?

Don't think you need to reinstall VB.

What add-ons are installed on the VB?

[gbml4u]

nothing...because i created this two days ago, and all set by default. Maybe a languague scripts but its not add-ons. I just edited and added some cripts in footer of template.

[webmazter]

try reverting the templates changed one by one. After each reverted, try to access the problem page again.

If it's just a clean install from two days ago, then you can reinstall VB and forget all the hassles. But you need to re-configure your modifications.

You said you paid the firm money for the license and the site. Did you download the script directly from vbulletin.com members area or the script provided by the firm?

If it's provided by the firm, then those scripts may have been tampered.

[gbml4u]

i downloaded this scripts from a site, not from vbulletin and i installed it by myself. I think the best way it to reinstall it now. thanks so much 4 ur help. Wish u all the best, guy.