Missing Discussions - Upgrade to 2.0.18.10

JamieD

I just upgraded to version 2.0.18.10. I know that my database is connected because all of my previous applicants are there, but all of the previous discussions are missing. Is there a setting that i need to change?

peregrine

what version of vanilla did you upgrade from.

not sure if you have a cache, database or permission issue, not clear from your explanation.

try clearing your ini files from /cache folder

and run /utility structure.

use phpmyadmin to see if you actual have discussions in discussion table.

check your permissions to see if you are allowed to view discussions.

read thru this:
http://vanillaforums.org/discussion/comment/199091/#Comment_199091

JamieD

It was an upgrade from version 2.0.18.3

Troubleshooting using your suggestions now, thanks

x00

upgrading does not changign existing data normally.

it is is not a permissions issue then perhaps you tried to export/import which isn't necessary.

JamieD

Out of curiousity, i did a database restore from before the upgrade. Something in the upgrade did in fact delete discussions, categories, etc.

peregrine

Out of curiousity, i did a database restore from before the upgrade. Something in the upgrade did in fact delete discussions, categories, etc.

perhaps the restore was the problem, did you test after the restore before the upgrade.

for that matter, did you backup the database prior to the upgrade or prior to the restore?

the upgrade will NOT delete data from you discussion tables. Check in phpmyadmin and see if you have discussions in discussion table, and make sure you are pointing to the correct database.

you may want to post your config.php here. BUT remove passwords, salts, email addresses and any other confidential information prior to posting.

can you post new discussions?

JamieD

Prior to the upgrade, we had discussions in the database. After the upgrade, all of the discussions were missing (about half of the tables were blank, the other half like applicants and members remained). I was able to restore all of the blank tables from the backup in phpmyadmin with no problem and everything is working as expected again.

peregrine

yes. but the best way to upgrade is backup the forum directory and store it on a local pc.
and backup the database. download the core zip, extract and copy file to where your forum is located. and then do the utility upgrade, and remove the ini file from the cache folder if necessary. At no time would the database remove records.

rudra

Hi, I have the same problem. I am also using 2.0.18.10 and I had to restore the database and start a new install. After connecting, I am getting the users, the user data, but no real discussions.

1) I have cleared the .ini files
2)run/utility and utility/structure has been tried
3)i looked at the database and i do see discussions there
4) the permission part I am not sure, what I need to check?

Please assist.

Thanks

hgtonight

@rudra Welcome back to the community!

What steps did you take to upgrade?

rudra

Hi,

actually I was not upgrading. I wanted to have a slightly older database restored and in a different subdomain. And I made a few mistakes. I did the following -

1) export the relevant database from phpmyadmin as sql file

2) at first I downloaded the 2.1 stable version, put it in a separate folder and extract it there. Then I installed it, pointing to a new database which I created, importing the earlier downloaded file. This first time it actually worked and then I copied the library folder from by old forum folder to this new one and the website stopped working.

3) I started afresh, cleaning all the folders, starting fresh installation, this time with 2.0.18.10, everytime I install it poiting to the correct database it gives me either a forum with no comments, but users are there, even it shpows there last activity and number of comments, although no comments are there.

or it gives the error Fatal Error in Gdn_Database.Query(); Can't DROP 'FK_Comment_DiscussionID'; check that column/key exists|Gdn_Database|Query|drop index FK_Comment_DiscussionID on GDN_Comment
similar to this - http://vanillaforums.org/discussion/23386/bonk-updating-2-0-18-to-2-1/p1

4) Since last 12 hours I have tried different forum versions, even different database backups, cache cleaning, but can't get out of this loop. And it doesn't help that I am a noob in these things.

I can see the thread topics in the database, so its there. I dunno why can't it connect.
Please help.

Will it help if I delete all the identical databases and just keep one and try to link it?

Thanks

hgtonight

After step 2, why did you copy the library folder from your old forum to the new one?

What features were you trying to get?

Generally I would suggest only moving the /uploads folder and /conf/locale.php from an older version to a newer version. You could also merge in your /conf/config.php file, but I would suggest manually copying over only relevant changes manually.

rudra

I was was trying to recover the user images and I felt last time I did the same. Now that this is done how can I go about given I have database back up before all this happened? What is the meaning of the error I am getting? Seems like others have seen this too, but I didn't get a clear cut remedy

hgtonight

That error appears to be related to old foreign key fields existing in the Comment table. You should be able to remove the associated field on the Comment table without issue.

I would still only try it on a backed up table though.

rudra

Given the fact, I am a noob in this area, would you guide me a bit more. Sorry for being a pain

hgtonight

Give me a list on the Comment table's structure. You should have a bunch of fields like 'CommentID', 'InsertUserID', etc. Those names are what I am interested in.

rudra

yes i am giving you a screen shot. On I had dropped the tables and imported them BEFORE the installation, should I be doing that after the installation? What I am seeing is that in the installed databases, the comments part is all wiped out, uninstalled one's have the full

rudra

Here's a snapshot of that is there in the GDN_Comment

but after installation of the database (in the cases it does), this is entirely wiped out and only the welcome message is shown

hgtonight

Firstly, that is a screenshot of the Discussion table.

Secondly, run a fresh install on an empty db, them replay your SQL file to the newly populated db.