IntegraMOD

Since doing the update no one can log in anymore not even me:

Here's what happens:

phpBB : Critical Error

User not found in IM preferences table

DEBUG MODE

SELECT * FROM phpbb_im_prefs WHERE user_id=153

Line : 95
File : functions_im.php

I'm about ready to give it up - I'm getting so many problems but this is a major on if no one can log in anymore.

Please advise anyone? thanks

Ok I can get now log in if I delete cookies in Firefox/IE and have them set to enabled, but normal users can't...

Which update did you do?

Can you change your cookie name in acp>General

Yes I could do that but what do I change it to - I did the latest security update after updating to 2.0.20

Is there a default value I could put in there for cookies name etc?

Thanks

try changing it to your domain name like lostit

It's already set to my domain name <img>

you left off the www and com correct?

Try changing it to see if it helps, just add a number to it.

Yes, this is what I have:

Cookie domain: mydomain.com

Cookie name: phpbb2mysql

Cookie path: /forum/

It worked no problem before the security update

Can I set these values to some generic default value at all?

Ok this is interesting, this problem only affects previously registered users.

New registrations have no problem, admins also have no problem.

Cookie name: phpbb2mysql

Try this

Cookie name: lostit

Tried changing it, but still have the same problem. I can log in, but a normal user can't. Interestingly, after failing to log in as a normal user, I then tried to log in as me (admin) and I too had the same problem. However, once I deleted the cookies in browser I was able to log in again, but normal user still can't.

This problem is the same in both Firefox and IE...at this rate everyopne will have to re-register as new members don't have the problem.

What is IM preferences table anyway and can I look at it in db?

try this

open phpmyadmin and select your current IM db

drop the tables

phpbb_im_prefs
phpbb_contact_list
phpbb_im_sites
phpbb_im_sessions
phpbb_im_config

now re-upload to your forum root, the folder "prill_install" , from the original Integramod zip.
(ill attach it in case you dont have it anymore)

in your web browser, go to http://www.your forum/prill_install/im_install.php

this will re-install prillian and add all your users to the phpbb_im_prefs table.

also check your config.php and be sure that after

define('PHPBB_INSTALLED', true);

you also have

define('PRILLIAN_INSTALLED', true);

thanks, I'll try that

That fixed the problem I think - well at least my sockpuppets can log in as normal users no problem now.

Thank you so much for taking the time to help me, it's much appreciated <img>

glad it worked out for you. <img>