syntax error at DBUpdate-to-3.1.mysql.sql

[qt_zetroc]

Hi All,

Anyone can help?After running DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs I got this error :

[root@helpdesk scripts]# perl DBUpdate-to-3.1.mysql.sql | mysql -p -f -u root otrs
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 7, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 9, near "'' WHERE"
(Missing operator before WHERE?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 10, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 14, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 16, near "'' WHERE"
(Missing operator before WHERE?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 17, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 21, near ") NULL"
(Missing operator before NULL?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 23, near "'' WHERE"
(Missing operator before WHERE?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 24, near ") NOT"
(Missing operator before NOT?)
Bareword found where operator expected at DBUpdate-to-3.1.mysql.sql line 30, near ") NOT"
(Missing operator before NOT?)
syntax error at DBUpdate-to-3.1.mysql.sql line 7, near ") NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 9, near "'' WHERE queue "
syntax error at DBUpdate-to-3.1.mysql.sql line 10, near ") NOT NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 14, near ") NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 16, near "'' WHERE s_state "
syntax error at DBUpdate-to-3.1.mysql.sql line 17, near ") NOT NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 21, near ") NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 23, near "'' WHERE s_lock "
syntax error at DBUpdate-to-3.1.mysql.sql line 24, near ") NOT NULL"
syntax error at DBUpdate-to-3.1.mysql.sql line 30, near ") NOT NULL"
DBUpdate-to-3.1.mysql.sql has too many errors.
Enter password:

[jojo]

please read the UPGRADING file correctly.

perl is not used to run or cat sql scripts

[qt_zetroc]

Sorry got confused there. I figured it out. Thanks for the tips.