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 'AND ml.ID_MSG = t.ID_LAST_MSG AND IFNULL(lt.logTime, IFNULL(lmr.logTime, 0))' at line 7 File: /home/director/public_html/forum/Sources/Recent.php Line: 742
try the latest version of JoomlaSMF Recent topics, 1.4.
Not the same thing. The problem shows up in SMF when clicking on the New Posts and No New Posts icons. From the SMF help text: "The New Posts and No New Posts icons in the leftmost column show registered members whether there have been any new posts to the board since they last read it."
Clicking on that yields the following message: 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 'AND ml.ID_MSG = t.ID_LAST_MSG AND IFNULL(lt.logTime, IFNULL(lmr.logTime, 0))' at line 7 File: /home/director/public_html/forum/Sources/Recent.php Line: 742
ahhh, I see. Is your smf db prefix 'smf_'? SQL syntax errors don't help much since it is usually the line before what is displayed that has the error. I tried to find this on my forums, is this new posts something enabled in admin? I modded the source file to display the SQL before it executes it but I can't find where to enable the button to trigger it.
Ok, got the exact SQL to echo but it is very specific to my site. If you want, make a backup of Recent.php under /home/director/public_html/forum/Sources/. Copy it to Recent.php.orig. Then upload the attached file(unzip it first of course) and copy it into /home/director/public_html/forum/Sources/. Then click the updated topics button/link and it will simply display the SQL it is trying to execute. After capturing the SQL revert back to the Recent.php.orig file.
You can use this SQL and connect to php myadmin or similar tool to execute it manually. See what the results are... that might help in diagnosing the problem.
Click on one of the icons on the left of a forum that isn't faded (meaning there are new topics within that forum).
The result for me at least is a database error (I've included a pic of this below). JoomlaHacks doesn't show the error, only that there was one. On my site, it provides the text that I entered in my prvious message.
Is anyone else still having this problem? I have yet to get it squared away. If it helps at all, I learned tonight that it doesn't happen if I follow these steps: 1. Login with the joomlahacks login module. 2. Directly access the SMF forum by going to http://www.mindgamesonline.net/forums/ 3. Hit the back button on my browser to return to my site's home page
After this, all the links work... the ones in the login module and the ones at the top of the forums index page.
I have the same problem when I click at "New Post" icon.
Quote
Databese Error: 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 'AND IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) < t.ID_LAST_MSG' at line 7 File: /home/xxx/public_html/smf/Sources/Recent.php Line: 748
and new bug with "Insert Quote" button, after click I see quote on the moment and after disappeare. Strange but URL is with "&top" string added. Quick Replay is working OK with quote.
JSMF 1.1 SMF 1.1 RC2 Joomla 1.08
« Last Edit: April 04, 2006, 08:37:20 AM by WaMaR_PL »
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
