News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Like Posts

Started by vbgamer45, June 29, 2013, 09:29:03 AM

Previous topic - Next topic

Arantor

Ultimate Profile hasn't been updated for 2.1 either though... not surprising it doesn't work, it hasn't been properly updated in years.

Steve

There are an abundance of mods that need to be updated for 2.1.x.
DO NOT pm me for support!

Doug Heffernan

Quote from: SGTC on May 28, 2022, 10:15:10 AMOne example I tried in SMF 2.1.2 is Ultimate Profile. It had a bunch of test fails since I ran it on the aforementioned SMF 2.1.2, but it installed anyways. However, I don't see the Ultimate Profile settings in my profile, so I uninstalled it. The mod Ultimate Profile is not a hooks only mod.

Did you mean this one?

https://custom.simplemachines.org/index.php?mod=1675

That is not compatible at all with Smf 2.1.x.

SGTC

Quote from: Doug Heffernan on May 28, 2022, 05:01:24 PM
Quote from: SGTC on May 28, 2022, 10:15:10 AMOne example I tried in SMF 2.1.2 is Ultimate Profile. It had a bunch of test fails since I ran it on the aforementioned SMF 2.1.2, but it installed anyways. However, I don't see the Ultimate Profile settings in my profile, so I uninstalled it. The mod Ultimate Profile is not a hooks only mod.

Did you mean this one?

https://custom.simplemachines.org/index.php?mod=1675

That is not compatible at all with Smf 2.1.x.


Yeah. That's why I'm staying with 2.0.19.

SGTC

Going back to the main situation I had, I wish there was a way I can use the "Like Posts" mod in 2.0.19
Unknown column 'id_member' in 'pinchbacksforum_like_post'
File: /home/youchewv3/pinchbacks.net/Packages/temp/installer/install.php
Line: 171

vbgamer45

Looks like your upgrade of the likes went partially run this on the forum's database
ALTER TABLE pinchbacksforum_like_post
ADD id_like INT(10) unsigned NOT NULL AUTO_INCREMENT FIRST,
DROP PRIMARY KEY,
ADD PRIMARY KEY(id_like, id_msg, id_member_gave)

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SGTC

#1206
Quote from: vbgamer45 on May 29, 2022, 03:24:59 PMLooks like your upgrade of the likes went partially run this on the forum's database
ALTER TABLE pinchbacksforum_like_post
ADD id_like INT(10) unsigned NOT NULL AUTO_INCREMENT FIRST,
DROP PRIMARY KEY,
ADD PRIMARY KEY(id_like, id_msg, id_member_gave)



I do not know much about coding mods, but is there a solution to try to get this code or mod to work?

Doug Heffernan

Quote from: SGTC on May 29, 2022, 05:34:08 PMI do not know much about coding mods, but is there a solution to try to get this code to work or find a way to let the mod actually work?

The mod works fine. This problem is locally to your forum. When you tried to upgrade the mod, it did not go through completely as per the explanation above. Running the query posted by @vbgamer45 will fix it for you.

shawnb61

Enhancement request: Don't exceed screen width on mobile.  Maybe allow the ability to specify width in %?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

SGTC

Quote from: Doug Heffernan on May 29, 2022, 05:50:11 PM
Quote from: SGTC on May 29, 2022, 05:34:08 PMI do not know much about coding mods, but is there a solution to try to get this code to work or find a way to let the mod actually work?

The mod works fine. This problem is locally to your forum. When you tried to upgrade the mod, it did not go through completely as per the explanation above. Running the query posted by @vbgamer45 will fix it for you.

How do I run the query?

vbgamer45

via phpmyadmin in your control panel or something simliar. If not if you do not care about the old likes you can drop the old like tables from the database and start fresh.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SGTC

Quote from: vbgamer45 on May 30, 2022, 09:06:35 PMvia phpmyadmin in your control panel or something simliar. If not if you do not care about the old likes you can drop the old like tables from the database and start fresh.

I'll let my webmaster know about that. By the way, is there also another solution to get the mod to also work by changing the local database?

vbgamer45

Yes, it would be that SQL query i menentioned in the previous post to run on the database. Then try to install the mod again.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SGTC

Quote from: vbgamer45 on May 31, 2022, 10:15:14 AMYes, it would be that SQL query i menentioned in the previous post to run on the database. Then try to install the mod again.

I see. Since I don't have access to cPanel, how do I put in the query by myself?

vbgamer45

There is not an easy way in that case.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SGTC

The host has put in the query, but it didn't work.

This is the same error. In context, there was a database cleaning a while ago before I asked how to solve the problem with the mod.

Unknown column 'id_member' in 'backup_pinchbacksforum_like_post'
File: /home/youchewv3/pinchbacks.net/Packages/temp/installer/install.php
Line: 171

vbgamer45

Looks more complicated in this case It is best to drop the old like tables and start from scratch.
have the host run these sql commands. This will reset likes.

DROP TABLE backup_pinchbacksforum_like_post;
DROP TABLE backup_pinchbacksforum_like_count;
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Doug Heffernan

Quote from: SGTC on June 01, 2022, 08:59:01 PMI see. Since I don't have access to cPanel, how do I put in the query by myself?

In this case you should check out Adminer. It's a single PHP file.

https://www.adminer.org/

SGTC

Quote from: Doug Heffernan on June 02, 2022, 06:04:55 AM
Quote from: SGTC on June 01, 2022, 08:59:01 PMI see. Since I don't have access to cPanel, how do I put in the query by myself?

In this case you should check out Adminer. It's a single PHP file.

https://www.adminer.org/ [nofollow]

I tried to get this code to work, but all I got back was an error that said " Duplicate column name 'id_like' ":
ALTER TABLE backup_pinchbacksforum_like_post
ADD id_like INT(10) unsigned NOT NULL AUTO_INCREMENT FIRST,
DROP PRIMARY KEY,
ADD PRIMARY KEY(id_like, id_msg, id_member_gave)

How do I fix it?

vbgamer45

Yeah the upgrade script failed for some reason tables are not setup with the right columns. I would drop the old like data if possible.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: