Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Missing Discussions - Upgrade to 2.0.18.10

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?

Comments

  • peregrineperegrine MVP
    edited January 2014

    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

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • It was an upgrade from version 2.0.18.3

    Troubleshooting using your suggestions now, thanks

  • 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.

    grep is your friend.

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

  • 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?

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • 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.

  • 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.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  • 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

  • @rudra Welcome back to the community!

    What steps did you take to upgrade?

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • 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

  • 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.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • 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

  • hgtonighthgtonight MVP
    edited May 2014

    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. :D

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

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

  • 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.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • 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

  • rudrarudra New
    edited May 2014

    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

  • 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.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

Sign In or Register to comment.