Elxis CMS Forum

Extensions => Modules => Topic started by: Amigamerlin on May 16, 2010, 09:27:11

Title: (Solved) Strange Problem with mod_smf_recent_topics_sa
Post by: Amigamerlin on May 16, 2010, 09:27:11
Hello to all.. I hope someone can help me.
I'm facing a strange problem using mod_smf_recent_topics_sa.

I've an ELXIS site instellad in a subfolder Root/web and a SMF forum installed under Root/forum. 
Both applications use 2 different database. SMF in a database called Sql_XXXXX_2 and  - ELXIS in database Sql_XXXXX_1 
I've installed mod_smf_recent_topics_sa and according to the post found here:

https://forum.elxis.org/index.php?topic=2892.0 

I've changed the line :
$this->smfpath = $mosConfig_absolute_path.$this->modparams['path']; 
With $this->smfpath = '/Root/forum'; 

All went ok.. enabling the module I can read the latest SMF post and if I click on it redirect me in the interested post but in the module pubblished below in the same position (login module in that case) I've this error: 

mysql Error [1146] : EXECUTE
URI: index.php
Message: Table 'Sql_XXXXX_2.elx_users' doesn't exist
SELECT name, avatar FROM elx_users WHERE id='62' LIMIT 0,1 

In that case was login module but wichever module I pubblish after SMF goes in error and starting from there all module goes in error. If I disable SMF all went ok. As you all can read It's like ELXIS stay with the SMF database searching data that obviusly are in the other database and don't switch back to the other db. In fact the ELXIS is installed with the  Sql_XXXXX_1 Db . 

Anyone can try to help me ?

Thank you.
Title: Re: Strange Problem with mod_smf_recent_topics_sa
Post by: datahell on May 16, 2010, 10:16:13
After module execution elxis stays connected to the smf database. It needs a small modification to solve this issue.
I will try to find some time to check this today.
Title: Re: Strange Problem with mod_smf_recent_topics_sa
Post by: Amigamerlin on May 16, 2010, 10:34:35
Thank you Datahell... I know you are really busy ...
Title: Re: Strange Problem with mod_smf_recent_topics_sa
Post by: datahell on May 16, 2010, 11:49:20
OK, here is a new version (1.2) of the module.
Test it and please tell me if it works OK in order to update the listing on EDC.
I did nt tested it.

[attachment deleted by admin]
Title: Re: Strange Problem with mod_smf_recent_topics_sa
Post by: Amigamerlin on May 16, 2010, 13:06:20
Fantastic !!! All is working now. :)
Thanks again for your availability.
Bye
Title: Re: (Solved) Strange Problem with mod_smf_recent_topics_sa
Post by: datahell on May 16, 2010, 13:14:00
The module SMF Recent topics SA (http://www.elxis-downloads.com/downloads/forums/121.html) was updated in EDC to version 1.2.
Thank you Amigamerlin for your help.