Find Jobs
Hire Freelancers

Fix DB Error On SQL Database

$10-11 USD

Closed
Posted almost 6 years ago

$10-11 USD

Paid on delivery
Error Static analysis: 2 errors were found during analysis. Unexpected beginning of statement. (near "phpMyAdmin" at position 0) Unrecognized statement type. (near "SQL" at position 11) SQL query: phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" MySQL said: Documentation #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 'phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1
Project ID: 17137093

About the project

22 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $19 USD for this job
User Avatar
Hi, I have good proficiency in sql. Available to start now. Get in touch to discuss more. Regards, Manish
$10 USD in 0 day
4.9 (103 reviews)
5.9
5.9
User Avatar
Hello, Let me help you in this project. let me know what is the best time to have a detailed conversation regarding your project? waiting for positive response! BR, Salma Noreen
$12 USD in 1 day
4.7 (56 reviews)
5.5
5.5
User Avatar
HI, I have excellent experience in database programming. I have worked on various databases like Oracle, MYSql, Sql. I have worked on various projects like tuning, writing complex queries , or working on full fledged BI / Analytics projects I have worked in Infosys a top IT services company for more than 10 years and now i have started on my own. As part of my infosys tenure i have been working with Microsoft as customer delivering projects in MS technologies. Will be able to leverage this experience to deliver this project successfully. Thanks Regards Vaidy
$15 USD in 1 day
4.8 (14 reviews)
5.3
5.3
User Avatar
!"i can start your work right now" hii there, please share the url of the website where you want to changes? please share the credential of your website so i would check and let you know exact time and budget. Kindly drop a message so we can discuss.
$11 USD in 1 day
5.0 (16 reviews)
4.6
4.6
User Avatar
Hi, I have several years of experience with MySQL, as you can see on my reviews, and would love to help you with this issue. This happens when you try to import the database right? ´ Looking forward to hearing from.you. Best regards, Marco Ramos
$15 USD in 1 day
5.0 (22 reviews)
3.8
3.8
User Avatar
Hello my name is Fares, i can get it done perfectly as you want let's chat when you are online. Thanks
$15 USD in 1 day
5.0 (6 reviews)
3.5
3.5
User Avatar
Hi, The query is wrong. Replace: phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" By: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" Thanks
$15 USD in 0 day
5.0 (1 review)
2.5
2.5
User Avatar
hi; try do delete SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1 and test. you can contact me now. i amavailable. thank you.
$15 USD in 1 day
5.0 (6 reviews)
2.2
2.2
User Avatar
hi I can help you to fix this issue in SQL. thanks Amit S.
$35 USD in 3 days
5.0 (2 reviews)
1.6
1.6
User Avatar
Hi, I am Nick we have experienced professional for this kind of job
$111 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; happens when different version of mysql is being used. When you are transfering from one server to another you should keep in mind the versions of database use in a new environment especially the mysql. The fix is as follow. simply delete the following lines from your database and you are done SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”; ENGINE=MyISAM DEFAULT CHARSET=latin1; Please let me know if its working. Regard Anisur
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Administrador de base de datos, manejador del lenguaje Sql
$15 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
SQL query: phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" Error #1064. You just need to remove this code : "phpMyAdmin SQL Dump". So, your query will be : SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO" it should work. I will help other errors.
$10 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, The asnswer, sir, is that you have a version of php server that have a bug. This bug reffer to white spaces in sql querys and comments from querys and also from php code behind. So try that and let me know if you succed. If it's work that it's to your latitude to decide if you want to pay me and to give me a review. Good luck, Alex
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am interested in your posting. Please drop me a message so we can further discuss and resolve this issue.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'll give it a try.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm a Database Professional with over 20 years of experience. I'm also a publushed author for Database technologies: https://www.amazon.com/Rodrigo-Ribeiro/e/B00L7WLHSE/ref=dp_byline_cont_ebooks_1
$20 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
21
Payment method verified
Member since Aug 6, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.