MySQL Error

[sully]

Can someone tell me what the following means and how do I rectify it?

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/sites/site.com/public_html/subs/script/inc/functions.php on line 183


Thanks

[Bloodrun]

Your config.php file was probably not setup right. Other than that line 183 falls into the getlinks() function, have you been editing the funtions.php file?

[sully]

Thanks blood. Nope, I haven't touched any files at all, I just used then install set up.

[Bloodrun]

Thanks blood. Nope, I haven't touched any files at all, I just used then install set up.


Hmm, double check your config.php file and make sure everything is correct.
If everything is correct, make sure the tables were actually made in your MySql Database. Especially the adopts_links table, if none of them were made it means you didn't supply the right data. If all of them were made except that one, I can help you fix that.

[sully]

I've just checked config.php and it's an empty file. It was empty in the zip file I downloaded too.

Initially, I uploaded sql.txt through my hosts mysql database panel as stated in the tutorial. I can view the tables there too, but I wouldn't if they were correct or not.

[Bloodrun]

I've just checked config.php and it's an empty file. It was empty in the zip file I downloaded too.

Initially, I uploaded sql.txt through my hosts mysql database panel as stated in the tutorial. I can view the tables there too, but I wouldn't if they were correct or not.


That tutorial is old, it is for the older version. The new version has a Walk Through script that will set up the information for the script as you supply the data. Once uploading the files to your FTP, you were suppose to CHMOD:

inc>config.php
picuploads>gif
picuploads>jpg

All to 777

Then you were suppose to navigate to the directory install


www.yoursite.com/adoptables/install/


Or where you placed your adoptables script at. Then following the steps in that process your site would have been set up properly. You didn't see the instructions on the first post of this thread? I suggest you read the instructions and do what they say. Then everything will work. I hope I helped you. =D

[exdiogene]

isnt
mysql_numrows
supposed to be
mysql_num_rows
Ive had problems with that in scripts I've made :)

[roryo]

Erm, I'm having something like that, in the installer it says Error connecting to MySQL when I try to submit from step 3.

[BMR777]

Erm, I'm having something like that, in the installer it says Error connecting to MySQL when I try to submit from step 3.


This usually means that your database details are incorrect. Either that, or MySQL is down on your host. Make sure the database and database host details are correct. :)