Cannot make group permission to work. Cannot make group permission to work.
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Cannot make group permission to work.

Started by halloway, July 19, 2005, 07:59:48 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

halloway

Hi,

I just uploaded Coppermine version: 1.3.3 and bridged to SMF 1.1 Beta 3 Public.

Everything looks fine when it comes to login for me as an admin and I have also logged in with a test user id from SMF. However, when using test user, Coppermine will not allow uploads. I know this has to do with group permissions.

But.....when clicking on Groups in Coppermine and to sync the info from SMF, I get this error message:

QuoteWhile executing query "SELECT ID_GROUP as usergroupid, groupName as title FROM `forumhall`.SMF_membergroups" on 0

mySQL error: Table 'forumhall.SMF_membergroups' doesn't exist

SMF_membergroups does exist in the database, but why cannot Coppermine find it?

Here is my debug info:

QuoteUSER:
------------------
Array
(
   [ID] => cb3a517433f2de9c6877a1766f8784df
   [am] => 1
)

==========================
USER DATA:
------------------
Array
(
   [disk_max] => 0
   [disk_min] => 0
   [can_rate_pictures] => 1
   [can_send_ecards] => 1
   [ufc_max] => 3
   [ufc_min] => 3
   [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] => 8
           )

    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content FROM cpg133_filetypes;
       [1] =>
          SELECT variable, value
          FROM smf_settings
       [2] =>
             SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, a.attachmentType
             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 cpg133_usergroups WHERE group_id in (1,8)
       [4] => SELECT group_name FROM  cpg133_usergroups WHERE group_id= 1
       [5] => DELETE FROM cpg133_banned WHERE expiry < '2005-07-19 12:51:39'
       [6] => SELECT * FROM cpg133_banned WHERE ip_addr='64.71.110.58' OR ip_addr='64.71.110.58' OR user_id=1
       [7] => SELECT ID_GROUP as usergroupid, groupName as title FROM `forumhall`.SMF_membergroups
    )

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

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.11 - OK
    ------------------
    mySQL version: 3.23.56
    ------------------
    Coppermine version: 1.3.3
    ==========================
    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.56
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /tmp/mysql.sock
    MYSQL_INCLUDE -I/usr/local/mysql/include/mysql
    MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient  
    ==========================
    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.513 seconds - 8 queries in 0.008 seconds - Album set :

Nibbler

The smf10.inc.php bridge file is for SMF 1.0, SMF 1.1 is not currently supported.

shipwreck

is there still no fix for this? or work around.  I also have the latest SMF 1.0.5 I think

Joachim Müller

coppermine runs fine with SMF1.0.5 (or whatever 1.0.x version you have), but it does not run with SMF1.1.x. This has been discussed both on the SMF forum as well as the coppermine forum in detail, Please search the forum if you need details.