Recent content by jmmp

(y) Those are good queries, Kirby. I can use it. Thank you very much!

Interesting approach, Kirby. Can you translate into words exactly what, for example, the first query is looking for? "List of usernames that have posted...¿?"

Brogan, these queries work to merge john1988 guest to john1988's normal account (I assume john1988 is the same person with two accounts, one normal and one with guest posts): UPDATE xf_post SET user_id = 741, username = 'john1988' WHERE username = 'john1988' AND user_id = 0; UPDATE xf_thread...

It would be a query to find all the users in the database with this id: user_id = 0

Other people had this happen to them after an import, for example: https://xenforo.com/community/threads/user-showing-as-guest.76007/ I know how to merge guest user with another one with the same nick correctly registered. But first I want to know the list of all those guest users and then...

I assure you that there are guest users due to an import. Does anyone know how to find them all with a query? Thanks for the help.

Hi, Brogan. I have a number of such guest users and I would like to know what they are and how many in total so I can assign them to other accounts and manage all their messages. Assigning other accounts I know what is the query to do, but not HOW TO FIND THEM (a list of them), so I ask how to...

What query do I have to run to get a list of all GUEST users? I tried this but it didn't work: SELECT * FROM xf_user WHERE user_id = 0;

@AndyB The image got uploaded as attachment in attachment folder but the image did not get embedded in the forum. Instead the link to image was showing. The attachment however was in the attach tags.

@Race Sim Central Did that work what do you say? I want to do the same as you.

Thank you, ozzy. it was hard to find out, certainly.

Mike said: "If it only happens in a few forums, that could indicate it's down to people watching the forums and thus XF having to do a large amount of mail processing." He suggested a change and I've implemented it and it works: Open /library/XenForo/Model/ForumWatch.php find "function...

Forums and subforums with few threads works, takes between 5 and 10 seconds to redirect after click on the send button new thread. But if the forum or subforum has many threads it takes 15, 20, 25... and if it reaches 30 seconds it stops and does not redirect, although the thread has been...

No, Steve, that's not the cause the problem. My forum has 70 forums and subforums, and the problem is about 10, usually the ones with the most threads, but not necessarily. In several forums the redirection works very justly, at 20-25 seconds. On average it takes 15 seconds for the new thread...

I understand.... I can't update at this time for several reasons. Is there anything I can look at or check? Can be server performance? I need to do something, an idea to try something concrete. Thank you so much for your help.