forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: fets on November 19, 2006, 01:14:00 pm
-
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
-
- 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