Fix PHP & MySQL code

$10-30 USD

Færdiggjort

Slået op

cirka 3 år siden

$10-30 USD

Betales ved levering

We've encountered issues with old PHP code and MySQL follwing a a server move - some scripts are no longer working. Previous version of MySQL was 5.1.69; new is 5.7.34. Techs have tried numerous fixes including disabling strict_mode but have not restored functionality . Initially the error was: "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '******.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" After some changes we are now getting: "ERROR 1064 (42000) at line 93: 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 'STATS_PERSISTENT=0' at line 9". I need someone with strong PHP and MySQL understanding and experience to get us back up and running. ***the project is for an adult website - please do not bid if that is an issue Thank you.

PHP

MySQL

SQL

Projekt-ID: 30126602

Om projektet

19 forslag

Projekt på afstand

Aktiv 3 år siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@oliviainfotech

Hi greetings of the day I am a Experienced Full Stack Developer based out in Chennai,India. I can fix ur php and mysql issue. I am Ready to start now. Thanking you, All the very best, Cheers!!! Saurav

$30 USD på 1 dag

4,9

(109 anmeldelser)

5,9

19 freelancere byder i gennemsnit $40 USD på dette job

@dnplugins

Please provide more information about the code, more specifically the query. It seems the the problem you are encountering is an issue on the query itself. I have been a website developer for more than 7 years, working for a private company making and maintaining administrative website and developer tools. I work with websites built with PHP, MySQL, Javascript, Wordpress, Laravel and more. Please feel free to send me a message so we can discuss further details. Thanks.

$50 USD på 2 dage

5,0

(106 anmeldelser)

6,3

@TechnicalKnight

I am php and sql expert. I have strong understanding of mysql. I can fix the error for you. I dont have issue working on adult website. Please send me details over chat.

$30 USD på 1 dag

4,9

(110 anmeldelser)

5,9

@ankur625

The errors you mentioned here are not about PHP but MySQL. Looks like you've upgraded to MySQL 8+ version. The MySQL 8 has some default settings which cause some SQL queries not to work properly. I can help you update your MySQL queries as well PHP codes so that it supports the latest PHP (7.3+) & MySQL (8+) version.

$150 USD på 7 dage

5,0

(62 anmeldelser)

5,5

@kchoudhary95

Hello, I am an Expert in software. Because of this, I feel confident to deliver this project. I have 7+ years experience. Kindly let us discuss details in the chat. Cheers.

$30 USD på 1 dag

5,0

(44 anmeldelser)

4,7

@yalinvyacheslav

✤✤✤ FullStack Web Developer 7 years Exp ✤✤✤ I have read your requirement in detail. I can do this task and will start working on it right now! I have excellent knowledge on web technologies PHP,JAVA,Javascript,Laravel, WordPress, Shopify, HTML, CSS,Angular, MySQL, APIS based on 7+ years' rich experiences.I understood your requirements & I can complete the work as per your requirements. Lets discuss about the project in more details Wating for your reply... Thank you and regard.

$30 USD på 7 dage

5,0

(4 anmeldelser)

4,1

@towojuads

I will fix all issues in your adult website script, am available to get the task done right away, kindly chat me up sir.

$50 USD på 1 dag

4,8

(14 anmeldelser)

4,0

@edwarddzi8f

I will help you with new server configurations, most of the time the issue is PHP extensions or version. Hi, I am a senior PHP (Laravel, VueJs) developer and software architect with 10+ years experience in software development. I focus on developing large and scalable websites and services building long-term relationships with my clients. Working with me you’ll get more than just a web developer. You also get a technical expert and consultant for the most appropriate and efficient solutions your project needs. I am the best match for your job when: ✓ You want to build something with Laravel, Vuejs frameworks. Does not matter if it is a new application or an existing one. ✓ You need one freelancer for your project. Or you think that you’ll need more experts in the future. ✓ You need full-time commitment of at least 25 hours per week. ✓ You have a project with complex business logic and a high load or going to build it.

$40 USD på 3 dage

5,0

(10 anmeldelser)

3,5

@volodmart

Hello Dear. I read your job description carefully. What you require is basic in MySQL. I am a PHP expert. It is piece of cake for me. I have a lot of experience in this field. Please contact me and let's discuss more detail. Thank & Regard. Volodymyr M

$20 USD på 1 dag

5,0

(9 anmeldelser)

3,7

@technicalfoodie

Dear Sir, I can do the work in 1 day but it may vary depends upon the changes it requires. Let me very clear mysql upgrade shouldn't affect the script as mysql support previous version but it should be with php version. So better I can answer after checking url and code Hope for your reply next. I have 10 years of php experience. Regards, J. singh

$111 USD på 1 dag

5,0

(4 anmeldelser)

3,7

@VaLer0chka

Hello Sir, I read the description of your project. I am an experienced php programmer. And I can work full time for you because I don't have any projects now. So, if you give me this project, I will work well and maintain the best communication. I look forward to hearing from you.

$30 USD på 1 dag

5,0

(2 anmeldelser)

2,2

@gausstoday

Hi Dear. It's my pleasure to put my bid in your project. I read your requirement very carefully. I hope to discuss with you in more detail by chatting. I have rich experiences in web development by using PHP/Laravel/Angular/React/NodeJs/VueJs and etc for 5+ years. And I have high skills in WebsiteDesign, CSS, HTML, BootStrap, JavaScript/Jquery, DBconnection. I hope that I work with you. If you hire me, I will do my best to complete your project. So, you can get the very good project. I hope your kind reply. Best Regards. Gauss T.

$20 USD på 2 dage