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

[Coyote23]

My provider just upgraded thier platform - but after my site was transitioned I get the following error when trying to enter a forum:

SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username, p3.poster_id AS my_reply_id FROM (phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_users u2 LEFT JOIN phpbb_posts p3 ON p3.topic_id = t.topic_id AND p3.poster_id = 2) WHERE t.forum_id = 2 AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u2.user_id AND t.topic_type = 2 GROUP BY p.post_id ORDER BY t.topic_last_post_id DESC

Line : 296
File : viewforum.php

If I go to a poster's profile and "FInd all posts by..." I can view that post. My site has been down 5 days and my provider's support team is providing no help at all.

Thanks.

[Lumpy Burgertushie]

let me guess.... Ipowerweb.

robert

[T0ny]

Try changing

Code: Select all

FROM (phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_users u2 LEFT JOIN phpbb_posts p3 ON p3.topic_id = t.topic_id AND p3.poster_id = 2) WHERE

to

Code: Select all

FROM (phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_users u2) LEFT JOIN phpbb_posts p3 ON p3.topic_id = t.topic_id AND p3.poster_id = 2 WHERE

[Coyote23]

let me guess.... Ipowerweb.

Yep the one and only. It has been 6 days now and no help. Last time I was down it took them 3 weeks to figure things out, I have a large forum database that they have queries/hour limits...

[Coyote23]

Try changing...

Thanks T0ny - but I basically get the same error message with the parentheses in the new position:

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

SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username, p3.poster_id AS my_reply_id FROM (phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_users u2 LEFT JOIN phpbb_posts p3 ON p3.topic_id = t.topic_id AND p3.poster_id = -1) WHERE t.forum_id = 20 AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u2.user_id AND t.topic_type = 2 GROUP BY p.post_id ORDER BY t.topic_last_post_id DESC

Line : 296
File : viewforum.php

[stevemaury]

Habe you used phpMyAdmin to look at the database and confirm that there is a topic_id field in the topics table and the its datatype is mediumint(8) and that it has an auto-increment property?

[Coyote23]

Oops - wrong line - but still needed the change to the second instance.
Thank you so much T0ny. You are a life saver and all my friends at eOmahaForums will also be in debt to you!
You guys are the best!!!

[Coyote23]

Habe you used phpMyAdmin to look at the database and confirm that there is a topic_id field in the topics table and the its datatype is mediumint(8) and that it has an auto-increment property?

Yes I did. That is why I knew something else was wrong. But thanks for the suggestion Steve. We are up and running again.

[Lumpy Burgertushie]

Habe you used phpMyAdmin to look at the database and confirm that there is a topic_id field in the topics table and the its datatype is mediumint(8) and that it has an auto-increment property?

Yes I did. That is why I knew something else was wrong. But thanks for the suggestion Steve. We are up and running again.

now, be smart, start looking for a new host. Ipowerweb is in the top 3 worst hosts in the world.

robert

[Coyote23]

now, be smart, start looking for a new host. Ipowerweb is in the top 3 worst hosts in the world.

And now I know why. Is their a list of hosts here that people recommend - particularly one that could transfer all my files for me

Thanks for everyone's help!!! You guys came through again for me.

[stevemaury]

http://www.hostingtalk.com

[Coyote23]

http://www.hostingtalk.com

Thanks Steve!

[moodgard]

http://www.hostingtalk.com

I went to that site, and it had a banner ad for ipowerweb!

I go to http://www.webhostingtalk.com , it's massive; maybe that's the one you meant.

[Rafter]

Lumpy, hi again.

I saw that smbdy had equal problem as me - and, how funny, almost the same avatar as me. ))))))))

I*ll try the same solution as you suggested him.

Hear you soon.

[Rafter]

BTW, my host is Hostgator (Texas, USA).