PDA

View Full Version : View Private Message Statistics


nuno
Sat 14th Jun '03, 8:18pm
../admincp/user.php?do=pmfolderstats&userid=5466&s=


<body onload="">
<html><head><title>Forums Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error">&nbsp;</p><p class="error"><b>There seems to have been a slight problem with the Forums database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:john@doe">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p><form><textarea class="error" rows="15" cols="100" wrap="off">Database error in vBulletin 3.0.0 Beta 3:

Invalid SQL:
SELECT COUNT(*) AS messages, folderid
FROM pm
WHERE userid =
GROUP BY folderid

mysql error: 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 'GROUP BY folderid' at line 4

mysql error number: 1064


Script: ../admincp/user.php?do=pmfolderstats&amp;userid=5466&amp;s=
Referer:
Username: xxxxxxx
IP Address: xxx.xxx.xxx.xxx
</textarea></form></blockquote>

</body>

Freddie Bingham
Sat 14th Jun '03, 8:27pm
How did you get there? It obviously worked before since you posted the phrase error about $user[userid]

nuno
Sat 14th Jun '03, 8:46pm
userid=5466 was a dummy user account and deleted from the database, hence the db error message.

Freddie Bingham
Sat 14th Jun '03, 9:43pm
userid=5466 was a dummy user account and deleted from the database, hence the db error message.Ah, I've put a check in for userid now.