Print

[jgb6534]

I know this is not the place for support requests, but in the interest of testing Coppermine 1.4.1 I wanted to report my experience with the Mambo bridge.

Yesterday, I successfully upgraded a fully functioning Coppermine 1.3.3 to 1.4.1.  I then used the Bridge Manager to connect to Mambo 4.5.2.3. 

After going through the bridging process, I tried to logout and I received an error message (sorry, didn't write it down).

Then I tried to access Coppermine and the only thing that displays is:  Fatal error :.  As per the docs, I tried to call up bridgemgr.php to undo the bridge.  Again, I get Fatal error :.

My next step was to go directly into Coppermine's config table (cpg133_config, in my case), and set bridge_enable to 0. This allowed me to get back into Coppermine.

Other site info:

Red Hat Enterprise Linux
Apache 2.0
PHP 4.3.2
MySQL 3.23.58

Oh, and here are the relative locations of the two packages:

Coppermine:  http://www.tcf.ua.edu/gallery/
Mambo:  http://www.tcf.ua.edu/

And my bridge settings:

Forum URL:    http://www.tcf.ua.edu
Relative path to your BBS's config file:    ../
Use post-based groups?:    0

Regards,

[Nibbler]

Enable debug mode and post the sql error message that you now get when you duplicate the error.

[jgb6534]

Here you go...

Code: [Select]

While executing query "delete from `tcfmambo`.mos_session where (time < 1121960659);" on 0

mySQL error: delete command denied to user: 'cpgadmin@localhost' for table 'mos_session'
It appears that Coppermine is trying to delete a record from the Mambo database's mos_session table, but, under the Coppermine MySQL/admin account (cpgadmin), it doesn't have the right to do so.

Interesting...

In this bridge, is the Coppermine MySQL account 'sposed to have the same rights as the Mambo MySQL admin account?


P.S.  SourceForge sure is busy and sloooow today.

[jgb6534]

I've since tried installing the bridge on another, different machine.  This time it was a completely fresh installation of Coppermine 1.4.1 (not an upgrade from 1.33 like my other machine).

Same result, I'm afraid.  I'll attach the debut info below.

I'm no PHP/MySQL expert, but I may try messing around with the code a bit anyway...

Debug info:

Code: [Select]

While executing query "delete from `jbutler_redrover`.mos_session where (time < 1122025132);" on 0

mySQL error: delete command denied to user: 'jbutler_copper@localhost' for table 'mos_session'


[Nibbler]

Can't you just give the user the required permissions ?

[jgb6534]

Can't you just give the user the required permissions ?

Yep!  And it worked!

So, what I wound up doing was going into phpMyAdmin and giving the Coppermine MySQL account the same rights as the Mambo MySQL account.

Still, it seems strange.  Shouldn't the following bit of mambo.inc.php code glom onto the Mambo account info?

Code: [Select]

// Database connection settings
$this->db = array(
'name' => $mosConfig_db,
'host' => $mosConfig_host ? $mosConfig_host : 'localhost',
'user' => $mosConfig_user,
'password' => $mosConfig_password,
'prefix' =>$mosConfig_dbprefix
);
Or, if the Coppermine and Mambo accounts do need to be the same, perhaps this should be added to the docs.

In any event, I'm glad to find this solution!

Regards,

Jeremy

[Joachim Müller]

glad that this was sorted out. However, imo this is not a bug, but a pilot error: if you want to bridge the two apps, this means that they can share access to the same database. Of course, if you want a mySQL user to perform operations on a database, you'll have to grant this user the access rights to do so. It's a very rare setup that you're using different mySQL accounts for two web apps that share the same database and server, so I can't see a point in adding this to the docs, as it will only confuse users (they will start messing with permissions even though they're on shared hosting with only one mySQL database and database user).
Marking this thread as "solved", as it's more some sort of support question than actually a bug report imo.

[jgb6534]

I bow to your greater experience with this, GauGau.  But perhaps I should detail the path I took that led me to this problem.  Who knows?  Maybe my setup is not that rare.

I think what threw me off is that the docs encouraged me to install Coppermine as a standalone app and to debug it thoroughly as such before messin' with bridging.  Which makes perfect sense.  You want to make sure your CPG installation is functioning correctly before you start complicating matters with another app. 

However, the standalone installation also implied--to me, at least--that CPG should live in its own database and that's how I set it up on both a shared host and a host that I control myself.  And, of course, for security's sake, I set up a unique database user for CPG.

And voila!  Two databases and two unique users!

Perhaps what the docs could indicate is that IF you've already got a CMS or BB running (as I did) and IF you plan on bridging CPG to it, THEN you should install the CPG tables in the CMS's database.  Or is that too many acronyms?

In any event, I'm still grateful for Coppermine, in general, and the Mambo bridge, in specific.  CPG is the best gallery app I've seen and the bridge was the last piece in my Mambo puzzle.

Thanks!

Jeremy

[Nibbler]

It looks like a bug with the mambo bridge to me, the delete command should be being run over the mambo db connection instead of the coppermine db connection. Can you put the permissions/users back as they were originally and then try this code change instead to the mambo bridge file ?

Code: [Select]

// Delete old sessions
$past = time()-$mosConfig_lifetime;
$sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
cpg_db_query($sql);
Change to

Code: [Select]

// Delete old sessions
$past = time()-$mosConfig_lifetime;
$sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
cpg_db_query($sql, $this->link_id);
Please report back.

[jgb6534]

Tried the new code, but got a fatal error again.

Sorry.

[rrhode]

Hi,

I am using Mambo 4.5.2.3 and Coppermine 1.4.1 with the bridge you guys are working with here and I am having a problem as well that might be related to this.

I would be interested in helping you fix this so maybe I can use coppermine on my site properly.

The site is at falomi.net/gallery

I have tried to visually integrate it using steps found here http://forum.mamboserver.com/showthread.php?p=254241#post254241

Now, there are a lot of people who do this so I think it only seems right for you to look at it this way too.  It isnt much of an edit we are doing with this but it is pretty neat if it works.

Whether you decide to look at this or not, lots of people are trying to use coppermine this way and I feel it would be a good idea to work together on this.

If you have a look at the site at falomi.net/gallery you will see whats happening.

I have followed all the steps numerous times and Im not quite sure whats happening but...

I get this {MAIN_MENU} {COPPERMINE_PATHWAY} and You are not authorized to view this resource.  You need to login.

It seems to be not parsing things together properly.  Some people are able to do this ok but not me.

Here is some info about the server...

Code: [Select]

PHP built On:  Linux locus.webserversystems.com 2.4.31-grsec #2 SMP Wed Jul 20 16:19:09 EDT 2005 i686  
Database Version:  4.0.24-standard  
PHP Version:  4.3.11  
Web Server:  Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a PHP-CGI/0.1b  
WebServer to PHP interface:  cgi  
Mambo Version:  Mambo 4.5.2.3 Stable [ Titan Reassigned ] 15-June-2005 04:30 GMT  
User Agent:  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)  
Relevant PHP Settings:  Safe Mode:  OFF  
Open basedir:  none  
Display Errors:  ON  
Short Open Tags:  ON  
File Uploads:  ON  
Magic Quotes:  ON  
Register Globals:  ON  
Output Buffering:  OFF  
Session save path:  /tmp  
Session auto start:  0  
XML enabled:  Yes  
Zlib enabled:  Yes  
Disabled Functions:  none  
WYSIWYG Editor:  No WYSIWYG Editor  
 



Here is the debug info from Coppermine

Code: [Select]

USER:
------------------
Array
(
    [ID] => ed652fbdfda9a6afb2a09fb96ae45866
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 1
    [priv_upl_need_approval] => 1
    [upload_form_config] => 3
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 3
    [ufc_min] => 3
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg140_filetypes; (0.002s)
    [1] => select * from cpg140_plugins order by priority asc; (0.001s)
    [2] => SELECT * FROM cpg140_bridge (0.001s)
    [3] => delete from `falomi_mamb1`.mos_session where (time < 1122369815); (0.039s)
    [4] => select userid from `falomi_mamb1`.mos_session where session_id=md5("054a847093091395e2d075a4f38a0a7570.49.11.114"); (0s)
    [5] => select id, password from `falomi_mamb1`.mos_users where id=0 (0.013s)
    [6] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg140_usergroups WHERE group_id in (3) (0.002s)
    [7] => SELECT group_name FROM  cpg140_usergroups WHERE group_id= 3 (0s)
    [8] => update `falomi_mamb1`.mos_session set time="1122370715" where session_id=md5("054a847093091395e2d075a4f38a0a7570.49.11.114"); (0s)
    [9] => DELETE FROM cpg140_banned WHERE expiry < '2005-07-26 09:38:40' (0.085s)
    [10] => SELECT * FROM cpg140_banned WHERE (ip_addr='70.49.11.114' OR ip_addr='70.49.11.114' OR user_id=0) AND brute_force=0 (0s)
    [11] => SELECT aid FROM cpg140_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0.035s)
    [12] => SELECT aid FROM cpg140_albums WHERE category = 0 (0.001s)
    [13] => SELECT cid FROM cpg140_categories WHERE parent = '0' (0.006s)
    [14] => SELECT aid FROM cpg140_albums as a WHERE category>=10000 (0s)
    [15] => SELECT cid FROM cpg140_categories WHERE parent = '1' (0s)
    [16] => SELECT aid FROM cpg140_albums WHERE category = 2 (0s)
    [17] => SELECT cid FROM cpg140_categories WHERE parent = '2' (0.001s)
    [18] => SELECT aid FROM cpg140_albums WHERE category = 7 (0s)
    [19] => SELECT cid FROM cpg140_categories WHERE parent = '7' (0s)
    [20] => SELECT aid FROM cpg140_albums WHERE category = 8 (0s)
    [21] => SELECT cid FROM cpg140_categories WHERE parent = '8' (0s)
    [22] => SELECT aid FROM cpg140_albums WHERE category = 9 (0s)
    [23] => SELECT cid FROM cpg140_categories WHERE parent = '9' (0s)
    [24] => SELECT aid FROM cpg140_albums WHERE category = 3 (0s)
    [25] => SELECT cid FROM cpg140_categories WHERE parent = '3' (0s)
    [26] => SELECT aid FROM cpg140_albums WHERE category = 10 (0s)
    [27] => SELECT cid FROM cpg140_categories WHERE parent = '10' (0s)
    [28] => SELECT aid FROM cpg140_albums WHERE category = 11 (0s)
    [29] => SELECT cid FROM cpg140_categories WHERE parent = '11' (0s)
    [30] => SELECT aid FROM cpg140_albums WHERE category = 12 (0s)
    [31] => SELECT cid FROM cpg140_categories WHERE parent = '12' (0s)
    [32] => SELECT aid FROM cpg140_albums WHERE category = 13 (0s)
    [33] => SELECT cid FROM cpg140_categories WHERE parent = '13' (0s)
    [34] => SELECT aid FROM cpg140_albums WHERE category = 14 (0s)
    [35] => SELECT cid FROM cpg140_categories WHERE parent = '14' (0s)
    [36] => SELECT aid FROM cpg140_albums WHERE category = 15 (0s)
    [37] => SELECT cid FROM cpg140_categories WHERE parent = '15' (0s)
    [38] => SELECT aid FROM cpg140_albums WHERE category = 4 (0s)
    [39] => SELECT cid FROM cpg140_categories WHERE parent = '4' (0s)
    [40] => SELECT aid FROM cpg140_albums WHERE category = 16 (0s)
    [41] => SELECT cid FROM cpg140_categories WHERE parent = '16' (0s)
    [42] => SELECT aid FROM cpg140_albums WHERE category = 17 (0s)
    [43] => SELECT cid FROM cpg140_categories WHERE parent = '17' (0s)
    [44] => SELECT aid FROM cpg140_albums WHERE category = 18 (0s)
    [45] => SELECT cid FROM cpg140_categories WHERE parent = '18' (0s)
    [46] => SELECT aid FROM cpg140_albums WHERE category = 5 (0s)
    [47] => SELECT cid FROM cpg140_categories WHERE parent = '5' (0s)
    [48] => SELECT aid FROM cpg140_albums WHERE category = 19 (0s)
    [49] => SELECT cid FROM cpg140_categories WHERE parent = '19' (0s)
    [50] => SELECT aid FROM cpg140_albums WHERE category = 20 (0s)
    [51] => SELECT cid FROM cpg140_categories WHERE parent = '20' (0s)
    [52] => SELECT aid FROM cpg140_albums WHERE category = 21 (0s)
    [53] => SELECT cid FROM cpg140_categories WHERE parent = '21' (0s)
    [54] => SELECT aid FROM cpg140_albums WHERE category = 22 (0s)
    [55] => SELECT cid FROM cpg140_categories WHERE parent = '22' (0s)
    [56] => SELECT aid FROM cpg140_albums WHERE category = 23 (0s)
    [57] => SELECT cid FROM cpg140_categories WHERE parent = '23' (0s)
    [58] => SELECT aid FROM cpg140_albums WHERE category = 24 (0s)
    [59] => SELECT cid FROM cpg140_categories WHERE parent = '24' (0s)
    [60] => SELECT aid FROM cpg140_albums WHERE category = 6 (0s)
    [61] => SELECT cid FROM cpg140_categories WHERE parent = '6' (0s)
    [62] => SELECT aid FROM cpg140_albums WHERE category = 25 (0s)
    [63] => SELECT cid FROM cpg140_categories WHERE parent = '25' (0s)
    [64] => SELECT aid FROM cpg140_albums WHERE category = 26 (0s)
    [65] => SELECT cid FROM cpg140_categories WHERE parent = '26' (0s)
    [66] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = ''  ORDER BY pos (0s)
    [67] => SELECT aid FROM cpg140_albums WHERE category = 2 (0s)
    [68] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 2 (0.002s)
    [69] => SELECT count(*) FROM cpg140_albums as a WHERE category = '2' (0s)
    [70] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg140_albums as a LEFT JOIN cpg140_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,1 (0s)
    [71] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg140_albums AS a  LEFT JOIN cpg140_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (1)GROUP BY p.aid (0.001s)
    [72] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg140_pictures WHERE pid='7' (0s)
    [73] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '2'  ORDER BY pos (0s)
    [74] => SELECT aid FROM cpg140_albums WHERE category = 7 (0s)
    [75] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 7 (0s)
    [76] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '7'  ORDER BY pos (0s)
    [77] => SELECT aid FROM cpg140_albums WHERE category = 8 (0s)
    [78] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 8 (0s)
    [79] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '8'  ORDER BY pos (0s)
    [80] => SELECT aid FROM cpg140_albums WHERE category = 9 (0s)
    [81] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 9 (0s)
    [82] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '9'  ORDER BY pos (0s)
    [83] => SELECT aid FROM cpg140_albums as a WHERE category>=10000 (0s)
    [84] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category >= 10000 (0s)
    [85] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '1'  ORDER BY pos (0s)
    [86] => SELECT aid FROM cpg140_albums WHERE category = 3 (0s)
    [87] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 3 (0s)
    [88] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '3'  ORDER BY pos (0s)
    [89] => SELECT aid FROM cpg140_albums WHERE category = 10 (0s)
    [90] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 10 (0s)
    [91] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '10'  ORDER BY pos (0s)
    [92] => SELECT aid FROM cpg140_albums WHERE category = 11 (0s)
    [93] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 11 (0s)
    [94] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '11'  ORDER BY pos (0s)
    [95] => SELECT aid FROM cpg140_albums WHERE category = 12 (0s)
    [96] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 12 (0s)
    [97] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '12'  ORDER BY pos (0.001s)
    [98] => SELECT aid FROM cpg140_albums WHERE category = 13 (0s)
    [99] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 13 (0s)
    [100] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '13'  ORDER BY pos (0s)
    [101] => SELECT aid FROM cpg140_albums WHERE category = 14 (0s)
    [102] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 14 (0s)
    [103] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '14'  ORDER BY pos (0s)
    [104] => SELECT aid FROM cpg140_albums WHERE category = 15 (0s)
    [105] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 15 (0s)
    [106] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '15'  ORDER BY pos (0s)
    [107] => SELECT aid FROM cpg140_albums WHERE category = 4 (0s)
    [108] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 4 (0.001s)
    [109] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '4'  ORDER BY pos (0.001s)
    [110] => SELECT aid FROM cpg140_albums WHERE category = 16 (0s)
    [111] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 16 (0s)
    [112] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '16'  ORDER BY pos (0s)
    [113] => SELECT aid FROM cpg140_albums WHERE category = 17 (0s)
    [114] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 17 (0s)
    [115] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '17'  ORDER BY pos (0s)
    [116] => SELECT aid FROM cpg140_albums WHERE category = 18 (0s)
    [117] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 18 (0s)
    [118] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '18'  ORDER BY pos (0s)
    [119] => SELECT aid FROM cpg140_albums WHERE category = 5 (0s)
    [120] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 5 (0.001s)
    [121] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '5'  ORDER BY pos (0s)
    [122] => SELECT aid FROM cpg140_albums WHERE category = 19 (0s)
    [123] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 19 (0s)
    [124] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '19'  ORDER BY pos (0s)
    [125] => SELECT aid FROM cpg140_albums WHERE category = 20 (0s)
    [126] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 20 (0s)
    [127] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '20'  ORDER BY pos (0s)
    [128] => SELECT aid FROM cpg140_albums WHERE category = 21 (0s)
    [129] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 21 (0s)
    [130] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '21'  ORDER BY pos (0s)
    [131] => SELECT aid FROM cpg140_albums WHERE category = 22 (0s)
    [132] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 22 (0s)
    [133] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '22'  ORDER BY pos (0s)
    [134] => SELECT aid FROM cpg140_albums WHERE category = 23 (0s)
    [135] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 23 (0s)
    [136] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '23'  ORDER BY pos (0s)
    [137] => SELECT aid FROM cpg140_albums WHERE category = 24 (0s)
    [138] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 24 (0s)
    [139] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '24'  ORDER BY pos (0s)
    [140] => SELECT aid FROM cpg140_albums WHERE category = 6 (0s)
    [141] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 6 (0s)
    [142] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '6'  ORDER BY pos (0s)
    [143] => SELECT aid FROM cpg140_albums WHERE category = 25 (0s)
    [144] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 25 (0s)
    [145] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '25'  ORDER BY pos (0s)
    [146] => SELECT aid FROM cpg140_albums WHERE category = 26 (0s)
    [147] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category = 26 (0s)
    [148] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '26'  ORDER BY pos (0s)
    [149] => SELECT aid FROM cpg140_albums as a WHERE category = '0' (0s)
    [150] => SELECT count(*) FROM cpg140_albums as a WHERE 1 (0s)
    [151] => SELECT count(*) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [152] => SELECT count(*) FROM cpg140_comments as c LEFT JOIN cpg140_pictures as p ON c.pid=p.pid LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0.001s)
    [153] => SELECT count(*) FROM cpg140_categories WHERE 1 (0s)
    [154] => SELECT sum(hits) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [155] => SELECT count(*) FROM cpg140_albums as a WHERE category = '0' (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 5.413 seconds - 156 queries in 0.194 seconds - Album set : ; Meta set: AND aid IN (1,2,3) ;

Code: [Select]

Notices
/bridge/mambo.inc.php
Warning line 354: Missing argument 1 for session_extraction()
Notice line 150: Undefined index: usercookie
/themes/coppermambo/template.html
Notice line 72: Undefined variable: str
/index.php
Notice line 726: Undefined variable: file
 


I dont know what the errors mean but I have tried everything and I cant figure it out.  It seems that other users are having this same problem and some are able to solve it and others are not.  So hopefully this information can help you in some way

Ryan

[jgb6534]

I am using Mambo 4.5.2.3 and Coppermine 1.4.1 with the bridge you guys are working with here and I am having a problem as well that might be related to this.

{snip}

I get this {MAIN_MENU} {COPPERMINE_PATHWAY} and You are not authorized to view this resource.  You need to login.

Maybe it's a template issue?

One problem I see is that version 1.4.1 of Coppermine eliminated {MAIN_MENU} from templates.  As it says in the docs:

Coppermine 1.4.1 officially split the main menu into two menus: SYS_MENU and SUB_MENU.

So, perhaps you have a funky template.

Was Coppermine working as a standalone app before you tried to bridge it?

Was version 1.4.1 installed fresh, or was this an upgrade from a previous Coppermine?

Regards,

[jmiba]

It looks like a bug with the mambo bridge to me, the delete command should be being run over the mambo db connection instead of the coppermine db connection. Can you put the permissions/users back as they were originally and then try this code change instead to the mambo bridge file ?

Code: [Select]

// Delete old sessions
$past = time()-$mosConfig_lifetime;
$sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
cpg_db_query($sql);Change to

Code: [Select]

// Delete old sessions
$past = time()-$mosConfig_lifetime;
$sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
cpg_db_query($sql, $this->link_id);
Please report back.

Ey! I fixed this!!

First. I changed ALL "cpg_db_query($sql);"

Second, and the most important one: mambo.inc.php has an error, please put:
      

Code: [Select]

// Connect to db
$this->connect();BEFORE:

Code: [Select]

// Delete old sessions
$past = time()-$mosConfig_lifetime;
$sql = 'delete from '.$this->sessionstable.' where (time < '.$past.');';
cpg_db_query($sql, $this->link_id);
(and not after!)

This is working fine for me 

[CPG Guru]

Hi

im having :

mambo 4.5.2
copg:1.4.1 beta

& after installing cpg 1.4.1 & sharing same database & its username & password that is with mambo 4.5.2

ive moved to admin tools > bridge & enter www.sitename.com & in config file i enter : ../

& after this click no for post users steps & start bridging

But when I return www.sitename.com/gallery/bridgemgr.php & enter my default name & pwd enter during installation of coppermine  i got this error


Authorization failed
You supplied the wrong credentials. You will have to supply the admin account data of the standalone version (usually the account you set up during Coppermine install). 



Please suggest

[Joachim Müller]

don't post dummy placeholder domains, but actual links.

[seb123]

I made the changes in mambo.inc in de bridge folder, but when i'm bridge en finishes a get to the main page of my website. Ans it seems that noting is changed. Do i have to make an menu item (can't see a component for coppermine).
Can also somebody explain what happend is bridging is succesfull? And another question: does the registered users in coppermine also be (after the bridging) registered in mambo?
Thanks!

Seb

[Nibbler]

This is the bugs forum, it is not for asking support questions. Why are you bridging if you have idea what it is ??

[Joachim Müller]

moving this thread from the bugs board to support.

[hfhs72]

Well I had my Mambo bridge working flawlessly until I just upgraded to Mambo 4.5.3h. A new patch. Now I get:

Fatal Error:

While executing query "insert into `hfhs72_XXXX`.mos_session (session_id, username, guest, time, gid) values ("0d27e38a198f44c9aa493139eb67d3f9", "", 1, "1136590132",0)" on 0

mySQL error:

Any ideas how to fix it.

[hfhs72]

Ok, disregard --- I have that problem solved. I needed to add my mambo username to the Coppermine mysql database.