Bug Product Likes System plug-in fails to import

[Robert DiMaggio]

I have the files uploaded but the plug-in starts to imports, gets thru several table modifications, then it just hangs. I have to stop it because the server overloads if I just let it contnue to hang there. I never get an error message.

Also, I upgraded from vBSEO to dbSEO, everything is working fine with that plug-in, I had no problems.

 

[Fillip H.]

Are you importing from vBSEO Likes? If so, how many entries are there in the vbseo_likes table?

 

[Robert DiMaggio]

Are you importing from vBSEO Likes? If so, how many entries are there in the vbseo_likes table?

I just looked thru the vBulletin DB and I do not see any tables vbseo_ or _likes

 

[bzcomputers]

Looks like you uninstalled vbseo before you imported the likes. Do you have a recent backup of the database where you could get the vbseo_likes table from?

 

[Robert DiMaggio]

Looks like you uninstalled vbseo before you imported the likes. Do you have a recent backup of the database where you could get the vbseo_likes table from?

no I do not, but I don't care about past likes, we can start over.

 

[Robert DiMaggio]

but why would that affect importing the plug-in via vBulletin, it would just appear as a new install since those vbseo tables are gone?

 

[bzcomputers]

but why would that affect importing the plug-in via vBulletin, it would just appear as a new install since those vbseo tables are gone?

You are correct. From your original post I (and it appears Fillip H. also) were under the impression the issue you were referring to was occurring when trying to import likes from vbseo, after this product had been installed successfully.

Now I see the issue you're having is from importing the product .xml on install. Fillip H. will probably need to help you diagnose that issue. I know you said there were no errors, does this include no errors listed in the server logs? He'll probably ask you that first.

 

[Fillip H.]

In that case, do you have a very large post table? If so, that's most likely where the script is hanging on.

You can run these queries via SSH or phpMyAdmin (remember to add your table prefix) to make the installer skip them:

ALTER TABLE post ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_attach UNSIGNED NOT NULL DEFAULT '0'

 

[Robert DiMaggio]

In that case, do you have a very large post table? If so, that's most likely where the script is hanging on.

You can run these queries via SSH or phpMyAdmin (remember to add your table prefix) to make the installer skip them:

ALTER TABLE post ADD dbtech_thanks_disabledbuttons INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_content INT(10) UNSIGNED NOT NULL DEFAULT '0'

ALTER TABLE post ADD dbtech_thanks_requiredbuttons_attach UNSIGNED NOT NULL DEFAULT '0'

Yes, we have over 3 million posts.
I tried running that querey in phpMyAdmin and and it just hung there?

I do not understand what you mean by this:
(remember to add your table prefix) to make the installer skip them:

 

[Robert DiMaggio]

Okay, I ran all 3 queries successfully, it was hanging up on the first query because that table already existed.

 

[Robert DiMaggio]

okay, I finally got everything to import including the plugin.

however the only thing the the Like button does is takes you to the top of the forums?

 

[Fillip H.]

Please enable the mod so that I can see this in action.

 

[Robert DiMaggio]

Please enable the mod so that I can see this in action.

will a screenshot work?

 

[Fillip H.]

No, I will need to see this in action.

 

[Robert DiMaggio]

No, I will need to see this in action.

I sent you a PM, can you please respond.
Thanks1