Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: I messed up my gallery, now I'm stuck - please help  (Read 6436 times)

0 Members and 1 Guest are viewing this topic.

andyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
I messed up my gallery, now I'm stuck - please help
« on: March 25, 2011, 09:31:45 pm »

I installed a plug in to try to change the way the filmstrip was presented, and typically I didn't read the instructions. And now I seem to have lost everything

I Started off by getting a page error, so I tried to overwrite the file structure with my original downloaded files. That didn't work so I backed up my Mysql database, deleted the file I was told to and reinstalled using the same database user as the original install. The pictures still appear in the albums/userpics folder. But I cant seem to get the structure that is saved on the database to load again.

Not too sure what screen shots I can show you to help,

Thank you in advance
Logged

andyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: I messed up my gallery, now I'm stuck - please help
« Reply #1 on: March 25, 2011, 10:08:54 pm »

Sorry forget to mention the link http://www.andyoneilphotography.co.uk/cpgx/ although all there is there at the moment is the blank gallery
Logged

Phill Luckhurst

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4822
    • Windsurf.me
Re: I messed up my gallery, now I'm stuck - please help
« Reply #2 on: March 25, 2011, 10:35:10 pm »

Check to see if include/config.inc.php is pointing to the correct database. If not adjust it as required then fun update.php
Logged
It is a mistake to think you can solve any major problems just with potatoes.

andyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: I messed up my gallery, now I'm stuck - please help
« Reply #3 on: March 26, 2011, 12:19:56 am »

Thankyou for your guidance Phill, I have checked the file as suggested, and although it was pointing at the correct db, there where some extra tables ( I'm guessing that the reason is because I had re run the install) so I have deleted all of the tables then reimported the tables I had exported before the re install. and I have the attached db structure and when I run the update I get the following error

Quote
Coppermine critical error:
The group table does not contain the Anonymous group !

Then when I browse to the main gallery page I get

Quote
While executing query 'SELECT name, value FROM config' in include/init.inc.php on line 181

mySQL error: Table 'andyonei_photos.config' doesn't exist

Here are the contents of the congifg.inc.php
Quote
<?php
// Coppermine configuration file
// MySQL configuration
$CONFIG['dbserver'] =                         'correct ip;        // Your database server
$CONFIG['dbuser'] =                         'correct_user';        // Your mysql username
$CONFIG['dbpass'] =                         'correct password';                // Your mysql password
$CONFIG['dbname'] =                         'andyonei_photos';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                '';
?>

If I run a query on the table "galleryusergroups" it has three entrie. Administrators, registered users and anonymous
Logged

Nibbler

  • Guest
Re: I messed up my gallery, now I'm stuck - please help
« Reply #4 on: March 26, 2011, 06:33:55 am »

Set the prefix.

Code: [Select]
$CONFIG['TABLE_PREFIX'] =                'gallery';
Logged

andyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: I messed up my gallery, now I'm stuck - please help
« Reply #5 on: March 26, 2011, 10:59:48 am »

Thanks Nibbler,
Done that and now I get the following

Quote
Template error
Failed to find block 'faq' (#<!-- BEGIN faq -->(.*?)<!-- END faq -->#s) in :

            <!-- BEGIN home -->
        <a href="{HOME_TGT}" title="{HOME_TITLE}" >{HOME_LNK}</a> |
  <!-- END home -->  <!-- BEGIN contact -->
        <a href="{CONTACT_TGT}" title="{CONTACT_TITLE}" >{CONTACT_LNK}</a> |
  <!-- END contact -->  <!-- BEGIN my_gallery -->
        <a href="{MY_GAL_TGT}" title="{MY_GAL_TITLE}" >{MY_GAL_LNK}</a> |
  <!-- END my_gallery -->  <!-- BEGIN allow_memberlist -->
        <a href="{MEMBERLIST_TGT}" title="{MEMBERLIST_TITLE}" >{MEMBERLIST_LNK}</a> |
  <!-- END allow_memberlist -->  <!-- BEGIN my_profile -->
        <a href="{MY_PROF_TGT}" title="{MY_PROF_TITLE}" >{MY_PROF_LNK}</a> |
  <!-- END my_profile -->  <!-- BEGIN enter_admin_mode -->
        <a href="{ADM_MODE_TGT}" title="{ADM_MODE_TITLE}" >{ADM_MODE_LNK}</a> |
  <!-- END enter_admin_mode -->  <!-- BEGIN leave_admin_mode -->
        <a href="{USR_MODE_TGT}" title="{USR_MODE_TITLE}" >{USR_MODE_LNK}</a> |
  <!-- END leave_admin_mode -->  <!-- BEGIN sidebar -->
        <a href="{SIDEBAR_TGT}" title="{SIDEBAR_TITLE}" >{SIDEBAR_LNK}</a> |
  <!-- END sidebar -->  <!-- BEGIN upload_pic -->
        <a href="{UPL_PIC_TGT}" title="{UPL_PIC_TITLE}" >{UPL_PIC_LNK}</a> |
  <!-- END upload_pic -->  <!-- BEGIN register -->
        <a href="{REGISTER_TGT}" title="{REGISTER_TITLE}" >{REGISTER_LNK}</a> |
  <!-- END register -->  <!-- BEGIN login -->
        <a href="{LOGIN_TGT}" title="{LOGIN_TITLE}" >{LOGIN_LNK}</a>
  <!-- END login -->  <!-- BEGIN logout -->
        <a href="{LOGOUT_TGT}" title="{LOGOUT_TITLE}" >{LOGOUT_LNK}</a>
  <!-- END logout -->
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1504
  • aka 'i-imagine'
    • Home Page
Re: I messed up my gallery, now I'm stuck - please help
« Reply #6 on: March 26, 2011, 01:53:39 pm »

Make certain...

   - you have uploaded all of the cpg 1.5.12 files without any faults or errors
   - there are no cpg 1.4.x files remaining
   - there are no theme related files in your gallery root directory
   - that you run update.php after confirming / fixing the above

andyo

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: I messed up my gallery, now I'm stuck - please help
« Reply #7 on: March 26, 2011, 10:20:26 pm »

Once again I need to say thank you very much for all of your help.
Everything seems to be back to normal now.

And I know this isn't the correct place to ask, but is there any way I can shift the filmstrip along more than one image at a time?
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.