Question vBulletin4 upgrade, installation instructions and missing counts

Status
Not open for further replies.

alfreema

New member
Background
---
Hi, we are attempting to upgrade our existing production site (ShockerNet Wichita State Forum) from vb4 to vb5 on a brand new server. The test site is Forums - ShockerNet Wichita State Forum. It took some deep diving to get the new site up using HTTPS, but we got it working and running smoothly. Next step is to get the plugins from the old site working.

I installed Advanced User Mention (chose the Upgrade option), and it worked great. The old [MENTION] bbCode started rendering properly right away.


Questions
---
1) But the next step was to get Advanced Post Thanks Like working, and here is where my trouble is. I installed it (again I chose "upgrade"). The 4th step in the Installation says: "Configure your Usergroup settings by clicking "Manage Buttons" under "DBTech - Post Thanks" in your AdminCP navigation menu, then editing each button and setting your usergroup permissions from there."

I am guessing those instructions are for older version of vb5.x because I can't find anything in the AdminCP that jives with that. I do however already see the Thanks and Like buttons. Can you clarify what step 5 should be for 5.3.2 users? If that step is correct, where do I find the "DBTech - Post Thanks" in my AdminCP, because I don't see that anywhere except under Manage Products, and when I hit Edit it has nothing to do with "Manage Buttons".

2) The second problem is that all of the counts are zero, and the history seems to be missing. On the Feature List of the plugin it says its upgradeable, so I was expecting (hoping) that that history would not be lost. Is there a way to recover that stuff?

I absolutely am going to pay for the Thanks and Like plugin to support you guys, even though I don't _think_ I need any of the features. If I need that to fix the problem, or if it's better to start with that one instead of Lite, let me know.
 
Hi there,

The instructions are current, you may need to double-check to see that you are set as Super Administrator in config.php. If I remember correctly, the name of the superadmin variable changed from superadministrators to superadmins or something - the default vB5 config file would be able to tell you for certain.

Counters being zero is probably fixable via a rebuild in the Maintenance once you see the menu.

I should advise you that the vB5 version is not in active development and it is strongly not recommended to switch any forum over to vB5 at this time, due to the fact that vB5 is not very modification friendly. If you look at vBulletin.org, you'll see this is a view shared by the vast majority of 3rd party addon developers.

If you still wish to purchase the Pro version, we'd appreciate it :) I felt like I should let you know that the vB5 mods are sold more "as-is" at the moment for the above reasons.
 
The instructions are current, you may need to double-check to see that you are set as Super Administrator in config.php. If I remember correctly, the name of the superadmin variable changed from superadministrators to superadmins or something - the default vB5 config file would be able to tell you for certain.

Turns out you just need to logout of the AdminCP and then log back in after installing the plugin, then that menu option magically appears. You might want to mention that in the installation instructions after running the product_dbtechthanks.xml (if you can recreate that).

Counters being zero is probably fixable via a rebuild in the Maintenance once you see the menu.

With the menu working I was able to try Rebuild Statistics. No luck. I even tried Clean Up and Recalculate Statistics for fun.

Just to be sure we are talking about the same thing, I am talking about a post that was created in vb4 that is now rendering in vb5 after an upgrade. At the bottom of the post are the Thanks and Like buttons and they have number next to them (which was not the case in vb4). I don't see any of the users that actually liked or thanked the post, and the counters next to the buttons are zero.

Thoughts on what else I can try? Any tables I should query?

I should advise you that the vB5 version is not in active development and it is strongly not recommended to switch any forum over to vB5 at this time, due to the fact that vB5 is not very modification friendly. If you look at vBulletin.org, you'll see this is a view shared by the vast majority of 3rd party addon developers.

If you still wish to purchase the Pro version, we'd appreciate it :) I felt like I should let you know that the vB5 mods are sold more "as-is" at the moment for the above reasons.

I have been warned! :) Honestly everything is working great for us in vb5, except this one plugin not seeing the old Thanks and Likes. Once that's working we are good to go!

I appreciate and do understand that the vb5 mods are "as-is". I feel like I should donate because our old site enjoyed the benefit of the plugin and we hope to use it going forward. It just makes sense to support your effort.
 
Last edited:
Just to be sure we are talking about the same thing, I am talking about a post that was created in vb4 that is now rendering in vb5 after an upgrade. At the bottom of the post are the Thanks and Like buttons and they have number next to them (which was not the case in vb4). I don't see any of the users that actually liked or thanked the post, and the counters next to the buttons are zero.

Thoughts on what else I can try? Any tables I should query?
This is the DB query that's being ran:

Code:
SELECT user.*
FROM {TABLE_PREFIX}dbtech_thanks_entry AS entry
INNER JOIN {TABLE_PREFIX}user AS user ON (user.userid = entry.userid)
WHERE entry.contentid = {nodeid}
	AND entry.varname = {varname}
ORDER BY entry.entryid DESC

I'd double-check to make sure that the post IDs are the same as they were in vB4, and that the varname of the buttons haven't changed. Note that the varname is case sensitive, so if you did remove the original buttons in vB4 and replace them with your own, that may be the problem.
 
I'd double-check to make sure that the post IDs are the same as they were in vB4, and that the varname of the buttons haven't changed.

So I did a select distinct varname and they were exactly the same, so the problem wasn't there. So when I looked at a post that should have lots of thanks and likes on the new system, it shows a postid of 23955. But on the old system it was 741423. Nooooooo!!! :)

At some point the vb4 to vb5 upgrade has caused my postids to change. I see there is an "oldid" in the new node table. I am thinking I need to update the dbtech_thanks_entry.contentid with the nodeid, where it currently is mapping to node.oldid? Does that make sense?
 
Yeah that would be why. Did you use ImpEx to upgrade, or did you upgrade normally?

In either case, you will need to do that update in order for stats to work, yeah.
 
Hello alfreema,

This ticket has now been closed with the status Answered.

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!
 
Not sure if this is how I continue the thread or just a request to reopen the thread, but I wanted to follow up on how we solved this.

The scenario: We have a vb4 instance that we want to upgrade to vb5 and it uses the DragonByte Thanks/Like plugin.

These are the major steps. There are a few minor steps that also need to happen, but these are the big ones:

1) We shut down the vb4 instance and then export the database
2) Import the database into mysql on the new server
3) Install vb5 on the new server and then go to it's configuration page
4) Run the tools.php to fix some stuff that was broken during the upgrade
5) Get https working by modifying .htaccess
6) Install the DragonByte Thanks and Like Plugin from scratch.
7) Run these statements in the database:

create table dbtech_thanks_entry_bak (select * from dbtech_thanks_entry);


update dbtech_thanks_entry d,
node n
set d.contentid = n.nodeid
where d.contentid = n.oldid;

update dbtech_thanks_entry d,
thread_post p
set d.contentid = p.nodeid
where d.contentid = p.postid;

8) Install our styles, etc ...
 
Hello alfreema,

This ticket has now been closed with the status Answered.

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!
 
Status
Not open for further replies.

Legacy Advanced Post Thanks / Like

vBulletin 5.0.x vBulletin 5.1.x vBulletin 5.2.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
159
Customer rating
0.00 star(s) 0 ratings
Back
Top