[MissKalunji]

Originally Posted by sifuhall

Hello. I just installed and immediately recieved several hundred error emails (we have a very busy site) with the following error:

Invalid SQL:

			SELECT a.*, au.*, post.userid, post.postid 
			FROM post AS post
			INNER JOIN award_user AS au ON (au.userid=post.userid)
			INNER JOIN award AS a ON (a.award_id=au.award_id)
			WHERE post.postid IN (0,214689,214697,214701,214703,214705,214711,214713,214715,214731,214742,214745,214747,214767,214768,214771)

			GROUP BY au.issue_id
			ORDER BY au.issue_time DESC;

MySQL Error  : Unknown column 'a.award_id' in 'on clause'

I opened my awards table (it was created and appears there was no errors during the creating step of installation) and sure enough, there is no field named award_id in the awards table.

However there is a fieldnamed awardsid

Could this be a left over remnant from a hack long ago?

its because its a none register post......check in the previous post theres fix for it