PDA

View Full Version : DEBUG MODE help please


Gizmo
01-03-2008, 05:43 AM
Hi the techy guy for my forum is on his jollies and I need a fix for this problem.
Its all foreign to me so will need and a step through in simple terms please as I don't even know where to look .:confused:
I have done a support ticket but not had a reply yet.



SQL requests not achieved

DEBUG MODE

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

SQL Request: SELECT t.*, p.post_text as hover_post FROM phpbb_topics t, phpbb_forums f LEFT JOIN phpbb_posts_text p ON p.post_id = t.topic_last_post_id WHERE f.forum_id = t.forum_id AND (f.forum_order BETWEEN 0 AND 1740) AND f.forum_id <> 0 ORDER BY t.topic_last_time DESC LIMIT 5

Line : 105
File : class_topics_recent.php

Thanks in advance

Basil
01-03-2008, 07:18 AM
What is line 105 in class_topics_recent.php?

Is this from a mod or something? What did you do before this error occured?

Gizmo
01-03-2008, 09:04 AM
What is line 105 in class_topics_recent.php?

Is this from a mod or something? What did you do before this error occured?

Well we have a recent last 5 post that show up at top of forum but its been there for aslong as we have. I went offline for a couple of hours last night (UK time) and it was offline when I cameback on, live tech did say they were working on Boxes that included mine 33 and since it cameback had that error, the other sites on domain are ok.

Edit all other pages load up its just the one to the forum main index page

Gizmo
01-04-2008, 11:56 AM
Just an update

The problem is still there so had to re direct to another forum we were setting up. The server wont touch the scripts as they are custom ones done by my techy partner.

Anyway looking through a few other posts its looks like its connected to the update the server has been doing and the software we have is no longer compatable to it. I maybe wrong but the server did a back up for me the most recent one would have been 10 hours and problem would have still been there so had to go back to 20th of December which you would have thought would solve it, it hasn't so upgrade is all I can put it down to.