Hi Guys:For a fresh install or update i recieved this two email errors.For DB Error #1064, email content: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 'FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entr' at line 2For DB Error #1146, email content:Table 'codeline_osticket.ost_ticket__cdata' doesn't existI think 2nd error is for first error.Regards.

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance.  The more information you give us the better we will be able to assist you. Thank you.

Thanks ntozier.Centos 6.8 (VPS) with cPanelosTicketv1.10 (901e5ea) —  Up to dateWeb Server SoftwareApacheMySQL version5.6.34PHP version5.6.30 Log TitleLog TypeLog DateIP Address DB Error #1146Error jueves 26 de enero de 2017 4179.8.117.168  DB Error #1064Error jueves 26 de enero de 2017 4179.8.117.168DB Error #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 'FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entr' at line 2Attached file show next to click "install button"Regards

sshot-1.png

This: 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 'FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entr' at line 2Indicates that the SQL query is being rejected by the MySQL server.  Specifically because there is a syntax error.  My guess would be that you have a problem with your MySQL (maybe a bug in the 5.6.30 version).  The second error you listed is a cascading error because of the first one.  Ensure that your DB user has the CREATE permission (which it should since you used it to setup the database in the first place and I would think would result in a permission error otherwise).  If it were me I would try a different version of MySQL.  I believe that the Devs are running MariaDB these days so you could also try that.  Also since your running CentOS you could try disabling SELinux and see if that changes the errors you are getting.  If the __cdata table is created with that shutoff then we would know that it was blocking the creation some how.  I wouldn't think that it would interfere with this sort of thing but was a thought.

Hi.SElinux was disablled before installation.The mysql user have all permissions.I don't think it's a mysql error because I did install 1.9.15 and I had no problem on fresh install.I'll try with MariaDB & comment to you next.Regards.

Hi:OS: Centos 6.8 with cPanel 11.60.38MariaDB 10.0.29PHP: 5.6.30SELinux: disabledOsticket: 1.10Fresh install.When click install button i got error http 500.Same errors #1064 (create table) & #1146 (select).CREATE TABLE IF NOT EXISTS `ost_ticket__cdata` (PRIMARY KEY (ticket_id)) DEFAULT CHARSET=utf8 AS SELECT entry.`object_id` as `ticket_id`, FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entry_id = entry.id JOIN ost_form_field field ON field.id=ans.field_id WHERE entry.object_type='T' GROUP BY entry.object_idRegards.

MySQL and Maria DB are rejecting the query due to syntax error:"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 'FROM ost_form_entry entry JOIN ost_form_entry_values ans ON ans.entr' at line 2"

Sure.This command is from osticket 1.10 install, not from me.With 1.9.15 all ok.Regards.

Correct osTicket is generating the query.  MySQL (or Maria) is rejecting it.Over 9000 people are running 1.10 and not having the problem.So it seems that its unique to your SQL instance.

You recommend to me install 1.9.15 & upgrade to 1.10?Regards

I never ran 1.9.15 so I dont find it likely that I would recommend such a thing.If your new to osTicket I would say install the latest version (always).If you have an old server, I would say upgrade it to 1.10 if you meet the requirements.

14 days later

I have the same error. Also a new installation.

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 'FROM ost_form_entry entry

JOIN ost_form_entry_values ans ON ans.entr' at line 2<br />

MySQL 5.7Centos 7 with php 5.4.16

Hi Hivset.I has to install first 1.9.15 & next upgrade to 1.10I'm using MariaDB 10.0.29 & PHP 5.6CentOS 6.8This an error from osTicket install.Regards

I dont know about MariaDB but I know that MySQL 5.7 doesn't work with osTicket right now.

2 months later

There is a comma after `ticket_id` and before FROM... entry.`object_id` as `ticket_id`, FROM ...The installation doesn't generate the correct SQL query

4 months later

I have only seen this errors when you try to install osticket 1.10 with an additional language pack.Adding the language pack after the install would prevent the errors.The language files seem to be the reason for the problem. They will be updated to avoid this:

https://github.com/osTicket/osTicket/issues/3865

thanks for your answer @[deleted] but i didn't  install osticket 1.10 with  additional language pack.but in the installation I selected spanish languague (In the installation have the option to choose the language)

Only with the built-in english language pack this problem doesn't occur. Normally no other language pack is available at the installation unless you add an additional language pack from osticket.com.So I guess you don't have installed it from osticket.com (and therefore you didn't know that the other language packs are not built-in)..

Write a Reply...