Finally SMF and coppermine are one, but...

[doyle]

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?

[kegobeer]

Enable debug mode and post the actual error message.

[doyle]

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 :
  

[Nibbler]

Can you post the sections of the bridge file that you have changed ?

[doyle]

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

[Nibbler]

Put everything below

Code Select Expand

// ------------------------------------------------------------------------- //
// Nothing to edit below this line
// ------------------------------------------------------------------------- //

back as it was.

[doyle]

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?

[Nibbler]

No, I was joking 

[doyle]

BAH XD so crual