Find Jobs
Hire Freelancers

MySQL Syntax Error Fix

£20-250 GBP

Ukończony
Opublikowano prawie 8 lat temu

£20-250 GBP

Płatne przy odbiorze
I have an old job board site which is based on jamit job board. I am moving hosting companies and am getting error messages (see below). I believe the errors are due to the new host using a newer version of MySQL (the site currently runs on MySQL 5.0.45). I need this to be fixed. Example Syntax Error 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='5' 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
Identyfikator projektu: 10525989

Informację o projekcie

18 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
I have read your project description and am ready to start immediately. Long experience in Web design and development with (X)HTML, CSS, PHP, JS/JQuery, MySQL, Joomla, Wordpress. I believe the error is in " t1.* AS ID" as you can't assign all columns to an alias (the .* means all columns in table). If you have access to the code you can probably fix this yourself if you change that part to "t1.field_id". If you want me to fix it I will need FTP access to your site as well as MySQL access Hope this helped.
£20 GBP w 1 dzień
5,0 (14 opinii)
0,0
0,0
18 freelancerzy składają oferty o średniej wysokości £84 GBP dla tej pracy
Awatar Użytkownika
I am the best coder in SQL PHP, I have checked your project. I can provide same functions. You will be satisfied. I am working in Wipro company as software engineer.
£77 GBP w 3 dni
5,0 (42 opinii)
0,0
0,0
Awatar Użytkownika
Hello Kindly send me server details so I and check issues and fix it. I have 6+ years experience on php and mysql. Regards\ Neha
£88 GBP w 1 dzień
4,9 (42 opinii)
0,0
0,0
Awatar Użytkownika
Hi, I am interested to solve these mysql errors, Thanks................................................................................
£50 GBP w 3 dni
4,8 (63 opinii)
0,0
0,0
Awatar Użytkownika
Hi I am highly interested to do this project. I will make you happy.I don’t need any upfront or milestone payment. Pay me when you will happy. Looking forward. Thanks
£50 GBP w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
First of all consider making use of doctrine or an analogues entity manager, you should never actually have queries inside your code without an abstraction on top of it. As far as your issue goes I could fix the website however you could encounter the same problem once you migrate hosts again.
£150 GBP w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi, This seems to be a mysql error. I can fix this. I can ensure there won't be any error in the code and your site will run as it should be, Please let me know if you are interested. I can start working right now and can fix it within few hours. Thanks
£150 GBP w 3 dni
5,0 (51 opinii)
0,0
0,0
Awatar Użytkownika
Hello I am PHP programmer. I have 5 years experience. I can fix it in 2-days. Budget: $50 Pls contact me via by inbox or skype: duongga Regards
£50 GBP w 2 dni
5,0 (2 opinii)
0,0
0,0
Awatar Użytkownika
Hello sir , Waiting for your positive response, so we can start the work soon ... Thank you ...
£40 GBP w 1 dzień
5,0 (189 opinii)
0,0
0,0
Awatar Użytkownika
Hi Please replace following : 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='5' ORDER BY field_sort with SELECT t2.field_label AS FLABEL, t1.field_id 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='5' ORDER BY field_sort and it will work. I can fix any other issues as well.
£111 GBP w 1 dzień
4,8 (158 opinii)
0,0
0,0
Awatar Użytkownika
Hello, my name is Martin Nowosad. I am from Germany. I graduaded in Computer Science and I have several years of Programming Experience on my back. I specialize in Java (+ Android), MySQL and Python. I would like to help you out with your project, I am sure I can do this fast and good. Best regards, Martin
£44 GBP w 3 dni
5,0 (1 opinia)
0,0
0,0
Awatar Użytkownika
Hello, I’d like to be considered for your project. I am a senior developer with over 20 years of experience in software development, using mainly open source technologies (PHP, Zend Framework, CodeIgniter, Apache, Linux) and MySQL databases. I have a significant experience with many other related technologies and concepts such as HTML5, CSS3, XML/XSL, JavaScript(jQuery, ExtJS, Kendo UI, YUI), Wordpress, Google APIs, Dropbox API, AJAX, MVC/OOP, Payment gateways and more. Over the years I have been working on a diverse range of projects for some large software companies covering industries such as tourism, energetics, car leasing, recruitment and training. You will find a detailed information of the key projects I have been working on as well as a complete list of my skill set in my Portfolio section. Why would you choose me over someone else? I have extensive skills and experience with a wide range of projects (intranets, websites, business systems and web applications). Compared to most of the other developers at Freelancer, my 5.0/5.0 rating, 100% completion rate, 100% on-time completion and 40% repeat hire rate are rather indicative of the quality of my work. I highly value professionalism and would love to form a long-term working relationship. I am more than confident that thanks to my experience and skills I can achieve the results that you are looking for. I would be happy to get in touch with you to discuss your project specific needs. Best regards, K Anagnostos
£150 GBP w 3 dni
5,0 (40 opinii)
0,0
0,0

O kliencie

Flaga UNITED KINGDOM
Swadlincote, United Kingdom
4,9
21
Zweryfikowana metoda płatności
Członek od paź 20, 2007

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.