fets 
Coppermine novice
Posts: 29
|
 |
« Reply #20 on: November 19, 2006, 03:10:14 pm » |
|
done, but still blank  ( omg i am gonna suicide  |
|
|
|
|
Logged
|
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #21 on: November 19, 2006, 04:45:25 pm » |
|
Ι '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 ?
|
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender: 
 Iran, Islamic Republic of
Posts: 3689
BMossavari
|
 |
« Reply #22 on: November 19, 2006, 05:03:01 pm » |
|
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  |
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #23 on: November 19, 2006, 05:18:00 pm » |
|
I PMed you with all info. Really thanks mate! Hope you solve the problem.. |
|
|
|
|
Logged
|
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #24 on: November 19, 2006, 05:21:45 pm » |
|
ah, forgot the ftp server.
its: ftp.stathrania.com
Cheers
|
|
|
|
|
Logged
|
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #25 on: November 19, 2006, 05:41:19 pm » |
|
Did you get my PMs ? I checked at my Outbox and there are no messages there..
|
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #26 on: November 19, 2006, 06:00:03 pm » |
|
Yes I've got your PM
give me some time to figure things out ,
- why didn't you upgrade anyway?
|
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #27 on: November 19, 2006, 06:06:33 pm » |
|
- 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
|
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #28 on: November 19, 2006, 06:21:03 pm » |
|
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 docSorry I don't have that much time to do it for you ... |
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #29 on: November 19, 2006, 06:45:20 pm » |
|
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.. |
|
|
|
|
Logged
|
|
|
|
|
Joachim Müller
|
|
« Reply #30 on: November 19, 2006, 07:09:31 pm » |
|
e107 goes unsupported. Ask the creator of your bridge file for help.
|
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #31 on: November 19, 2006, 07:10:49 pm » |
|
Sorry I don't understand what you say
- login as an admin and delete duplicated albums !!!
Do not play with database
|
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #32 on: November 19, 2006, 07:13:05 pm » |
|
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 |
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #33 on: November 19, 2006, 07:18:12 pm » |
|
I can't !
You have the backup ,
|
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #34 on: November 19, 2006, 07:20:03 pm » |
|
Ok i ll give it a try now..
|
|
|
|
|
Logged
|
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #35 on: November 19, 2006, 07:26:48 pm » |
|
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.
|
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #36 on: November 19, 2006, 07:31:51 pm » |
|
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 ...
|
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #37 on: November 19, 2006, 07:54:29 pm » |
|
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 ? |
|
|
|
|
Logged
|
|
|
|
Sami
Dev Team member
Gender:
Iran, Islamic Republic of
Posts: 3689
BMossavari
|
|
« Reply #38 on: November 19, 2006, 07:58:24 pm » |
|
yes
|
|
|
|
|
Logged
|
I don't answer to PM with support question
Please post your issue to related board
|
|
|
fets
Coppermine novice
Posts: 29
|
|
« Reply #39 on: November 19, 2006, 08:10:22 pm » |
|
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: 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? |
|
|
|
|
Logged
|
|
|
|
|
