Mysql Database Syntax errors need fixing
- or -
Post a project like this3616
$18/hr
- Posted:
- Proposals: 10
- Remote
- #485320
- Awarded
Description
Experience Level: Intermediate
I run a job board ( uses jamit.com backend software) and written in php and have done for many years. My server company updated the server fro Mysql 5.1 to 5.5.36-cll MySQL . This has resulted in syntax errors on the pages which access the database and is throwing up the below error.
I need someone to update the SQL syntax so that it functions again.
JB_mysql_query(SELECT t2.field_label AS FLABEL, t1.* AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translations AS t2 WHERE t1.field_id=t2.field_id AND lang='EN' AND section='1' AND form_id='1' ORDER BY field_sort ) - 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 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1
I need someone to update the SQL syntax so that it functions again.
JB_mysql_query(SELECT t2.field_label AS FLABEL, t1.* AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translations AS t2 WHERE t1.field_id=t2.field_id AND lang='EN' AND section='1' AND form_id='1' ORDER BY field_sort ) - 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 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ID, t2.field_comment AS FCOMMENT FROM form_fields AS t1, form_field_translati' at line 1
Andrew P.
100% (2)Projects Completed
1
Freelancers worked with
2
Projects awarded
0%
Last project
20 Jun 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies