Coppermine integration

[[Unknown]]

You could be using PATHS not URLs.

-[Unknown]

[DaMysterious]

You could be using PATHS not URLs.

-[Unknown]

Thanks, but nope.

// other includes
cm_include_smf_funcs("C:\Inetpub\smf\Sources\Load.php", array("reloadSettings", "md5_hmac", "loadUserSettings"));
cm_include_smf_funcs("C:\Inetpub\smf\Sources\Security.php", array("updateMemberData", "updateStats", "updateSettings"));

Fatal error :
There was an error while processing a database query

[[Unknown]]

Use two slashes when using windows-type paths.  Examples:

C:\\Inetpub\\smf\\Sources\\Load.php
C:/Inetpub/smf/Sources/Load.php

Both of the above should work fine.

-[Unknown]

[DaMysterious]

Use two slashes when using windows-type paths.  Examples:

C:\\Inetpub\\smf\\Sources\\Load.php
C:/Inetpub/smf/Sources/Load.php

Both of the above should work fine.

-[Unknown]

Sorry but this does'nt works to  .

[Shadowc]

Use two slashes when using windows-type paths.  Examples:

C:\\Inetpub\\smf\\Sources\\Load.php
C:/Inetpub/smf/Sources/Load.php

Both of the above should work fine.

-[Unknown]

Sorry but this does'nt works to  .

Do you have right table prefix in the bridge file ?
If you have upgraded from YaBB the prefix should be yb_

// Prefix for the database tables
define('SMF_TABLE_PREFIX',  'SMF_'); // Table Prefix

[DaMysterious]

Do you have right table prefix in the bridge file ?
If you have upgraded from YaBB the prefix should be yb_

// Prefix for the database tables
define('SMF_TABLE_PREFIX',  'SMF_'); // Table Prefix

My setup is a fresh install and the prefix is OK. I checked all and everything til no but nothing wil help  .

[Shadowc]

I will install coppermine at my local wintendo machine and try to figure out the problem.

Ill be Back

[DaMysterious]

I will install coppermine at my local wintendo machine and try to figure out the problem.

Ill be Back

That would be great. Hold in mind that I use the latest Cpg public beta 1.3b4.

[jack]

Just to point out that the Coppermine bridge for SMF is available in the Coppermine CVS repository, and is in the beta packages for 1.3.

I have received two IMs today asking for the bridge.

[DaMysterious]

Just to point out that the Coppermine bridge for SMF is available in the Coppermine CVS repository, and is in the beta packages for 1.3.

I have received two IMs today asking for the bridge.

I tryed this bridge om my server 2003 and stuck on it as you could read above.

[jack]

I tryed this bridge om my server 2003 and stuck on it as you could read above.

My message was to make it clear to others where to get it from, so they don't have to hope that I'm able to see the message - things are a bit hectic for me at the moment.

Unfortunatley, I don't have a Windows box to try this on, but after trying Unknown's suggestions, the error messages should have changed. Can you post the current ones please?

[DaMysterious]

I tryed this bridge om my server 2003 and stuck on it as you could read above.

My message was to make it clear to others where to get it from, so they don't have to hope that I'm able to see the message - things are a bit hectic for me at the moment.

Unfortunatley, I don't have a Windows box to try this on, but after trying Unknown's suggestions, the error messages should have changed. Can you post the current ones please?

Code Select Expand


Fatal error :
There was an error while processing a database query


with the latest changes suggested by Unknown for my Windows box.

[jack]

Do SMF and Coppermine both work properly seperateley?

Test this by removing the entry for the bridge from init.inc.php. If so, turn on debug mode in Coppermine band re-enable the bridge.

[DaMysterious]

Do SMF and Coppermine both work properly seperateley?

Test this by removing the entry for the bridge from init.inc.php. If so, turn on debug mode in Coppermine band re-enable the bridge.

Both verions working wel standalone.

In bridgemode this error came up in Coppermine with bridge enabled:

Code Select Expand


Fatal error :

There was an error while processing a database query.


While executing query "
SELECT variable, value
FROM smf_settings" on 0

mySQL error: Table 'coppermine.smf_settings' doesn't exist


[Ben_S]

mySQL error: Table 'coppermine.smf_settings' doesn't exist

Are your SMF tables in your database named coppermine?

[DaMysterious]

mySQL error: Table 'coppermine.smf_settings' doesn't exist

Are your SMF tables in your database named coppermine?

No! Both databases resides appart on my server, one for /coppermine and the other for /smf, noting is mixed up (both works standalone without problems). You may check SMF [nofollow] and Coppermine [nofollow] on that. Personally I think this is a redirection problem for Wind-Boxes in the bridgefile of coppermine but as I'm not a programmer I could'nt trace the problem  .

[[Unknown]]

Database and directory are not synonymous.

In smf/Settings.php, what is $db_name?  What is $db_prefix?

What database name is Coppermine installed under?

-[Unknown]

[DaMysterious]

Database and directory are not synonymous.

In smf/Settings.php, what is $db_name?  What is $db_prefix?

What database name is Coppermine installed under?

-[Unknown]

My smf/settings.php

Code Select Expand


########## Forum Info ##########
$mbname = 'My Community'; # The name of your forum.
$language = 'english'; # The default language file set for the forum.
$boardurl = 'http://damysterious.xs4all.nl/smf'; # URL to your forum's folder. (without the trailing /!)
$webmaster_email = '[email protected]'; # Email address to send emails from. (like [email protected].)
$cookiename = 'SMFCookie10'; # Name of the cookie to set for authentication.

########## Database Info ##########
$db_server = 'localhost';
$db_name = 'smf';
$db_user = 'root';
$db_passwd = '';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

########## Directories/Files ##########
# Note: These directories do not have to be changed unless you move things.
$boarddir = dirname(__FILE__); # The absolute path to the forum's folder. (not just '.'!)
$sourcedir = dirname(__FILE__) . '/Sources'; # Path to the Sources directory.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 0;

if (file_exists(dirname(__FILE__) . '/install.php'))
header('Location: http://' . (empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST']) . dirname($_SERVER['PHP_SELF']) . '/install.php');


And my coppermine/include/config.inc.php

Code Select Expand


// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] =                       "localhost";        // Your database server
$CONFIG['dbuser'] =                         "root";        // Your mysql username
$CONFIG['dbpass'] =                         "";                // Your mysql password
$CONFIG['dbname'] =                         "coppermine";        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =                "cpg_";


[[Unknown]]

Hmm, it's possible that the bridge may not expect that....

Jack, you should use $db_name . '.' . $db_prefix as the SMF prefix.

-[Unknown]

[jack]

Yup - there are many problems and awkward situations introduced when Coppermine and any Forum it is integrating with do not share the same database. The current recommendation is to have them both share the same DB,

http://coppermine.sourceforge.net/manual.php#integrating