single quote | ww.wp.xz.cn

Resolved wpshushu
(@wpshushu)

2 years, 11 months ago

In the query builder, a query like

update wp_options set autoload=’yes’ (single quotes) where ….

will trigger a SQL syntax error. But

update wp_options set autoload=”yes” (double quotes) where ….

executes fine.

Is this an issue with the plugin or my mysql settings? I am using MariaDB 1:10.6.14+maria~ubu2204

Thanks

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Contributor Kim L
(@kimmyx)

2 years, 11 months ago

Hi @wpshushu,

Make sure your single quote is not slanted (’yes’) when using it in a query.

They should be straight like this: ‘yes’

Let us know if that works! 😊

Thread Starter wpshushu
(@wpshushu)

2 years, 11 months ago

@kimmyx They were straight: https://www.screencast.com/t/DuW2kOCHEkR

Plugin Contributor Kim L
(@kimmyx)

2 years, 11 months ago

Hi @wpshushu,

Thanks for the video! Do you have the latest version of WP Data Access installed?

We tried the query on our test site and it was executed without issues.

See our test here: https://share.getcloudapp.com/bLuZ0QRo

Thread Starter wpshushu
(@wpshushu)

2 years, 11 months ago

@kimmyx Using 5.3.9. Should be lates.

Plugin Contributor Kim L
(@kimmyx)

2 years, 11 months ago

Hi @wpshushu,

Could you try updating to the latest 5.3.10? That should sort out the single quote issue.

Let us know how it goes. 🙂

Thread Starter wpshushu
(@wpshushu)

2 years, 11 months ago

@kimmyx That took care of it. Ty.

Leeberty
(@aaronvincentlee)

2 years, 11 months ago

Hi @wpshushu ,

I’m glad that Kim was able to help you out with this.

Feel free to reach out when you encounter issues again. We’d be glad to help.

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘single quote’ is closed to new replies.

8 replies
3 participants
Last reply from: Leeberty
Last activity: 2 years, 11 months ago
Status: resolved