Support > cpg1.5 bridge contributions
Drupal 6 bridge
palle:
Because of the debug information given in my posting from 04:11 pm July 13th 2010, I just deployed the same system to a new site with a small change in order to do some more black box test on the problems.
Still drupal 6.17, cpg 1.5.7 (svn rev 7757).
New site:
http://www.egebjergvej.dk/bridgetest/ (drupal)
http://www.egebjergvej.dk/bridgetest/gallery/ (cpg)
This time I chose to not specify any database table prefix for cpg. And that actually took care of the fatal error 4) mentioned in my previous postings: Instead of the fatal error, I am now redirected to the user management in drupal - this is good.
So it could seem that something (error in my setup, error in drupal, error in cpg, error in the bridge) has the effect that the bridge makes cpg not consider table prefix correctly.
Error 3 is also gone - however now it indicates another error when choosing the admin tools:
--- Code: ---While executing query 'SELECT uid AS user_id, name AS user_name FROM `pallepalle_db_bridge_test`.users ORDER BY name' in include/functions.inc.php on line 5957
mySQL error: Unknown column 'uid' in 'field list'
--- End code ---
And errors 1 and 2 still remain the same. Still not good.
And one last thing: When disabling the visual integration plugin, error 1) still occurs. I just tried the same thing for my site created in my posting yesterday - and it had the same effect - error 1) is still present until I also disable the bridge. Strange, because yesterday I made the observation that error 1) was not present until I enabled the visual integration plugin....
extrabigmehdi:
@palle
just made some change to the bridge (overwrite the file drupal6.inc.php, with the new one) . The issue with usermgr should be gone.
I don't know why you get an error with admin tools, it works fine for me.
According to your error, the drupal database is called pallepalle_db_bridge_test.
Inside this database , there's a table called users. But for a weird reason, the column uid is missing in this table (a mandatory column).
Maybe drupal is not properrly installed ? i don't see why you get the error.
Is the column uid really missing ? I'm not sure drupale could work without it.
palle:
@extrabigmehdi
Thanks for the usermgr fix.
And I also think we are closing in on the other errors now - I think the cause for error 1) and 3) must be the same...
--- Quote from: extrabigmehdi on July 14, 2010, 03:10:12 am ---According to your error, the drupal database is called pallepalle_db_bridge_test.
Inside this database , there's a table called users. But for a weird reason, the column uid is missing in this table (a mandatory column).
Maybe drupal is not properrly installed ? i don't see why you get the error.
Is the column uid really missing ? I'm not sure drupale could work without it.
--- End quote ---
Drupal is properly installed and also works fine regarding user management - the problem is that the database table pallepalle_db_bridge_test.users is not belonging to drupal, but to coppermine - as I wrote yesterday, coppermine was installed without database prefix. In coppermine, the id field is called user_id, not uid.
I am baffled that this works for you, as I should think it is a pretty basic error and that I can not see how you could get around it by having drupal and cpg share the same users table, as the layout is different.
The only thing I can come up with is my bridge settings that could be wrong - my settings are:
full_forum_url : http://www.egebjergvej.dk/bridgetest
relative_path_to_config_file : ../
use_post_based_groups : 1.
By the way, there is a small error in the online help when setting the URL of the bridge app - it says to contradictory things:
--- Code: ---Make sure to add a trailing slash - the URL must be http://www.yourdomain.tld/forum/ and not just http://www.yourdomain.tld/forum
And when I do that, then I am given the following error:
There mustn't be a trailing slash in the field URL of the bridge app.
--- End code ---
Again to recap, I did the following:
- Installed drupal (6.17)
- Installed coppermine (1.5.7 - 7757)
(- Same administrator with same password was used for both drupal and coppermine)
- Enabled cpg module in drupal
- Enabled drupal bridge in coppermine
- Enabled visual integration
I think the problems occur already after enabling the bridge, because after removing the visual integration, then the problem is present - but I will test that in a new install if this information does not help...
extrabigmehdi:
hi,
since both drupal & coppermine have a table called users,
you must ensure that either:
- you use a database prefix for coppermine
- install them in separate database.
--- Quote ---the problem is that the database table pallepalle_db_bridge_test.users is not belonging to drupal, but to coppermine
--- End quote ---
Maybe you have installed coppermine after drupal, in same database ?
--- Quote ---am baffled that this works for you,
--- End quote ---
I'm not dreaming, see screenshot:
EDIT: see post from moderator below.
Works also, when disabling visual integration. Clean url of drupal doesn't seem to matter.
I've done a local install with last version of wampserver. I've disabled the display of errors, and off course enabled gd2.
Your error 3 is not useful because when I go to line 5957, I see no sql query.
Please don't use svn, but the regular coppermine release.
--- Quote ---By the way, there is a small error in the online help when setting the URL of the bridge app
--- End quote ---
I think you can specify in the bridge code, either you want a trailing slash or not . I asked for not.
Not a big matter.
--- Quote ---I think the cause for error 1) and 3) must be the same...
--- End quote ---
I also got error 1, but it's magically gone after a few random clicks. Maybe a bug from copermine ?
Ensure you run at least once the drupal cron.
And give at least permission "access cpg" to "authenticated users" in drupal backend for coppermine module , even if you get it by default for main admin drupal account.
The bridge code doesn't do any sql query. It just use either native functions of cpg or drupale (that might indirectly do sql query).
The only sql thing I do, is when creating a database connection .
In fact it depends if the database connection to drupale is sql, or sqli.
If it's sql, I tell coppermine to re-use the existing connection.
Otherwise I tell coppermine to create a new sql connection, but I'm not even sure that this one is used at all.
Joachim Müller:
--- Quote from: extrabigmehdi on July 14, 2010, 04:37:44 pm ---I'm not dreaming, see screenshot:
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fi286.photobucket.com%2Falbums%2Fll99%2Fextrabigmehdi%2Fth_drupa-capture.jpg&hash=f47e9538189a74716fdbe9cc3eeadd144b11da74)
--- End quote ---
Hotlinking is not allowed per board rules. Embedding images into postings has been disabled because of frequent abuse. That's why the board rules say that you should attach images instead of doing anything else. I did just that: I attached the image you refered to above to this posting.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version