AlegroCart open source E-commerce
Web hosting by Host1Plus

Warning: mysql_fetch_assoc

Support for Template related issues

Warning: mysql_fetch_assoc

Postby 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
mekgacom
 
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Postby 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?
User avatar
leo
admin
 
Posts: 4117
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Postby 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.)
mekgacom
 
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Postby 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.
User avatar
leo
admin
 
Posts: 4117
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Postby 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 16875 times
Slide1960720 (600 x 450).png
Slide1960720 (600 x 450).png (221.59 KiB) Viewed 16875 times
mekgacom
 
Posts: 10
Joined: Tue Feb 26, 2013 11:45 am

Re: Warning: mysql_fetch_assoc

Postby leo » Wed Oct 23, 2013 6:55 am

What browser are you using?
User avatar
leo
admin
 
Posts: 4117
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Postby 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.
User avatar
leo
admin
 
Posts: 4117
Joined: Sun Dec 13, 2009 8:27 am
Location: Hungary

Re: Warning: mysql_fetch_assoc

Postby mekgacom » Wed Oct 23, 2013 12:35 pm

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


Return to Template Support

Who is online

Users browsing this forum: No registered users and 5 guests

cron