Server error when merging topics

[southstar86]

Thank you!

[southstar86]

This error also occurs, but only sometimes

An unexpected error was returned: 'Too few arguments to function vB_Library_Node::deleteNodes(), 1 passed in /usr/share/nginx/html/main/public/forums/core/vb/api/node.php...

[southstar86]

It looks like timeout errors

[08-Feb-2021 18:55:51] WARNING: [pool www] child 12408, script '/usr/share/nginx/html/main/public/forums/index.php' (request: "POST /forums/index.php?routestring=ajax/api/node/mergeTopics")

...

[southstar86]

Even with debug mode on, there is no extra info or stack output... likely because this is the result of an AJAX call and not a page load?

...

[southstar86]

Hello,

We are trying to troubleshoot an issue with our forums that causes a 500 error when trying to merge two topics in the same channel. I have traced the execution path of the web request...

[southstar86]

Is there a way in the Issue Tracker to see which issues were fixed in each release?

[southstar86]

Thanks! we are running version 5.6.3, so that makes sense.

[southstar86]

When a guest user clicks the "Latest Activity" tab on the forum, the AJAX call returns a database error. The following query gets generated:

SELECT DISTINCT CASE WHEN starter.nodeid 

...

[southstar86]

Hello,

We've identified another query that seems to be running way slower than it should be.

'deleteMovedNodeClosureRecords' => array(vB_dB_Query::QUERYTYPE_KEY => 

...

[southstar86]

Hello, I know this post is somewhat old now, but I am having a similar issue. I uploaded a style but it does not show in style manager. It looks correct in the DB, and if I manually type in URL param...

[southstar86]

Is there a VB5 equivalent to the older /newreply.php?do=newreply script?

The use case is that we display some comments on another site using the API, and provide an "add comment"...

[southstar86]

This definitely fixed the issue. It now takes about 200ms to delete a topic instead of 1 to 2 minutes. Thanks for your help!

[southstar86]

I'm still checking it out.. I will let you know. Could this type of issue be affecting any other queries? Do the queries in querydefs get cached?

[southstar86]

New EXPLAIN attached...

[southstar86]

That makes it a million times better!

[southstar86]

Thanks for reaching out! This is version 5.7.12

[southstar86]

Hello,

I was trying to track down an issue that was causing delete / undelete of topics to be extremely slow, taking almost 2 minutes sometimes. The slow query log showed the following query,...

[southstar86]

I did NOT change the query. That's why I brought this up. That is the source code in that file.

When looking at these threads with firstpostid of 0 in vb 3.8, they are real threads with no...

[southstar86]

Hello, we noticed after a forum upgrade from version 3, we were missing almost 70K threads. We tracked it down to this particular upgrade step in 500a1.

function step_143()
{ 

...

[southstar86]

Thanks, I was finding multiple rows in the node table that had the same oldid with different content types. I was trying to see how it was handled in core/vb5/route/legacy/node.php but I couldn't quite...