mysql_fetch_assoc(): MySql Error after installing

[Meheer Thakare]

After I successfully install the script. I get a Mysql Error as follows,

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webdata/deopack/linux/referringsites.com/htdocs/temp/classes/DirDb.php on line 114
SELECT COUNT(`id`) FROM `dir_links` WHERE `id_category` = '0'
You have an error in your SQL syntax near '(SELECT t1.*, COUNT(DISTINCTROW t3.`id`) num_links, '0' `crossed` FROM `dir_cate' at line 1

you can check for this error at http://www.referringsites.com/temp/index.php

Please Let me know, what could I do to solve this thing out.

Thanks and Regards,
Meheer

[DevilsGun]

I'm having the same trouble with my install of the free version:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site30/fst/var/www/html/classes/DirDb.php on line 114
SELECT COUNT(`id`) FROM `dir_links` WHERE `id_category` = '0'
You have an error in your SQL syntax near '(SELECT t1.*, COUNT(DISTINCTROW t3.`id`) num_links, '0' `crossed` FROM `dir_cate' at line 1

[Nick Collins]

Welcome to our forum, guys! Please check if your MySQL version is 4.0 or above. Here is a one of the ways: login to your admin panel, and click "SERVER INFO".

[DevilsGun]

dam, only version 3.23 :(

[Nick Collins]

You can ask your hosting company to upgrade it for you...

[Meheer Thakare]

Im using 4.1 :unsure: What am I suppose to do now????

[Nick Collins]

I need your ftp and phpMyAdmin credentials to investigate your problem. Please send them to ncollins[at]esyndicat.com

[WTM]

Welcome to our forum, guys! Please check if your MySQL version is 4.0 or above. Here is a one of the ways: login to your admin panel, and click "SERVER INFO".
Hey Nick,

I opened new account with ResellerZoom and made new clean install. Everything is fine except one page: when I click "news" button in the bottom menu I get the same message as other guys on top of the news page:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/my_site/public_html/websources/classes/DirDb.php on line 111

I checked MySql version - 4.1.18-standard
This is my first experience with cPanel and reseller account.
Any ideas if I am doing something wrong or what could it be?

Thanks.

[Nick Collins]

I need to have a look at your website. I need your cpanel credentials as well. Please PM that info.

[mrallen]

I am getting same error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/hwy777co/public_html/cdir/classes/DirDb.php on line 114
SELECT COUNT(`id`) FROM `dir_links` WHERE `id_category` = '0'
Got error 127 from table handler

Using free version 1.5
MySQL version 4.0

Your help would be greatly appreciated.

[Sergey Ten]

Hello mrallen,

Please email your FTP and CPanel (phpMyAdmin) credentials.

sten@esyndicat.com

[mrallen]

Thanks Sergey. I have emailed you the info.

[Sergey Ten]

Hello mrallen,

I investigated this error and I have found that it is error in MySQL database.

[mrallen]

Thanks for your help, Sergey. I finally realized that I needed to start over. So, I created a new database and reinstalled the script. I am now adding all the links manually (using the cache of the pages on Google).

Thanks again and keep up the great work!

[Vasily B.]

Hey Nick,
I opened new account with ResellerZoom and made new clean install. Everything is fine except one page: when I click "news" button in the bottom menu I get the same message as other guys on top of the news page:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/my_site/public_html/websources/classes/DirDb.php on line 111
Any ideas if I am doing something wrong or what could it be?
Thanks.
Hi
Please make sure you have enabled news functionality in admin panel. I used to meet this problem before and I went to news configuration in admin panel and clicked save. The problems disappeared. Please let me know the results.

[WTM]

Yes Simon, that was it.

I found the solution you suggested while ago but forgot to post an update...

Thanks anyway.

[Vasily B.]

always at your services :)

[wcaa987]

I just purchased eSyndicat Pro and got the same error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/username/public_html/maternal/directory/classes/DirDb.php on line 111

PHP version 5.1.2
MySQL version 5.0.18-standard

Can anyone give me a clue as to what might be causing this warning?

[wcaa987]

I just found the above posts....

I can't even login to admin. I get a similar problem when I put in the username and password

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/username/public_html/maternal/directory/classes/DirDb.php on line 94

Any ideas?

[wcaa987]

CANCEL my two above posts...

For some reason, when I first installed, the database was no populated. I just done a reinstall and all seems to be working fine.

[Vasily B.]

welcome to our support forums, wcaa987
I'm glad you have sorted out the problem

[crakup]

Hi,

I have searched for this error and this is the only thread i found about it, the error that i get in the admin panel is this:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mydir/public_html/mydir/classes/DirDb.php on line 114
By the way, i'm in a PHP Version 5.2.5 host.

Any help would be very appreciated, thanks. :sos:

[Nikita B.]

I suppose, this problem with your server configuration..
please PM me your site URL and also ftp details, i'll try to fix this problem asap.