Does it work if you import the theme manually then activate the plugin?
I'd have to think it's something host-related, then. It's worked for everyone else as far as I know, just not you. Maybe someone with more MyBB/SQL experience can comment.
only trouble is i don't have another host/server to try it on.
any one willing to lend me some hosting/sql space.
I don't have a locahost set up besides wouldn,t know how to set it up.
(2010-12-15, 02:48 AM)Mark.M Wrote: [ -> ] (2010-12-15, 12:03 AM)adbrad Wrote: [ -> ]I don't have a locahost set up besides wouldn,t know how to set it up.
http://www.howcast.com/videos/214490-How...-17-Server
Thanks i'll play around with that later.
well i replicated the board and database on localhost installed pluging activated no problems so am now talking to host to see if this can be resolved
(2010-12-14, 09:58 PM)adbrad Wrote: [ -> ]SQL Error:
1104 - 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
This means the query is requesting more information than your host's MAX_JOIN_SIZE allows it to. Your host should be able to increase it, but it's not an awful lot of information it's requesting anyway...
Well i spoke to the host and they have said that i need to add
$db->sql_query("SET OPTION SQL_BIG_SELECTS=1");
to the script but where would i add it.