error when updating

webblynx · 12-13-2004, 07:56 AM

I just upgraded to 1.85, which went fine. Now i am trying to update the links in my database and I am getting this error on every link:

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/html/search/admin/spider.php on line 246

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/search/admin/spider.php on line 356

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/search/admin/spider.php on line 371

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/search/admin/spider.php on line 356
No link in temporary table

Also, if I go to Update sites from the Admin page, I get this:

Code:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/html/search/admin/limit_upd.php on line 227

Was I supposed to delete the existing database entries before upgrading?

Charter · 12-13-2004, 08:11 AM

Update the database tables 1.8.3 -> 1.8.4 -> 1.8.5.

webblynx · 12-13-2004, 08:22 AM

works like a charm Charter! thanks.

forsakenZen · 12-13-2004, 02:35 PM

I get the same errors after upgrade, the only thing I can see from your above statement is that in the 1.8.5 zip there is no update 1.8.3 sql file or did I get a bad dl?

vinyl-junkie · 12-13-2004, 07:21 PM

Quote:

Originally Posted by forsakenZen

I get the same errors after upgrade, the only thing I can see from your above statement is that in the 1.8.5 zip there is no update 1.8.3 sql file or did I get a bad dl?

I don't recall just which versions of phpdig required database changes, but you would only need an update 1.8.3 sql file if you were upgrading from a lower version than 1.8.3.

If you're having problems upgrading, you may want to consider starting over from scratch rather than trying to upgrade your existing database. That might be easier in the long run.

forsakenZen · 12-14-2004, 01:20 PM

Quote:

Originally Posted by vinyl-junkie

If you're having problems upgrading, you may want to consider starting over from scratch rather than trying to upgrade your existing database. That might be easier in the long run.

I was upgrading from 1.8.0 -> 1.8.5 but there isn't a 1.8.3 upgrade script in the 1.8.5 zip file, I can't start from scratch as I have over 7000 sites in my DB already.

Charter · 12-14-2004, 01:37 PM

If there is no update SQL file for a particular version, then there were no DB changes for that version.

forsakenZen · 12-14-2004, 01:46 PM

Ok,

I got most of the errors to disappear but now I get this in the back-end

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/standard/public_html/admin/index.php on line 48

Charter · 12-14-2004, 01:57 PM

Do "SHOW COLUMNS FROM table_name" and compare with the init_db.sql file. Make sure the prefix is set correctly in the connect.php file. Otherwise, in admin/index.php add:

PHP Code:


			
if (!$result) {

    echo "The error: ".mysql_error()."<br />\n";

}

After the following line:

PHP Code:


			
$result = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."$table"),MYSQL_ASSOC);

And see what it prints onscreen.

forsakenZen · 12-14-2004, 02:07 PM

Sweet that did it, It was a broken table

mysql

repair table engine;

did the trick

Thanks for the help

12-13-2004, 08:11 AM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	Update the database tables 1.8.3 -> 1.8.4 -> 1.8.5. __________________ 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, 01:37 PM	#7
Charter Head Mole Join Date: May 2003 Posts: 2,539	If there is no update SQL file for a particular version, then there were no DB changes for that version. __________________ 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, 01:46 PM	#8
forsakenZen Green Mole Join Date: Dec 2004 Posts: 5	Ok, I got most of the errors to disappear but now I get this in the back-end Code: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/standard/public_html/admin/index.php on line 48

12-14-2004, 01:57 PM	#9
Charter Head Mole Join Date: May 2003 Posts: 2,539	Do "SHOW COLUMNS FROM table_name" and compare with the init_db.sql file. Make sure the prefix is set correctly in the connect.php file. Otherwise, in admin/index.php add: PHP Code: `if (!$result) { echo "The error: ".mysql_error()."<br />\n"; }` After the following line: PHP Code: `$result = mysql_fetch_array(mysql_query("SELECT count(*) as num FROM ".PHPDIG_DB_PREFIX."$table"),MYSQL_ASSOC);` And see what it prints 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, 02:07 PM	#10
forsakenZen Green Mole Join Date: Dec 2004 Posts: 5	Sweet that did it, It was a broken table mysql repair table engine; did the trick Thanks for the help Last edited by forsakenZen; 12-14-2004 at 02:10 PM.

12-13-2004, 08:22 AM	#3
webblynx Green Mole Join Date: Mar 2004 Posts: 3	works like a charm Charter! thanks.

12-13-2004, 02:35 PM	#4
forsakenZen Green Mole Join Date: Dec 2004 Posts: 5	I get the same errors after upgrade, the only thing I can see from your above statement is that in the 1.8.5 zip there is no update 1.8.3 sql file or did I get a bad dl?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem updating to 1.8.8	1001studio	Troubleshooting	0	04-04-2006 06:53 AM
Updating the index (or lack thereof)	dhall5	Troubleshooting	2	02-23-2005 12:48 PM
Site not updating - head requests?	guinessec	Troubleshooting	5	12-15-2004 04:00 AM
updating the index via the shell	liquidice	How-to Forum	1	08-31-2004 11:58 AM
"Update One Page" Updating The Whole Database	vinyl-junkie	Bug Tracker	3	08-08-2004 05:02 PM