phpBB Smartfeed

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
User avatar
Pixel8r
Registered User
Posts: 177
Joined: Mon Nov 30, 2009 4:39 pm
Contact:

Re: phpBB Smartfeed

Post by Pixel8r » Fri Feb 26, 2010 9:42 am

As stated in my previous message, I have made the changes manually but am unaware of how to make the SQL database changes.

Please can you tell me how to make SQL changes required manually?
24knews.com - We live on the edge of chaos.

User avatar
MarkDHamill
Registered User
Posts: 3316
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: phpBB Smartfeed

Post by MarkDHamill » Fri Feb 26, 2010 2:55 pm

The SQL changes to go from 2.2.15 to 2.2.16 are in the upgrade instructions. They only apply to MySQL. AutoMod is database independent.

Code: Select all

UPDATE phpbb_config SET config_value = '2.2.16' where config_name = 'sf_version';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sf_max_size', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sf_new_post_notifications_only', 0);
DELETE FROM phpbb_config WHERE config_value = 'sf_smartfeed_title_explain';
Look for similar instructions in upgrade instructions for other versions.
Get the latest versions of my Digests and Smartfeed mods and extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

User avatar
Pixel8r
Registered User
Posts: 177
Joined: Mon Nov 30, 2009 4:39 pm
Contact:

Re: phpBB Smartfeed

Post by Pixel8r » Fri Feb 26, 2010 3:33 pm

MarkDHamill wrote:The SQL changes to go from 2.2.15 to 2.2.16 are in the upgrade instructions. They only apply to MySQL. AutoMod is database independent.

Code: Select all

UPDATE phpbb_config SET config_value = '2.2.16' where config_name = 'sf_version';
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sf_max_size', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sf_new_post_notifications_only', 0);
DELETE FROM phpbb_config WHERE config_value = 'sf_smartfeed_title_explain';
Look for similar instructions in upgrade instructions for other versions.
You are not understanding me.

I have made all other changes, but am unsure as to how to make the changes required to my SQL database. When I initially installed 2.2.15 automod made the changes to the database for me, but I can't get it to work for the upgrade.

Thanks for your help.
24knews.com - We live on the edge of chaos.

User avatar
MarkDHamill
Registered User
Posts: 3316
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: phpBB Smartfeed

Post by MarkDHamill » Fri Feb 26, 2010 3:37 pm

Assuming you have a MySQL database, the web host usually provides an interface program for manipulating the database, typically phpMyAdmin. Go to your web host control panel and look for it. It is usually there. If not you might be able to install it in a directory on your web server.

If using some other database look for a similar program. You will have to translate the SQL for MySQL if needed into any peculiarities needed for your database.

Link to phpMyAdmin: http://www.phpmyadmin.net/
Get the latest versions of my Digests and Smartfeed mods and extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

User avatar
Pixel8r
Registered User
Posts: 177
Joined: Mon Nov 30, 2009 4:39 pm
Contact:

Re: phpBB Smartfeed

Post by Pixel8r » Fri Feb 26, 2010 4:18 pm

I have checked and I am using a MySQL DB and my system has phpMyAdmin installed. :D

I have never used phpMyAdmin before, could I ask you to give me a quick run down on how to make the changes listed above. I have started phpMyAdmin have selected the correct database, do I just copy the code supplied above into the Run SQL query/queries on database box and hit go?

Sorry to be a pain, thanks for your help.
24knews.com - We live on the edge of chaos.

User avatar
IPB_Refugee
Registered User
Posts: 1290
Joined: Fri Jul 07, 2006 2:25 pm
Location: Austria
Name: Wolfgang Weber

Re: phpBB Smartfeed

Post by IPB_Refugee » Fri Feb 26, 2010 5:52 pm

Hello Pixel8r,

you might find this helpful: [Tutorial] How to use phpMyAdmin
Pixel8r wrote:I have started phpMyAdmin have selected the correct database, do I just copy the code supplied above into the Run SQL query/queries on database box and hit go?
Seems to be correct.

Regards
Wolfgang

User avatar
MarkDHamill
Registered User
Posts: 3316
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: phpBB Smartfeed

Post by MarkDHamill » Fri Feb 26, 2010 8:54 pm

Just a warning. A tool like phpMyAdmin is very powerful and you can issue SQL that can easily delete rows, tables and cause major havoc to your database. You might want to back up your database before doing anything.
Get the latest versions of my Digests and Smartfeed mods and extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

User avatar
Pixel8r
Registered User
Posts: 177
Joined: Mon Nov 30, 2009 4:39 pm
Contact:

Re: phpBB Smartfeed

Post by Pixel8r » Fri Feb 26, 2010 10:23 pm

Thanks for the advice I always backup anything before making any changes, especially when it is something I am not up to speed on.

Any more tips would be gratefully received. :)
24knews.com - We live on the edge of chaos.

bcooksley
Registered User
Posts: 2
Joined: Fri Jul 10, 2009 9:34 am

Re: phpBB Smartfeed

Post by bcooksley » Sat Feb 27, 2010 12:32 pm

There is an issue with Smartfeed's ability to display PM's in feeds, which causes them to not be visible in UCP if not previously viewed.

This is because they are not processed by phpBB's PM system, which will only deliver a message if it is new.

How to fix this:
Not mark messages as read when showing them in a feed.

User avatar
ToonArmy
Former Team Member
Posts: 4608
Joined: Sat Mar 06, 2004 5:29 pm
Location: Worcestershire, UK
Name: Chris Smith
Contact:

Re: phpBB Smartfeed

Post by ToonArmy » Sat Feb 27, 2010 12:38 pm

bcooksley wrote:There is an issue with Smartfeed's ability to display PM's in feeds, which causes them to not be visible in UCP if not previously viewed.

This is because they are not processed by phpBB's PM system, which will only deliver a message if it is new.

How to fix this:
Not mark messages as read when showing them in a feed.
Further to this the ideal solution appears to be, adjust the pm_unread flag to 0 but leave the pm_new flag at 1, remember to also adjust the user_unread_privmsg column on the users table.
Chris SmithBlogGitHub
Image
In a foreign field he lay. Lonely soldier unknown grave. On his dying words he prays. Tell the world of Paschendale.

User avatar
MarkDHamill
Registered User
Posts: 3316
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

Re: phpBB Smartfeed

Post by MarkDHamill » Sat Feb 27, 2010 2:22 pm

The assumption is if you select the "Add my private messages" option to the feed that you will have read them, and consequently they are no longer new nor unread. I could add a checkbox in a future version to allow the option to leave them unread. I have this for my Digests mod. I will likely add this in a future version since it bothers some.
Get the latest versions of my Digests and Smartfeed mods and extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

User avatar
ToonArmy
Former Team Member
Posts: 4608
Joined: Sat Mar 06, 2004 5:29 pm
Location: Worcestershire, UK
Name: Chris Smith
Contact:

Re: phpBB Smartfeed

Post by ToonArmy » Sat Feb 27, 2010 3:43 pm

MarkDHamill wrote:The assumption is if you select the "Add my private messages" option to the feed that you will have read them, and consequently they are no longer new nor unread. I could add a checkbox in a future version to allow the option to leave them unread. I have this for my Digests mod. I will likely add this in a future version since it bothers some.
The code only suggests it includes new or unread ones and then adjusts the status so they are not new and read, adjusting the new flag breaks phpBB's handling of private messages. Also not adjusting the user_unread/new_privmsg counters will display bogus values to the user when they login.
Chris SmithBlogGitHub
Image
In a foreign field he lay. Lonely soldier unknown grave. On his dying words he prays. Tell the world of Paschendale.

sbloomer
Registered User
Posts: 78
Joined: Fri Jun 12, 2009 8:18 pm

Re: phpBB Smartfeed

Post by sbloomer » Wed Mar 03, 2010 8:15 pm

I am considering using this MOD for my forum to post to twitter using twitterfeed.

Has anyone used this mod for this purpose?

User avatar
MarkDHamill
Registered User
Posts: 3316
Joined: Fri Aug 02, 2002 12:36 am
Location: Florence, MA USA
Contact:

3.0.7 compliance

Post by MarkDHamill » Thu Mar 04, 2010 12:59 am

I did a quick test to see if phpBB Smartfeed would install with 3.0.7 using a XAMP installation and there were no errors and the feed seemed to work right and all the file changes reported successful. So I believe the latest version 2.2.17 should work fine with phpBB 3.0.7.
Get the latest versions of my Digests and Smartfeed mods and extensions.
Need phpBB services or a phpBB consultant? I offer most phpBB services.

User avatar
MasterZ
Registered User
Posts: 712
Joined: Wed Sep 24, 2003 5:33 am
Contact:

Re: phpBB Smartfeed

Post by MasterZ » Thu Mar 04, 2010 1:47 am

sbloomer wrote:I am considering using this MOD for my forum to post to twitter using twitterfeed.

Has anyone used this mod for this purpose?
That is an interesting idea... I think I might try that! :)

Locked

Return to “[3.0.x] MOD Database Releases”

Who is online

Users browsing this forum: No registered users and 13 guests