Do you have the database's character set and collation set to utf8/utf8_general_ci (you can check it with "USE otrsdb; SELECT @@character_set_database, @@collation_database;" )?
Regards Gergely Kún Amaris GmbH +421232115171 -----Original Message----- From: otrs [mailto:[email protected]] On Behalf Of Amey Abhyankar Sent: Thursday, December 28, 2017 10:20 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] MySQL error when trying to run /otrs-schema.mysql.sql script for otrs 6.0.3 On 26 December 2017 at 13:24, Renee B <[email protected]> wrote: > Replace < with < > > mysql -u root -p otrs < > /opt/otrs/scripts/database/otrs-schema.mysql.sql Thanks Renee it worked for above command but getting error for following command = ------------------------------------------------------------------------------------------------------------------------------------------------------------ [otrs@localhost ~]$ mysql -u root -p otrsdb < /opt/otrs/scripts/database/otrs-initial_insert.mysql.sql Enter password: ERROR 1366 (HY000) at line 1838: Incorrect string value: '\xE2\x96\xA0</s...' for column 'text' at row 1 ------------------------------------------------------------------------------------------------------------------------------------------------------------ How to solve this 1? :-) Regards, Amey. > > > > > Am 26.12.2017 um 08:38 schrieb Amey Abhyankar: >> Hello, >> >> I have installed MySQL 5.7.20 for Cent OS 7 using RPM method. [64bit] >> I have installed OTRS 6.0.3 using RPM. >> OTRS & MySQL are on same Cent OS 7 machine. >> >> Now trying to run mysql script using following command = mysql -u >> root -p otrs < /opt/otrs/scripts/database/otrs-schema.mysql.sql >> [Same error if I execute this command by root user or by otrs user.] >> >> But it's throwing error as follows = >> >> --------------------------------------------------------------------- >> --------------------------------------------------------------------- >> [root@localhost ~]# mysql -u root -p otrs < >> /opt/otrs/scripts/database/otrs-schema.mysql.sql >> [1] 29397 >> bash: lt: command not found... >> >> [1]+ Stopped mysql -u root -p otrs >> /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: syntax >> error near unexpected token `(' >> /opt/otrs/scripts/database/otrs-schema.mysql.sql: line 7: `CREATE TABLE acl >> (' >> --------------------------------------------------------------------- >> --------------------------------------------------------------------- >> >> How to solve this issue? >> >> Thanks & Regards, >> Amey. >> --------------------------------------------------------------------- >> OTRS mailing list: otrs - Webpage: >> https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h >> =40517080&f=n&p=y >> Archive: >> https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpiperma >> il%2Fotrs&e=abe3d79a&h=3fcb0a61&f=n&p=y >> To unsubscribe: >> https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman >> %2Flistinfo%2Fotrs&e=abe3d79a&h=9cf85515&f=n&p=y > > > -- > Perl / OTRS development: > https://urlsand.esvalabs.com/?u=http%3A%2F%2Fperl-services.de&e=abe3d7 > 9a&h=7e35bb6d&f=n&p=y OTRS AddOn repository: > https://urlsand.esvalabs.com/?u=http%3A%2F%2Fopar.perl-services.de&e=a > be3d79a&h=d823bc4f&f=n&p=y > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: > https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h= > 40517080&f=n&p=y > Archive: > https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpipermai > l%2Fotrs&e=abe3d79a&h=3fcb0a61&f=n&p=y > To unsubscribe: > https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman% > 2Flistinfo%2Fotrs&e=abe3d79a&h=9cf85515&f=n&p=y --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: https://urlsand.esvalabs.com/?u=http%3A%2F%2Fotrs.org%2F&e=abe3d79a&h=40517080&f=n&p=y Archive: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fpipermail%2Fotrs&e=abe3d79a&h=3fcb0a61&f=n&p=y To unsubscribe: https://urlsand.esvalabs.com/?u=http%3A%2F%2Flists.otrs.org%2Fmailman%2Flistinfo%2Fotrs&e=abe3d79a&h=9cf85515&f=n&p=y --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
