Recent Topics
  1. b2evolution CMS Support Forums
  2. b2evolution Support
  3. General Support
  4. "You have an error in your SQL syntax;"

"You have an error in your SQL syntax;"

1 Feb 22, 2020 12:08    

In the Back-office I go to: System-Regional-Countries, and I get this:

An unexpected error has occurred!
If this error persists, please report it to the administrator.

Go back to home page

Additional information about this error:
MySQL 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 ' ctry_code ASC LIMIT 0, 20' at line 1(Errno=1064)

Your query: Results::run_query()

SELECT ctry_ID, ctry_code, ctry_name, curr_shortcut, curr_code, ctry_enabled, ctry_preferred, ctry_status, ctry_block_count

  FROM evo_regional__country

  LEFT JOIN evo_regional__currency ON ctry_curr_ID=curr_ID

 ORDER BY   , ctry_code ASC

 LIMIT 0, 20

The site is already up since 2 years. I had it at v6.11.2 at first when the error showed up 2 days ago. I upgraded to v6.11.5 but the error persists.
I did not change anything in the database (mariadb) and mariadb is still the same version.
I have another instance of b2evolution on the same server (other domain name), using the same db server and there I do not have this error.

Back to top

2 Feb 22, 2020 12:34

Hi
I'm using 6.11.4 at the moment and don't have your problem using maria.

The other instance, that works ~ what veresion b2evo is that?

Back to top

3 Feb 22, 2020 13:19

The other one is 6.11.2

Where I have the problem now 6.11.5, it appeared only 2 days ago. I had it running for month on 6.11.2 without problems. And I only upgraded today to see if the error goes way, but it doesn't.

Back to top

4 Feb 22, 2020 14:25

The last thing I did in 'Countries' is that I disabled those countries that I do not need. So I left United States, United Kingdom, Germany, Netherlands, Belgium and Luxembourg.
If I go to Regions I still see the Countries and from there I can also edit the Country.

Back to top

5 Feb 22, 2020 15:00

I'll install 6.11.5 this evening (UK) and get back here with an update

Back to top

6 Feb 22, 2020 19:22

Maybe I am not clear enough.
I had v 6.11.2 installed for a long time without any issues. Only 2 days ago it started to give me this error.
Only than did I upgrade to 6.11.5 to see if this would resolve the issue. But it does persist into 6.11.5

My other b2evoltion 6.11.2 on the same server and using the same mariadb does not have this issue.

Back to top

7 Feb 22, 2020 19:29

Maybe a bit clearer with a screenshot:

Back to top

8 Feb 23, 2020 23:31

Strange , (COMMA) after ORDER BY

Low resources at my place. Need to find source of query. Maybe someone knows off hand.
It may be a malformed query not a Maria issue, but then why? :(

Back to top

9 Feb 24, 2020 10:25

Hi Again
I think your posts were clear but I have been a bit a miss.

The screen shit would be better with the url so the page where you see the error can be seen. I tend to ttwck errors form the fiel name.

In my previou post I emention what looks odd, the comma without a preceding parameter. Have you tried re-enabling the Countries you disabled?

Back to top

10 Feb 25, 2020 10:54

I can not enable/disable countries because the list of countries doesn' t show up anymore - see screenshot above -/

Back to top

11 Feb 26, 2020 14:05

It is getting even more strange:
I have another user in de Administrators group and on his account I do not have this error!

It is only for the admin account!

Back to top

12 Feb 26, 2020 18:58

Maybe just make another account, give it admin priveledges and delete the original admin as it may just be a database error.

Ensure you have a working alternative admin account before deleting the original :)

Back to top

13 Feb 28, 2020 17:41

@fplanque
Do you think removing the admin user is a good idea for this problem?
Or do you have any other suggestion?

Back to top

14 Mar 02, 2020 03:56

@fplanque
Thank you for giving a reply.
Yes I did log out and in again.
I wasn't sure how to get the preferred sort order undone at first. But I realized that I still got another admin user that worked.
So I logged in as another admin user and copied the link for sorting the table, pasted that link while logged in as 'admin' user. That brought back the country list. Puhh. No other fancy stuff needed.
Thanks for the hint. All good again!

Back to top

This post has 2 feedbacks awaiting moderation...


Form is loading...