SMF Version: SMF 1.1.1
Hello.
I'm using Alienation1.1 Theme
My forum is http://www.pajareo.net
The problem is that when you click on any 'balloon' to see new unreaded posts (http://www.pajareo.net/index.php?action=unread;board=10.0 (http://www.pajareo.net/index.php?action=unread;board=10.0), for example) or in your personal box's unreaded post link (http://www.pajareo.net/index.php?action=unread (http://www.pajareo.net/index.php?action=unread)), as admin I get this 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
Archivo: .../public_html/Sources/Recent.php
Línea: 755
So, I've posted this problem to the Theme's creator. He told me about duplicate and translate two files:
Only two files in .../public_html/Themes/alienation11final/languages :
Modifications.english.php
Settings.english.php
So, I've copied this two, rename and translate them, then this folder shows this four files:
Modifications.english.php
Modifications.spanish.php
Settings.english.php
Settings.spanish.php
As you can see in http://www.simplemachines.org/community/index.php?topic=104626.msg890315#msg890315 (http://www.simplemachines.org/community/index.php?topic=104626.msg890315#msg890315)
And, well, by a few hours the problem is gone... And now is back again!
Any idea? I've refreshed my browser's cache and still unsolved... ???
Hi,
QuoteYou 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
Archivo: .../public_html/Sources/Recent.php
Línea: 755
That sounds like it may be a problem in Recent.php. Could you please attach your Recent.php here (if you can't attach it, could you pleas epaste lines 760 - 780 from it)?
Here you are.
Thanks for your quick answer! :)
No ideas on what's happen?
Well, I'm getting two more errors... [My forum is melting down?¿? 8) ] I resume all with a bit of more info:
SMF Version: SMF 1.1.1
Using Alienation1.1final Theme
My forum is http://www.pajareo.net
The problem is that when you click on any 'balloon' to see new unreaded posts (http://www.pajareo.net/index.php?action=unread;board=10.0 , for example) or in your personal box's unreaded post link (http://www.pajareo.net/index.php?action=unread), as admin I get TWO errors. I paste them as they're shown in forum error log window:
8: Undefined index: ID_MSG_LAST_VISIT
Archivo: .../public_html/Sources/Recent.php
Línea: 754
Error en la Base de Datos: 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
Archivo: .../public_html/Sources/Recent.php
Línea: 755
AND I have these problems too:
- I log as admin, logout, close browser, open browser, clear browser cache, log in as user, and admin (me) still logged!
- Can't reach to 2nd page on thread when click on 2nd thread page number showed on top on thread... It only shows first page!! Nobody can go to next page!
Quote from: 3nd3r on January 07, 2007, 12:05:14 PM- I log as admin, logout, close browser, open browser, clear browser cache, log in as user, and admin (me) still logged
Solved... This was my fault... I've not seen the 'expire' option. I apologize for this.
SOLVED
Quote from: 3nd3r on January 07, 2007, 12:05:14 PM- Can't reach to 2nd page on thread when click on 2nd thread page number showed on top on thread... It only shows first page!! Nobody can go to next page!
I've unmarked this option:
Administration > Options > Basic Features > Show URLs without ?s
Problem solved
Only one more got unsolved...
Main problem (see above) solved!
http://www.simplemachines.org/community/index.php?topic=129739.msg906205#msg906205
Hi.
I am checking older posts. I see that the main problem was solved. Did you manage to ever resolve the second one? If not then could you go into a bit of detail and someone will surely try to take a look at it.
Ok. This was my fault. I wasn't as clear as I could. So, let's go to clarify this.
Problem #1: About unread post link
The problem is that when you click on any 'balloon' to see new unreaded posts
(http://www.pajareo.net/index.php?action=unread;board=10.0 , for example) or in your personal box's unreaded post link
(http://www.pajareo.net/index.php?action=unread), as admin I get this error:
Code:
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
Archivo: .../public_html/Sources/Recent.php
Línea: 755
SOLVED HERE: http://www.simplemachines.org/community/index.php?topic=129739.msg906205#msg906205
Problem #2:
- I log as admin, logout, close browser, open browser, clear browser cache, log in as user, and admin (me) still logged!
SOLUTION: Check the 'expire' option in Admin options
Problem #3:
Can't reach to 2nd page on thread when click on 2nd thread page number showed on top on thread...
It only shows first page!! Nobody can go to next page!
SOLUTION: Unmark this option:
Administration > Options > Basic Features > Show URLs without ?s
:)
Excellent stuff and we're most thankful. :)