I finally got the two intergrated aftr 3 days of whaterness. however now i have a problem. i was fallowing the last instructions to sync the user groups. but there is something wrong
There was an error while processing a database query
And coppermine user list cant even find the page.
however i can log in an out on my SMF boards and it logs me in and out of Coppermine perfectly fine.
what else do i need to do?
Enable debug mode and post the actual error message.
okies
While executing query "SELECT ID_GROUP as usergroupid, groupName as title FROM `winterbr_smf1`.SMF_TABLE_PREFIXSMF_GROUP_TABLE" on 0
mySQL error: Table 'winterbr_smf1.SMF_TABLE_PREFIXSMF_GROUP_TABLE' doesn't exist
File: /home/winterbr/public_html/gallery/include/functions.inc.php - Line: 105
Notice: Constant smf_ already defined in /home/winterbr/public_html/gallery/bridge/smf.inc.php on line 106
Notice: Use of undefined constant SMF_TABLE_PREFIX - assumed 'SMF_TABLE_PREFIX' in /home/winterbr/public_html/gallery/bridge/smf.inc.php on line 378
Notice: Use of undefined constant SMF_GROUP_TABLE - assumed 'SMF_GROUP_TABLE' in /home/winterbr/public_html/gallery/bridge/smf.inc.php on line 378
Here is the debug info
USER:
------------------
Array
(
[ID] => 34fdbbd4d97ae3b4335598116a8091a2
[am] => 1
)
==========================
USER DATA:
------------------
Array
(
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 0
[custom_user_upload] => 0
[num_file_upload] => 5
[num_URI_upload] => 3
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[groups] => Array
(
- => 1
[1] => 4
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg_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 = 1)
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(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1,4)
[4] => SELECT group_name FROM cpg_usergroups WHERE group_id= 1
[5] => DELETE FROM cpg_banned WHERE expiry < 1113770127
[6] => SELECT * FROM cpg_banned WHERE ip_addr='24.2.39.36' OR ip_addr='24.2.39.36' OR user_id=1
[7] => SELECT ID_GROUP as usergroupid, groupName as title FROM `winterbr_smf1`.SMF_TABLE_PREFIXSMF_GROUP_TABLE
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.20-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create 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 /var/tmp/mysql.sock
MYSQL_INCLUDE no value
MYSQL_LIBS no value
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.0.7
Linked Version 1.2.0.7
==========================
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 | system,shell_exec,telnet,friends | system,shell_exec,telnet,friends
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
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 | 55M | 55M
==========================
Page generated in 0.298 seconds - 8 queries in 0.093 seconds - Album set :
Can you post the sections of the bridge file that you have changed ?
these are the peices i edited
// Set this to the location of your Settings file:
$path = '/board/';
// database configuration
define('SMF_DB_NAME', 'winterbr_smf1');
// The name of the database used by the board
define('SMF_DB_HOST', 'localhost');
// The name of the database server
define('SMF_DB_USERNAME', 'winterbr_smf1');
// The username to use to connect to the database
define('SMF_DB_PASSWORD', '*********'); //[edit GauGau] Removed password! [/edit]
// The password to use to connect to the database
// The web path to your SMF Board directory
define('SMF_WEB_PATH', "http://www.winterbreeze.com/board");
// The Name of the Cookie used for SMF logon
define('SMF_COOKIE_NAME', 'SMFCookie10');
// Prefix for the database tables
define('hi', 'smf_'); // Table Prefix
// Names for the database tables
define('smf_', 'members'); // The members table
define('smf_', 'membergroups'); // The groups table
Put everything below
// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //
back as it was.
um thats like EVERYTHING. Everything in the manual i was told to edit i did and you want me to put it back the way it was?
No, I was joking ::)
BAH XD so crual :D