mistic100,

I am sorry to be such a pain but I am now on my 4th reinstall today!

In my latest attempt to get this working I have created the file with the following code in it:

<?php

$conf['piwigo_users'] = 'smf_members';

$conf['user_fields'] = array(
  'id' => 'id_members',
  'username' => 'members_name',
  'password' => 'passwd',
  'email' => 'email_address'
  );

$conf['guest_id'] = 32000;

?>

I have saved the file.

In the piwigo_users table, I have set the ID for the user 'guest' to 32000 (I have discovered that it is a small integer)
In the piwigo_user_infos table I have set user_id to 32000 for status guest
I have created a member_name of guest in smf_members
In the smf_members table I have set the id_member to 32000 for member_name guest

When I log out of piwigo and attempt to open it again I get a page full of sql errors and am back to re-installing!

Help!

Bob

mistic100,

I have attached the errors as a text file.

Bob

mistic100,

This is the complete output.

Bob
================================================================

Warning:  [mysql error 1054] Unknown column 'id_member' in 'field list'

SELECT id_member AS id
     , members_name AS username
     , passwd AS password
     , email_address AS email
  FROM piwigo_users
  WHERE id_member = '32000' in /home/sites/thedomainnobodywanted.com/public_html/gallery/include/dblayer/functions_mysql.inc.php on line 770

Hi!

This is irritating! I am beginning to think that this is beyond me! I have lost count of how many times I have done a reinstall now! I appreciate your assistance.

This is the latest errors!

Bob
================================================================
Warning:  [mysql error 1054] Unknown column 'id_member' in 'field list'

SELECT id_member AS id
     , member_name AS username
     , passwd AS password
     , email_address AS email
  FROM piwigo_users
  WHERE id_member = '32000' in /home/sites/thedomainnobodywanted.com/public_html/gallery/include/dblayer/functions_mysql.inc.php on line 770

mistic100,

Good morning and thanks for the continued support! A step forward!

I have entered the following code which when saved does not generate any error messages:

<?php

$conf['users_table'] = 'smf_members';

$conf['user_fields'] = array(
  'id' => 'id_member',
  'username' => 'member_name',
  'password' => 'passwd',
  'email' => 'email_address'
  );

$conf['guest_id'] = 32000;

?>

The only problem is that piwigo does not then accept any password. At this stage SMF functions normally.

If I do a password reset with piwigo, it works as normal but SMF no longer accepts passwords. If SMF's password is reset it works as normal but piwigo no longer accepts any password and so it goes on!

Having checked the database, identical passwords are shown for both piwigo and SMF. In piwigo it is of type varchar(32) and SMF shows varchar(64).

Bob

Last edited by thecorfiot (2013-02-05 08:21:02)

mistic100,

Thank you. Would you be in a position to advise further in the event that I can find out the function SMF uses to hash password?

I understand if I am asking a lot. Thank you for the help you have provided.

Bob

Greybrow wrote:

I just started to think of integrating Piwigo with SMF and found this topic :)

I've found this in mediawiki bridge:

Code:

$pw = sha1(strtolower($username) . $password);

so I'm not sure if it's possible to pass it to $conf['pass_convert'] as it combines username and typed password to create password in database

Greybow,

Thanks for that. I too found that when checking out the SMF support site. My problem is that as I said from the outset, I am no coder! It would certainly be an asset to bridge the two applications as the gallery mods that are available for SMFare nowhere near the quality of Piwigo (IMHO).

Bob