Page 1 of 1

Warning: mysql_fetch_assoc

Posted: Mon Oct 21, 2013 11:55 am
by mekgacom
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

Re: Warning: mysql_fetch_assoc

Posted: Mon Oct 21, 2013 12:21 pm
by leo
Is it AC1.2.8 or earlier? Stable version or development release? Fresh install?
Can you edit the images?
Have you modified something?

Re: Warning: mysql_fetch_assoc

Posted: Tue Oct 22, 2013 7:46 am
by mekgacom
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.)

Re: Warning: mysql_fetch_assoc

Posted: Tue Oct 22, 2013 8:56 am
by leo
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.

Re: Warning: mysql_fetch_assoc

Posted: Tue Oct 22, 2013 12:12 pm
by mekgacom
Hi
It seems not to work. I added an image for you.

Re: Warning: mysql_fetch_assoc

Posted: Wed Oct 23, 2013 6:55 am
by leo
What browser are you using?

Re: Warning: mysql_fetch_assoc

Posted: Wed Oct 23, 2013 9:49 am
by leo
It seems that you have uploaded some images containing ' in the filename (e.g. BOA'S).
So, remove it from the filenames.

Re: Warning: mysql_fetch_assoc

Posted: Wed Oct 23, 2013 12:35 pm
by mekgacom
thanks