Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   MySQL Error (http://www.mysidiaadoptables.com/forum/showthread.php?t=1181)

sully 11-19-2009 08:50 AM

MySQL Error
 
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 11-19-2009 09:23 AM

RE: MySQL Error
 
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 11-19-2009 09:27 AM

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

Bloodrun 11-19-2009 09:29 AM

RE: MySQL Error
 
Quote:

Originally Posted by sully
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 11-19-2009 09:36 AM

RE: MySQL Error
 
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 11-19-2009 09:45 AM

RE: MySQL Error
 
Quote:

Originally Posted by 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.

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

Code:

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 11-21-2009 04:14 AM

RE: MySQL Error
 
isnt
PHP Code:

mysql_numrows 

supposed to be
PHP Code:

mysql_num_rows 

Ive had problems with that in scripts I've made :)

roryo 12-10-2009 11:25 AM

RE: MySQL Error
 
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 12-10-2009 03:18 PM

RE: MySQL Error
 
Quote:

Originally Posted by 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.

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. :)


All times are GMT -5. The time now is 10:36 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.