Is fine here in the UK
Early ,'Objects In Space'
Buffistas Building a Better Board ++
Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
I can never remember if this is helpful or not, but I just got this error while trying to post:
December 21, 2007, 5:21 am Stephanie[1216]: ERROR [2] mysql_query(): Unable to save result set line 103 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php
Array ( [0] => Array ( [function] => buffistaerrorhandler [args] => Array ( [0] => 2 [1] => mysql_query(): Unable to save result set [2] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php [3] => 103 [4] => Array ( [query] => select count(post_number) from posts where thread_id=475 [db] => Resource id #9 )
)
)
[1] => Array ( [file] => /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php [line] => 103 [function] => mysql_query [args] => Array ( [0] => select count(post_number) from posts where thread_id=475 )
)
[2] => Array ( [file] => /var/www/vhosts/buffistas.org/httpdocs/classes/post.php [line] => 218 [function] => connectandquery [args] => Array ( [0] => select count(post_number) from posts where thread_id=475 )
)
[3] => Array ( [file] => /var/www/vhosts/buffistas.org/httpdocs/classes/post.php [line] => 254 [function] => _save [class] => post [type] => -> [args] => Array ( )
)
[4] => Array ( [file] => /var/www/vhosts/buffistas.org/httpdocs/processPost.php [line] => 33 [function] => add [class] => post [type] => -> [args] => Array ( )
)
)
There has been an error. It's of the type we call fatal. Please don't be scared. You're not the one that's going to die.
Okay, where the $$&#&(@#& are the developers? December 21, 2007, 5:21 am Stephanie[1216]: FATAL [256] select count(post_number) from posts where thread_id=475 failed: Server shutdown in progress Fatal error in line 103 of file /var/www/vhosts/buffistas.org/httpdocs/classes/giles.php, PHP 4.3.9 (Linux)
Fatal error in context array ( 0 => array ( 'query' => 'select count(post_number) from posts where thread_id=475', 'db' => NULL, 'result' => false, ), )Aborting...
I just got a similar error trying to post, but then I tried again and it was OK.
Likewise, at the same time, but I lost the post and ran out of time and out the door to work.
buffistas on iPhone for the win. This is easily the quickest site I've used.
I'm worried about the posts mysql table. I think it needs to be repaired/reindexed/vacuumed or something. By someone who knows more about mysql than I do.
By someone who knows more about mysql than I do.
That's no fun. What's the source of your worry?
What's the source of your worry?
Well, the board froze earlier this week, and people have been reporting errors since then.
I haven't had the chance to look at the source of those errors. Are you thinking of the errors as a result of the corruption caused by the freeze, or that the freeze might have been caused by corruption?
I can start up a conversation with their tech support--or do you want to? Or should we both? Whatever's more efficient, let's go.
If the server hung it is likely the MySQL table is corrupt. You can run a 'check' on it easily enough, that should tell you. A repair is usually always safe to run if you need it.