Advertisement:

Author Topic: [SOLVED] Problem when click on unread posts link  (Read 5273 times)

3nd3r

  • Guest
[SOLVED] Problem when click on unread posts link
« 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 , 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: [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
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... ???
« Last Edit: January 13, 2007, 07:07:11 AM by 3nd3r »

Offline Daniel15

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,222
  • Gender: Male
  • http://dan.cx/
    • daaniel on Facebook
    • Daniel15 on GitHub
    • daniel15 on LinkedIn
    • @Daniel15 on Twitter
    • Daniel15
Re: Problem when click on unread posts link
« Reply #1 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)?
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

  • Guest
Re: Problem when click on unread posts link
« Reply #2 on: January 05, 2007, 05:46:21 AM »
Here you are.
Thanks for your quick answer!  :)

3nd3r

  • Guest
Re: Problem when click on unread posts link
« Reply #3 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!
« Last Edit: January 08, 2007, 12:15:30 PM by 3nd3r »

3nd3r

  • Guest
Re: Problem when click on unread posts link
« Reply #4 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.

3nd3r

  • Guest
Re: Problem when click on unread posts link
« Reply #5 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...

3nd3r

  • Guest
Re: Problem when click on unread posts link
« Reply #6 on: January 13, 2007, 07:06:44 AM »

Offline KGIII

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,293
  • Gender: Male
  • If you can build it, I can wreck it.
    • Web Hosting
Re: [SOLVED] Problem when click on unread posts link
« Reply #7 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.
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

  • Guest
Re: [SOLVED] Problem when click on unread posts link
« Reply #8 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

 :)
 

Offline KGIII

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,293
  • Gender: Male
  • If you can build it, I can wreck it.
    • Web Hosting
Re: [SOLVED] Problem when click on unread posts link
« Reply #9 on: February 03, 2007, 12:48:58 PM »
Excellent stuff and we're most thankful. :)
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?