Search options

No wonder I couldn't find it. I was searching at punres...
Thanks.

Okay, I'll try to look for that plugin
Don't want to manually mes with the table.

Thanks Smartys. It seems that you're here all the time
Keep up the good work.

That is weird! I swear that it didn't work earlier today. I've also gotten 2 emails complaining about it.

I did a search and I read something about this today and I made the changes.

* Dns resolved raymond.cc to 75.127.71.130
It wasn't able to resolve the IP address to hostname.

So I ask my webhost to do the PRT changes and it worked now
Thanks! Great support and forum script.

Smartys, this is what the guys at my server gave me. sponsored1 is my old server and server1.raymond.cc is the new server.

sponsored1:
##################
mysql> explain SELECT p.message AS fpost, p.id AS fpost_id, v.message AS lpost, v.id AS lpost_id, t.id, t.moved_to, t.last_post_id FROM topics AS t LEFT JOIN posts AS p ON (t.id=p.topic_id OR t.moved_to=p.topic_id) LEFT JOIN posts AS v ON (t.last_post_id=v.id AND t.moved_to IS NULL) WHERE t.forum_id=1 GROUP BY t.id ORDER BY sticky DESC, last_post DESC LIMIT 0, 30;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1552938
Current database: raycc_forum

+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
| 1 | SIMPLE | t | ref | topics_forum_id_idx | topics_forum_id_idx | 4 | const | 509 | Using temporary; Using filesort |
| 1 | SIMPLE | p | ALL | posts_topic_id_idx | NULL | NULL | NULL | 7029 | |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | raycc_forum.t.last_post_id | 1 | |
+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
3 rows in set (0.05 sec)

mysql>
##################

server1.raymond.cc
##################
mysql> explain SELECT p.message AS fpost, p.id AS fpost_id, v.message AS lpost, v.id AS lpost_id, t.id, t.moved_to, t.last_post_id FROM topics AS t LEFT JOIN posts AS p ON (t.id=p.topic_id OR t.moved_to=p.topic_id) LEFT JOIN posts AS v ON (t.last_post_id=v.id AND t.moved_to IS NULL) WHERE t.forum_id=1 GROUP BY t.id ORDER BY sticky DESC, last_post DESC LIMIT 0, 30;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 127838
Current database: raycc_forum

+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
| 1 | SIMPLE | t | ref | topics_forum_id_idx | topics_forum_id_idx | 4 | const | 494 | Using temporary; Using filesort |
| 1 | SIMPLE | p | ALL | posts_topic_id_idx | NULL | NULL | NULL | 7048 | |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | raycc_forum.t.last_post_id | 1 | |
+----+-------------+-------+--------+---------------------+---------------------+---------+----------------------------+------+---------------------------------+
3 rows in set (0.00 sec)

mysql>
##################

Uh oh.. It's Topic Preview...

But can anyone tell me why this problem start appearing after I've migrated to a different server?

Opps, missed that one out. I've enabled it. Please check it for me? Thanks