update sites mysql warning

cjones · 12-12-2004, 06:11 AM

has the phpdig_in_domain been removed in version 1.8.5?

EDIT: i thought i should do this here instead of creating a new thread

i clicked update sites and i got
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/cjones/public_html/phpdig/admin/limit_upd.php on line 227

is this a bug in 1.8.5?

Charter · 12-12-2004, 11:19 AM

In limit_upd.upd find:

PHP Code:


			
while (list($id,$url,$days_db,$links,$depth,) = mysql_fetch_row($result_id)) {

And replace with:

PHP Code:


			
while (list($id,$url,$days_db,$links,$depth) = mysql_fetch_row($result_id)) {

Note the removal of the straggling comma after the $depth variable.

cjones · 12-14-2004, 01:05 AM

i edited the code but i still got the error.
still on line 227

Charter · 12-14-2004, 10:10 AM

In limit_upd.php find:

PHP Code:


			
$result_id = mysql_query($query,$id_connect);

And afterwards add:

PHP Code:


			
if (!$result_id) {

    echo "The error is: ".mysql_error();

}

What does it print onscreen?

cjones · 12-14-2004, 05:59 PM

ok, i'll try it now

cjones · 12-14-2004, 06:08 PM

heres the result:
The error is: Unknown column 'P.days' in 'field list'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/cjones/public_html/phpdig/admin/limit_upd.php on line 230

does this mean theres any error in one of my tables?

Charter · 12-14-2004, 08:15 PM

The straggling comma was a bug/typo in the code. The "unknown column 'P.days' in 'field list'" means that you probably missed adding the days column to the site_page table when doing the upgrade:

Code:

ALTER TABLE site_page ADD COLUMN days INT(4) NOT NULL DEFAULT 0;

cjones · 12-15-2004, 07:07 PM

sorry but im new, so what do i do with the code?

vinyl-junkie · 12-15-2004, 09:05 PM

Go into phpMyAdmin on your web server, find the SQL command line dialog box, copy and paste that line of code into the dialog box and run it. That will get rid of your error.

12-12-2004, 06:11 AM	#1
cjones Green Mole Join Date: Dec 2004 Posts: 13	has the phpdig_in_domain been removed in version 1.8.5? EDIT: i thought i should do this here instead of creating a new thread i clicked update sites and i got Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/cjones/public_html/phpdig/admin/limit_upd.php on line 227 is this a bug in 1.8.5? Last edited by cjones; 12-12-2004 at 06:16 AM.

12-12-2004, 11:19 AM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	In limit_upd.upd find: PHP Code: `while (list($id,$url,$days_db,$links,$depth,) = mysql_fetch_row($result_id)) {` And replace with: PHP Code: `while (list($id,$url,$days_db,$links,$depth) = mysql_fetch_row($result_id)) {` Note the removal of the straggling comma after the $depth variable. __________________ 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-14-2004, 10:10 AM	#4
Charter Head Mole Join Date: May 2003 Posts: 2,539	In limit_upd.php find: PHP Code: `$result_id = mysql_query($query,$id_connect);` And afterwards add: PHP Code: `if (!$result_id) { echo "The error is: ".mysql_error(); }` What does it print onscreen? __________________ 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-14-2004, 08:15 PM	#7
Charter Head Mole Join Date: May 2003 Posts: 2,539	The straggling comma was a bug/typo in the code. The "unknown column 'P.days' in 'field list'" means that you probably missed adding the days column to the site_page table when doing the upgrade: Code: ALTER TABLE site_page ADD COLUMN days INT(4) NOT NULL DEFAULT 0; __________________ 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: mysql_num_rows(): supplied argument is not a valid MySQL result resource	ullone	Troubleshooting	19	05-18-2004 02:39 PM
Security update breaks sites that call the search function from another directory	pittster	Troubleshooting	3	01-19-2004 05:30 PM
Warning	clearwater	Troubleshooting	1	01-02-2004 09:31 PM
Requested Warning	Charter	The Mole Hole	0	11-28-2003 06:14 AM
I got a warning, please help	David J Harmon	Troubleshooting	6	09-29-2003 06:36 PM

12-14-2004, 01:05 AM	#3
cjones Green Mole Join Date: Dec 2004 Posts: 13	i edited the code but i still got the error. still on line 227

12-14-2004, 05:59 PM	#5
cjones Green Mole Join Date: Dec 2004 Posts: 13	ok, i'll try it now

12-14-2004, 06:08 PM	#6
cjones Green Mole Join Date: Dec 2004 Posts: 13	heres the result: The error is: Unknown column 'P.days' in 'field list' Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/cjones/public_html/phpdig/admin/limit_upd.php on line 230 does this mean theres any error in one of my tables?

12-15-2004, 07:07 PM	#8
cjones Green Mole Join Date: Dec 2004 Posts: 13	sorry but im new, so what do i do with the code?

12-15-2004, 09:05 PM	#9
vinyl-junkie Purple Mole Join Date: Jan 2004 Posts: 694	Go into phpMyAdmin on your web server, find the SQL command line dialog box, copy and paste that line of code into the dialog box and run it. That will get rid of your error.