Thank you Phalynx. I found 2 achievements named "New Achievement". Deleted them, but no other achievements were showing, although I do have the 100 pts achievement. I had to do recounts for them to show again.
I did encounter a new error. When recounting, the following error came up when trying to update experience points:
Quote:
Database error in vBulletin 4.0.6:
Invalid SQL:
SELECT
COUNT(*) AS count_threads,
SUM(votetotal/votenum) AS count_votes,
SUM(replycount) AS count_replycount,
SUM(views) AS count_views,
SUM(sticky) AS count_stickies
FROM thread
WHERE visible=1 AND forumid NOT IN(Off-Topic,Off Topic)
AND postuserid=1;
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 'Topic)
AND postuserid=1' at line 8
Error Number : 1064
Request Date : Wednesday, August 25th 2010 @ 01:31:52 PM
Error Date : Wednesday, August 25th 2010 @ 01:31:53 PM
Script : http://***/admincp/xperience_admin.p...min_recount_xp
Referrer : http://***/admincp/xperience_admin.php?do=recount
IP Address : ***
Username : Alaera
Classname : vB_Database_MySQLi
MySQL Version : 5.0.91-community
|
Experience points don't seem to be updating. The default parameters to recount experience do not work (Number of users to process per cycle = 150, User ID to start at = 1). But at 150/5 the error doesn't pop up.
Concerning the social groups and album CSS files... I can't find them. Any idea where they are, or what specifically they are called?
[S]EDIT: Fixed my own error. I didn't have an Off Topic forum. If you specify an invalid or non-existing forum in "ignore this forum for points", experience will not be counted anywhere.[/S]
EDIT2: Use forum IDs, not forum names in "ignore these forums".