[Bridge 1.1.6] Problem with SMF DiscussBot

[ormuz]

nothing going wrong, the bot works just fine!

[ahwoogamac]

I must seeing things on my website then....   

Maybe some constructive help might come in a little handier than telling me my problem doesn't exist.

[ormuz]

if u insert the code in your template, that just can be a configuration problem...

You can see it in action in many sites...

[shinbushi]

Go to my site www.taijutsu.com/content
register and try to click on any of the discuss article links and tell me what you get.

BTW in the default template I have the

Code Select Expand

<?php ob_start('output');$buffer = ob_get_contents();ob_end_clean();$buffer = str_replace('<input type="hidden" name="sc" value="" />','<input type=hidden name="sc" value="'.$sc.'">', $buffer);echo $buffer;?>
at the bottem.

[ahwoogamac]

My code is correct.  Configuration is correct.  I have already had the bot working correctly on my site.  But with the new Bridge update came a new bot update.  That's where the problem started. 

I am not denying that it is working on sites.  I congratulate you for getting it to work on yours.  However, as shinbushi has just posted the exact problem, this isn't an isolated incident.  All I'm asking is that if somebody has run into this problem and found the solution, they would be so kind to share it.

[Orstio]

In the bot params, it asks for your SMF database name and the SMF database prefix.  You will need to enter those.

[ahwoogamac]

They had already been entered correctly.

I have Joomla! 1.0.11, SMF 1.1 RC3, and (like I said) this newest discussbot file that is available in this thread. I have the databases set up with their correct permissions.  In fact, did work for a while, with SMF 1.1 RC2 and the older discussbot, but when I upgraded both, this started to happen.

I'm not dealing with a fact that I missed a step in setup, because it DID work correctly before I upgraded.  I can't go back to the older versions because of the forum upgrade, but this keeps giving me a truncated url.

Code Select Expand

index.php?option=com_smf&Itemid=84&

[shinbushi]

With me I set the default to Article Discussion which is http://taijutsu.com/content/index.php?option=com_smf&Itemid=27&board=17.0
When I click on the link in my article it goes to http://taijutsu.com/content/index.php?option=com_smf&Itemid=27&topic=106.new#new
I double check my DB name taijutsu_smf1 and prefix is smf_
any ideas?

[Orstio]

Try this code at the vottom of your template instead of what you have:

Code Select Expand

<?php ob_start('output');
$buffer = ob_get_contents();
ob_end_clean();
$buffer = str_replace('<input type="hidden" name="sc" value="" />','<input type=hidden name="sc" value="'.$sc.'">', $buffer);
echo $buffer;

mysql_select_db($GLOBALS['db_name']);
?>

[shinbushi]

Same error.
On the template I am doing it in Joomla edit template HTML and I have tried it both before and after the </HTML> tag

[Orstio]

Does your Joomla database user have access to your SMF database?

[shinbushi]

Code Select Expand

Users in smf1
taijutsu_joom1 (Privileges: ALL PRIVILEGES)

[ahwoogamac]

Here's a link to the page I'm have the issue with: hxxp:www.e3students.com/index.php?option=com_content&task=view&id=25&Itemid=81 [nonactive]

When you click on the discussbot link, it goes to the forum with a "The board you specified doesn't exist" and the ever annoying url: hxxp:www.e3students.com/index.php?option=com_smf&Itemid=84& [nonactive]

For recap:

1) Again, I went in a checked and the users of both databases have full permissions to the other database.
2) The correct SMF database is listed in the config page and the default SMF_ prefix is correct in my situation.
3) I inserted Orstio's newest code at the bottom of my template.

I'm also still getting the error on the front page:

Code Select Expand

Database Error: Table 'e3stud_joom1.smf_sessions' doesn't exist
File: /home/e3stud/public_html/forum/Sources/Load.php
Line: 1981

I'm usually one to exhuast all forum posts for solutions before I even post at all.  But this has one really has me stumped.

[jonblazn]

I'm not sure what's different between me and everyone else but I'm getting the following error:

Code Select Expand

Database Error: Table 'mysite_joomla.messages' doesn't exist
File: /home3/mysite/public_html/forum/SSI.php
Line: 259
Can anyone help. I'm using:
* Joomla 1.0.10
* SMF 1.1 RC3
* SMF DiscussBot as downloaded from this thread
*Bridge 1.1.6

Thanks in advance-

[Orstio]

Go to your Joomla admin panel, and edit the params of the discussbot.

Make sure to enter both the database name and prefix into their respective textboxes.

Make sure to click Save.

[jonblazn]

Thanks. Now I'm getting this error though:

Code Select Expand

Database Error: Table 'mysiteDBprefix_smf.mysiteDBprefix_messages' doesn't exist
File: /home3/mysite/public_html/forum/SSI.php
Line: 259
Any ideas?

[Orstio]

Your database prefix and database name are two different things.

[jonblazn]

I think I had been including the db prefix in my db name. Thanks. However I'm now getting this message:

Code Select Expand

Database Error: Table 'elitetra_mambo.[color=red]elitetr[/color]_messages' doesn't exist
File: /home3/elitetra/public_html/forum/SSI.php
Line: 259

• My SMF Database Name: smf
• SMF database prefix: elitetra_
• Default discussion board: Don't know what to put here....is it the full web address? the local directory? the bridged joomla address? 

Incidentally, my joomla db name is elitetra_mambo. I don't know why this is showing up in the error code. I'm also unsure why the highlighted red text would be elitetr instead of elitetra.

Thanks again-

[Kindred]

I think you are incorrect.

your SMF database name is elitetra_smf
your smf database prefix (if you did not alter it during installation) would default to be smf_

the default board is the NAME of the default board to put the discussions in... like: General Discussion

[jonblazn]

Thanks you were helpful as usual.