Elxis CMS Forum

Extensions => Modules => Topic started by: de-active on September 18, 2009, 03:42:28

Title: SMF Forum New Topic Module: Error
Post by: de-active on September 18, 2009, 03:42:28

Hi all,

I'm testing bits and bob with Elxis and it's sub modules and components. Currently I've installed SMF forum and also the Elxis show current topic of SMF but I got this error:

Quote

mysql Error [1054] : EXECUTE
There is nothing to show!

Full details:

Quote

URI: index.php
Message: Unknown column 'mem.realName' in 'field list'
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, 1 AS isRead, 0 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) WHERE t.ID_LAST_MSG = m.ID_MSG AND b.ID_BOARD = t.ID_BOARD AND ms.ID_MSG = t.ID_FIRST_MSG ORDER BY t.ID_LAST_MSG DESC LIMIT 0,10

I do have topics in the SMF forum ...can anyone help? Thanking you in advance.
de-active  ;D

Title: Re: SMF Forum New Topic Module: Error
Post by: datahell on September 18, 2009, 19:48:10

I guest that current version of SMF has different column names.
Go to your phpmyadmin and check if column realName exists in table smf_members
If not, then which is the column that stores user's name? Find that column and update the module's source code.

Title: Re: SMF Forum New Topic Module: Error
Post by: de-active on October 07, 2009, 18:34:09

It's been a while and finally I've taken the big step of looking under the hood....

the column realName has been renamed 'real_name' in the latest version of SMF, so I've changed that on the source code of the Elxis SMF Forum New Topic Module (the mod_smf_recent_topics_sa.php file) BUT...

I still get errors, which at the moment is:

Code: [Select]

mysql Error [1054] : EXECUTE
URI: index.php
Message: Unknown column 'm.posterTime' in 'field list'
SELECT mem.real_name, 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.real_name, m.posterName) AS posterName, 1 AS isRead, 0 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) WHERE t.ID_LAST_MSG = m.ID_MSG AND b.ID_BOARD = t.ID_BOARD AND ms.ID_MSG = t.ID_FIRST_MSG ORDER BY t.ID_LAST_MSG DESC LIMIT 0,10
There is nothing to show!
I can't find m.posterTime....which I assume is a new field or column in the new version of SMF but has not been taken into account with the Elxis SMF Module?

Thanking you in advance...