Can't register users at my hotel! ERROR

[Kopperud]

When I try to create a new user on my hotel it fails! So after I have entered the name for the user and the password, and I press continue, and then i am redirected to a white page, where it says:
Incorrect string value: '\xE5 Norb...' for column 'motto' at row 1 How do i fix this error, so other peopel can register at my hotel!? Thanks for any help

 

[Weasel]

Which CMS are you using?

 

[Kopperud]

I am using REVCMS and i am using bcstorm database R63B

 

[Weasel]

RevCMS 1.9.9, is as far as I know, not directly compitable with BcStorm.

 

[Kopperud]

it worked for 3 week, and i have 400 registered users, this error appeared randomly today

 

[Sledmore]

What is the value in app/management/config.php for the default value?

 

[Weasel]

Try to run this query:

ALTER TABLE users MODIFY motto NOT NULL COLLATE utf8_bin;

 

[Kopperud]

when i run that sql code this happend!

[SQL] ALTER TABLE users MODIFY motto NOT NULL COLLATE utf8_bin;
[Err] 1064 - 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 'NOT NULL COLLATE utf8_bin' at line 1

 

[Weasel]

ALTER TABLE users MODIFY motto DEFAULT NOT NULL COLLATE utf8_general_ci;

 

[Kopperud]

I get the same error!

[SQL] ALTER TABLE users MODIFY motto DEFAULT NOT NULL COLLATE utf8_general_ci;
[Err] 1064 - 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 'DEFAULT NOT NULL COLLATE utf8_general_ci' at line 1

 

[Weasel]

I get the same error!

[SQL] ALTER TABLE users MODIFY motto DEFAULT NOT NULL COLLATE utf8_general_ci;
[Err] 1064 - 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 'DEFAULT NOT NULL COLLATE utf8_general_ci' at line 1

I'm sorry, try this:

DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;

 

[Kopperud]

It's okay. I tried the others they did not work.

[SQL] DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
[Err] 1064 - 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 'DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci' at line 1

 

[Weasel]

And what if you add a ; after utf8?

 

[Kopperud]

A new error

[SQL] DEFAULT CHARACTER SET utf8;
[Err] 1064 - 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 'DEFAULT CHARACTER SET utf8' at line 1

 

[Artixius]

Read the error, check row 1 in your users table and look at the motto, set it to null and it should work.

 

[Kopperud]

and how do i do that??

 

[sim0n]

and how do i do that??

He just told you? Go to your db, find the users table, check row 1 in your users table and look at the motto, set it to null and it should work.

 

[Kopperud]

it dosent work

 

[Kopperud]

can somone help me from teamviwer?

 

[Nebula]

make sure you're using the official RevCMS, none of this crap edited stuff, and thats one hell of a messed up error, try redoing RevCMS and re importing a fresh db