Can't get on gallery at all!

[loubymar]

would it be possible to create it again and if so how?

[Stramm]

as long as your site and your account on funpic is existing it should be possible. Usually you use phpmyadmin to create a database dump. Funpic has that installed too. Read funpic FAQ and the phpmyadmin documentation for that.

[loubymar]

What about if i installed coppermine again created the category on the main page, and download the category table of MySQL and upload on to my previous one with all my pictures and users on! Do u think that cud work??

[Stramm]

then you basically have 'imported' the categories, no albums, users, pics, comments etc

[loubymar]

Ok, so doing that will not do anything? So i need to create the table my self on Phpmyadmin?

[Stramm]

again: go to your funpic account and backup your mysql db. Then restore it on your new server. That's the procedure when you move

[Joachim Müller]

Then what do you expect us to advice?

[loubymar]

i backed it up funpic MySQL and put it on new server, but still no category table! Is they no other way that i cud keep all my pics and users and re-create the category table again? Or i am left with no other choice but to re-install coppermine competely?

[loubymar]

If i re-installed coppermine, would it be possible to get all the users and pictures of the old gallery, and put them on the new 1? Not all my pics are on server!

[Sami]

then there is no way to restore that table !
you need to re-create it

[loubymar]

The table? How

[Sami]

- Find your table prefix from include/config.inc.php
- go to phpmyadmin or any other mysql tool that you have and run this query (Cahnge the CPG_ with your table prefix):

Code Select Expand


CREATE TABLE CPG_categories (
  cid int(11) NOT NULL auto_increment,
  owner_id int(11) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description text NOT NULL,
  pos int(11) NOT NULL default '0',
  parent int(11) NOT NULL default '0',
  thumb int(11) NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY cat_parent (parent),
  KEY cat_pos (pos),
  KEY cat_owner_id (owner_id)
) TYPE=MyISAM COMMENT='Used to store categories';

after that you have an empty table

Go to admin mode and :
- re-create categories
- set the albums

[loubymar]

Im not 100% sure what u mean!

I can't see table prefix in include/config.inc.php
And im on phpmyadmin, but where do i go to run this query (Cahnge the CPG_ with your table prefix):
Can u explain more 2 me plz?
Sorry

[Sami]

I can't see table prefix in include/config.inc.php

Download it to your local computer via ftp and open it with a simple text editor (such as notepad)

And im on phpmyadmin, but where do i go to run this query (Cahnge the CPG_ with your table prefix):

- Select your CPG database from left menu
- Click SQL button on top menu
- Paste that code to text area
- Hit the Go button

[loubymar]

ok, i done phpmyadmin bit, but what do i do when i opened include/config.inc.php? What am i pasting on to it?

http://anagallery.ifastnet.com/cpg148/index.php

[Sami]

You shouldn't pass anything on that file !
you should have something like this on that file:

Code Select Expand


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

that indicate your table prefix , cahnge the CPG_ under query with your prefix

also if it's hard for you ,you can simply look at the other tables on your cpg database and find out what table prefix you are using by phpmyadmin

[loubymar]

Ok, i done that, but now when i add a news category on the gallery, it doesn't show on homepage, and i can only see the gallery if it is in debug_mode, what do i need to do?

Many Thanks
Louis

[Sami]

Yes they will not show up until you have albums under ...
you need to set albums as suggested , go to each album properties and set the correct category for it

[loubymar]

Great, they isn't cpg148_albums in MySQL datebase! I reali can't believe this!
Is they any way that i can create cpg148_albums again? cus it not on backup iver, i must ave deleted that 2!!!
I no what i done, i have read the docs for Big Dump, and read it wrong!
If not im just gonner have to re-install coppermine!

[Sami]

I think it's better to re-install coppermine and re-upload your image using batch add
- overwrite all files and folder except include/config.inc.php and albums folder
- and then use batch add