[BETA] Forum (phpbb3) with bot response (ALICE & Hal9000)

sotis · Post by **sotis** » Mon Sep 21, 2009 5:08 am

I receive this. I have column "post_bot_respond" in users table.

SQL ERROR [ mysql4 ]

Unknown column 't.post_bot_respond' in 'where clause' [1054]

SQL

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') ORDER BY a.post_id) as t WHERE LOCATE('*315190 ',t.post_bot_respond)=0 group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

BACKTRACE

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

FILE: ai/posting_bot2.php
LINE: 173
CALL: dbal_mysql->sql_query()

FILE: ai/bot_ai.php
LINE: 17
CALL: include('ai/posting_bot2.php')

FILE: index.php
LINE: 439
CALL: include('ai/bot_ai.php')

petrocad3d · Post by **petrocad3d** » Mon Sep 21, 2009 3:06 pm

sotis wrote:I receive this. I have column "post_bot_respond" in users table.

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 't.post_bot_respond' in 'where clause' [1054]

SQL

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') ORDER BY a.post_id) as t WHERE LOCATE('*315190 ',t.post_bot_respond)=0 group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

I need the version of your mysql.

I amnot sure about this error, but try with this

SELECT * FROM (SELECT a.* FROM phpbb_posts a, phpbb_forums b
WHERE a.forum_id='' AND a.forum_id=b.forum_id AND a.poster_id<>'2310'
AND a.post_time>0 AND (b.forum_name<>'trigger by message' AND
b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss')
ORDER BY a.post_id) t WHERE LOCATE('*315190 ',t.post_bot_respond)=0
group by t.topic_id ORDER BY t.post_id DESC LIMIT 10

in the line 5, i delete the word 'as'

sotis · Post by **sotis** » Tue Sep 22, 2009 3:01 pm

I receive the same error after changes.

My mysql version is: MySQL 5.1.33-community

petrocad3d · Post by **petrocad3d** » Wed Sep 23, 2009 9:34 am

sotis wrote:I receive the same error after changes.

My mysql version is: MySQL 5.1.33-community

I forget this instruction :
FIND : 'test'
DELAT : 1-3min
FORUM TARJET : test_forum

Maybe your mysql doesnt like SELECT OF SELECT.

Try with it

SELECT a.* FROM phpbb_posts a JOIN phpbb_forums b ON a.forum='' AND
a.forum_id=b.forum_id AND a.poster_id<>'2310' AND a.post_time>0 AND
(b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
LOCATE('*315190 ',a.post_bot_respond)=0
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT 10

REPLACE THE LINE 181 and 186 in the file posting_bot2.php with these

$sql = "SELECT a.* FROM " . POSTS_TABLE . " a JOIN " . FORUMS_TABLE . " b ON a.forum_id='$donde' AND a.forum_id=b.forum_id AND a.poster_id<>'$user_id' AND a.post_time>$desdeaqui AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
LOCATE('$IDXX',a.post_bot_respond)=0
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT $limitus";

$sql = "SELECT a.* FROM " . POSTS_TABLE . " a JOIN " . FORUMS_TABLE . " b ON a.forum_id='$donde' AND a.forum_id=b.forum_id AND a.poster_id<>'$user_id' AND a.post_time>$desdeaqui AND (b.forum_name<>'trigger by message' AND b.forum_name<>'trigger by time' AND b.forum_name<>'trigger by rss') AND
(post_bot_respond IS NULL or a.post_bot_respond='')
GROUP BY a.topic_id ORDER BY a.post_id DESC LIMIT $limitus";$numpo=0;

muggins · Post by **muggins** » Wed Sep 23, 2009 3:11 pm

petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.

petrocad3d · Post by **petrocad3d** » Wed Sep 23, 2009 4:32 pm

muggins wrote:petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.

This part 'trigger by message' is in development. It is very dificult for me to test this part of the mod, because it has a delay.

it isnot my fault that people try to install in very old versions of php or mysql.(also phpbb)

'Select by Select' is not supported in version before Mysql 4.0.0. I get the solution, but i need the other person say the code works or not to work.

I tested the mod in phpbb 3.0.3 and 3.0.5, offline and online, i didnt receive any king of rutime error.

I noticed that one tryied to install phpbb 2.0.x, i knew it, but i helped him, i got the code for that problem. Others had beed downloaded that version(modbot_v0.2.3b.zip), i am sure it works for phpbb 3.0.x, but i didnt like that situation.

I appreciate your suggestion, i will do it, when people say me this mod works very well.

muggins · Post by **muggins** » Wed Sep 23, 2009 9:28 pm

Your mod works better than some, sir.

It is much easier to document changes to the instructions, and to correct them as needed, when we have the install.xml file to aid us in installation and upgrade...

lachlan438 · Post by **lachlan438** » Tue Sep 29, 2009 5:04 pm

I am getting this error I have disabled all the bots but Hal just for testing and stuff you can find my very newest work in progress here http://lance4681.x10hosting.com/forums/right now this is on free hosting until I build it so it might be down or slow just a heads up
SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

SQL

SELECT user_id FROM phpbb_users WHERE username_clean = 'hal9000'

BACKTRACE

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

FILE: posting_bot.php
LINE: 1031
CALL: dbal_mysql->sql_query()

lachlan438 · Post by **lachlan438** » Tue Sep 29, 2009 7:18 pm

Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal

I have played around with Hal before and he was kind of kool so if anyone knows a fix that would be sick.

My second problem is. How do I train up
Ralf and Alissa so how can I add AIML files to there brains?

Once Again thanks for this very cool Mod

Its always good to suck up when asking for support lol

Petesat · Post by **Petesat** » Wed Sep 30, 2009 10:34 am

I get this error..

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT post_bot_respond FROM posts WHERE post_id = 19618

BACKTRACE

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

FILE: posting_bot.php
LINE: 1005
CALL: dbal_mysql->sql_query()

I have

Apache version 2.2.13 (Unix)
PHP version 4.4.9
MySQL version 5.0.81-community-
log
Architecture x86_64

And am running PHPBB3.05 with loads of mods..

I have emulated my live board to test this mod..

I also do not get option to tick who answers..

Pete

muggins · Post by **muggins** » Wed Sep 30, 2009 12:10 pm

The instruction:

Code: Select all

ALTER TABLE `phpbb_users` ADD post_bot_respond varchar(250) NULL default "";

Should be:

Code: Select all

ALTER TABLE `phpbb_posts` ADD post_bot_respond varchar(250) NULL default "";

As to why you don't get the question, I don't know.

Petesat · Post by **Petesat** » Sat Oct 03, 2009 8:05 pm

Yes, this fixed the prob, going to try again from scratch though as I said it was on a forum duplicate..

So I have now deleted the database and am going to add the mod with admin CP as well this time..

Thanks for the MOD as I think it is fun..

Pete

petrocad3d · Post by **petrocad3d** » Sun Oct 04, 2009 1:29 am

muggins wrote:petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.

No problem, i will do it, thank for your suggestion.

lachlan438 wrote:Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal I have played around with Hal before and he was kind of kool so if anyone knows a fix that would be sick.

My second problem is. How do I train up
Ralf and Alissa so how can I add AIML files to there brains?

Once Again thanks for this very cool Mod

Its always good to suck up when asking for support lol

In order to add more AIML files you can go to this URL, I think it is the best of AIML files sources, it has funny AIML files like board games, horoscope, alot fun AIMLs.

For Ralf, go to http://www.verbots.com

muggins · Post by **muggins** » Sun Oct 04, 2009 3:49 am

Excellent, sir!

I will visit Square Bear's site, too. Thank you!

Petesat · Post by **Petesat** » Sun Oct 04, 2009 5:55 am

Where do these file go then?

Pete