UserCP Sent Messages BB SQL Error (RESOLVED)

[Jimothy]

When clicking 'sent messages' in the user message centre thingamy, I get this screen:
<SNIP IMAGE NOW RESOLVED>
I have been seeing this for as long as I can remember, and if memory serves, started just after the forum change, which I admit has been a while, but I've been absent and it's not a feature I use very often anyways.
However, I have done the usual restart, cache clearing, log in/out... blah.
But this time, I'm finally getting round to asking: How does I fix?

---

I was formerly know as Spiritar.

It's been a while.

[Vigilia.Procuratio]

This isn't a client bug, but appears to relate to a conversion from a previous installation over to MyBB, and is therefore a server issue. It looks as if the guest account is the target, which doesn't exist in the context of the message centre.

I don't know, but this link may be useful...

http://community.mybb.com/post-408031.html

On a side-note, these error messages should be logged but not displayed to the client as they could potentially disclose sensitive data.

[Jimothy]

So, nothing to do personally, well, at least I didn't break it.

On a side-note, these error messages should be logged but not displayed to the client as they could potentially disclose sensitive data.

So, I shouldn't see it, or I shouldn't be showing it to the wordl?

---

I was formerly know as Spiritar.

It's been a while.

[Error]

This thread pops up rather frequently, and luckily it is also rather easy to fix if you're getting the exact same MyBB/MySQL error message as Trogdor.

Have a look at this thread, and particularily my last post in it.

EDIT:
What you need to do is:
1. Download your old messages, if you want to keep them
2. Empty all of your PM folders.

That'll fix it.

Sorry for just copying and pasting my old post, but a quick search would have answered this. As I said in my post from October; this question pops up rather frequently, and is related to our transition from IPB to MyBB in late 2012. Just follow the instructions above to fix it.

---

[Vigilia.Procuratio]

On a side-note, these error messages should be logged but not displayed to the client as they could potentially disclose sensitive data.

So, I shouldn't see it, or I shouldn't be showing it to the wordl?

Both.

Most importantly, it is good practice for a web master to suppress error messages but in this case they are either displayed by default or they have been enabled.

As a precaution, I recommend privately forwarding any database errors to an Administrator. However, given that MyBB is a rather standard and popular forum package, the relevant information would be available by simply downloading the software from the vendor and looking at its code, and it is very unlikely that the data would be sensitive. At least it doesn't look problematic in this case.

On some websites, particularly if of a financial nature, the names of a database, its tables and columns ought not be publicly disclosed because attackers might then know where to look should an SQL injection vulnerability exist.

Further, public disclosure of such errors could even identify a vulnerability.

[Jimothy]

Thanks Error, problem solved.

And as for the vulnerabilities side of things, I'll take the image down just to be on the safe-side.

Thanky

---

I was formerly know as Spiritar.

It's been a while.

[chase.way]

Nice, had the same problem, deleting took care of it.

---

Either way - when you let go, and stop holding on so tightly, life can actually be fun - you can't steer a train, but you can RIDE it!