Re-install becoming drama

  • Resolved pol2112

    (@pol2112)


    7 years, 10 months ago

    I installed Nextgen a few years ago but never really used it. It wasn’t super intuitive and I never got around to doing the proper reading.

    Almost 2 years ago I was far from home when my website crashed. I don’t remember why, but I surmised that Nextgen was doing it. Maybe a line of code was showing instead of my website. I couldn’t get to my wordpress Dashboard but I called my wife at home and told her how to delete the Nextgen folder via FTP. Everything was fine the moment she did that. Everything has been fine since then.

    Flash forward to this month when I re-installed Nextgen in hopes of figuring out how to use it. It was a little buggy so I assumed there were problems with the previous install. So I deleted it and saw that it left a lot of junk behind. I downloaded THREE plugins to completely remove it as instructed by this post. Then I re-installed, hoping to start “Tabula Rasa”.

    Now I get this error on all of my admin pages (I imagine because I scrubbed the SQL DB tables) and of course it only has partial functionality in the admin works.

    :[Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN gid BIGINT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN name VARCHAR(255)

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN slug VARCHAR(255)

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN path TEXT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN title TEXT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN pageid INT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN previewpic INT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN author INT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    ALTER TABLE wp_ngg_gallery ADD COLUMN extras_post_id BIGINT

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SHOW COLUMNS FROM wp_ngg_gallery

    WordPress database error: [Table ‘db518176678.wp_ngg_gallery’ doesn’t exist]
    SELECT COUNT(gid) AS gid FROM wp_ngg_gallery

    Thanks
    ~Jimm

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor photocrati

    (@photocrati)

    @pol2112 – Following the ideas outlined in the post you referenced should work although it appears something has gone awry in your process. Unfortunately I cannot say what that might be as I do not know the exact steps you took.

    Have you tried restoring the back-up we recommended and going through the steps again?

    Thanks!

    – Cais.

    Thread Starter pol2112

    (@pol2112)

    That appears to have done the trick, thanks. That was the only thing I could thing of to do as well, but I wanted to check in in case this looked like a known problem. One thing I had not considered is that there were extra plugins involved, like the Nextgen Facebook helper.
    Also, can anyone tell me if one of the Nextgen album permutations lets each photo open onto a page where comments, adsense ad placement and blog-length captions are possible? I’m trying to recreate the full-functionality of a Facebook photo album.

    thanks again,
    ~Jimm

    Plugin Contributor photocrati

    (@photocrati)

    @pol2112 – Thanks for the update!

    As to your idea for a display type that would provide all of those features, we do not have anything out of the box; you will likely need to create a custom template to accomplish that.

    – Cais.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Re-install becoming drama’ is closed to new replies.