New topics and replies not being saved

[LunarOrbit]

I have an old SMF forum running version 2.0.19 that has pretty much been ignored for years. I went to check it out today and discovered that any new topics and replies that I make are not being saved, or are not being displayed. I don't think they are being saved at all because I don't see them in phpMyAdmin.

I recently transferred the forum to a new host, so maybe something broke then. I also used to have the Tapatalk addon installed, but I removed it last year.

I've ran all of the Forum Maintenance tasks.

Any idea what the problem might be? Has anyone reported something similar to this?

The forum can be found here:

hxxp:thespacerace.com/forum [nonactive]

[Kindred]

If you transferred to a new host, are you certain that you connected to the new location and new database?

[Doug Heffernan]

I went to check it out today and discovered that any new topics and replies that I make are not being saved, or are not being displayed.

Do you get any errors at all when you make a new post/topic?

[Sir Osis of Liver]

If you transferred to a new host, are you certain that you connected to the new location and new database?

^ This.  Run repair_settings.php, make sure database settings are to current db on new host.

[LunarOrbit]

If you transferred to a new host, are you certain that you connected to the new location and new database?

Sorry, I should have specified that yes, I did check that.

I did some more digging today and found that the test posts that I made were saved to the database, but they were being given message and topic IDs of 0.

When I go to my profile and view my posts, the test posts are listed but when I hover over their links I see this in the URL:

?topic=0.msg0#msg0

When I click the links it takes me to the forum index instead of the post.

I checked the database and the messages and topics tables were missing their primary and index keys. I compared it to another forum that I run (one that works) and added the same keys.

I also deleted a bunch of topics and messages that had 0 for the msg and topic ID.

But it's still trying to assign message & topic IDs of 0 when I try to make a new post.

[Kindred]

Load a clean set of files

[LunarOrbit]

Load a clean set of files

Ok, I've done that now.

I think I fixed the problem. The id_topic and id_msg rows were not set to auto increment. New posts are appearing normally now.

Thanks for your help, Kindred.

[Aleksi "Lex" Kilpinen]

That would likely be a fault with the database transfer, and if I were you I would probably start over with a completely new database dump from the old host and an empty database on the new host. If still possible. Something obviously went wrong the last time, and you can't really be sure what else went wrong and is waiting to reveal itself later.

[LunarOrbit]

That would likely be a fault with the database transfer, and if I were you I would probably start over with a completely new database dump from the old host and an empty database on the new host. If still possible. Something obviously went wrong the last time, and you can't really be sure what else went wrong and is waiting to reveal itself later.

That's not an option, unfortunately. I no longer have access to the old host.

I kind of suspect that this issue actually originated before the hosting transfer and I just didn't notice until now because the forum has been inactive for years. I had an issue with it several years ago that I thought I fixed, but it was probably worse than I realized.

I'm not too worried about it now, to be honest. Everyone has moved on to other forums or social networks, and I'm happy as long as the history of the forum is preserved.