Transfered my gallery, and images and albuns dont appear

mariamsr · September 15, 2008, 10:11:16 PM

Hey!
So I'm trying to tranfer my coppermine gallery from a domain that got suspended to another. I backed up the data from my last domain through phpmyadmin and then I imported it to the new domain. I think all of it went well. Then I downloaded with an ftp client the gallery from my last domain and before uploading it again to the new domain(new host) I corrected the information in the config.php file.

Now I've installed and I can see my index page, but any of the images or albums from the last gallery are there... What should I do?

phill104 · September 15, 2008, 10:38:23 PM

Try posting a link for a start.

Have you checked the settings in include/config.inc.php ? I'm guessing that is what you meant by config.php.

mariamsr · September 15, 2008, 11:02:50 PM

Hey, yes this is the file that I'm talking about.

The link is: http://www.7crgallery7.co.cc/Gallery/index.php

Thanks,
Maria

Joachim Müller · September 16, 2008, 08:03:16 AM

Did you restore the database backup on the new server?

You should tweak your google analytics code btw (not related to your issue though) - it must be inserted before the </body>-tag

mariamsr · September 16, 2008, 02:43:48 PM

What should I add before the body tag, and in waht file...?

About the database, i imported the backupdata with phpmyadmin.
Then I uploaded the gallery (which I has downloaded from the last server) to the new one. Is it normal that the pictures inside the albums/ directory are inside pastes named: wpw-20080902 and wpw-20080903 until wpw-20080909?

Thanks,
Maria

Nibbler · September 16, 2008, 07:59:34 PM

Looks like you messed up either the backing up or restoring of your database. Take a look in the backup file you made and make sure it contains all your info. The wpw names are normal if you used the xp publisher to upload the pictures.

mariamsr · September 16, 2008, 08:14:41 PM

I checked it, but it seems ok, to have all the files...
I'll upload all the gallery again, but should I upload all of it, or should I make any changes?
In my phpadmin there are files that seem repeated to me... like cpg132_abums, cpg140_abums, cpg1419_albums... and this for all directories like config, comments, categories, ... but there is none about include/ directory... Is this normal?

Thanks,
Maria

Nibbler · September 16, 2008, 08:36:08 PM

You should only have one set of tables in use, and the prefix of that set should match what the prefix is set to in include/config.inc.php. Determine which prefix is the correct one (by looking at the contents of the tables in phpmyadmin) and set that prefix in include/config.inc.php. The include directory is on the filesystem, not in the database.

Joachim Müller · September 17, 2008, 06:33:37 AM

Quote from: mariamsr on September 16, 2008, 02:43:48 PM
What should I add before the body tag, and in waht file...?

Edit http://www.7crgallery7.co.cc/Gallery/themes/mac_ox_x/template.html - it currently looks like this:

Code Select

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="{LANG_DIR}">
<head>
<meta http-equiv="Content-Type" content="text/html; charset={CHARSET}" />
<meta http-equiv="Pragma" content="no-cache" />
<title>{TITLE}</title>
{META}
<link rel="stylesheet" href="themes/mac_ox_x/style.css" type="text/css" />
<script type="text/javascript" src="scripts.js"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v6.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>
<!--
  SVN version info:
  Coppermine version: 1.4.19
  $Revision: 4392 $
  $LastChangedBy: gaugau $
  $Date: 2008-04-16 09:25:35 +0200 (Mi, 16 Apr 2008) $
-->
</head>
<body>
<div id="CUSTOM_HEADER">

  {CUSTOM_HEADER}
</div>

<div class="top_panel">
  <div class="top_panel_r">
    <div id="GAL_NAME">
      <h1>{GAL_NAME}</h1>
      <h3>{GAL_DESCRIPTION}</h3>
    </div>

  </div>
</div>
  
<div id="MENUS">
  <div id="SUB_MENU">
    {SUB_MENU}
  </div>
  <div id="SYS_MENU">
    {SYS_MENU}
  </div>
</div>

<div id="GALLERY">
  {ADMIN_MENU}
  {GALLERY}
</div>


<div id="SELECT_LISTS">
  {THEME_SELECT_LIST}
  {LANGUAGE_SELECT_LIST}
</div>


<div id="SELECT_FLAGS">
  {LANGUAGE_SELECT_FLAGS}
</div>

<div id="CUSTOM_FOOTER">
  {CUSTOM_FOOTER}
</div>

<div id="VANITY">
  {VANITY}
</div>
  
</body>
</html>

<!-- www.0[b][/b]0[b][/b]0[b][/b]w[b][/b]e[b][/b]b[b][/b]h[b][/b]o[b][/b]s[b][/b]t[b][/b].[b][/b]c[b][/b]o[b][/b]m (this is an unsolicited advert that triggered the stop-word filter) Analytics Code -->
<script type="text/javascript">
var websiteID='7crgallery7.co.cc';
</script>

<script type="text/javascript" src="http://analytics.hosting24.com/s.php"></script>
<noscript>
<a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/s.php?websiteID=7crgallery7.co.cc" alt="web hosting" /></a>
</noscript>
<!-- End Of Code -->

but needs to be

Code Select

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="{LANG_DIR}">
<head>
<meta http-equiv="Content-Type" content="text/html; charset={CHARSET}" />
<meta http-equiv="Pragma" content="no-cache" />
<title>{TITLE}</title>
{META}
<link rel="stylesheet" href="themes/mac_ox_x/style.css" type="text/css" />
<script type="text/javascript" src="scripts.js"></script>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_showHideLayers() { //v6.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}
//-->
</script>
</head>
<body>
<div id="CUSTOM_HEADER">

  {CUSTOM_HEADER}
</div>

<div class="top_panel">
  <div class="top_panel_r">
    <div id="GAL_NAME">
      <h1>{GAL_NAME}</h1>
      <h3>{GAL_DESCRIPTION}</h3>
    </div>

  </div>
</div>
  
<div id="MENUS">
  <div id="SUB_MENU">
    {SUB_MENU}
  </div>
  <div id="SYS_MENU">
    {SYS_MENU}
  </div>
</div>

<div id="GALLERY">
  {ADMIN_MENU}
  {GALLERY}
</div>


<div id="SELECT_LISTS">
  {THEME_SELECT_LIST}
  {LANGUAGE_SELECT_LIST}
</div>


<div id="SELECT_FLAGS">
  {LANGUAGE_SELECT_FLAGS}
</div>

<div id="CUSTOM_FOOTER">
  {CUSTOM_FOOTER}
</div>

<div id="VANITY">
  {VANITY}
</div>

<!-- www.0[b][/b]0[b][/b]0[b][/b]w[b][/b]e[b][/b]b[b][/b]h[b][/b]o[b][/b]s[b][/b]t[b][/b].[b][/b]c[b][/b]o[b][/b]m (this is an unsolicited advert that triggered the stop-word filter) Analytics Code -->
<script type="text/javascript">
var websiteID='7crgallery7.co.cc';
</script>

<script type="text/javascript" src="http://analytics.hosting24.com/s.php"></script>
<noscript>
<a href="http://www.hosting24.com/"><img src="http://analytics.hosting24.com/s.php?websiteID=7crgallery7.co.cc" alt="web hosting" /></a>
</noscript>
<!-- End Of Code -->
  
</body>
</html>

Not related to your initial question though - you should have started a separate thread for that. Plain HTML btw.
I'm not sure though wether

Code Select

var websiteID='7crgallery7.co.cc';is valid - usually, Google analytics code looks different - yours looks kind of made-up.

mariamsr · September 17, 2008, 02:54:35 PM

Quote from: Nibbler on September 16, 2008, 08:36:08 PM
You should only have one set of tables in use, and the prefix of that set should match what the prefix is set to in include/config.inc.php. Determine which prefix is the correct one (by looking at the contents of the tables in phpmyadmin) and set that prefix in include/config.inc.php. The include directory is on the filesystem, not in the database.

Ok. I deleted the tables that weren't of the same prefix as the one I had on include/config.inc.php . But now I've installed the gallery again, and it gave me this error:
mySQL Error: Table 'cpg1419albums' already exists on query ' CREATE TABLE cpg1419albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM COMMENT='Used to store albums''

mariamsr · September 17, 2008, 03:00:58 PM

OMG! Thanks you all, now the pictures are all there!!

phill104 · September 17, 2008, 08:40:31 PM

It looks like a lot of the pictures are still missing to me.

coppermine-gallery.com/forum

News:

Transfered my gallery, and images and albuns dont appear

mariamsr

phill104

mariamsr

Joachim Müller

mariamsr

Nibbler

mariamsr

Nibbler

Joachim Müller

mariamsr

mariamsr

phill104