Post by rencat » Fri Sep 23, 2011 1:26 pm

I am using bluehost space, my products over 5000. I get a error xls when I export them.
Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

I tried run SET SQL_BIG_SELECTS=1 and run SET SQL_MAX_JOIN_SIZE=800000 in mysql database, but nothing happened
I asked customer service, they can not help me, they said:"you must modify your database". I do not know what it is meaning.

Anyone can help? how to export products data use this extension. or tell me how to modify in mysql.
thanks

Newbie

Posts

Joined
Thu Feb 11, 2010 11:26 am

Post by bestnumberonesuper » Sat Sep 24, 2011 1:30 am

Here is there helpdesk with the links to different ways to export: https://my.bluehost.com/cgi/help/search ... _started=1


Posts

Joined
Sat Sep 24, 2011 1:22 am
Who is online

Users browsing this forum: No registered users and 9 guests