gallery problem (init.inc.php) after several bridge attempts

[fets]

done, but still blank ( omg i am gonna suicide  :'(

[fets]

Ι 've created a 'gallery2' and installed a fresh coppermine (cpg1.4.4). I restore comments and photos. Everything is fine.

But albums haven't been restored and it will be very very difficult to recreate them. Even if i do, will pictures be automaticaly placed on their previous albums ? Is there such table in database ?

[Sami]

Hey fets before you done any harm to your self give me an admin account of gallery + ftp account to your gallery + mysql account and I'll fix it for you

[fets]

I PMed you with all info.

Really thanks mate! Hope you solve the problem.. :'(

[fets]

ah, forgot the ftp server.

its: ftp.stathrania.com

Cheers

[fets]

Did you get my PMs ? I checked at my Outbox and there are no messages there..

[Sami]

Yes I've got your PM
give me some time to figure things out ,
- why didn't you upgrade anyway?

[fets]

- well, i was afraid that things will get worst :]

If you want and have time and it won't affect the database restore feel free to do it man

[Sami]

Your gallery is back you've set the theme to e107 that theme doesn't work with stand-alone at all !
I change your theme to classic

- First thing to do is upgrading your gallery to 1.4.10 it important
read the upgrading doc
Sorry I don't have that much time to do it for you ...

[fets]

Man really really thanks!

I did a stupidity. In all categories albums appear twice and three-times. I deleted the "cloned" galleries but unfortunately the albums that contained the photos have been deleted Can you restore that? I ll be 10x carefull now..

[Joachim Müller]

e107 goes unsupported. Ask the creator of your bridge file for help.

[Sami]

Sorry I don't understand what you say
- login as an admin and delete duplicated albums !!!
Do not play with database

[fets]

i deleted the duplicated, but through Albums, so i couldn't look which is one is the clone and which one is the original 


I just lost 3 albums from Larnaca category. If you can restore it i 'd appreciate it man

[Sami]

I can't !
You have the backup ,

[fets]

Ok i ll give it a try now..

[fets]

Man can't you do it ? Am afraid that am gonna destroy it again :s

Or tell me how can i restore the albums + photos please.

[Sami]

do you have mysql backup ?
IF yes then
- truncate the cpg143_album table
- copy the content of cpg143_album (INSERT INTO ....) from backup (usually it's right after table creation statement) and past it to SQL section of  phpmyadmin ,

Sorry I should go here is dinner time ...

[fets]

Code Select Expand

INSERT INTO `cpg143_albums` (`aid`, `title`, `description`, `visibility`, `uploads`, `comments`, `votes`, `pos`, `category`, `thumb`, `keyword`, `alb_password`, `alb_password_hint`) VALUES
('','American Academy', '', 0, 'YES', 'YES', 'YES', 100, 2, 0, '', '', ''),


Here is a example... shall i paste aaalll these lines in SQL Query in phpMyAdmin ?

[Sami]

yes

[fets]

done that.

Now the albums are back but the photos that were in these albums are still not there.

Now shall i enter into SQL Query lines of this format:

Code Select Expand

INSERT INTO `cpg143_pictures` VALUES (1, 1, 'userpics/10001/', 'greece~0.jpg', 363454, 378622, 1480, 861, 518, '2006-11-17 07:32:47', 1142732035, 1, 'Webmaster', 0, 0, '', 'Sto ksenodoxeio logw kathisterisis tis ptisis mas!', '', 'YES', 0, '', '', '', '', 0, '195.251.255.211', '195.251.255.211', '194.30.128.24', 0);


?? Will conflict the current photos?