Not sure what is up with mine over Benediktus's, This is the latest error, would it be easier if you had direct access to my site? Thanks again for all you do.
Code:
Error fetching Recent Topics: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.ID_MSG DESC LIMIT 5' at line 30
SELECT mem.realName, m.posterTime, m2.subject, t.ID_TOPIC, t.ID_MEMBER_UPDATED, t.ID_LAST_MSG, m.ID_MSG_MODIFIED, m.ID_BOARD, b.name AS bName, t.numReplies, m.posterName AS memberName, IFNULL( lt.ID_MSG, IFNULL( lmr.ID_MSG, -1 ) ) +1 AS new_from FROM (
smf_members AS mem, smf_topics AS t, smf_messages AS m, smf_messages AS m2, smf_boards AS b 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 = t.ID_BOARD AND lmr.ID_MEMBER = '' ) ) WHERE t.ID_BOARD = m.ID_BOARD AND t.ID_BOARD = b.ID_BOARD AND t.ID_LAST_MSG = m.ID_MSG AND t.ID_FIRST_MSG = m2.ID_MSG AND mem.memberName = m.posterName AND ORDER BY m.ID_MSG DESC LIMIT 5
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.ID_MSG DESC LIMIT 5' at line 1
SELECT mem.realName, m.posterTime, m2.subject, t.ID_TOPIC, t.ID_MEMBER_UPDATED, t.ID_LAST_MSG, m.ID_MSG_MODIFIED, m.ID_BOARD, b.name AS bName, t.numReplies, m.posterName AS memberName, IFNULL( lt.ID_MSG, IFNULL( lmr.ID_MSG, -1 ) ) +1 AS new_from FROM (
smf_members AS mem, smf_topics AS t, smf_messages AS m, smf_messages AS m2, smf_boards AS b 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 = t.ID_BOARD AND lmr.ID_MEMBER = '' ) ) WHERE t.ID_BOARD = m.ID_BOARD AND t.ID_BOARD = b.ID_BOARD AND t.ID_LAST_MSG = m.ID_MSG AND t.ID_FIRST_MSG = m2.ID_MSG AND mem.memberName = m.posterName AND ORDER BY m.ID_MSG DESC LIMIT 5
Not much I can do about this. $user_info is not global and I cannot get SMF information from Joomla/Mambo. $user_info is how I get the ID_MEMBER and the info on what this user has permission to view. If it isn't global at this point then I don't know that there is any way to get those. I will look around.
Do you think this has something to do with the com_connector that I have been forced to use? I would really like to use cowboys but since it no longer works and my forums have been down for about a month now I had to do soemthing else in the interim. Do you have anykind of time line for an update to the bridge?
I have seen a lot of references both here and on other boards that people are waiting on Joomla 1.1 but I have not seen any firm dates for that yet. The road map says Q1 2006 but that could be up to 2 months from now.
Again thanks for all you are doing. Have a great day,
Error fetching Recent Topics: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.ID_MSG DESC LIMIT 5' at line 30
What if try Orstio's "Bridge Mambo,Joomla SMF 1.1 RC2.zip". You know where is to download? Yes SMF forum. Please read "readme.html" file first, and good luck!
It's a nice bridge but does not support Community Builder. Most of the time they are even hostile towards even discussing it so that is not a solution for me. Thanks
Warning: main(/home/whbl/www/www/administrator/components/com_smf/config.smf.php): failed to open stream: No such file or directory in /home/whbl/www/www/modules/mod_smf_recent_topics.php on line 31
Warning: main(/home/whbl/www/www/administrator/components/com_smf/config.smf.php): failed to open stream: No such file or directory in /home/whbl/www/www/modules/mod_smf_recent_topics.php on line 31
Fatal error: main(): Failed opening required '/home/whbl/www/www/administrator/components/com_smf/config.smf.php' (include_path='.:/usr/local/lib/php') in /home/whbl/www/www/modules/mod_smf_recent_topics.php on line 31
Can anyone immediately see what's happening?
I am NOT using the bridge, but would still very much like to see the most recent topics via a Joomla module on the front page.
For this module, and most of the other joomla_smf modules, you will need them both on the same db. At least for now, maybe in the future I cna adapt them to work on two separate dbs, but for now it needs to be one to use it. Which bridge or connector are you using. Many times I can take a look at how they implemented the two separate db functionality and mimic it for the modules. Don't expect anything soon though... I've been extremely busy lately, sorry...
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved. Terms of Use
Author
Forum
Logged
).
