problem integration smf coppermine

[ppeter]

hello!

after an normal install i have this error in coppermine:

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

i have acitvated:
define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'woltlab21');
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');

regards
peter

[Casper]

Undo the bridge (put the '//' back in the init.inc.php file), and check that everything works ok, if it does, turn on debug mode in config, turn the bridge back on, and post the full error message here.

[JayBachatero]

im having a problem with the cm and smf integration.  i did everything correct but it says couldnt connect to database.  i wrote the debug that showed bellow

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

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

My dabase setting on smf.inc is as follows

// database configuration
define('SMF_DB_NAME', $db_name); // The name of the database used by the board
define('SMF_DB_HOST', $db_server); // The name of the database server
define('SMF_DB_USERNAME', $db_user); // The username to use to connect to the database
define('SMF_DB_PASSWORD', $db_passwd); // The password to use to connect to the database

this is my init.inc file

// User database integration
// Uncomment the applicable line if you want to use it
define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin23');
// define('UDB_INTEGRATION', 'vbulletin30');
// define('UDB_INTEGRATION', 'yabbse');
// define('UDB_INTEGRATION', 'woltlab21');
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');

i reuploaded all the files to see and it still the same problem.  i tried what you said avobe and that how i got the error message.  my website gallery is kevmundial.com/gallery2

thank you in advance

[Joachim Müller]

merged your identical postings. Don't double-post!

GauGau

[JayBachatero]

ok done and sorry for that

[Casper]

Is this actually the name of your smf database?

'kevmundi_gallery2.smf'

[JayBachatero]

no the name is kevmundi_forum...  the board works correctly its http://kevmundial.com/board
can i PM you?

[Casper]

No pm please.

Check your smf.inc.php file has this setting at line 48;

Code Select Expand

$path = '../board';

[JayBachatero]

yes it has that setting

Code Select Expand

$path = '../board';

i also tried

Code Select Expand

$path = '/home/kevmundi/public_html/board';

[Casper]

Ok, try changing line 86 to;

Code Select Expand

define('SMF_DB_NAME', 'kevmundi_forum'); // The name of the database used by the board

edit, the above code had an extra '_', i've modified it to be correct.

[JayBachatero]

its still the same
thats what i have

// database configuration
define('SMF_DB_NAME', 'kevmundi_forum'); // The name of the database used by the board
define('SMF_DB_HOST', $db_server); // The name of the database server
define('SMF_DB_USERNAME', $db_user); // The username to use to connect to the database
define('SMF_DB_PASSWORD', $db_passwd); // The password to use to connect to the database

[Casper]

Please post your latest mysql error.

[JayBachatero]

same as before

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

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

[Joachim Müller]

Eventually you have to databases: your forum seems to be running on database 'kevmundi_forum', your gallery on 'kevmundi_gallery2'. This is simply a drawback with coppermine currently: it requires you to have both on the same database (refer to the documentation). So, move either your board or your gallery, so both are on the same database. If you can't, you currently can't use coppermine.

GauGau

[JayBachatero]

ok thank you.  i just have to run the install.php again or what?

[Joachim Müller]

Running the installer again would result in a total loss of all pics, comments etc. (and would reuire you to delete the install.lock file in the include dir). Not necessary (and not recommended).

Here's what you do:

• back up your database (with phpMyAdmin)
  
• Move all tables named "smf_*" from 'kevmundi_gallery2' to 'kevmundi_forum'
  
• edit include/config.inc.php (change reference from 'kevmundi_gallery2' to 'kevmundi_forum')
  
• clear the temp files in your browser
  
• Browse to your coppermine gallery and log in

GauGau

[JayBachatero]

ok everything worked but now i get another error code this is the syntax it has to do wit the database also

Code Select Expand

USER:
------------------
Array
(
   [ID] => 75b59e236a66fa937b8b94b36274eddd
   [am] => 1
)

==========================
USER DATA:
------------------
Array
(
   [0] => 0
   [disk_max] => 0
   [1] => 0
   [disk_min] => 0
   [2] => 1
   [can_rate_pictures] => 1
   [3] => 1
   [can_send_ecards] => 1
   [4] => 1
   [can_post_comments] => 1
   [5] => 1
   [can_upload_pictures] => 1
   [6] => 1
   [can_create_albums] => 1
   [7] => 0
   [pub_upl_need_approval] => 0
   [8] => 0
   [priv_upl_need_approval] => 0
   [group_quota] => 0
   [group_name] => Admin
   [group_id] => 1
)

==========================
Queries:
------------------
Array
(
   [0] => SELECT extension, mime, content FROM cpg130_filetypes;
   [1] =>
SELECT variable, value
FROM smf_settings
   [2] =>
SELECT
mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH
FROM smf_members AS mem
LEFT JOIN smf_attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER)
WHERE mem.ID_MEMBER = 1
LIMIT 1
   [3] => 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(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg130_usergroups WHERE group_id=1 or group_id=4
   [4] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1
   [5] => DELETE FROM cpg130_banned WHERE expiry < 1087964301
   [6] => SELECT * FROM cpg130_banned WHERE ip_addr='207.38.219.29' OR ip_addr='207.38.219.29' OR user_id=1
   [7] => SELECT * FROM cpg130_online WHERE user_ip = '207.38.219.29' AND user_id = 1
   [8] => UPDATE cpg130_online SET last_action = NOW() WHERE user_ip = '207.38.219.29' AND user_id = 1
   [9] => DELETE FROM cpg130_online WHERE last_action < NOW() - INTERVAL 5 MINUTE
   [10] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = ''  ORDER BY pos
   [11] => SELECT aid FROM cpg130_albums WHERE category>=10000
   [12] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category >= 10000
   [13] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '1'  ORDER BY pos
   [14] => SELECT aid FROM cpg130_albums as a WHERE category = '0'
   [15] => SELECT count(*) FROM cpg130_albums as a WHERE category>0
   [16] => SELECT count(*) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE a.category>=0
   [17] => SELECT count(*) FROM cpg130_comments as c LEFT JOIN cpg130_pictures as p ON c.pid=p.pid LEFT JOIN cpg130_albums as a ON a.aid=p.aid WHERE a.category>=0
   [18] => SELECT count(*) FROM cpg130_categories WHERE 1
   [19] => SELECT sum(hits) FROM cpg130_pictures as p LEFT JOIN cpg130_albums as a ON p.aid=a.aid WHERE a.category>=0
   [20] => SELECT count(*) FROM cpg130_albums as a WHERE category = '0'
   [21] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT 0,1
   [22] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (1) AND approved = 'YES' GROUP BY aid
   [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg130_pictures WHERE pid='2'
   [24] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND aid IN (2,1)
   [25] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg130_pictures WHERE approved = 'YES' AND aid IN (2,1)  ORDER BY RAND() LIMIT 8
   [26] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND aid IN (2,1)
   [27] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg130_pictures WHERE approved = 'YES' AND aid IN (2,1)  ORDER BY pid DESC  LIMIT 0 ,8
   [28] => SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (2,1)
   [29] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, pic_rating, votes, aid FROM cpg130_pictures WHERE approved = 'YES' AND votes >= '1' AND aid IN (2,1)  ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC  LIMIT 0 ,4
   [30] => SELECT COUNT(*) FROM **ERROR**
)

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

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

==========================
VERSION INFO :
------------------
PHP version: 4.3.2 - OK
------------------
mySQL version: 4.0.16
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.12 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.49
MYSQL_MODULE_TYPE builtin
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/local/lib/php | .:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.16 seconds - 31 queries in 0.006 seconds - Album set : AND aid IN (2,1)

[Joachim Müller]

You broke something, this is what I get on http://kevmundial.com/forum/index.php

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'kevmundi_forum.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 166
File : /home/kevmundi/public_html/forum/common.php

I told you not to touch 'kevmundi_forum', but apparently you did. Time to restore the backup I guess.

GauGau

[JayBachatero]

no sorry you got the wrong board the link to the board is kevmundial.com/board and gallery is kevmundial.com/gallery2. 

[Joachim Müller]

switch off debug_mode completely, or at least for the admin only and you should be fine.

GauGau