[SOLVED]Users can no longer log in!!

[LostIt]

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

[LostIt]

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...

[Fubie]

Which update did you do?

Can you change your cookie name in acp>General

[LostIt]

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

[Fubie]

try changing it to your domain name like lostit

[LostIt]

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

[Fubie]

you left off the www and com correct?

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

[LostIt]

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?

[LostIt]

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

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

[Fubie]

Cookie name: phpbb2mysql

Try this

Cookie name: lostit

[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?

[Helter]

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);

[LostIt]

thanks, I'll try that

[LostIt]

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>

[Helter]

glad it worked out for you. <img>