[GESIOR] Invalid argument (Foreach())

[Sentinel3]

Hello everyone,

I think that a lot of people had this error sometimes, so how can I solve this? I don't know. Maybe I miss some queries in database?

Error that I got:
Warning: Invalid argument supplied for foreach() in /pages/latestnews.php on line 38

latestnews.php

I hope that you can help us with this problem, it's very anoying to see this when you try to add something in your website.

 

[Ninja]

Enable DEBUG_DATABASE (index.php#L6, set it to true). You're most likely missing an important column.

 

[Sentinel3]

Alright, done. But now how can I know what type of queries I have to add in my database (like: item,itemid,player,etc)?

Query:     SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;
SQLSTATE:     42S02
Driver code:     1146
Error message:     Table 'forgottenserver.z_news_tickers' doesn't exist
Query:     SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE:     00000
Driver code:   
Error message:

 

[Ninja]

The error indicates that z_news_tickers doesn't exist, so search either on OTLand or Google to find the query.

http://otland.net/threads/error-with-gesior-0-3-8-aac.163490/#post-1575711
http://otland.net/threads/problem-whit-my-page-gesior-0-3-6.85215/#post-874589

 

[Sentinel3]

I added the queries and still not working, i got the same error as comment above. But now I have the table, thank you!

Bump

 

[Tropix]

What error do you get foreach still?

 

[Sentinel3]

Getting the same error.

Error that I got in Website:
Warning: Invalid argument supplied for foreach() in /pages/latestnews.php on line 38

Query:     SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;
SQLSTATE:     42S02
Driver code:     1146
Error message:     Table 'forgottenserver.z_news_tickers' doesn't exist
Query:     SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE:     00000
Driver code:
Error message:

 

[artofwork]

Do you have a table called z_news_tickers?
Post latestnews.php

 

[Sentinel3]

Do you have a table called z_news_tickers?
Post latestnews.php

OMG, read the previous posts please.

I already posted latestnews.php, and I said that yes I have the table in my database.

Bump

 

[Vanderlay]

Don't be rude.
The error clearly states:

Error message: Table 'forgottenserver.z_news_tickers' doesn't exist

So your probably just stupid enough to realize that your data table doesn't exist.
MySQL doesn't print this error just for fun.

 

[Sentinel3]

@Vanderlay I think that I can be enough intelligent to know that I have the table in my database.

z_news_tickers, it's below z_forum and on z_ots_comunication.

structure of table.

 

[Vanderlay]

You're probably looking at the wrong database.
MySQL would never print that error otherwise, unless its a custom error message made from Geisor which could be incorrect.

 

[Sentinel3]

I don't know what's this.. I'm very very confused

Warning: Invalid argument supplied for foreach() in /pages/latestnews.php on line 38
Query:     SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 4;
SQLSTATE:     00000
Driver code:   
Error message:   
Query:     SELECT `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 6;
SQLSTATE:     00000
Driver code:   
Error message:

 

[imkingran]

Try this:

http://pastebin.com/XAwReM7R

 

[Sentinel3]

Alright now I can see the most powerfull guilds without logos !

How can I make to show the New Tickers? Because news tickers are added in latestnews.php

 

[imkingran]

Have you added any News Tickers into the table?

p.s.
It's always nice to say Thanks or give a Like if someone helped you.

 

[Sentinel3]

Have you added any News Tickers into the table?

Ye I've the table as you can see in previous comments that I posted a pictures.

Thanks [/I]or give a Like if someone helped you.

Yes I'm so sorry @imkingran, thank you so much for your time and your job.

 

[imkingran]

Ye I've the table as you can see in previous comments that I posted a pictures.


Yes I'm so sorry @imkingran, thank you so much for your time and your job.

I mean have you inserted data into the tables? In the picture I only see the basic structure of the table

Like this:

 

[Sentinel3]

Here is the direcction of table

And here you can see that yes, I have inserted data in table

 

[imkingran]

Change hide_ticker from 1 to 0.