Re: bbpress posting errors? missing database tables!
Well – I’ve made progress already : I did a clean re-install of WordPress, then bbPress –
Doing a manual install of bbPress is helpful (for those having issues) because if there are any issues with installation (which may be occuring during a single click install as well) it will be laid out in the post-installation error report. I’m sure there is an error report log somewhere after a single-click installation I just haven’t bothered to look for one –
In any case I googled the error coming up on my report :
`You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16`
and found mention of errors with SQL syntax involving utf8 on many other sites (not just for bbpress) – the general consensus is that the newer version(s) of MYsQL sometimes have hiccups with utf8 during table creation (I have no idea why). In particular I am running a WAMP server with MySQL version 5.5.8
Seeing as BuddyPress has a min. requirement of MySQL version 4.x (something, hehe) – I figured I would try to run a manual install with a lower version of MySQL, so I installed 5.1.40 (arbitrary, could have used any version I’m sure) : WAMP Server 2 makes this very easy by the way, simply mouse over your MySQL -> Version -> and click ‘More’. You can then toggle between versions.
In any case, with MySQL 5.1.40 installed I was able to do the manual install and there were no errors reported! And checking my database I now see that bb_posts was successfully installed!
Testing now to see if this made any changes in the forum errors I’ve been having with bbPress + BuddyPress.