Warning: mysql_fetch_assoc

Support for Template related issues
Post Reply
mekgacom
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Warning: mysql_fetch_assoc

Post by mekgacom » Mon Oct 21, 2013 11:55 am

Hi
When I log in as administrator I and go to images I get these warnings at the top of the page. Please help with this matter.


Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 64

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 65

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 64

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 65

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 64

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/mekgacom/public_html/adult/alegroadult/library/database/database.php on line 65

User avatar
leo
admin
Posts: 4264
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Post by leo » Mon Oct 21, 2013 12:21 pm

Is it AC1.2.8 or earlier? Stable version or development release? Fresh install?
Can you edit the images?
Have you modified something?

mekgacom
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Post by mekgacom » Tue Oct 22, 2013 7:46 am

Hi
It is the 1.2.8 stable version. It has been running for a while. I can upload images. No. I did not modify any script. I did upload a lot of image files from my domain control panel. Then I started to notice this. Should I send you a screen shot of what it is doing?

Then maybe nothing to do with each other. But non the less: If a person is placing an order, (my setting is set to verify stock before bank payment is made). Should the system not notify me of that order?. ( so : the system is not mailing me if an order is placed.)

User avatar
leo
admin
Posts: 4264
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Post by leo » Tue Oct 22, 2013 8:56 am

If you have uploaded a lot of files directly to the image dir, and you went to the Images to add them to your shopping cart automatically, and your host limits the database queries, it could result such an error. So, go to the Images again, wait and hour and go back again. Repeat these steps until the error disappears.

If you have enabled sending e-mails in Setting and mails are not sent, then your host restricts it. Ask your host whether php's mail function is blocked. In this case you have to use smtp authentication, this will be added to AC in 1.2.9. Anyway, it is already done, just check our SVN.

mekgacom
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Post by mekgacom » Tue Oct 22, 2013 12:12 pm

Hi
It seems not to work. I added an image for you.
Attachments
Slide2960720 (600 x 450).png
Slide2960720 (600 x 450).png (207.62 KiB) Viewed 19505 times
Slide1960720 (600 x 450).png
Slide1960720 (600 x 450).png (221.59 KiB) Viewed 19505 times

User avatar
leo
admin
Posts: 4264
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Post by leo » Wed Oct 23, 2013 6:55 am

What browser are you using?

User avatar
leo
admin
Posts: 4264
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Post by leo » Wed Oct 23, 2013 9:49 am

It seems that you have uploaded some images containing ' in the filename (e.g. BOA'S).
So, remove it from the filenames.

mekgacom
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Post by mekgacom » Wed Oct 23, 2013 12:35 pm

thanks

Post Reply