[RC][1.1.0-r2] FIND

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
automat01
Registered User
Posts: 17
Joined: Mon Feb 07, 2011 2:48 am

Re: [RC-5] RSS Input

Post by automat01 »

hello, I installed the mod on a test forum (3.0.10) with automod 1.0.0.1 and it installed fine, played with it a little, and decided to give it a shot on my live board. I had to ditch my outdated test forum due to another mod I was testing, so I decided to clone my live board to validate the install of rss input. 3.0.11 and automod 1.0.2. now the mod won't auto install, I get a sql error .

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'mod_contribs' in 'field list' [1054]

SQL

INSERT INTO phpbb_mods (mod_time, mod_dependencies, mod_name, mod_description, mod_version, mod_path, mod_author_notes, mod_author_name, mod_author_email, mod_author_url, mod_actions, mod_languages, mod_template, mod_contribs) VALUES (1354720942, '', 'a:2:{s:2:\"en\";s:9:\"RSS Input\";s:5:\"zh-TW\";s:16:\"RSS 新聞匯集\";}', 'Import RSS news to your forums.', '1.0.1', './../store/mods/rss_input/install.xml', 'Code based on 2.0.x mod \'FIND\'.<br />\n<br />\nThis mod require:<br />\n<br />\n 1. php > 5.0<br />\n 2. php setting "allow_url_fopen = on" or cURL library support.<br />\n 3. php setting "safe_mode = on" is NOT supportted!', 'PoPoutdoor', '', '', 'a:4:{s:3:\"SQL\";a:1:{i:0;s:942:\"CREATE TABLE phpbb_xmlfeeds (\n feed_id smallint(4) unsigned NOT NULL auto_increment,\n post_forum mediumint(8) unsigned NOT NULL default \'0\',\n bot_id mediumint(8) unsigned NOT NULL default \'0\',\n status tinyint(1) unsigned NOT NULL default \'0\',\n feedname varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,\n url varchar(255) character set utf8 collate utf8_bin NOT NULL,\n last_import int(11) unsigned NOT NULL default \'0\',\n encodings varchar(32) character set utf8 collate utf8_bin NOT NULL,\n topic_ttl tinyint(2) unsigned NOT NULL default \'1\',\n post_items tinyint(2) unsigned NOT NULL default \'10\',\n post_contents smallint(3) unsigned NOT NULL default \'0\',\n feedname_topic tinyint(1) unsigned NOT NULL default \'0\',\n inc_channel tinyint(1) unsigned NOT NULL default \'1\',\n inc_cat tinyint(1) unsigned NOT NULL default \'1\',\n feed_html tinyint(1) unsigned NOT NULL default \'1\',\n PRIMARY KEY (feed_id),\n KEY post_forum (post_forum)\n);\";}s:9:\"NEW_FILES\";a:9:{s:28:\"root/adm/style/acp_find.html\";s:23:\"adm/style/acp_find.html\";s:32:\"root/includes/functions_find.php\";s:27:\"includes/functions_find.php\";s:28:\"root/includes/rss_parser.php\";s:23:\"includes/rss_parser.php\";s:30:\"root/includes/acp/acp_find.php\";s:25:\"includes/acp/acp_find.php\";s:35:\"root/includes/acp/info/acp_find.php\";s:30:\"includes/acp/info/acp_find.php\";s:25:\"root/language/en/find.php\";s:20:\"language/en/find.php\";s:33:\"root/language/en/find_posting.php\";s:28:\"language/en/find_posting.php\";s:29:\"root/language/en/acp/find.php\";s:24:\"language/en/acp/find.php\";s:19:\"root/rss_import.php\";s:14:\"rss_import.php\";}s:5:\"EDITS\";a:2:{s:22:\"includes/constants.php\";a:2:{i:0;a:1:{s:54:\"// Additional constants\ndefine(\'VOTE_CONVERTED\', 127);\";a:1:{s:9:\"after add\";s:86:\"// RSS Input\ndefine(\'FIND_BOT_ID\', \'[RSS Bot]\'); // string to identify our posting bot\";}}i:1;a:1:{s:20:\"// Additional tables\";a:1:{s:9:\"after add\";s:63:\"// RSS Input\ndefine(\'FIND_TABLE\', $table_prefix . \'xmlfeeds\');\";}}}s:26:\"language/en/acp/common.php\";a:2:{i:0;a:1:{s:60:\" \'ACP_FORUM_BASED_PERMISSIONS\' => \'Forum based permissions\',\";a:1:{s:10:\"before add\";s:41:\" \'ACP_FIND\' => \'RSS Import Settings\',\";}}i:1;a:1:{s:67:\" \'LOG_FORK\' => \'<strong>Copied topic</strong><br />» from %s\',\";a:1:{s:10:\"before add\";s:214:\" \'LOG_FEED_ADDED\' => \'<strong>FIND: feed added</strong><br />» %s\',\n \'LOG_FEED_DELETED\' => \'<strong>FIND: feed deleted</strong><br />» %s\',\n \'LOG_FEED_UPDATED\' => \'<strong>FIND: feed updated</strong><br />» %s\',\";}}}}s:16:\"DIY_INSTRUCTIONS\";a:1:{i:0;s:633:\"1. Install the ACP module\n\n a. Login ACP\n b. Go to: SYSTEM - MODULE MANAGEMENT -> acp -> general -> Board configuration page, select "RSS Import Settings [acp_find]" and click Add module.\n c. Enable the module after the page refreshed.\n d. Purge the cache.\n\n2. Initial setup\n\n Follow instructions from contrib/setup.txt\n\n3. You can manage your feeds from GENERAL - BOARD CONFIGURATION -> RSS Import Settings by now.\n\n\n4. Read instructions from contrib/customize.txt if you like to customize this mod.\n\n\nCheck post at http://www.phpbb.com/community/viewtopic.php?p=11231965#p11231965 for updates.\";}}', '', '', '')

BACKTRACE


FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 754
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: [ROOT]/includes/acp/acp_mods.php
LINE: 1262
CALL: dbal_mysql->sql_query()

FILE: [ROOT]/includes/acp/acp_mods.php
LINE: 253
CALL: acp_mods->install()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_mods->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()

on the second try it partially installed, with a sql error saying that the table xmlfeeds was already installed. if I force the install the same error comes back, I assume it tries to write in the mods table but there seems to be a typo in the statement. in automod tab rss input is till labeled as uninstalled.

I'll post back to tell if the mod still works as it should
automat01
Registered User
Posts: 17
Joined: Mon Feb 07, 2011 2:48 am

Re: [RC-5] RSS Input

Post by automat01 »

looks like there's a bug in automod updater. uninstalled automod altogether and reinstalled and now mods install fine, rss input mod included. gonna post about it in automod forum
mtechama
Registered User
Posts: 75
Joined: Sun Oct 12, 2008 9:31 pm
Location: Texas

Re: [RC-5] RSS Input

Post by mtechama »

I am unable to find this in the (ACP):


2) Manage feed from GENERAL - BOARD CONFIGURATION -> RSS Import Settings.
Click 'Add Feed' to proceed
mtechama
Registered User
Posts: 75
Joined: Sun Oct 12, 2008 9:31 pm
Location: Texas

Re: [RC-5] RSS Input

Post by mtechama »

When the feed has been posted how do make it automatically locked?
mtechama
Registered User
Posts: 75
Joined: Sun Oct 12, 2008 9:31 pm
Location: Texas

Re: [RC-5] RSS Input

Post by mtechama »

This mod isn't pulling the feeds automatically,,, Why?
mtechama
Registered User
Posts: 75
Joined: Sun Oct 12, 2008 9:31 pm
Location: Texas

Re: [RC-5] RSS Input

Post by mtechama »

Anyone?
fmacmahon
Registered User
Posts: 34
Joined: Fri Jul 13, 2007 9:51 pm

Re: [RC-5] RSS Input

Post by fmacmahon »

mtechama wrote:When the feed has been posted how do make it automatically locked?
Mess wrote:
PoPoutdoor wrote:The cron autopost part, I just don't know how to do... :P
I got the cron autopost feature working on the LastRSS autoposting bot. Maybe these 3 posts can help you.
http://www.phpbb.com/community/viewtopi ... 0#p9004075
http://www.phpbb.com/community/viewtopi ... #p10708775
http://www.phpbb.com/community/viewtopi ... 5#p8569125
Good luck on the mod. :)
Edit: Can this be setup so some feeds post in the same thread? Are you taking feature requests?
I haven't tried yet:

OPEN
cron.php
FIND:

Code: Select all

// Do not update users last page entry
$user->session_begin(false);
$auth->acl($user->data);
AFTER ADD

Code: Select all

// RSS Input autopost mod begin
include ($phpbb_root_path . 'includes/functions_find.'.$phpEx);
// RSS Input autopost mod end
mtechama
Registered User
Posts: 75
Joined: Sun Oct 12, 2008 9:31 pm
Location: Texas

Re: [RC-5] RSS Input

Post by mtechama »

This mod is still not pulling updated feed from another webpage automatically,,,, Why is that?
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [RC-5] RSS Input

Post by PoPoutdoor »

As stated on the first post: This mod is not for green hand

Anyway, I will review current code and hopefully release new version around late summer.

If you have any idea to make this mod easier for green hands or dealing with CRON (better with links to code for reference), I will consider before coding for new release as long as it doesn't make this mod too complicated.
fmacmahon
Registered User
Posts: 34
Joined: Fri Jul 13, 2007 9:51 pm

Re: [RC-5] RSS Input

Post by fmacmahon »

It worked fine until yesterday...
i didn't change anything but now:

Code: Select all

Erro Geral
SQL ERROR [ mysqli ]

Column 'post_text' cannot be null [1048]

SQL

INSERT INTO posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_approved, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES ('21', 2476, 0, '127.0.0.1', 1361186875, 1, 1, 0, 1, 0, '', 'Circular nº 40 - Pool Português - Plantéis', NULL, 'd41d8cd98f00b204e9800998ecf8427e', 0, '', '', 1, 1, 0)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/includes/functions_posting.php
LINE: 2000
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/functions_find.php
LINE: 847
CALL: submit_post()

FILE: [ROOT]/includes/functions_find.php
LINE: 485
CALL: rss_autopost()

FILE: [ROOT]/includes/acp/acp_find.php
LINE: 119
CALL: get_rss_content()

FILE: [ROOT]/includes/functions_module.php
LINE: 507
CALL: acp_find->main()

FILE: [ROOT]/adm/index.php
LINE: 74
CALL: p_master->load_active()
Any sugestion?
fmacmahon
Registered User
Posts: 34
Joined: Fri Jul 13, 2007 9:51 pm

Re: [RC-5] RSS Input

Post by fmacmahon »

I tried to add:

root/includes/functions_posting.php

Code: Select all

'post_text'      => (!empty($data['message']) ? $data['message'] : ''), 
And the error disappears but the new rss messages are empty... :cry:
InTempest
Registered User
Posts: 26
Joined: Tue Feb 01, 2011 8:58 pm

Port to forum failure

Post by InTempest »

Code: Select all

php version:5.4.14

Code: Select all

Board version: 3.0.11

Code: Select all

MySQL (i) 5.5.30-cll-lve

I have read through the previous posts and have not found any current users with my issue. Might I first start off by saying amazing work (even though I don't have it working yet). I've noticed all the great support you've done all throughout this thread.

So here is my issue. I have installed everything just as the install requires. Everything seemed to go great till I attempt to import the threads.

And here is where my issue differs. I don't get a specific error. It posts the contents of the RSS in the ACP. So i know the mod is reading the information. I'm setting up my board for a warcraft guild, so i'm wanting to be able to rss blizzard and mmo-champion news posts for my guildies. I had started off with those feeds (which everything posts in acp error, images/videos.ect). So I thought maybe it was something in the formating, so i tried with the google test thread.

Here is a image i made with cuts of everything important

Image

I don't know what to do. I'm also needing to have an addon like this up and running to sync to the bloggers who want to post to my site through their RSS.

I don't know how often you check this thread. But thank you in advance.
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [RC-5] RSS Input

Post by PoPoutdoor »

@fmacmahon

I notice this after phpBB upgrade (from last code release).

I got similar error converting source encoding to UTF-8 containing alternate characters that is not (yet) in ISO-10646, or like some BIG5-HKSCS characters being rejected or need revised.

I haven't start code review to confirm what is the catch, but I'm pretty sure this is related to encoding support (be php, mysql or my code).

@InTempest

I do watch closely with this mod to import RSS feeds from this thread. I do miss @fmacmahon post for my home server hardware died while I'm on trip.

Back to your issue: I think the mod instructions is not right due to phpBB version changes or human error.

Please check instructions related to ACP editing.
InTempest
Registered User
Posts: 26
Joined: Tue Feb 01, 2011 8:58 pm

Re: [RC-5] RSS Input

Post by InTempest »

I manually checked all code edits located in
rss_input/install.xml

What ACP edits are you referring to?

Code: Select all

Open: includes/constants.php
Find

Tip: This may be a partial find and not the whole line.
Code:Select all

// Additional constants
define('VOTE_CONVERTED', 127);

Add after

Tip: Add these lines on a new blank line after the preceding line(s) to find.
Code:Select all

//	RSS Input
define('FIND_BOT_ID', '[RSS Bot]');	// string to identify our posting bot

<< Hide
Find

Tip: This may be a partial find and not the whole line.
Code:Select all

// Additional tables

Add after

Tip: Add these lines on a new blank line after the preceding line(s) to find.
Code:Select all

//	RSS Input
define('FIND_TABLE',		$table_prefix . 'xmlfeeds');

Code: Select all

Open: language/en/acp/common.php
Find

Tip: This may be a partial find and not the whole line.
Code:Select all

	'ACP_FORUM_BASED_PERMISSIONS'	=> 'Forum based permissions',

Add before

Tip: Add these lines on a new blank line before the preceding line(s) to find.
Code:Select all

	'ACP_FIND'					=> 'RSS Import Settings',

<< Hide
Find

Tip: This may be a partial find and not the whole line.
Code:Select all

	'LOG_FORK'					=> '<strong>Copied topic</strong><br />» from %s',

Add before

Tip: Add these lines on a new blank line before the preceding line(s) to find.
Code:Select all


	'LOG_FEED_ADDED'	=> '<strong>FIND: feed added</strong><br />» %s',
	'LOG_FEED_DELETED'	=> '<strong>FIND: feed deleted</strong><br />» %s',
	'LOG_FEED_UPDATED'	=> '<strong>FIND: feed updated</strong><br />» %s',
Those are the only code edits in the instal file. I don't see anything about editing the ACP files other than language/en/acp/common.php. Which i made all those edits manually. So I know they're there.
User avatar
PoPoutdoor
Registered User
Posts: 217
Joined: Fri Oct 31, 2008 2:58 pm

Re: [RC-5] RSS Input

Post by PoPoutdoor »

@InTempest

Check adm/style/acp_find.html first, see if any other installed mods changing this. Provide the list of mods installed if acp_find.html is intact.

BTW, there is a known bug related to google feed urls, try other feed source to verify this.

Return to “[3.0.x] MODs in Development”