News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SOLVED] Problem when click on unread posts link

Started by 3nd3r, January 05, 2007, 04:04:04 AM

Previous topic - Next topic

3nd3r

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 , 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:
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
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... ???

Daniel15

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)?
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

3nd3r

Here you are.
Thanks for your quick answer!  :)

3nd3r

#3
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!

3nd3r

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.

3nd3r

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...


KGIII

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.

My PC Support Forum
Please ask in-thread before PMing
                   SMF Help
                   Visit My Blog

How can we improve the support process?:
http://www.simplemachines.org/community/index.php?topic=163533.0

SMF vs. Godzilla? Who do you think will win?

3nd3r

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

:)

KGIII


My PC Support Forum
Please ask in-thread before PMing
                   SMF Help
                   Visit My Blog

How can we improve the support process?:
http://www.simplemachines.org/community/index.php?topic=163533.0

SMF vs. Godzilla? Who do you think will win?

Advertisement: