forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 install => Topic started by: andyo on March 25, 2011, 09:31:45 pm

Title: I messed up my gallery, now I'm stuck - please help
Post by: andyo 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
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: andyo 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
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: phill104 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
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: andyo 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
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: Nibbler on March 26, 2011, 06:33:55 am
Set the prefix.

Code: [Select]
$CONFIG['TABLE_PREFIX'] =                'gallery';
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: andyo 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 -->
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: Joe Carver 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
Title: Re: I messed up my gallery, now I'm stuck - please help
Post by: andyo 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?