Home arrow Forum [FIXED] database error when trying to access unread posts
  Welcome, Guest. Please login or register.
Did you miss your activation email?
December 03, 2008, 12:03:57 AM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 1.0.x (Moderators: -Wolverine, kai920)
| | | |-+  [FIXED] database error when trying to access unread posts
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: [FIXED] database error when trying to access unread posts  (Read 2406 times)
kai920
Moderator
Joomla Expert
*****

Karma: +14/-2
Offline Offline

Posts: 275



View Profile
[FIXED] database error when trying to access unread posts
« on: September 29, 2005, 06:48:40 AM »

Hey Cowboy,

My host mistakenly deleted config.smf.php!!!  Roll Eyes Angry

So I had to upload a blank copy of config.smf.php as well as the fixed functions.smf.php, and re-ran the component configuration in Joomla. I didn't have to do all the steps as I did in the first installation, but the checklist looks good.  Is this okay, and were things screwed up by deleting my config.smf.php?

I also get this database error when trying to access unread posts.  Note I only get this when logged in as the admin

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/mydomain/public_html/forums/Sources/Recent.php
Line: 742

when logged in as a normal user, i get this:

Quote
Please try again. If you come back to this error screen, report the error to an administrator.
« Last Edit: September 29, 2005, 12:21:03 PM by cowboy » Logged

Editor (cowboy)
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1144



View Profile WWW
Re: Doh!
« Reply #1 on: September 29, 2005, 10:56:35 AM »

i'm investigating this right now, somehow i thought this was fixed when I tested it yesterday.

EDIT:
Here's a temporary solution:
Please go to SMF Admin / "Features and Options"
Uncheck "Use database driven sessions".

Somehow, the unread sql is not passed properly. That's why you get that sql error. Just do the above config first while i'm further investigating it.

EDIT:
Get the new file from the announcements board / change log
« Last Edit: September 29, 2005, 12:21:50 PM by cowboy » Logged
kai920
Moderator
Joomla Expert
*****

Karma: +14/-2
Offline Offline

Posts: 275



View Profile
Re: [FIXED] database error when trying to access unread posts
« Reply #2 on: September 29, 2005, 02:13:20 PM »

Works now, thanks cowboy  Cheesy
Logged

Gandalf
Joomla Master
***

Karma: +4/-0
Offline Offline

Posts: 131



View Profile WWW
Re: [FIXED] database error when trying to access unread posts
« Reply #3 on: October 08, 2005, 08:47:04 PM »

Hello there,

I am using the latest version of Joomla 1.0.2, SMF 1.1 and Joomla-SMF 1.0.1b

Server : Debian Sarge
PHP : PHP 4.3.10-16
MySQL : 12.22 Distrib 4.0.24

I didn't get this error, but somehow almost all users are getting it Shocked i don't know why

P.S: "Use database driven sessions" is checked...
Logged
draysniro
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 19


View Profile
Re: [FIXED] database error when trying to access unread posts
« Reply #4 on: November 08, 2005, 03:37:58 AM »

Ok, I was wondering if anyone else is still getting this error. I just installed the newest version of the Component (I think... 1.0.2a) on my Joomla 1.0.3. I installed the arcade mod for SMF before trying to post, but I'm getting this error when I try to read a new post. I have uninstalled the Arcade (I can't get it to work anyway bc Joomla won't let me execute the database file) but it still is messed up.

Platform: Apache
PHP: 4.3.10
MySQL: 4.025-standard
Joomla: 1.0.3
SMF: 1.1 RC1
URL: http://draysniro.com
Logged
Editor (cowboy)
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1144



View Profile WWW
Re: [FIXED] database error when trying to access unread posts
« Reply #5 on: November 08, 2005, 09:43:51 AM »

gandalf/gray,

how did you guys get this error? by clicking the board button?
Logged
draysniro
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 19


View Profile
Re: [FIXED] database error when trying to access unread posts
« Reply #6 on: November 08, 2005, 04:09:06 PM »

I got it just by clicking on the link to the discussion.

I think mine is a little different though...

Database 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 '' at line 1
File: /home/xxxxx/public_html/forum/Sources/Display.php
Line: 691
Logged
draysniro
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 19


View Profile
Re: [FIXED] database error when trying to access unread posts
« Reply #7 on: November 10, 2005, 11:28:03 PM »

Ok, I just figured out that it's only doing this when I install the arcade mod in SMF. I uninstalled it and it works again...hmm
Logged
Editor (cowboy)
Administrator
Joomla Guru
*****

Karma: +86/-23
Offline Offline

Posts: 1144



View Profile WWW
Re: [FIXED] database error when trying to access unread posts
« Reply #8 on: November 10, 2005, 11:33:54 PM »

Remember, you have to unpatch first the smf files then repatch after you install the mod.
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

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
Joomla Hacks



Joomla Hacks
German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
Search Contact About Advertise Blogs Topsites Submit News Register Login