Problem with wordpress database error: [you have an error in your SQL syntax;

Question

1.00/5 (2 votes)

See more:

My system was working fine, but now i have this problem

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND user_email = ''' at line 1]
SELECT * FROM wp_users WHERE ID = AND user_email = ''

Richard, a member, told me!!

as you can see, you are missing a parameter value after "ID = " in your SQL statement.

But where can i find thids ID?

Hope someone can help!

What I have tried:

I put all my plugins on and off to see if there is a confict, but that did not work

Posted 18-Dec-23 3:43am

Henk1964

Add a Solution

Comments

Richard MacCutchan 18-Dec-23 10:59am

I told you wahat is wrong. Your SQL says:

SELECT * FROM wp_users WHERE ID = AND user_email = ''

But you have not provide the ID value after the equals sign, so the database server has no idea how to find the record you are interested in.

Henk1964 18-Dec-23 11:07am

Hello Richard, thanks for responding. Some build this website for me, years ago. I dont have any contact with him anymore. This system he build is for tuningfile. a customer can upload his original file. That part is working well. In my email i get a message. And his file. In that message there is a upload link, and that is not working anymore. Now you know whaT MY PROBLEM IS. i CANT FIX IT, I AM NOT A EXPERT. hOPE YOU CAN HELP ME> rEGARDS hENK

Richard MacCutchan 18-Dec-23 12:35pm

Sorry, the fix to the SQL is quite straightforward, and if you have not recently changed something in the code, I do not see how that could ever work. I am afraid you will need to find a developer to help you, as they will need to see all the code.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-12-18T04:03:00

Solution 1

Uhh, how would we know? It's your code and you put the ID condition in the WHERE clause for some reason. You are the only person who knows that reason.

Let me guess. You copied and pasted code from the web into your WordPress site without having a single clue what it's doing or why?

Posted 18-Dec-23 4:03am

Dave Kreskowiak