Status
Not open for further replies.

spurs

Customer
Hello,

First of all, I want to say that I've very impressed with the operation you guys have going here. Great products and everything seems to be run in a professional manner. Compared to the typical service you get with a lot of vB mods, this is a breath of fresh air.

Anyways, I'm working on an upgrade from 3.8 to 4.2 and I want to include a handful of your products -- including this one. However, I have a few questions first.

1. When trying to install this product, I get stuck on the product import step. After re-attempting it a number of times, this is as far as I can get:

Code:
Updating Version Number To: 1.0.0

    Altered Table: administrator
    Altered Table: forum
    Altered Table: post
    Altered Table: thread
    Altered Table: user
    Altered Table: usergroup
    Created Table: dbtech_thanks_entry

Updating Version Number To: 1.0.1

Updating Version Number To: 1.1.0

    Altered Table: dbtech_thanks_entry
    Altered Table: forum

At this point, it appears to try to do the next step but eventually quits. Is there anything I can do to aid in importing?



2. My message board is highly active (1000-2000 concurrent users typically) and has ~6 million posts. I saw in another thread in this support forum that it was mentioned that this product might not be suitable for forums with large post tables. Given my specs, should I skip this product or do you recommend giving it a try?


3. If I purchase this product (with installation, if it comes down to that) and then I find out that it slows down the message board too much, can I get some sort of refund or credit to use on another product? I'll need the Pro version before I go live but I won't really know how the product affects the board until then ... so I'm in a difficult spot here.


Thanks in advance for any help and keep up the good work.
 
Well this is not a product issue....
I did have the same problem i contacted vB support they responded me with some steps like to disable/enable each product one by one to see which one is doing this?
But i can't find one exactly.

Now i created my own solution :) you can try this...

1. Upload all the files for the product you want to import.
2. just before the import from AdminCP open config.php and this right after <?php (as desctibled below) to disable all plugins temporarily for install.
PHP:
 <?php
define('DISABLE_HOOKS', true);
3. import the plugin. It ll be successful :)
4. Remove the above line from config.php or just disable that line as below
PHP:
 <?php
//define('DISABLE_HOOKS', true);
5. Check in adminCP you ll see the settings set for newly imported product and for old ones ofcourse :)

Hope this ll help :)
 
Hello,

First of all, I want to say that I've very impressed with the operation you guys have going here. Great products and everything seems to be run in a professional manner. Compared to the typical service you get with a lot of vB mods, this is a breath of fresh air.

Anyways, I'm working on an upgrade from 3.8 to 4.2 and I want to include a handful of your products -- including this one. However, I have a few questions first.

1. When trying to install this product, I get stuck on the product import step. After re-attempting it a number of times, this is as far as I can get:

Code:
Updating Version Number To: 1.0.0

    Altered Table: administrator
    Altered Table: forum
    Altered Table: post
    Altered Table: thread
    Altered Table: user
    Altered Table: usergroup
    Created Table: dbtech_thanks_entry

Updating Version Number To: 1.0.1

Updating Version Number To: 1.1.0

    Altered Table: dbtech_thanks_entry
    Altered Table: forum

At this point, it appears to try to do the next step but eventually quits. Is there anything I can do to aid in importing?

2. My message board is highly active (1000-2000 concurrent users typically) and has ~6 million posts. I saw in another thread in this support forum that it was mentioned that this product might not be suitable for forums with large post tables. Given my specs, should I skip this product or do you recommend giving it a try?
That is indeed the post table altering that's failing.

What you can do is manually run the following queries:
Code:
ALTER TABLE post ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE post ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE post ADD dbtech_thanks_requiredbuttons_attach INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE thread ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'
Code:
ALTER TABLE thread ADD dbtech_thanks_requiredbuttons_attach INT(10) UNSIGNED NOT NULL DEFAULT '0'

If you run them via the MySQL command line, they won't fail. You could try phpMyAdmin, but that has the potential to fail as well.

Once they're ran, the installer will see that these columns already exist and you shouldn't have any more troubles unless you decide to uninstall the mod, in which case you need to manually uninstall these columns by running
Code:
ALTER TABLE post DROP dbtech_thanks_disabledbuttons
Code:
ALTER TABLE post DROP dbtech_thanks_requiredbuttons_content
Code:
ALTER TABLE post DROP dbtech_thanks_requiredbuttons_attach
Code:
ALTER TABLE thread DROP dbtech_thanks_disabledbuttons
Code:
ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_content
Code:
ALTER TABLE thread DROP dbtech_thanks_requiredbuttons_attach


3. If I purchase this product (with installation, if it comes down to that) and then I find out that it slows down the message board too much, can I get some sort of refund or credit to use on another product? I'll need the Pro version before I go live but I won't really know how the product affects the board until then ... so I'm in a difficult spot here.
That's a difficult spot for us too, we'd very much prefer you being able to test the Lite version first.

Is there no way you can run a trial period for a week or two?
 
Alright, got it working. Thanks for the prompt help.

I'll consider running the Lite version first on a trial basis but since I'm a perfectionist, I'll probably end up buying the Pro version so I can do complete customizations before going live. In fact (despite the dislike from Cosmic on my complimentary post :) ), I'll probably buy the Pro versions of this, AJAX threads, User Tagging and the Arcade prior to making the switch to live.

Thanks again.
 
Hi there,

I am having a similar issue, i found this post via the search button :)

And thought I would post my issues here as it's kinda the same ball park.

Basically the installer dies everytime, so I do the above SQL entries (I think you should let people know if they have a prefix they will need to enter it)

I can get it to install using the mysql entries above then setting the product to overwrite... it will install it.

However if I try view a post all I get is the following error:

Snippet Error
Code:
Not unique table/alias: 'dbtech_thanks_statistics'

Full error report
Code:
Database error in vBulletin 4.2.0:

Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			spamlog.postid AS spamlog_postid,
			deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
			
			,blog_user.entries, dbtech_thanks_statistics.*, post.userid, dbtech_thanks_statistics.*, post.userid
		FROM theforumprefix__post AS post
		LEFT JOIN theforumprefix__user AS user ON(user.userid = post.userid)
		LEFT JOIN theforumprefix__userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN theforumprefix__usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN theforumprefix__icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN theforumprefix__avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN theforumprefix__customavatar AS customavatar ON(customavatar.userid = user.userid)
		LEFT JOIN theforumprefix__spamlog AS spamlog ON(spamlog.postid = post.postid)
			LEFT JOIN theforumprefix__deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN theforumprefix__editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN theforumprefix__postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 66 AND postparsed.languageid = 1)
		LEFT JOIN theforumprefix__sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 66 AND sigparsed.languageid = 1)
		LEFT JOIN theforumprefix__sigpic AS sigpic ON(sigpic.userid = post.userid)
		
			LEFT JOIN theforumprefix__blog_user AS blog_user ON (blog_user.bloguserid = post.userid) LEFT JOIN theforumprefix__dbtech_thanks_statistics AS dbtech_thanks_statistics ON(dbtech_thanks_statistics.userid = post.userid)  LEFT JOIN theforumprefix__dbtech_thanks_statistics AS dbtech_thanks_statistics ON(dbtech_thanks_statistics.userid = post.userid) 
		WHERE post.postid IN (02176369,2176372,2176373,2176375,2176385,2176388,2176390,2176439,2176476)
		ORDER BY post.dateline;

MySQL Error   : Not unique table/alias: 'dbtech_thanks_statistics'
Error Number  : 1066
Request Date  : Tuesday, December 25th 2012 @ 06:36:22 AM
Error Date    : Tuesday, December 25th 2012 @ 06:36:23 AM
Script        : http://www.digitalworldz.co.uk/showthread.php?t=295288
Referrer      : http://www.digitalworldz.co.uk/general-chat.html
IP Address    : 91.228.1.141
Username      : Mick
Classname     : vB_Database
MySQL Version : 5.2.12-MariaDB-mariadb115
 
Are you also using vBShop? vBShop has some duplicated code from APTL, but it's inert, so I have no idea how you managed to get that error. It's never been reported before at all.
 
In that case, can you please try disabling all other products other than APTL and re-enable them one by one?
I bet another product is re-doing the "showthread_query" plugin.
 
Just turned off all hacks, and it's still not working?

Dont worry about helping now enjoy your holidays!, merry xmas.

We can sort this out later, no rush.

Mick
 
Can you please open your showthread.php file and ensure the previously mentioned hook only appears once?
 
I have this issue. How did one fix it?

I get this error:

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

		SELECT
			post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
			user.*, userfield.*, usertextfield.*,
			icon.title as icontitle, icon.iconpath,
			avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
			spamlog.postid AS spamlog_postid,
			deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			
			editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
			editlog.reason AS edit_reason, editlog.hashistory,
			postparsed.pagetext_html, postparsed.hasimages,
			sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
			sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
			IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
			
			, dbtech_thanks_statistics.*, post.userid, dbtech_thanks_statistics.*, post.userid
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 54 AND postparsed.languageid = 1)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 54 AND sigparsed.languageid = 1)
		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
		
			 LEFT JOIN dbtech_thanks_statistics AS dbtech_thanks_statistics ON(dbtech_thanks_statistics.userid = post.userid)  LEFT JOIN dbtech_thanks_statistics AS dbtech_thanks_statistics ON(dbtech_thanks_statistics.userid = post.userid) 
		WHERE post.postid IN (0738202,738204,738206,738207,738209,738210)
		ORDER BY post.dateline;

MySQL Error   : Not unique table/alias: 'dbtech_thanks_statistics'
Error Number  : 1066
Request Date  : Friday, March 21st 2014 @ 02:16:15 PM
Error Date    : Friday, March 21st 2014 @ 02:16:15 PM

When viewing thread.
 
Last edited by a moderator:
Can you please open your showthread.php file and ensure the showthread_query hook only appears once?
 
Status
Not open for further replies.

Legacy Advanced Post Thanks / Like

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
4,024
Customer rating
5.00 star(s) 1 ratings
Back
Top