Page 4 of 12

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

Posted: Mon Sep 21, 2009 5:08 am
by sotis
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

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')

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

Posted: Mon Sep 21, 2009 3:06 pm
by petrocad3d
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'

:ugeek:

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

Posted: Tue Sep 22, 2009 3:01 pm
by sotis
I receive the same error after changes.

My mysql version is: MySQL 5.1.33-community

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

Posted: Wed Sep 23, 2009 9:34 am
by petrocad3d
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;

:o

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

Posted: Wed Sep 23, 2009 3:11 pm
by muggins
petrocad3d, it would help us quite a bit if this were packaged as a ModX. I find your instructions difficult sometimes.

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

Posted: Wed Sep 23, 2009 4:32 pm
by petrocad3d
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. 8-)

:ugeek:

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

Posted: Wed Sep 23, 2009 9:28 pm
by muggins
Your mod works better than some, sir. :D

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...

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

Posted: Tue Sep 29, 2009 5:04 pm
by lachlan438
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()

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

Posted: Tue Sep 29, 2009 7:18 pm
by lachlan438
Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal :cry: 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? :twisted:

Once Again thanks for this very cool Mod :)

Its always good to suck up when asking for support lol

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

Posted: Wed Sep 30, 2009 10:34 am
by Petesat
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

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

Posted: Wed Sep 30, 2009 12:10 pm
by muggins
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. :?

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

Posted: Sat Oct 03, 2009 8:05 pm
by Petesat
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

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

Posted: Sun Oct 04, 2009 1:29 am
by petrocad3d
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. :D
lachlan438 wrote:Ok, Hal9000 Seems to be the problem if I turn him off all the problems fade away. think is I like Hal :cry: 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? :twisted:

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. 8-)
For Ralf, go to http://www.verbots.com

:ugeek:

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

Posted: Sun Oct 04, 2009 3:49 am
by muggins
Excellent, sir!

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

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

Posted: Sun Oct 04, 2009 5:55 am
by Petesat
Where do these file go then?

Pete