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

[fets]

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

[Sami]

- 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

[fets]

- 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...

[Sami]

check the xxx_config table and look for value of bridge_enable it should be 0

[fets]

Its set on 1.

So, shall i change it, save the database, restore it and everything will work as before ?

[Sami]

just change it and see if it's working...

[fets]

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 ? :-\

[Sami]

run this:

Code Select Expand


UPDATE `cpg143_config` SET `value` = 0 WHERE `name` = 'bridge_enable';


[fets]

Επηρρεαζόμενες εγγραφές: 0 (Το επερώτημα χρειάστηκε 0.0581 δευτ/τα)

Translation: Affected values: 0 (Query execution time 0.0581 seconds)

[Sami]

- Check the xxx_config table , bridge_enable should be 0
- Clear your cookie
- Try login as an admin

[fets]

Now the whole gallery is blank. None link is working :|

[Sami]

What did you do !?

[fets]

cleared cookies and hit refresh 

[fets]

Ahhh,

by mistake, i changed 'value' type into FULLTEXT  :'(

How can undo / change that?:|

[Sami]

Use phpmyadmin and change it back to VARCHAR(255)

[fets]

ALTER TABLE `cpg143_config` DROP INDEX `value` ,
ADD FULLTEXT `value` (
`value`
)

is that correct ?

[Sami]

Code Select Expand


ALTER TABLE `cpg143_config` MODIFY COLUMN `value` VARCHAR(255) NOT NULL DEFAULT '0';


[fets]

done, succesfull but gallery still blank :|

[fets]

Check out the attachment. Its a print screen of phpMyAdmin.

[Sami]

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