Error message when moving forum to other main forum

[sandrose]

This the error message:


Error Invalid SQL: DELETE cl3 FROM closure AS cl INNER JOIN closure AS cl2 ON cl2.parent = cl.child AND cl2.depth > 0 INNER JOIN closure AS cl3 ON cl3.child = cl2.child AND cl3.parent = cl.parent WHERE cl.child IN (28) AND cl.depth > 0 /**deleteMovedNodeClosureRecords**/;

When I tried to move a forum to other forum.

Can you help?

[saiff]

same error

Error Invalid SQL: DELETE cl3 FROM closure AS cl INNER JOIN closure AS cl2 ON cl2.parent = cl.child AND cl2.depth > 0 INNER JOIN closure AS cl3 ON cl3.child = cl2.child AND cl3.parent = cl.parent WHERE cl.child IN (232) AND cl.depth > 0 /**deleteMovedNodeClosureRecords**/;

[sandrose]

Is there a solution for this problem.

Error Invalid SQL: DELETE cl3 FROM closure AS cl INNER JOIN closure AS cl2 ON cl2.parent = cl.child AND cl2.depth > 0 INNER JOIN closure AS cl3 ON cl3.child = cl2.child AND cl3.parent = cl.parent WHERE cl.child IN (79) AND cl.depth > 0 /**deleteMovedNodeClosureRecords**/;

[Mark.B]

So is this when moving a forum from one category to another?

[Wayne Luke]

Is there a solution for this problem.

Error Invalid SQL: DELETE cl3 FROM closure AS cl INNER JOIN closure AS cl2 ON cl2.parent = cl.child AND cl2.depth > 0 INNER JOIN closure AS cl3 ON cl3.child = cl2.child AND cl3.parent = cl.parent WHERE cl.child IN (79) AND cl.depth > 0 /**deleteMovedNodeClosureRecords**/;

This query shouldn't be invalid. What version of MySQL are you using? The minimum supported version is currently MySQL 5.5.0. If you're using MariaDB, it is recommended that you use 10+.

[sandrose]

I use MySQL 5.6 .
Which is better MariaDB or MySQL?

[Wayne Luke]

As far as running queries, MySQL 5.6 and MariaDB 10+ are pretty much equivalent. People tend to choose one or the other based on political and commercial interests, not performance.

What does your hosting company say about the query? If they run it, can they get more information about the error?