Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
Marcel

Yoast SEO and Admin Columns Pro

After updating to Yoast SEO (5.0.2) I get a huge MYSQL error on the products backend.
WordPress-Datenbank-Fehler: [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 '-1' at line 1]
SELECT wp_posts.ID AS id, wp_posts.post_content AS value FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (4936,9516,3043,3045,9447,2907,2929,3028,16299,2806,17779,20190,2188,15070,2177,2179,2181,2172,2082,2083,17786,4388,20340,20345,14182,2114,2116,5160,17925,14441,2191,2190,2068,2069,2904,2171,2174,10342,15558,2772,16262,17637,17386,8075,19242,2920,19774,2176,3753,3752,2994,16121,9483,9259,2932,3021,20325,1795,19500,3471,2272,2305,2308,2554,2562,2636,2669,2670,2687,2631,2632,2557,2633,2635,2700,2730,2600,2737,2773,2774,2634,2307,2398,2287,2309,2267,2268,2269,2270,2271,2273,2397,2276,2279,2281,2282,2283,2284,2285,2286,) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) LIMIT 0, -1

–> I deleted many of the posts ids. Actually there are way more in the list on my backend.

I guess it’s a problem with the new Yoast feature –> counting links. I am not able to inline edit any longer with that problem.
Deactivating Yoast does not work. Deactivating Admin Columns shows the normal columns without any mistakes.

Other possible problems: I activated memcache on my server

Any ideas how to solve the problem?

Many thanks!

4 years, 2 months ago
Marcel

Ok, maybe it’s not a yoast problem but a problem with my specific column. On other columns I don’t see this mistake. But I can’t inline edit every colum…

I get this error as well.

WordPress-Datenbank-Fehler: [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 '-1' at line 7]
SELECT wp_posts.ID AS id, wp_posts.post_content AS value FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) WHERE 1=1 AND wp_posts.ID IN (4936,,2916,2959,2917,19757,14179,2921,2923,10963,2926,2918,3039,2960,2974,3004,3017,20125,3980,3829,3659,20133,20124,3029,20128,3033,3034,20131,3036,3037,3082,2961,3002,3000,2975,2976,2981,8510,8507,2984,5463,2985,8501,2995,2996,2997,7654,7645,8504,1794) AND ( wp_term_relationships.term_taxonomy_id IN (373,1896) AND tt1.term_taxonomy_id IN (373,1896) AND tt2.term_taxonomy_id IN (373,1896) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) GROUP BY wp_posts.ID LIMIT 0, -1

4 years, 2 months ago
Marcel

Sorry for all these messages.

As of now this mistake is solved by resetting the sorting. Not sure why that resolved the mistake (for now).

4 years, 2 months ago
Marcel

New day, new topic.

Everything seems to work fine. I don’t see the MYSQL error, BUT if I do a search on the backend and get only one result, I am not able to inline edit this result. It only works If there are at least two results. What a strange behavior…

This actually does not happen after every search. If I search again, I can edit the poduct normally.

4 years, 2 months ago
Stefan
Developer

Marcel,

Can you send me an email at support@admincolumns.com where you explain all the steps you take so I can try to reproduce the issue? It would be great if we can get access to your environment so we can have a look for ourself.

The SQL error in combination with Yoast is a known issue, but we have to dive into what’s going wrong. I think it’s related to this issue: https://github.com/codepress/admin-columns-issues/issues/844

But your last comment is indeed strange behaviour so we will have to check that.

4 years, 2 months ago

You must be logged in to reply to this topic.