Home› General support

Upgraded - and lost descriptions and comments

Thelma Member
in General support
I just upgraded and now all my descriptions and all comments are gone. Any way to get them back to where they belong?

Comments

  • sbillard Member
    You probably did not enter the old table prefix when you upgraded. Edit your zp-config.php file to have the proper `$conf['mysql_prefix'] = "xxxx";` value.
    `
  • Thelma Member
    I checked the zp-config, and there is no prefix in there, but there wasn't in the old (pre-upgrade) file, either. However, the zenphoto maintenance screen tells me that my database is prefixed zp_. the Gallery stats show 122 images, 13 albums, and zero comments

    Looking at the database I see the following tables (number of records)

    albums (13)
    comments (36)
    images (590)
    zp_albums (13)
    zp_comments (0)
    zp_images (139) ...(as I'm clicking back and forth, this number has INCREASED...it was 122 when I wrote the above paragraph, 139 when I typed the list, and not it's 166 and I have not added anything)
    zp_options (49)

    The images in 'images' all have descriptions, and the few in 'zp_images' don't.

    The zp_tables all have a creation date of yesterday, when I made the upgrade. So it appears that my album (www.aandbwebdesign.com/zenphoto) is picking up the new tables, but they only picked up parts of the old records. Do I just have to move those records out of comments to zp_comments, images to zp_images? the rest seems ok - number of albums is the same, and options didn't seem to exist before at all.

    I wonder if the photos in the zp_images could be images I had deleted? Or would they be gone completely?

    Help, please.
  • acrylian Administrator, Developer
    The increasing image number in the prefixed tables is because zenphoto uses the newly generated prefixed tables and now adds all images and albums it finds within the albums folder to the database when you browse through your gallery. Zenphoto always reads from the file system.
    So your old image descriptions and comments are probably still in the non prefixed tables.

    Are you really sure that you not confused the zp-config.php files somehow before upgrading? The prefix "zp" is the default value.
    Sorry, if you don't set this in your zp-config, zenphoto should use the non prefixed tables. I hope sbillards has any idea.
  • Thelma Member
    No, I'm not REALLY sure - but my current zp-config file looks like this:

    $conf['mysql_prefix'] = "";

    I tried

    $conf['mysql_prefix'] = "zp_";

    but didn't notice any difference.

    Either way - what's the best approach here? Can I just delete the current tables and rename the old ones? Or do I need to move the records from images to zp_images, comments to zp_comments? And if so, can you point me to a 'how-to' - I don't know much about this stuff...
  • sbillard Member
    From your comments, when you did the new installation you left the default prefix `zp_` set. So zenphoto is now using tables with that prefix.

    Delete your zp-config.php file (after first making a copy of it so you can check what your mySQL user, password, etc. are.) Then re-run setup.php. This time make sure you set the database prefix field to empty.

    Once you have that running and your descriptions, etc. back, you can delete the tables prefixed with `zp_`
  • Thelma Member
    I'm back in business - thank you very much. And just in case somebody else has this problem, let me explain what the exact issue was:

    I'm an idiot!!! I had neglected the part about deleting the zen folder, so all this time I was making changes to the zp-config in zen, not in the new zp-core folder, where my zp-config was adding the prefix and causing my problems. Now, zen is deleted, zp-core/zp-config is corrected to $conf['mysql_prefix'] = ""; and I have my comments and descriptions back.

    THANKS!!!!
Sign In or Register to comment.