Database Error: Table 'db_joomla.smf_sessions' doesn't exist

[Orstio]

Can I suggest adding this to the readme - I completely missed it, assuming that it would be picked up from the SMF or bridge, which is probably asking too much because you aren't going to know where they are.

This may already be a part of the instructions for the bot.  I'm not certain as it's a GPL product, maintained mostly by Chadness.

While on the subject of settings (should I open new topics for these questions?) - how do you point the discussion to child boards - I have two boards called Discussion, one General, and the other Technical. How do I select a specific one.

I believe if you are using discussbot 4.2b1, you can specify by board id number rather than board name by selecting that in the parameters.

Can I also point to an existing board and topic?

Only if the topic has exactly the same title as the content item.

Can the number of words to be quoted be set to "up to", so a short article doesn't get a 700 letter quote but just the number of letters it contains?

Just set the value larger in the parameters.  It can quote as large as any post in SMF can be made.

[mpetrie]

Can I suggest adding this to the readme - I completely missed it, assuming that it would be picked up from the SMF or bridge, which is probably asking too much because you aren't going to know where they are.

This may already be a part of the instructions for the bot.  I'm not certain as it's a GPL product, maintained mostly by Chadness.

I looked there before posting. Hopefully Chadness keeps an eye on here and picks this up for the next version.

...you can specify by board id number rather than board name by selecting that in the parameters.

I was hoping for a way to do this in words. The board numbers show as 3.0, 5.0, etc - I guess board.child_board? It would be nice to go General.Discussion - maybe a problem if spaces in the name though.

Can I also point to an existing board and topic?

Only if the topic has exactly the same title as the content item.

Shame. I have a couple of articles about the same overall subject and it would be nice to collate all comments into a single thread. From what you've said I've managed to link an existing thread to an article in Joomla - thanks. Unfortunately I can't link another article to the same thread. Chadness - next version?

Can the number of words to be quoted be set to "up to", so a short article doesn't get a 700 letter quote but just the number of letters it contains?

I meant, it's fine if the article is 700 characters long (the default quote limit), it gets truncated at that limit. But if it's less the quote block in the forum gets padded out to what looks like a 700 character block, even if the article only contained a couple of words. Another one for Chadness and the next version.

Thanks for all your help.

[Orstio]

Quote
...you can specify by board id number rather than board name by selecting that in the parameters.

I was hoping for a way to do this in words. The board numbers show as 3.0, 5.0, etc - I guess board.child_board? It would be nice to go General.Discussion - maybe a problem if spaces in the name though.

No, each board id is unique, regardless of whether it is a child board.  The format is board.topic ordering start of page.  That is, for the first page, a 0, because you want it to start at the beginning, but if you have 20 topics/page, 20 for the second page so that it starts at the 20th topic record selected.

[mpetrie]

Thanks Oristo.

Not going to help for what I want to do - because the topic is going to move as new topics get added.

What I was hoping for was to specify the category.board.topic, or topic_id, regardless of the topic's title - there could be two boards or topics with the same title, as I have with boards, which you've pointed out how to get around by using board number rather than name. For topics - it finds the newest (nearest the top?), you may (as I do) want two articles with different titles to point to a single topic - I know, I can give them the same name in Joomla.

[Caitlain]

Okay, I've followed all of the directions I can find in this thread, and I am still getting this error message at the bottom of each of the articles (and the front page) on the site.

Database Error: Table 'myjoomladb.smf_sessions' doesn't exist
File: /home/sitename/public_html/forums/Sources/Load.php
Line: 2056
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

Everything (the bridge, the discussbot) installed without an error, I modified the index.php as described, and everything appears to be working correctly - it will generate a discussion thread on my 1.1.2 forum.  The only problem is that error message at the bottom of the pages.

What else do I need to be looking for to fix this issue?

[undoIT]

you know, it might be a module that is causing the problem.  i have a module i added on http://themebot.com. you can see the "become a sponsor" module in the right column.  in it i have some code that calls on the Jumi mambot.  for some reason, when that module is active on the forum, i get the same error.  try deactivating modules on the forum page and see if the error goes away.  best of luck.

[Caitlain]

you know, it might be a module that is causing the problem.  i have a module i added on http://themebot.com [nofollow]. you can see the "become a sponsor" module in the right column.  in it i have some code that calls on the Jumi mambot.  for some reason, when that module is active on the forum, i get the same error.  try deactivating modules on the forum page and see if the error goes away.  best of luck.

Good idea, but I turned all of them off, and am still experiencing the same problem.

Thanks, though!  ;-)

[undoIT]

have you logged in to the standalone smf installation without logging out?  try logging out all user on both the standalone and the joomla brige. just guessing based on the error message.

[Orstio]

Okay, I've followed all of the directions I can find in this thread, and I am still getting this error message at the bottom of each of the articles (and the front page) on the site.

Database Error: Table 'myjoomladb.smf_sessions' doesn't exist
File: /home/sitename/public_html/forums/Sources/Load.php
Line: 2056
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0

Everything (the bridge, the discussbot) installed without an error, I modified the index.php as described, and everything appears to be working correctly - it will generate a discussion thread on my 1.1.2 forum.  The only problem is that error message at the bottom of the pages.

What else do I need to be looking for to fix this issue?

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

Did you enter both the database name and the database prefix for your SMF database in your discussbot params?

[Caitlain]

have you logged in to the standalone smf installation without logging out?  try logging out all user on both the standalone and the joomla brige. just guessing based on the error message.

Yes.

[Caitlain]

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

Yes, sir.

Did you enter both the database name and the database prefix for your SMF database in your discussbot params?

Yes, I did.  Am I correct in assuming that, if that were not the case, the discussbot wouldn't be working at all?  Like I said, it does function like it is supposed to.  The "Discuss this article" appears at the bottom of the articles, and when it is clicked on, it does generate a thread in the appropriate location in the forum itself.

[undoIT]

As I remember, I had some problems with the Discussbot as well and ended up having to uninstall it to get rid of the error.  Actually, I had to restore a backup of my site, because the database error was still there even after uninstalling the Discussbot. Why don't you list all of the modules and components you have installed. That would help people troubleshoot the problem.

[chadness]

I think I've finished beta 2, which solves the multiple database issues (I hope).

As far as getting multiple topics pointing towards the same topic without giving them the same title, that's not possible with the current design of the bot.  Right now, all you specify is the board.  It's a good idea for a future addition, though!

I'll also add those instructions you mentioned to beta 2, and I'll give the quote a quick look to see what's wrong with it.

[Caitlain]

As I remember, I had some problems with the Discussbot as well and ended up having to uninstall it to get rid of the error.  Actually, I had to restore a backup of my site, because the database error was still there even after uninstalling the Discussbot. Why don't you list all of the modules and components you have installed. That would help people troubleshoot the problem.

I am actually leaning toward it not being a module, so much as a database issue. Or, more specifically, a sessions issue.

When I install the discussbot, not only do I get the error mentioned above, but upon logging in, I seem to have issues maintains sessions across any length of time, and the Joomla admin panel appears to be looking for a location to save session information.

The issue is addressed here:

http://www.netregistry.com.au/customer-service/support/scripting/PHP/php_sessions.php [nofollow]

I am waiting on the host I use (that link above is not my host) to send the specific location that I need to plug into that to see if doing what that suggests fixes the issues.

Both issues disappear completely when I uninstall the discussbot, so they appear to be linked in some way.

When will beta 2 be available to play with?   

[chadness]

Should be available within the next 24 hours.  I added in the ability to specify a board topic as well, because it was actually pretty simple to do.

[mpetrie]

Chadness,

I added in the ability to specify a board topic as well, because it was actually pretty simple to do.

Excellent - thanks!

I'll also add those instructions you mentioned to beta 2, and I'll give the quote a quick look to see what's wrong with it.

Thanks for taking note of the suggestion. Did you manage to fix the quote length for articles of less than the quote limit value?

[chadness]

Thanks for taking note of the suggestion. Did you manage to fix the quote length for articles of less than the quote limit value?

That's nothing that the discussbot is doing.  All it does is take the exact text of the article and post it as the message.  The only thing it adds in is ". . ." and the quote tags.  This is the exact line of code:

Code Select Expand

$message = '[quote]'.substr($row->text,0,$num_chars).'. . .'.'[/quote]';

This part:
substr($row->text,0,$num_chars)
just says take only the first so many characters of the message text.

[Caitlain]

When I install the discussbot, not only do I get the error mentioned above, but upon logging in, I seem to have issues maintains sessions across any length of time, and the Joomla admin panel appears to be looking for a location to save session information.

The issue is addressed here:

http://www.netregistry.com.au/customer-service/support/scripting/PHP/php_sessions.php [nofollow]

I am waiting on the host I use (that link above is not my host) to send the specific location that I need to plug into that to see if doing what that suggests fixes the issues.

Both issues disappear completely when I uninstall the discussbot, so they appear to be linked in some way.

*sigh* I resolved the issue above, but am still getting the error message referenced earlier.

Interestingly, when I have Alikno's "Latest Posts from SMF" http://www.alikonweb.it/451/ [nofollow] installed, I get a slightly different error message inside that box when I install the discussbot in addition to the one mentioend ealier:

Database Error: Table 'cc_joom.smf_messages' doesn't exist
File: /home/caitlain/public_html/forums/SSI.php

The page footer goes away completely with both of those active as well.

When I uninstall the discussbot, all of the error messages go away and everything functions normally. I also tried the latest & greatest Beta 2 of the bot, with the same results.

This is perplexing.

[mpetrie]

Thanks for taking note of the suggestion. Did you manage to fix the quote length for articles of less than the quote limit value?

That's nothing that the discussbot is doing.  All it does is take the exact text of the article and post it as the message.  The only thing it adds in is ". . ." and the quote tags.  This is the exact line of code:

Code Select Expand

$message = '[quote]'.substr($row->text,0,$num_chars).'. . .'.'[/quote]';

This part:
substr($row->text,0,$num_chars)
just says take only the first so many characters of the message text.

I've just run this again using a very simple Joomla article with a single sentence of intro text only, saying "This is only for testing and will be deleted shortly."

The HTML in the Joomla editor is:

Code Select Expand

<p>This is only for testing and will be deleted shortly.</p><p>{mos_smf_discuss:5.0}</p>

When output in SMF it gets translated to:

Code Select Expand


[url=http://www.simuser.com/joomla/index.php?option=com_content&task=view&id=325&Itemid=77]
Read the article...[/url]
[quote][br][br]This is only for testing and will be deleted shortly.[br][br]

. . .[/quote]

Note the two br tags before and after the text and the extra blank line that's likely to get output. It's all these that made me think it was being padded out to $num_chars length.

Where do these tags come from? This is what needs to get removed from shorter quoted text.

Regards - Mike

[Orstio]

THe <p> tags get translated into [ br ][ br ] for posting.  If they don't paragraphs don't get separated in the SMF post.