I have trouble here and on my site with the "Unread Posts" link from SMF.
From my website I get this randomly, if I refresh eventually I get the recent topics correctly:
Quote
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 File: /home/myfolder/public_html/simpleMachines/Sources/Recent.php Line: 742
And here I get a database error, I am assuming its the same error since if you just keep trying it works.
Quote
Database Error Please try again. If you come back to this error screen, report the error to an administrator.
If it's any help, if I click on the "Show new replies to your posts" link it always works, and it makes the "Show unread posts since last visit." link work everytime.
i'm getting this error too - it didn't work before but since the last joomla upgrade it seems to show more errors. the strange thing is that if you keep trying then after a few attempts it works - but on the first attemp it always shows the 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 ml.ID_MSG = t.ID_LAST_MSG AND IFNULL(lt.logTime, IFNULL(lmr.logTime, 0))' at line 7 File: /home/masyomo/public_html/board/Sources/Recent.php Line: 742
My best guess for this one, since you can create a pattern of when it won't work (like right after login) is that the "SQL Syntax error" is really because there is missing data... I haven't dug into yet, but I'm guessing a cookie issue where it's asking for the var that holds the last visit time is empty or improperly formatted. This holds true until you click on or login using something that sets the value correctly then the recent posts start working.
Just a guess in case someone else wants to look at it.
This error is due to some session issue. The thing is it's not happening here. maybe I just don't catch it. I will try to work on this issue this weekend. But i can't promise, I've just been really busy with my job and family. Hopefully I can release 1.0.2 this weekend with the session sync issue fixed.
Here's how: Logout. Then click on login on the top right (which is your joomla login, you can't make this happen with the SMF stock login box). Do not do anything else except enter the forum and click on the link "Show unread posts since last visit." Do not click on "Show new replies to your posts." first or you won't see the error. Your error apparently does not have the SQL error mentioned, but then again all it says is "Database error". I am assuming you have changed it for security reasons not to dump the SQL error code.
I've noticed that if you actively move around your site or my site, at some point the session gets fixed up and everything will work as it is supposed to.
This issue has no pattern at all! Sometimes I get this message directly after login and othertimes after a while using the forum!
And yes, itīs reproduceable here by login via login-module:
Quote
Database Error Please try again. If you come back to this error screen, report the error to an administrator.
Edit: This error also happens with the other *ambo/joomla-smf-bridge from ostio. Error seems to be gone after klicking some topics or posts and than hitting "Show unread posts since last visit." Very strange...
« Last Edit: October 21, 2005, 07:06:44 PM by Sorian »
Here's how: Logout. Then click on login on the top right (which is your joomla login, you can't make this happen with the SMF stock login box). Do not do anything else except enter the forum and click on the link "Show unread posts since last visit." Do not click on "Show new replies to your posts." first or you won't see the error. Your error apparently does not have the SQL error mentioned, but then again all it says is "Database error". I am assuming you have changed it for security reasons not to dump the SQL error code.
I've noticed that if you actively move around your site or my site, at some point the session gets fixed up and everything will work as it is supposed to.
Joel
The fix I did for this was to set something in session. I guess something is still wrong with it. I have to check my fix again.
I logged in, clicked on a couple posts (this being the second one).. saw you asked me to check to see if I still had problems here, so I clicked on your "unread since last visit" link and got this again:
Quote
Database Error Please try again. If you come back to this error screen, report the error to an administrator.
I logged in, clicked on a couple posts (this being the second one).. saw you asked me to check to see if I still had problems here, so I clicked on your "unread since last visit" link and got this again:
Clicked on it a second time, works fine.
Joel
I cannot duplicate this error on Joomlahacks forums...
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
If not, I don't know now!
