[GESIOR 2012] Invalid argument supplied for foreach() ...

[Hugofasima]

Hello Guys. I'm having this error since forever on Gesior's latestnews page:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\latestnews.php on line 14 and 282

I have no clue what it is!

This is my line 14:

foreach($SQL->query('SELECT ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' AS ' . $SQL->fieldName('id') . ', ' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ' AS ' . $SQL->fieldName('name') . ', COUNT(' . $SQL->tableName('g') . '.' . $SQL->fieldName('name') . ') AS ' . $SQL->fieldName('frags') . ' FROM ' . $SQL->tableName('killers') . ' k LEFT JOIN ' . $SQL->tableName('player_killers') . ' pk ON ' . $SQL->tableName('k') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('kill_id') . ' LEFT JOIN ' . $SQL->tableName('players') . ' p ON ' . $SQL->tableName('pk') . '.' . $SQL->fieldName('player_id') . ' = ' . $SQL->tableName('p') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guild_ranks') . ' gr ON ' . $SQL->tableName('p') . '.' . $SQL->fieldName('rank_id') . ' = ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('id') . ' LEFT JOIN ' . $SQL->tableName('guilds') . ' g ON ' . $SQL->tableName('gr') . '.' . $SQL->fieldName('guild_id') . ' = ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' WHERE ' . $SQL->tableName('g') . '.' . $SQL->fieldName('id') . ' > 0 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('unjustified') . ' = 1 AND ' . $SQL->tableName('k') . '.' . $SQL->fieldName('final_hit') . ' = 1 GROUP BY ' . $SQL->fieldName('name') . ' ORDER BY ' . $SQL->fieldName('frags') . ' DESC, ' . $SQL->fieldName('name') . ' ASC LIMIT 4;') as $guild)

This is my line 282:

foreach ($announcements as $announcementsRow){$news_content .= '<div id="featuredarticle" class="Box">

Can't get this out of my Gesior! Can you guys help me with that?

Thank you OT Land!

 

[Stellow]

It's a query issue, make sure it works on you database, check all the tables and fields.

 

[Zoe Skandinavia]

Xampp it's really bad for gesior. I recommend you Uniform Server. I have never had problems with it.
Using Uniform Server will solve your problem.

 

[Damon]

Xampp it's really bad for gesior. I recommend you Uniform Server. I have never had problems with it.
Using Uniform Server will solve your problem.

I never had problems with Xampp but I had problems with UniServer in the past.
If you wanna go for security Id recommend a Unix server with LAMP stack