Code: Select all
INSERT INTO `phpbb_lastrss_autopost` (`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`) VALUES
('NAME', 'http://URL.TO/RSS.FEED', 0, 12, DESTINATION_FORUM_ID, 1);
Code: Select all
Feed wasn´t updated, because malformed
Hello its nice to see you are back Smix, i really love this modAboutIt´s error caused by bad URL ...Code: Select all
Feed wasn´t updated, because malformed
Code: Select all
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_lastrss_autopost` (
`name` varchar(255) collate utf8_bin NOT NULL,
`url` varchar(255) collate utf8_bin NOT NULL,
`next_check` int(10) NOT NULL,
`next_check_after` int(2) NOT NULL,
`destination_id` int(3) NOT NULL,
`enabled` int(1) NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO `phpbb_lastrss_autopost` (`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`) VALUES
('lastRSS', 'http://phpbb3.smika.net/lastrss.php', 0, 1, 1, 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('lastrss_type', 'curl', 0),
('lastrss_ap_version', '0.1.0', 0),
('lastrss_ap_enabled', '1', 0),
('lastrss_ap_items_limit', '5', 0),
('lastrss_ap_bot_id', '2', 0);
Code: Select all
/*CREATE TABLE `phpbb_lastrss_autopost` (
`name` varchar(255) collate utf8_bin NOT NULL,
`url` varchar(255) collate utf8_bin NOT NULL,
`next_check` int(10) NOT NULL,
`next_check_after` int(2) NOT NULL,
`destination_id` int(3) NOT NULL,
`enabled` int(1) NOT NULL,
PRIMARY KEY ( `name` )
) ENGINE = MYISAM ;*/
Code: Select all
/*CREATE TABLE `phpbb_lastrss_autopost` (
`name` => wowinsider.com
`url` => http://www.wowinsider.com/rss.xml
`next_check` => 0
`next_check_after` => 1
`destination_id` => 29
`enabled` => 1
PRIMARY KEY ( `name` )
) ENGINE = MYISAM ;*/
Code: Select all
//$config['lastrss_ap_bot_id'] = 164;
If you wan´t to change (for testing purposes) the poster of the feed through the php file - not through the config table (the id is stored in table phpbb_config) ... uncomment the line (delete the "//") and set the user_id of account, which you want to post the feeds (at this time, only one account is posting all the topics ...)INSERT INTO `phpbb_lastrss_autopost` (`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`) VALUES
('wowinsider.com', 'http://www.wowinsider.com/rss.xml', 0, 12, 29, 1);
Code: Select all
//$config['lastrss_ap_bot_id'] = 164;
Code: Select all
INSERT INTO `phpbb_lastrss_autopost` (`name`, `url`, `next_check`, `next_check_after`, `destination_id`, `enabled`) VALUES
('wowinsider.com', 'http://www.wowinsider.com/rss.xml', 0, 1, 29, 1);
Code: Select all
INSERT INTO `megalomania_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('lastrss_type', 'curl', 0),
('lastrss_ap_version', '0.1.0', 0),
('lastrss_ap_enabled', '1', 0),
('lastrss_ap_items_limit', '5', 0),
('lastrss_ap_bot_id', '91', 0);
Code: Select all
General Error
SQL ERROR [ mysql4 ]
Table 'megal5_forum.megalomania_lastrss_autopost' doesn't exist [1146]
SQL
SELECT * FROM megalomania_lastrss_autopost WHERE next_check < "1221815548" AND enabled = "1"
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/functions_lastrss_autopost.php
LINE: 233
CALL: dbal_mysql->sql_query()
FILE: index.php
LINE: 28
CALL: include('includes/functions_lastrss_autopost.php')
Smix wrote:Please, remember this mod is still in development and installation is recommended only for experienced php & phpBB programers ...