[ABD] lastRSS autoposting bot MOD (0.1.4)

Smix · Post by **Smix** » Fri Sep 19, 2008 10:42 am

Yes, it´s the user_id which is posting all the topics ... But you´ll have to purge cached configuration to make it working ...

PrattP · Post by **PrattP** » Fri Sep 19, 2008 12:45 pm

Thanks Smix.

But I've just made a news post, and no output. Not sure what the problem is, as I've followed the instructions fully and I really need this to work.

Smix · Post by **Smix** » Fri Sep 19, 2008 1:35 pm

Check the permissions for the user you´ve chosen.
Check phpinfo() if you have cURL or fopen enabled (curl is defaultly selected - phpbb_config -> lastrss_type) ...
Go to phpMyAdmin into table phpbb_lastrss_autopost and set column 'next_check_after' to 0 (this forces grabing the feed)

PrattP · Post by **PrattP** » Fri Sep 19, 2008 1:57 pm

Smix wrote:1. Check the permissions for the user you´ve chosen.
2. Check phpinfo() if you have cURL or fopen enabled (curl is defaultly selected - phpbb_config -> lastrss_type) ...
3. Go to phpMyAdmin into table phpbb_lastrss_autopost and set column 'next_check_after' to 0 (this forces grabing the feed)

1. User permission is set to Admin.
2. cURL is enabled.
3. Completed this last task, did not post.

megalomania · Post by **megalomania** » Fri Sep 19, 2008 4:00 pm

megalomania · Post by **megalomania** » Fri Sep 19, 2008 7:05 pm

New error..

Code: Select all

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WorldofWarcraft Gaming Mouse""' at line 3 [1064]

SQL

SELECT topic_title FROM megalomania_topics WHERE topic_title = "wowinsider.com | Gamestop listing for "WorldofWarcraft Gaming Mouse""

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_lastrss_autopost.php
LINE: 159
CALL: dbal_mysql->sql_query()

FILE: includes/functions_lastrss_autopost.php
LINE: 96
CALL: autopost()

FILE: includes/functions_lastrss_autopost.php
LINE: 244
CALL: autopost_init()

FILE: index.php
LINE: 28
CALL: include('includes/functions_lastrss_autopost.php')

What do you make of this? Can you see what's wrong?

Edit: Now the error message is gone.. Maybe I tried browsing the forum JUST as it updated? A known bug perhaps?

megalomania · Post by **megalomania** » Fri Sep 19, 2008 10:40 pm

Hmm.. the bot seems to occasionally be posting the same topic multiple times

If you go to this page http://megalomania-eu.com/viewforum.php?f=29 you will see the duplicates of the same topic, any idea how to fix this?
You can log in with the login testuser and the password test123.
edit: Think I fixed this with the fix from earlier pages in this thread.. I should start reading others posts before asking so many questions - sorry!

And you will also see how it cuts the topic names, for example:
Mythic makes one last case for switching from WoW to Warhammer
becomes
Mythic makes one last case for switching from WoW to Warha
Is there any way to extend the length of the topic name the bot posts?
edit: Think I've fixed this too.. I removed the ´name´ to make room for more topic name!

Thanks!

PrattP · Post by **PrattP** » Sat Sep 20, 2008 12:00 am

Check my above reply, did all things but still doesn't work.

blitztrading · Post by **blitztrading** » Sun Sep 21, 2008 8:13 pm

Hi Smix,

In another forum (yours I think) I suggested as a new feature to choose the user_id to post each feed.

Another thing that may be useful : filter the feed with the category. For instance, you have a feed with 2 categories (A and B), then you can declare as 2 seperate entries (feed X - category A and feed X - category B), with 2 seperate destination forums.

Hope you will be able to work on this for the next release

Thx for everything, and the great Mod you initiated.

megalomania · Post by **megalomania** » Mon Sep 22, 2008 11:00 am

Hello Smix! You can disregard all my earlier posts.

Now I get this error everytime I hit my index link:

Code: Select all

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Tigole Deep-Breaths more""' at line 3 [1064]

SQL

SELECT topic_title FROM megalomania_topics WHERE topic_title = ""Tigole Deep-Breaths more""

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_lastrss_autopost.php
LINE: 159
CALL: dbal_mysql->sql_query()

FILE: includes/functions_lastrss_autopost.php
LINE: 96
CALL: autopost()

FILE: includes/functions_lastrss_autopost.php
LINE: 244
CALL: autopost_init()

FILE: index.php
LINE: 28
CALL: include('includes/functions_lastrss_autopost.php')

If I refresh the browser the error message goes away, but as soon as I click the Index link it's back again.. It's rather annoying!

Thanks again Smix!

(there really should be a thumbsupsmiley on this forum!)

Smix · Post by **Smix** » Mon Sep 22, 2008 11:10 am

Hello;

4 megalomania :
it´s known bug - please try the proposed fix on previous page ...

4 blitztrading :
I like your ideas

... I´ll see what I can do before next release

4 PrattP :
Please, check again if your settings is correct ... It really must work

...

jaunty_mellifluous · Post by **jaunty_mellifluous** » Mon Sep 22, 2008 6:00 pm

Wow! Neat Idea. I'm really looking forward for a real stable build for this mod.

blitztrading · Post by **blitztrading** » Tue Sep 23, 2008 8:07 am

Another issue: all special or latine characters such as ',à , é, è, create import pb.

is that possible to correct this, or add a module to change this character into non special character à ->a

Thx

Smix · Post by **Smix** » Tue Sep 23, 2008 8:53 am

blitztrading wrote:Another issue: all special or latine characters such as ',à , é, è, create import pb.

... What´s happening? What do you mean with "create import pb"?

All those characters are already UTF-8-ised with phpBB inbuild functions and may not harm the board ...

blitztrading · Post by **blitztrading** » Tue Sep 23, 2008 9:25 am

Here is the error msg I got:

SQL ERROR [ mysql4 ]

Incorrect string value: '\xC3' for column 'topic_title' at row 1 [1366]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (2, 1222070843, '6', 0, 1, 'Saxo Banque | 22/09/08 - Les marchés actions : Vendredi, journée d\'euphorie sur les places boursi�', 'blitztrader', 'AA0000', 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_posting.php
LINE: 1835
CALL: dbal_mysql->sql_query()

FILE: includes/functions_lastrss_autopost.php
LINE: 247
CALL: submit_post()

FILE: includes/functions_lastrss_autopost.php
LINE: 95
CALL: autopost()

FILE: includes/functions_lastrss_autopost.php
LINE: 291
CALL: autopost_init()

FILE: index.php
LINE: 29
CALL: include('includes/functions_lastrss_autopost.php')

Apparently � and ' generate the issue ...

I also tried in the lastrss function when defining the subject (before cutting it to 100 characters) something like :
$subject = recode_string("lat1..iso646-de",$subject);

But does not work (recode_string not recognized ...)

advertisements