MySQL issue with stats.php

[klaush]

Hi Chuck, let´s do this in a new thread, if you like.

We have this error with the stats with 2.51/vb 3.8.6 -latest release


Datenbankfehler in vBulletin 3.8.6:

Invalid SQL:

SELECT user.userid, user.usergroupid, user.username, ppgal_user.ppicount
FROM vb3_user AS user
LEFT JOIN vb3_ppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid)
WHERE ppicount > 0
ORDER BY ppicount DESC
LIMIT 10;

MySQL-Fehler : Column 'ppicount' in where clause is ambiguous
Fehler-Nr. : 1052
Fehler-Zeit : Monday, 13.12.2010 @ 17:06:57
Datum : Monday, 13.12.2010 @ 17:06:57
Skript : http://xxxxxxxgallery/stats.php

What can cause tgis error? It also apperas when deactivating all plugs!

Thanks!

Klaus

[Chuck S]

In stats.php the query I show should be this

Content visible to verified customers only.

[klaush]

Year, and that did the trick!

Thanks a lot as always!

Greetings

Klaus

Originally Posted by Chuck S

In stats.php the query I show should be this

Content visible to verified customers only.

[Chuck S]

Yeah it was already fixed in vbgallery 3.0