1 perpost 1
2 perpost_own 1
3 perthread 1
4 perthreadrating 1
5 perthreadratingreceived 1
6 pertag 0
7 pervmgiven 1
8 pervmreceived 1
9 perpollposted 1
10 perpollvote 1
11 perfriend 1
12 pergivenrep 1
13 pergottenrep 1
14 perinfractiongiven 1
15 perinfractionreceived 1
16 perreferral 1
17 persgmessage 1
18 persgdiscussion 1
19 percalendarevent 1
20 perdayregistered 1
21 totalpoints 1
22 activitylevel 1
23 albumpictures 0
24 attachments 0
25 attachmentviews 0
26 post 1
27 post_own 0
28 thread 1
29 threadrating 1
30 threadratingreceived 1
31 vmgiven 1
32 vmreceived 1
33 pollposted 1
34 pollvote 1
35 friend 1
36 givenrep 1
37 gottenrep 1
38 infractiongiven 1
39 infractionreceived 1
40 referral 1
41 sgmessage 1
42 sgdiscussion 1
43 calendarevent 1
44 dayregistered 1

^^ Results. Didn't solve the issue though.

I know it wouldn't, I'm just trying to figure out wtf is going on here :p

You're not missing any data, so it's just that the cache isn't rebuilding.
Try this plugin, refresh the main page, and tell me if you still have the error


Fillip

No, that didn't fix anything - just gave me a database error across the board. :p

It happens on two different forums that I've tried it on - on two different servers just an FYI.

What database error? Can you post the message?

Fillip

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT dbtech_vbactivity_medal.* FROM `dbtech_vbactivity_medal` AS dbtech_vbactivity_medal LEFT JOIN dbtech_vbactivity_category AS category ON (category.categoryid = dbtech_vbactivity_medal.categoryid)
ORDER BY category.displayorder, dbtech_vbactivity_medal.displayorder ASC;

MySQL Error : Table 'username_mysql.dbtech_vbactivity_medal' doesn't exist
Error Number : 1146
Request Date : Thursday, March 4th 2010 @ 08:03:23 PM
Error Date : Thursday, March 4th 2010 @ 08:03:23 PM
Script : [path]/forum.php
Referrer :
IP Address : 24.47.17.186
Username : ---------
Classname : vB_Database

Fillip,

Just an FYI - I've reviewed my slow_query_log and there's nothing in there from your modification at all. I believe the change you made fixed the issue.

Whoops, I'll attach a fixed plugin to this post and then we'll see what happens :)

Awesome, glad to hear it :D


Fillip

can this be combined with post thank you hack ... ?

Not a feature so far, but if our customers request hack integration then we will work to apply it in a future version =)

Iain

It would be a nice addition to the hack...

Does this mod have a way of installing some basic data? A working guideline, so to speak, of an ideal setup?

I'm working my way through installing on a test site, and would have liked a basic data setup...