PhpDig.net

Go Back   PhpDig.net > PhpDig Forums > Bug Tracker

Reply
 
Thread Tools
Old 12-12-2004, 05: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 05:16 AM.
cjones is offline   Reply With Quote
Old 12-12-2004, 10:19 AM   #2
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Old 12-14-2004, 12: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
cjones is offline   Reply With Quote
Old 12-14-2004, 09:10 AM   #4
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Old 12-14-2004, 04:59 PM   #5
cjones
Green Mole
 
Join Date: Dec 2004
Posts: 13
ok, i'll try it now
cjones is offline   Reply With Quote
Old 12-14-2004, 05: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?
cjones is offline   Reply With Quote
Old 12-14-2004, 07:15 PM   #7
Charter
Head Mole
 
Charter's Avatar
 
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.
Charter is offline   Reply With Quote
Old 12-15-2004, 06:07 PM   #8
cjones
Green Mole
 
Join Date: Dec 2004
Posts: 13
sorry but im new, so what do i do with the code?
cjones is offline   Reply With Quote
Old 12-15-2004, 08: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.
vinyl-junkie is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01:39 PM
Security update breaks sites that call the search function from another directory pittster Troubleshooting 3 01-19-2004 04:30 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


All times are GMT -8. The time now is 01:33 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.