[Beta 1.5.4] Coppermine Photo Album - YabbSE Integration Bridge V 0.9.2

[kartoo]

I'm trying to integrate CPG 1.2 with YaBBi 1.1 (yabbse 1.4.1 core)
 
Now i'm blocked on this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\htdocs\forum\Sources\Load.php on line 143

Line [email protected] is
if (mysql_num_rows($request) != 0)

part of LoadUserSettings(), a native function of YaBB that is working fine in the forum

Code Select Expand

function LoadUserSettings () {
   global $username,$settings,$password,$action,$realname,$realemail,$yySetCookies,$pwseed,$HTTP_COOKIE_VARS;
   global $cookieusername,$cookiepassword,$pwseed,$ID_MEMBER,$realNames,$db_prefix;

   /* Only load this stuff if the username isn't Guest */
   if($username != 'Guest')
   {
      $request = mysql_query("SELECT passwd,realName,emailAddress,websiteTitle,websiteUrl,signature,posts,memberGroup,ICQ,AIM,YIM,gender,personalText,avatar,dateRegistered,location,birthdate,timeFormat,timeOffset,hideEmail,ID_MEMBER,memberName,MSN,visualAdmin FROM {$db_prefix}members WHERE memberName='$username' LIMIT 1");
      /* If we found the user... */
      if (mysql_num_rows($request) != 0)
      {
         /* Initialize the settings array */
         $settings = mysql_fetch_row($request);
.....................................

If i use a pair of echo() i notice that $username is loaded correctly

Where is the problem??  :?:  :?:  :?:      
Thanks for help

[kartoo]

I finally found the error

$db_prefix is not loaded correctly... so all you need to to is change {$dbprefix}.members to you_real_db_prefix.mebers

[EliteRides]

I know I saw it somewhere, but I can't remember/find it on here or Coppermine's site.

How do you edit Coppermine to allow SSI.  More exact... I'm trying to get the SSI YaBB Menu to be called.

[jack-uk]

Ugh .. not sure, cos I'm a little drunk at the mo

Best wishes for the season, BTW

But .. IIRC, all the changes necessary in Coppermin are in include/mailer.inc.php. Also, SSI.php needs to be modified slightly.

Simply a couple of functions need to be renamed - there are only a couple of calls to thise functions so it isn't oo major.

The problem is that functions of the same name as those in Yabbse are defined

in Coppermines include/mailer.inc.php :-
Change all references to 'server_parse' to 'cpg_server_parse', and all references to 'smtp_mail' to 'cpg_smtp_mail'.

Also, in SSI.php, there are several lines similar to :-

include_once ($language)

or
include_once ($chklngfile2)

these need to be changed to

include_once ($full_yabbse_path. '/' .$language);

and

include_once($full_yabbse_path. '/' .$chklngfile2);

respectivley.

I think that is all I had to do when I last fiddled with it

[Uncle]

How can I understand if the bridge is working?
Can I see anything different?

my yabbse forum is here:
http://www.varesestore.it/community/yabbse

my coppermine album is here:
http://www.varesestore.it/community/photoalbum

tnx

[jack-uk]

It is working if you do not need to loginto the gallery after logging into yabbse. You will need to have 'Enable local storage of cookies' in YaBB SE turned OFF.

Also, you appear to be using an old version of Coppermine.

Download the latest version of coppermine from http://coppermine.sourceforge.net/ - this includes the latest version of the bridge.

[Uncle]

I've downloaded the 1.1 version because of what is written in the read me... so I have to download the latest one... ok, i'll try it...

tnx

[Uncle]

I've uploaded the lastest version of coppermine.
now i've a new problem: what's the cookie name? I have to put it in yabbse.inc.php and i receive this error:

Notice: Undefined variable: cookiename in /web/htdocs/www.varesestore.it/home/community/photoalbum/bridge/yabbse.inc.php on line 44

Fatal error: Call to undefined function: loadcookie() in /web/htdocs/www.varesestore.it/home/community/photoalbum/bridge/yabbse.inc.php on line 93

thank for helping me!

[Fizzy]

I've uploaded the lastest version of coppermine.
now i've a new problem: what's the cookie name? I have to put it in yabbse.inc.php and i receive this error:

Notice: Undefined variable: cookiename in /web/htdocs/www.varesestore.it/home/community/photoalbum/bridge/yabbse.inc.php on line 44

Fatal error: Call to undefined function: loadcookie() in /web/htdocs/www.varesestore.it/home/community/photoalbum/bridge/yabbse.inc.php on line 93

thank for helping me!

Did you use the install.php to install it?
I didn't have to make any changes to yabbse.inc.php when I used it and it's working a treat.

[Uncle]

i've followed the readme file in the lastest version of coppermine... but it doesn't tell about the cookie name... i'm looking for it due to the php error i have...

[kartoo]

Are you trying to install Coppermine under YaBBi??? (YaBB Italian Version)

[Fizzy]

Uncle,

I ignored the readme file when I had a look at the script in the install.php file.
If you run that script it will prompt you online for the settings etc. I didn't edit the yabbse file at all.

I do recall reading something about cookie problems on Coppermine forum and they recommended NOT suing the same cookie name as YaBBSE.

I just checked my cookie name for Coppermine and it's
cpg11d - NOT - YaBBSE

[kraphael]

Something strange is happening.

I integrated the latest version of coppermine with yabbse.

It works fine, except:

When I click on a link I made in coppermine to take the user back to the forum it logs them out.

If I instead type the url to the forum in the address bar of the browser it doesn't log them out and works fine.

The same is true in reverse.  When I click on a link I made to take the user to coppermine from the forum, it logs them out.

However, when I type type the address into the browser manually it stays logged in.

Any ideas?

Thanks

[Uncle]

Are you trying to install Coppermine under YaBBi??? (YaBB Italian Version)

I really don't know, but i think it isn't the italian version... my forum is located here: http://www.varesestore.it/community/yabbse

[Uncle]

Uncle,

I ignored the readme file when I had a look at the script in the install.php file.
If you run that script it will prompt you online for the settings etc. I didn't edit the yabbse file at all.

I do recall reading something about cookie problems on Coppermine forum and they recommended NOT suing the same cookie name as YaBBSE.

I just checked my cookie name for Coppermine and it's
cpg11d - NOT - YaBBSE

I ignored the readme file too, except for the part which tells about the coppermine integration with yabbse...
Step by step what i did was:
1. upload for all file and special chmod for launch install.php
2. modify for yabbse.inc.php in bridge and init.inc.php in include following what the readme file says http://www.varesestore.it/community/photoalbum/docs/README.html