Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: 3nd3r on January 05, 2007, 04:04:04 AM

Title: [SOLVED] Problem when click on unread posts link
Post by: 3nd3r on January 05, 2007, 04:04:04 AM
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:
Code: [Select]
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:
Code: [Select]
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... ???
Title: Re: Problem when click on unread posts link
Post by: Daniel15 on January 05, 2007, 04:55:05 AM
Hi,
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 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)?
Title: Re: Problem when click on unread posts link
Post by: 3nd3r on January 05, 2007, 05:46:21 AM
Here you are.
Thanks for your quick answer!  :)
Title: Re: Problem when click on unread posts link
Post by: 3nd3r on January 07, 2007, 12:05:14 PM
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:
Code: [Select]
8: Undefined index: ID_MSG_LAST_VISIT
Archivo: .../public_html/Sources/Recent.php
Línea: 754
Code: [Select]
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!
Title: Re: Problem when click on unread posts link
Post by: 3nd3r on January 08, 2007, 12:13:30 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.
Title: Re: Problem when click on unread posts link
Post by: 3nd3r on January 11, 2007, 06:23:54 AM
SOLVED
- 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...
Title: Re: Problem when click on unread posts link
Post by: 3nd3r on January 13, 2007, 07:06:44 AM
Main problem (see above) solved!

http://www.simplemachines.org/community/index.php?topic=129739.msg906205#msg906205
Title: Re: [SOLVED] Problem when click on unread posts link
Post by: KGIII on February 03, 2007, 05:58:23 AM
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.
Title: Re: [SOLVED] Problem when click on unread posts link
Post by: 3nd3r on February 03, 2007, 09:08:54 AM
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
Code: [Select]
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:
Code: [Select]
- 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:
Code: [Select]
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

 :)
 
Title: Re: [SOLVED] Problem when click on unread posts link
Post by: KGIII on February 03, 2007, 12:48:58 PM
Excellent stuff and we're most thankful. :)