SMF Recent Topics 1.7 problem

Home

Forum SMF Recent Topics 1.7 problem

	Welcome, Guest. Please login or register. Did you miss your activation email? January 09, 2009, 06:13:55 AM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 1.1.x (Moderators: -Wolverine, kai920)

SMF Recent Topics 1.7 problem

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: SMF Recent Topics 1.7 problem (Read 3025 times)

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

SMF Recent Topics 1.7 problem

« on: March 09, 2006, 03:58:11 PM »

Hello,

i have a problem with the recent topics. When i login into my page the module have a problem see below:

Code:

Error fetching Recent Topics: 1064 You have an error in your SQL syntax near ') LEFT JOIN smf_log_mark_read AS lmr ON (lmr.ID_BOARD = b.ID_BOARD ' at line 8

When i go to the wrapped forum then i see the last recent topics.

I have tested with annother template but the same problem.

How i can get die Recents on all pages?

By
Holger


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: SMF Recent Topics 1.7 problem

« Reply #1 on: March 09, 2006, 05:10:20 PM »

hmmm, that seems to indicate that ID_MEMBER is empty.... which shouldn't be the case. Either way, try this:

change line 61 in modules/mod_smf_recent_topics.php from this:

Code:

if(empty($user_info['is_guest'])) {

to this:

Code:

if(!$user_info['is_guest'] && (!isset($ID_MEMBER) || empty($ID_MEMBER))) {

Let me know if that works plz.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #2 on: March 10, 2006, 01:04:08 AM »

Hello Wolverine,

i have edit the Line 61 but the Problem is the same
who i post in my first thread.

Thanx
Holger


	Logged

kirck

QA / Testers
Joomla Pro

Karma: +7/-3
Offline

Offline

Posts: 91

Re: SMF Recent Topics 1.7 problem

« Reply #3 on: March 10, 2006, 03:37:34 AM »

Hi Holger,

Can you tell us the versions of your Joomla, SMF and components?


	Logged

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #4 on: March 10, 2006, 04:17:57 AM »

Thats my Versions:

Joomla 1.0.8
SMF 1.1 RC2
SMF Forum 1.1 RC2 patch1
Recent_Topics 1.7
PHP 4.3.5


« Last Edit: March 10, 2006, 04:21:47 AM by Holger »	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: SMF Recent Topics 1.7 problem

« Reply #5 on: March 10, 2006, 08:56:13 AM »

unzip this to the directory modules/

It will simply put the SQL query in the recent topics module. Copy that query and go into phpmyadmin and execute it under SQL. Is it failing there?


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #6 on: March 10, 2006, 09:45:52 AM »

Quote from: -Wolverine on March 10, 2006, 08:56:13 AM

unzip this to the directory modules/

It will simply put the SQL query in the recent topics module. Copy that query and go into phpmyadmin and execute it under SQL. Is it failing there?

I hope this was it what you want?

Code:

SELECT mem.realName, m.posterTime, ms.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, b.ID_BOARD, b.name AS bName, t.numReplies, t.ID_LAST_MSG, IFNULL( mem.realName, m.posterName ) AS posterName, IFNULL( lt.ID_MSG, IFNULL( lmr.ID_MSG, 0 ) ) >= m.ID_MSG_MODIFIED AS isRead, IFNULL( lt.ID_MSG, IFNULL( lmr.ID_MSG, -1 ) ) +1 AS new_from, LEFT( m.body, 384 ) AS body, m.smileysEnabled, m.icon
FROM (

smf_messages AS m, smf_topics AS t, smf_boards AS b, smf_messages AS ms
)
LEFT JOIN smf_members AS mem ON ( mem.ID_MEMBER = m.ID_MEMBER )
LEFT JOIN smf_log_topics AS lt ON ( lt.ID_TOPIC = t.ID_TOPIC AND lt.ID_MEMBER = )
LEFT JOIN smf_log_mark_read AS lmr ON ( lmr.ID_BOARD = b.ID_BOARD AND lmr.ID_MEMBER = )
WHERE t.ID_LAST_MSG >= -175 AND t.ID_LAST_MSG = m.ID_MSG AND b.ID_BOARD = t.ID_BOARD AND AND ms.ID_MSG = t.ID_FIRST_MSG
ORDER BY t.ID_LAST_MSG DESC
LIMIT 5

MySQL meldet:

#1064 - You have an error in your SQL syntax near ')
LEFT JOIN smf_log_mark_read AS lmr ON ( lmr.ID_BOARD = b.ID_BOARD AND lmr.ID' at line 4


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: SMF Recent Topics 1.7 problem

« Reply #7 on: March 10, 2006, 02:52:23 PM »

ok, ID_MEMBER is still not set, which is beyond me. But change line 61 to be:

Code:

if(!isset($ID_MEMBER) || empty($ID_MEMBER)) {


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #8 on: March 11, 2006, 03:19:51 AM »

Quote from: -Wolverine on March 10, 2006, 02:52:23 PM

ok, ID_MEMBER is still not set, which is beyond me. But change line 61 to be:

Code:

if(!isset($ID_MEMBER) || empty($ID_MEMBER)) {

Sorry, but the problem are not fixt with this entry. No ID_Member are give to the script.

Holger


	Logged

joomlanewbie

Joomla Master

Karma: +20/-5
Offline

Offline

Posts: 145

Re: SMF Recent Topics 1.7 problem

« Reply #9 on: March 11, 2006, 09:48:50 AM »

I believe he is not patched properly or at all. The smf functions are not being pre-loaded by his template.

that is why the Recent topics code works when he goes to the forum, because there the SMF code explicitly checks for and includes (if not already included) the relevant (and needed) code


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: SMF Recent Topics 1.7 problem

« Reply #10 on: March 11, 2006, 04:11:36 PM »

good point, you must be using one of the bridges for the SMF recent topics module to work correctly.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #11 on: March 11, 2006, 04:14:05 PM »

I have the component Bridge... but when i patch the joomla.php i can't login into my page and the login modul from joomlahacks dosen't work on my site.


« Last Edit: March 11, 2006, 04:22:57 PM by Holger »	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: SMF Recent Topics 1.7 problem

« Reply #12 on: March 11, 2006, 05:13:51 PM »

Quote from: Holger on March 11, 2006, 04:14:05 PM

I have the component Bridge... but when i patch the joomla.php i can't login into my page and the login modul from joomlahacks dosen't work on my site.

Ok, but you do realize that you waste our time trying to diagnose a problem that is caused by you not completing the installation of the bridge. And that detracts from time improving the bridge on top of taking me away from my personal life. Not be on a soap box here but that isn't fair to the people who are here trying to give support to everyone. Especially myself... Undecided

Now, have you double checked all your settings in SMF? I just pointed out a problem where the individual had mistakenly set the Forum URL under server settings in SMF admin to the Joomla URL which is incorrect. This causes the inability to login and failure of the login module. What is yours set to?


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Holger

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 11

Re: SMF Recent Topics 1.7 problem

« Reply #13 on: March 13, 2006, 02:21:16 AM »

Hello,

i have the new Joomla-SMF Forum 1.1RC2 (p1-3) installes an now i can
patch the joomla.php an i have no problems with the login.

the problem was by the componente and not by the modul.

Holger