Forgot?

Error 1267

Reply Topic
Link to this post 17 Mar 12

After installing and reinstalling Ninjaboard several times, I cannot get the forum to work, at all. I have already read tips and advice saying to go through and change collation to utf8_general_ci, in mySQL database, and I've done that. The only thing that remains is, for some reason- under MySQL's specs it says "MySQL charset: UTF-8 Unicode (utf8)." Everything else I manually went through and made utf8_general_ci, yes manually, yes all of it. Nothing I can do will change this, NOTHING. I've about had it, I've googled the crap out of myself and read so many forums my eyes are bleeding. Does anyone have ANY advice on this? I've wasted almost 6 hours on trying to get Ninjaboard to work, and I'd really like for that time to pay off because the extension looks fantastic (if it would work), but I'm really close to abandoning it for something else that (is inferior, BUT) WORKS.

Thanks in advance.

Link to this post 17 Mar 12

Hi Don926,

Sorry to hear you are having troubles with Ninjaboard.

You did a good job by changing the database collation to utf8_general_ci.
This is what we recommend when someone's got a 1267 error.
The strange thing is that Ninjaboard still doesn't work, while it should after these changes.

Try to uninstall Ninjaboard, check if your database is still set to utf8_general_ci, install Ninjaboard again.
In some cases, when a collation is changed, it affects only the newly created tables within a database after changing a collation.

I hope this helps.

Let us know how it goes.

Kind regards,
John

Link to this post 17 Mar 12

John,

Thanks for the advice, I gave what you suggested a try but there was no change. If I click on "Forums" in the Ninjaboard dashboard, or if I try to create a forum from the menu manager, I get "Error 1267" and nothing can be done further. I'm wondering if the issue is no longer with my collation but the fact that when the database was created it was with utf8_unicode_ci instead of utf8_general_ci. Even though everything says it is utf8_general_ci, under MySQL Charset on the database homepage, it says "utf8_Unicode_ci" and I can find no way to change that. However, mySQL collation connection is utf8_general_ci, and so are all of the tables and everything else. If this is not the problem, then I have absolutely no idea what else could cause Ninjaboard to fail so completely. If you have any other ideas, I'd really appreciate it.

Thanks again,
Don

Link to this post 18 Mar 12

Hi Don,

We have had this issue before.
I've looked up the threads about this issue.
It seems that you have to make sure that your jos_user table specifically (or whatever prefix you used other then jos) is set to a collation of utf8_general_ci or utf8_unicode_ci.
As long as it must be the same with the Ninjaboard tables where utf8_general_ci is default on most servers

Go to your database and select xxx_users (xxx stands for your prefix, default is jos).
Then select Operations in the menubar (top right side).
Then change the collation to the same collation/charset that Ninjaboard uses (Table Options section).
Save this setting by clicking the Go/Start button in this section.

This solved the problem for most users with the same issue.

You can read more in the following threads/topics from users who experienced the same and solved it with the suggestion above. The first one holds the solution, the others are just reports.

http://ninjaforge.com/forum/topic/25370-installation-problem/

http://ninjaforge.com/forum/topic/25829-1267-an-error-has-occurred/30701#p30701

http://ninjaforge.com/forum/topic/25572-1267-an-error-has-occurred

I hope this helps.
Let us know how it goes.

Kind regards,
John

Forums Joomla Extension Support NinjaBoard Error 1267