Coppermine + IPB 3.0.0

[Tim77]

Forgive me if this has been addressed before but when will you be releasing an update for IPB 3.0.0? I have upgraded my forum but currently the gallery is offline due to SQL changes that the upgrade of IPB caused.

[phill104]

Usually, bridges come from user contributions. I'm not sure if any of the team use IPB. If that is the case then the bridge will probably have to come from the IPB community.

There are just too many 3rd party apps that could be bridged to for us to create one for all of them.

[Tim77]

Anyone figure this one out yet? I can't believe I am the only one running CPG and Invision 3.0.0. I hope some SQL/PHP savvy person can step up and resolve this. Thank you!

[St. Anger]

Anyone figure this one out yet? I can't believe I am the only one running CPG and Invision 3.0.0.

You're not alone, I'm waiting for a fixed bridge for IPB 3.0 as well.

I could probably fix it myself but I've been busy lately. Maybe if it's still not done within the next few months when I plan on upgrading my forums to IPB 3.0 then I'll work on it.

[Tim77]

Thank you, yup still waiting myself.

[aeolus]

While executing query "SELECT member_id , member_login_key FROM `ipb302c`.ibf_sessions AS s INNER JOIN `ipb302c`.ibf_members AS u ON s.member_id = u.id WHERE s.id = '16fcbd20b64d1f602ea88afce2376679'" on 0

mySQL error: Column 'member_id' in field list is ambiguous

There are same fileds called member_id in sessions and members table.

So it's ambiguous.

But how to edit?

Thanks.

[Joachim Müller]

You should have read the thread you're replying to: there currently is no IPB3 bridge available, so there's no use in asking for one here. If you came here to actually solve the question you have posted (what it means and how to circumvent it), let me quote from http://sqlzoo.net/howto/source/z.dir/err918/mysql
:

Error 1052 Column 'name' in field list is ambiguous
Problem
When more than one table is used (in a JOIN for example) there may be two columns with the same name.

Code Select Expand

SELECT name
  FROM bbc JOIN cia ON bbc.name = cia.name
In this example there is a column called name in bbc and also in cia.

Solutions
    * Include the table name before the column name:

Code Select Expand

      SELECT bbc.name
        FROM bbc JOIN cia ON bbc.name = cia.name

    * Alias at least one of the tables and use that

Code Select Expand

      SELECT B.name
        FROM bbc B JOIN cia ON B.name = cia.name

Specific to MySQL

You need to be a coder to understand the answer though.

[phill104]

Thank you, yup still waiting myself.

You may be waiting a long time. One of the big stumbling blocks is the fact that IPB is not a free GPL package but one that costs $149. While the team or supporters may download free apps (especially gpl ones) and create bridges for them, I am 100% certain that nobody who does not use IPB will pay out just to see if they can build a bridge. That limits you to the IPB community which is relatively small compared to some of the free options out there.

[Tim77]

I have given up for now. I went ahead and purchased IP. Gallery. I would have gladly paid the same amount for a bridge. When it comes to support, you get what you pay for. Coppermine is a great script, just not the support that I would like. If ever a bridge is created for newer verions of IPS I will likely use Coppermine again, but until then I will continue to pay for IP Gallery

[aeolus]

You should have read the thread you're replying to: there currently is no IPB3 bridge available, so there's no use in asking for one here. If you came here to actually solve the question you have posted (what it means and how to circumvent it), let me quote from http://sqlzoo.net/howto/source/z.dir/err918/mysql
:You need to be a coder to understand the answer though.

Thanks for your suggestion, and i fixed it.

Thanks so much.

P.s.
Any one using it should edit the code fist , about

$this->boardurl = 'http://ipb.tw/forum';

         require_once('../forum/conf_global.php');

[Joachim Müller]

Thanks for your readiness to share your insight with others, but I strongly doubt that this is the right solution: without actually looking into that bridge file I guess that it's not a bright idea to hard-code that stuff into the bridge file. The bridge file should need no edits as far as individual setup is concerned.

[aeolus]

Thanks for your readiness to share your insight with others, but I strongly doubt that this is the right solution: without actually looking into that bridge file I guess that it's not a bright idea to hard-code that stuff into the bridge file. The bridge file should need no edits as far as individual setup is concerned.

Fixed it and test IPB 3.0.2 + CPG 1.4.25 ok

The new bridge file is no need to be edited

[magicvorlon]

Hello,

Has anyone else tried the solution offered up by the previous poster?

I have an IPB 3.0.5 forum and am looking for a gallery solution as the Invision gallery doesn`t quite have all the features we need. The CPMfetch is also a winner for me. If I can get an IPB > CPG 1.4 bridged we will be all set.

Cannot post any links, we do not have Coppermine installed. I am simply "shopping" around at the moment.

Thank you.

[St. Anger]

Yes, I tired it several months ago with my forum/gallery and it worked perfectly.

[magicvorlon]

Appears to be working.

Usernames are not appearing under the thumbnails, not sure if this was a problem with the bridging or not.

After bridging is done, in the admin sub menu my "users" button is redirecting to my forum admin page - is this normal?

Thank you.

[Joachim Müller]

Locking...