|
11-23-2003, 08:17 AM | #1 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
I have installed your search engine. I have had a problem to install it because i'm not an expert in plesk and i have not the capability to create an user batabase before the creation of the database itself. Then ... i' have created the database ( given to it the user) and then i have read SQL . After the installation of the script with the option "update" the database (and not "create"). All is well but after 2 good test ( lorenzone.it and clarence.com), a test is not good. I have an error. When i index repubblica.it (the first italian newspaper) i have this error :
( Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 ----------------- SITE : http://www.repubblica.it/ Exclude paths : - java - javascript - swf - online3 - news - quotidiano 1:http://www.repubblica.it/ (time : 00:01:06) + + + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + level 1... 2:http://www.repubblica.it/misc/gerenza/gerenza.html (time : 00:01:41) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 3:http://www.repubblica.it/servizi/trova.html (time : 00:01:45) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + 4:http://www.repubblica.it/servizi/scrivi.html (time : 00:01:50) Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 5:http://www.repubblica.it/indici/politica/politica.htm (time : 00:01:56) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + + 6:http://www.repubblica.it/indici/cronaca/cronaca.htm (time : 00:02:04) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + 7:http://www.repubblica.it/indici/economia/economia.htm (time : 00:02:11) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + 8:http://www.repubblica.it/indici/esteri/esteri.htm (time : 00:02:20) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + 9:http://www.repubblica.it/indici/sport/sport.htm (time : 00:02:28) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + + + + + + + + + + 10:http://www.repubblica.it/indici/scie...tecnologia.htm (time : 00:02:40) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + 11:http://www.repubblica.it/indici/spet..._e_cultura.htm (time : 00:02:48) + Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 462 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/eulisse.com/httpdocs/phpdig/admin/spider.php on line 478 + + + + + + + + + Last edited by ullone; 11-23-2003 at 08:21 AM. |
11-23-2003, 08:35 AM | #2 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. Did you set a table prefix in the connect.php file? If you used init_db.sql to make the tables directly, the table names do not contain the prefix.
__________________
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. |
11-23-2003, 10:23 AM | #3 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
I only read the SQL.
Prefix ??? Not. Not. I only read the SQL. I had not touch connect file. What Prefix ?
But... Installation update procedure do not write the "prefix" in the configuration files ? Now i read file connect. ... And i try to understand. ... Last edited by ullone; 11-23-2003 at 10:27 AM. |
11-23-2003, 10:31 AM | #4 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. Did you run install.php? It will write if the permissions are set. A prefix is not needed. Does the information in the connect.php file match your database?
__________________
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. |
11-23-2003, 10:35 AM | #5 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
// Connection configuration
define('PHPDIG_DB_PREFIX',''); define('PHPDIG_DB_HOST','localhost'); define('PHPDIG_DB_USER','username'); define('PHPDIG_DB_PASS','password'); define('PHPDIG_DB_NAME','database'); Structure of DataBase in PhpMyAdmin : Home dig (7) engine excludes keywords logs sites spider tempspider I do not understand. Prefix is blank ? Or "dig" ? |
11-23-2003, 10:44 AM | #6 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. The define('PHPDIG_DB_PREFIX',''); so prefix is blank.
If there were a prefix, say prefix_ for example, the tables would look like: prefix_engine prefix_excludes prefix_keywords prefix_logs prefix_sites prefix_spider prefix_tempspider You do not need a prefix. Hmm.. why does "Warning: mysql_num_rows()" show? What version of PHP do you have?
__________________
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. |
11-23-2003, 10:49 AM | #7 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
only with indexing of repubblica.it (the first italian site).
The strange is that i have this error only with indexing of repubblica.it (the first italian site). Not with the 2 other site i have indexed ( lorenzone.it and clarence.com ). For the site repubblica.it i have this error but the procedure continue and now is finished. A strange error.
Last edited by ullone; 11-23-2003 at 10:56 AM. |
11-23-2003, 10:53 AM | #8 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. There is no prefix. This is okay. What version of PHP?
__________________
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. |
11-23-2003, 11:01 AM | #9 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
The latest. I suppose (4.3). I have Plesk 6.0.2. with RedHat 9.0. And i have the same error also in Localhost (with the latest, i have install in localhost this server) http://www.appservnetwork.com/ .
|
11-23-2003, 11:15 AM | #11 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. In <? phpinfo(); ?> what is the error_reporting number?
__________________
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. |
11-23-2003, 11:17 AM | #12 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
To remove a lock, in the admin panel, click the site, click the update button, and click the unlock link. In config.php, you can set LIMIT_DAYS to zero.
__________________
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. |
11-23-2003, 11:18 AM | #13 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
Repubblica.it give me no error if i try to search in the box here :
http://www.eulisse.com/phpdig/index.php Mah. ... Boh. ... http://www.eulisse.com/phpdig/index....0&option=start |
11-23-2003, 11:28 AM | #14 |
Green Mole
Join Date: Nov 2003
Posts: 10
|
I' m only a newbie. I'm absolutely not an expert. I made law in university. ... I'm a beginner in server dedicated. I have a server only by 2 weeks. ...
Pardon my stupidity but. ... What is : <? phpinfo(); ?> ??? |
11-23-2003, 11:49 AM | #15 |
Head Mole
Join Date: May 2003
Posts: 2,539
|
Hi. That is a very small script to check your PHP configurataion.
I don't think this is a problem with your configuration though. I am able to duplicate these "Warning: mysql_num_rows()" with the repubblica.it site. ullone found a bug.
__________________
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. |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resource id #???? odbc_connect | ainu | Coding & Tutorials | 0 | 01-31-2006 03:28 AM |
update sites mysql warning | cjones | Bug Tracker | 8 | 12-15-2004 09:05 PM |
Warning | clearwater | Troubleshooting | 1 | 01-02-2004 09:31 PM |
Warning: .... foreach() | isto | Troubleshooting | 3 | 12-23-2003 05:03 PM |
I got a warning, please help | David J Harmon | Troubleshooting | 6 | 09-29-2003 06:36 PM |