Using view instead of table solved it for me now.
CREATE OR REPLACE VIEW smf_users_piwigo AS SELECT id_member AS id, member_name, passwd, email_address FROM smf_members;
Offline
oh great idea!
Offline
For information :
This post is quite old but I had the same problem with Piwigo 2.7.4 and my phpbb forum. In my case, it was the user_id field of the phpbb_users table the problem.
Moreover, I had to switch to md5 hash instead of pwg_password_hash : new users couldn't log in. (I changed the password field to char(255) and utf8 but that didn't fix the problem)
Offline
flop25 wrote:
I notify plg about your issue on the user list
So when you are going to fix this bug? Seems is almost 2 years old.
I have also reported identical error
http://piwigo.org/forum/viewtopic.php?p … 35#p163435
with the PhpBB3 external authentification and it's seems i'm not the only one who reported this.
Vassae wrote:
I had the same problem with Piwigo 2.7.4 and my phpbb forum. In my case, it was the user_id field of the phpbb_users table the problem.
You are right. I have changed the "user_id" column name to something else and now i do not have the error anymore.
Offline