MyBB Community Forums

Full Version: MyBB experienced an internal SQL error [solved]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
(2010-06-22, 07:40 PM)ZarzÄ…dca Wrote: [ -> ]
(2010-06-22, 07:23 PM)DotMRT Wrote: [ -> ]how did you manage to install it on your phone? Confused

http://wiki.opensource.nokia.com/projects/PAMP

Smile

OT-

This has happened to me before, I restarted MySQL and it worked.

Doesnt work for me though
I commented out the shutdown function and i still got the error. From all the steps, the last one seems to go wrong...

I have found my problem, but i need an answer as to why it happened. The problem came from this block of code

	if($db->supports_fulltext('threads'))
	{
		$db->create_fulltext_index('threads', 'subject');
	}
	if($db->supports_fulltext_boolean('posts'))
	{
		$db->create_fulltext_index('posts', 'message');
	}
After removing it, mybb installed successfully with no errors. Is it important and why did it not run? And just for the record i start mysql with --skip-grant-tables
after some searching, and test on IRC, the problem is that currently MySQL cannot move the file with altered table(so with the creation of FULLTEXT Index) to the effective "real" file.
Probably some leak of permission due to the phone...
But after applying a fix from the PAMP developers it seems to be working, but i will have to test with a fresh install!
Pages: 1 2