Warning: .... foreach()

isto · 12-22-2003, 08:11 AM

I get this error when I visit the link "response time by hour" in the admin menue.

Warning: Invalid argument supplied for foreach() in /var/www/web25/html/navigation/phpdig/admin/robot_functions.php on line 1364

anybody an idea what to do?

Charter · 12-23-2003, 05:20 AM

Hi. What OS and version of PhpDig are you running?

isto · 12-23-2003, 11:02 AM

PhpDig Version 1.6.5
PHP Version 4.3.2
MySql Version 3.23.49
Apache 1.3.26 (Unix)
Server Protocol HTTP/1.1
System Linux
Server API Apache

Charter · 12-23-2003, 04:03 PM

Hi. It looks like the following query is returning zero results. When that happens $result is not an array so foreach() throws a warning. As soon as the query returns greater than zero results, the warning should go away. Thanks for pointing it out. It's something to tweak in a future release.

PHP Code:


			
$query = 'SELECT DATE_FORMAT(l_ts,\\'%H:00') as hour,

round(avg(l_time),2) as avg_time,

count(l_id) as num_queries

FROM '.PHPDIG_DB_PREFIX.'logs

WHERE l_time > 0

GROUP BY hour';

$result = phpdigMySelect($id_connect,$query);

12-22-2003, 08:11 AM	#1
isto Green Mole Join Date: Oct 2003 Posts: 2	Warning: .... foreach() I get this error when I visit the link "response time by hour" in the admin menue. Warning: Invalid argument supplied for foreach() in /var/www/web25/html/navigation/phpdig/admin/robot_functions.php on line 1364 anybody an idea what to do?

12-23-2003, 05:20 AM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. What OS and version of PhpDig are you running? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

12-23-2003, 04:03 PM	#4
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. It looks like the following query is returning zero results. When that happens $result is not an array so foreach() throws a warning. As soon as the query returns greater than zero results, the warning should go away. Thanks for pointing it out. It's something to tweak in a future release. PHP Code: `$query = 'SELECT DATE_FORMAT(l_ts,\\'%H:00') as hour, round(avg(l_time),2) as avg_time, count(l_id) as num_queries FROM '.PHPDIG_DB_PREFIX.'logs WHERE l_time > 0 GROUP BY hour'; $result = phpdigMySelect($id_connect,$query);` __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Warning: ereg_replace(): REG_EBRACK	alivin70	Troubleshooting	3	02-23-2005 08:41 AM
Warning: ereg_replace(): REG_EBRACK in .....	Jad	Troubleshooting	3	12-11-2004 11:58 PM
Warning	clearwater	Troubleshooting	1	01-02-2004 08:31 PM
Requested Warning	Charter	The Mole Hole	0	11-28-2003 05:14 AM
I got a warning, please help	David J Harmon	Troubleshooting	6	09-29-2003 05:36 PM

12-23-2003, 11:02 AM	#3
isto Green Mole Join Date: Oct 2003 Posts: 2	PhpDig Version 1.6.5 PHP Version 4.3.2 MySql Version 3.23.49 Apache 1.3.26 (Unix) Server Protocol HTTP/1.1 System Linux Server API Apache