Bug 'Ghost' image in Forum Stats Display

[jhj8864]

When I turn on the 'Forum Stats' option, the display shows 5 items (with a missing icon for the 5th item) - but I only have 4 buttons/options built and turned on.



I have cleared caches, run the maintenance options, rechecked settings - I cannot figure out why this 5th option is showing up?

The only other thing I've noticed is that I can't run one of the 'Maintenance' options in the admin cp menu, the 'Rebuild Statistics' feature. When I try to run it, I get the following database error:

Database error in vBulletin 4.2.5:

Invalid SQL:
UPDATE dbtech_thanks_statistics SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`Like_received` = '1',
`Likes_received` = '3',
`thanks_received` = '1',
`Likes_given` = '1'
WHERE userid = 2;

MySQL Error : Unknown column 'Like_received' in 'field list'
Error Number : 1054
Request Date : Saturday, July 15th 2017 @ 02:58:01 PM
Error Date : Saturday, July 15th 2017 @ 02:58:02 PM
Script : Log in - BGObsession.com - vBulletin Admin Control Panel
Referrer : Log in - BGObsession.com - vBulletin Admin Control Panel
IP Address : 185.93.229.5
Username : Boone
Classname : vB_Database_MySQLi
MySQL Version : 10.0.31-MariaDB
Server : 199.193.247.148
User Agent :

Any help you can provide would be appreciated.

 

[Fillip H.]

If you manually inspect the dbtech_thanks_button table, does the "Like" button show up, or only "Likes"?

 

[jhj8864]

Can you explain what you mean by 'manually inspect the dbtech_thanks_button table'? I'm not sure what you are asking?

 

[Fillip H.]

You need to access phpMyAdmin or another database management tool and review the entries in that database table.

 

[jhj8864]

I can poke around but I'm not sure I would know what I am looking at. I have good skills within vB admin functionality, but my cPanel and server knowledge is limited. This will be the last mod I purchase here brother (and I've purchased a lot) because the support response seems to be 'figure it out yourself'. I understand you have to draw a line and can't personally fix every issue that comes up post-purchase, but this seems to be an issue with the mod itself (imho), not a setup issue or site conflict. This one isn't worth the time to fix. I just won't use that feature.

 

[Fillip H.]

This is not an issue that anyone else has reported before, so I don't see how this can be a bug in the mod itself - something may have gone wrong when deleting the original buttons and replacing them with the other buttons.

If you're not comfortable with accessing your database to check it yourself, on-site support is of course available. Pointing out where the customer can go to debug the issue is always the first step, not the last step.

If you PM me with an FTP and AdminCP account, I can look into this as soon as I can.

I'm not sure I understand how "can you check for me if a ghost entry exists in this database table" translates into "figure it out yourself"?

If you had came back and said "yes, there's an entry in that database table that doesn't show up in the Button Management interface" I could have given instructions for how to delete it and thus restore functionality to your forum.

If you had said "no, there's no extra entry there" I would have also asked for FTP and AdminCP information in order to diagnose the issue further.

It is unfortunately true that it is not feasible for me to immediately request FTP and AdminCP access whenever someone posts any form of support query, for two reasons; a) not all administrators are comfortable giving me this access, and b) there's not enough hours in the day for that.

I'm sorry if asking for the information from you makes you feel like you're not receiving adequate support, it is not my intention to come off as brushing you off. It saves both myself and you time, not to mention security concerns, if the issue can be resolved without having to wait for the creation of FTP/AdminCP details. That is the only reason why I asked you for more information before requesting FTP/AdminCP details.

 

[jhj8864]

It's fine Fillip H.. I've had quite a few issues with the Newsletter, Post Thanks, and Gallery mods all purchased in the past 2 months. I'm sorry to express that publicly - I understand you can't address every site issue with every mod. I'm moving on and sorry for the irritable post.

 

[Fillip H.]

Are you sure you don't want me to look into this issue for you? If you change your mind later, you can always re-open this thread or start a new one

 

[jhj8864]

Sent you a PM Fillip H. and thanks

 

[Fillip H.]

I've no idea what in the world happened with your database or how you managed to create 3 ghost entries (likes, Like and Likes) but I have unified all button clicks under likes (all lower case) and it now appears to work correctly

 

[jhj8864]

I don't know how it occurred either - but I appreciate you taking the time to look at it and resolve it.

 

[DragonByte Technologies]

Hello jhj8864,

This ticket has now been closed with the status Fixed.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!