A Place Thread not working

news about changes and fixes to the board, and a place to post any technical queries.

Moderator: staff

Post Reply
User avatar
SilverStarG
post laureate
post laureate
Posts: 10289
Joined: Sat May 07, 2005 11:44 pm
Location: Homewood, IL, US
Contact:

A Place Thread not working

Post by SilverStarG » Sat Jul 09, 2005 8:30 pm

Can't get into Coritiacus's place..

Could not obtain post/user information.

DEBUG MODE

SQL Error : 1030 Got error 127 from table handler

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 71226 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 10540, 20

Line : 398
File : viewtopic.php

viewtopic.php?p=1581898&sid=026781d8886 ... 51#1581898

User avatar
Laura
board admin emeritus
board admin emeritus
Posts: 8676
Joined: Mon Nov 19, 2001 1:00 am
Location: Scotland
Contact:

Post by Laura » Sat Jul 09, 2005 8:39 pm

That's very odd.
I managed to get to the first page viewtopic.php?t=71226 but trying to reach any other pages gave the error you describe.

Don't know how to fix - looks like a job for Deb or a techie person.
<center>
I feel <a href="http://www.imood.com/users/snail"><img src="http://moods.imood.com/display/uname=sn ... /imood.gif" alt="The current mood of snail at imood.com" border="0"></a>

<a href="http://www.irrepressible.info"><img src="http://uk.geocities.com/floor_sitter/im ... nner_5.gif" alt="Irrepressible.info"></a></center>

User avatar
GLaDOS
ticket inspector
ticket inspector
Posts: 31075
Joined: Wed Dec 15, 2004 1:56 am
Contact:

Post by GLaDOS » Sat Jul 09, 2005 9:59 pm

i can't access it either :-?
This was a triumph.

User avatar
guest11
staff member emeritus
staff member emeritus
Posts: 3984
Joined: Thu Apr 24, 2003 6:35 pm

Post by guest11 » Sat Jul 09, 2005 11:06 pm

I'm only new to SQL... but it looks like a problem with a database table called "posts"... I think it can't get information about the users who have posted. I dunno.

User avatar
mallie
board admin emeritus
board admin emeritus
Posts: 10443
Joined: Mon Sep 22, 2003 12:38 pm
Gender: Female
Location: Sydney, Australia

Post by mallie » Sun Jul 10, 2005 2:42 pm

Could it be something to do with length?

I know that Felo and Human over on Arc got archived because there were issues with the length of things, maybe there is something like that going on?

User avatar
mark
one of us
one of us
Posts: 22
Joined: Wed Nov 27, 2002 2:17 am

Post by mark » Sun Jul 10, 2005 5:18 pm

Should be fixed now, let me know if it's not. It was caused by mysql managing to mangle one of its index files.

Data doesn't get archived, btw. It's <1Gb at the moment so there's no real point.

User avatar
Milvus
board admin
board admin
Posts: 63790
Joined: Fri Nov 26, 2004 10:43 pm

Post by Milvus » Sun Jul 10, 2005 5:44 pm

It's fixed ^.^ thanks very much :D
A nevem Corti és papírzsepi vagyok meg gumikígyó jövetele!

Post Reply

Who is online

Users browsing this forum: No registered users and 53 guests