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
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.
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
QuoteWhile 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
Quote// 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
Quote// 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 (http://kevmundial.com/gallery2)
thank you in advance
merged your identical postings. Don't double-post!
GauGau
ok done and sorry for that
Is this actually the name of your smf database?
Quote'kevmundi_gallery2.smf'
no the name is kevmundi_forum... the board works correctly its http://kevmundial.com/board
can i PM you?
No pm please.
Check your smf.inc.php file has this setting at line 48;
$path = '../board';
yes it has that setting
$path = '../board';
i also tried $path = '/home/kevmundi/public_html/board';
Ok, try changing line 86 to;
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.
its still the same
thats what i have
Quote// 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
Please post your latest mysql error.
same as before
QuoteWhile executing query "
SELECT variable, value
FROM smf_settings" on 0
mySQL error: Table 'kevmundi_gallery2.smf_settings' doesn't exist
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
ok thank you. i just have to run the install.php again or what?
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
ok everything worked but now i get another error code this is the syntax it has to do wit the database alsoUSER:
------------------
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)
You broke something, this is what I get on http://kevmundial.com/forum/index.php
QuotephpBB : 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
no sorry you got the wrong board the link to the board is kevmundial.com/board (http://kevmundial.com/board) and gallery is kevmundial.com/gallery2 (http://kevmundial.com/gallery2).
switch off debug_mode completely, or at least for the admin only and you should be fine.
GauGau
i still get some theme errors like undefined index but i think that shouldnt interfer with anything. also i dont know if i should create a new post for this but how can i make it so that when you log in it redirects you back to the gallery like the phpbb forum i s setup? also i setup the online stats block can i still use it with this?