Hello,
i didn't post this topic into bridge/integration section, because i won't issue with bridging in my topic.
I just wanted to bridge e107 with cpg1.4.4. I didn't manage it and finally i got error to all gallery pages: BRIDGE ERROR: Can't find e107_config.php.
I backed up immediately gallery database and 'albums' folder.
Now i am overwriting some files of cpg1.4.4 so i can get it work.
Everyting works fine but i have a login problem. I click Login, database recognizes me, says: Welcome Webmaster but then nothing happens. i can't see the special admin buttons, is like i never logged in.
Url: http://www.stathrania.com/gallery
Q: If i delete the Coppermine and re-install it (cpg1.4.4) and then upload 'album' directory will photos remain in their current albums?
Anyhow please give me as many solutions as you can, because even if i restore the backed up database, it might be corrupted so i ll lost all photos :(
Regards
- First you need to upgrade , recent version is 1.4.10
- Check your bridge table and see if you have any data on value culomn
Quote from: Sami on November 19, 2006, 01:37:52 PM
- First you need to upgrade , recent version is 1.4.10
- Check your bridge table and see if you have any data on value culomn
I do have data...
check the xxx_config table and look for value of bridge_enable it should be 0
Its set on 1.
So, shall i change it, save the database, restore it and everything will work as before ?
just change it and see if it's working...
CREATE TABLE `cpg143_bridge` (
`name` varchar( 40 ) NOT NULL default '0',
`value` varchar( 255 ) NOT NULL default '',
UNIQUE KEY `name` ( `name` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;
#1050 - Table 'cpg143_bridge' already exists
What shall i do ? :-\
run this:
UPDATE `cpg143_config` SET `value` = 0 WHERE `name` = 'bridge_enable';
Επηρρεαζόμενες εγγραφές: 0 (Το επερώτημα χρειάστηκε 0.0581 δευτ/τα)
Translation: Affected values: 0 (Query execution time 0.0581 seconds)
- Check the xxx_config table , bridge_enable should be 0
- Clear your cookie
- Try login as an admin
Now the whole gallery is blank. None link is working :|
:o
What did you do !?
cleared cookies and hit refresh :-[
Ahhh,
by mistake, i changed 'value' type into FULLTEXT :'(
How can undo / change that?:|
:)
Use phpmyadmin and change it back to VARCHAR(255)
ALTER TABLE `cpg143_config` DROP INDEX `value` ,
ADD FULLTEXT `value` (
`value`
)
is that correct ? ???
ALTER TABLE `cpg143_config` MODIFY COLUMN `value` VARCHAR(255) NOT NULL DEFAULT '0';
done, succesfull but gallery still blank :|
Check out the attachment. Its a print screen of phpMyAdmin.
I see you've created fulltext index on your value , just delete it by click on X next to it ...
Do not change anything else please
done, but still blank :(( omg i am gonna suicide :'(
Ι '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 ?
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 ;D
I PMed you with all info.
Really thanks mate! Hope you solve the problem.. :'(
ah, forgot the ftp server.
its: ftp.stathrania.com
Cheers
Did you get my PMs ? I checked at my Outbox and there are no messages there..
Yes I've got your PM
give me some time to figure things out ,
- why didn't you upgrade anyway?
- 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
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 (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#14)
Sorry I don't have that much time to do it for you ...
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..
e107 goes unsupported. Ask the creator of your bridge file for help.
Sorry I don't understand what you say
- login as an admin and delete duplicated albums !!!
Do not play with database
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
I can't !
You have the backup ,
Ok i ll give it a try now..
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.
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 ...
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 ?
yes
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?
it should work ... but you need to insert only deleted pictures
try it with only one pic to see the result