RPGDXThe center of Indie-RPG gaming
Not logged in. [log in] [register]
 
 
Post new topic Reply to topic  
View previous topic - View next topic  
Author Message
cowgod
Wandering Minstrel


Joined: 22 Nov 2005
Posts: 114
Location: Pittsburgh, USA

PostPosted: Wed Mar 04, 2009 6:17 pm    Post subject: Unread Topics [quote]

For the past week or so, I've gotten an error message every time I click on the unread posts link. I didn't have time to post about it before, but I think it's time that I did.

It's strange that no one else has already posted about it.

Here is the message:

General Error

Could not obtain search results

DEBUG MODE

SQL Error : 1054 Unknown column 't.topic_id' in 'on clause'

SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time , IFNULL(r.read_time, 0) AS read_time FROM phpbb_topics t, phpbb_forums f, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 LEFT JOIN phpbb_reads r ON t.topic_id = r.read_topic_id AND r.read_user_id = 646 WHERE t.topic_id IN (2012, 2095, 2103, 2107, 2111, 2115, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY p2.post_time DESC LIMIT 0, 25

Line : 796
File : search.php
Back to top  
Ninkazu
Demon Hunter


Joined: 08 Aug 2002
Posts: 945
Location: Location:

PostPosted: Wed Mar 04, 2009 7:01 pm    Post subject: [quote]

Dupe.

(i.e. it's been noted)
Back to top  
Bjørn
Demon Hunter


Joined: 29 May 2002
Posts: 1424
Location: Germany

PostPosted: Sun Mar 08, 2009 5:21 pm    Post subject: [quote]

Yep, it's broken somehow (related to MySQL upgrade I think), but I don't have time to fix it. The code is out there if you want to have a look yourself:

http://gitorious.org/projects/rpgdx

Last thing I did was disabling a similar custom query in viewforum.php to at least allow browsing the forums again.
Back to top  
Hajo
Demon Hunter


Joined: 30 Sep 2003
Posts: 779
Location: Between chair and keyboard.

PostPosted: Mon Mar 23, 2009 9:28 am    Post subject: [quote]

Can we just upgrade the whole forum to a new software?

I wouldn't mind if the looks change a bit, because of a no-longer working template or so ... the accumulating number of unread threads make it hard to find new messages :/
Back to top  
DeveloperX
202192397


Joined: 04 May 2003
Posts: 1624
Location: Decatur, IL, USA

PostPosted: Thu Mar 26, 2009 2:22 pm    Post subject: [quote]

Just emailed Bjorn about a possible fix.
_________________
Principal Software Architect
Rambling Indie Games, LLC

See my professional portfolio
Back to top  
DeveloperX
202192397


Joined: 04 May 2003
Posts: 1624
Location: Decatur, IL, USA

PostPosted: Thu Mar 26, 2009 11:08 pm    Post subject: [quote]

Just wanted to say that I solved the issue, and Bjorn implemented my patch. No more ugly error.
:)
_________________
Principal Software Architect
Rambling Indie Games, LLC

See my professional portfolio
Back to top  
Hajo
Demon Hunter


Joined: 30 Sep 2003
Posts: 779
Location: Between chair and keyboard.

PostPosted: Fri Mar 27, 2009 10:02 am    Post subject: [quote]

Thanks a lot :)
Back to top  
DeveloperX
202192397


Joined: 04 May 2003
Posts: 1624
Location: Decatur, IL, USA

PostPosted: Fri Mar 27, 2009 12:16 pm    Post subject: [quote]

Hajo wrote:
Thanks a lot :)


Like I've always said; I'm here to help out in any way that I can.
I fully support this community, even though I am trying to grow my own indie game development community; my forums are oriented more towards educating people. I love RPGDX. I will do whatever I can to make it a better place. :)
_________________
Principal Software Architect
Rambling Indie Games, LLC

See my professional portfolio
Back to top  
RedSlash
Mage


Joined: 12 May 2005
Posts: 331

PostPosted: Sun Mar 29, 2009 8:08 am    Post subject: [quote]

What was the issue?
Back to top  
DeveloperX
202192397


Joined: 04 May 2003
Posts: 1624
Location: Decatur, IL, USA

PostPosted: Sun Mar 29, 2009 12:30 pm    Post subject: [quote]

RedSlash wrote:
What was the issue?


MySQL 5 changed the syntax that it accepts for JOINs.
_________________
Principal Software Architect
Rambling Indie Games, LLC

See my professional portfolio
Back to top  
Post new topic Reply to topic Page 1 of 1 All times are GMT
 



Display posts from previous:   
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum