Problems with Integra upgrade

[roccogalati]

Your phpBB Version: 2.0.22
phpBB Type: Standard phpBB
MODs: No
Your knowledge: Advanced Knowledge
Board URL: http://www.mangaitalia.net/phpBB2

PHP Version:
MySQL Version:


What was done before the problem appeared?
I had phpBBfm installed, then i run its unistall utility and so i come back to phpBB 2.0.22


What was done to try to solve the problem?




De.scription and Message

I had phpBBfm installed, then i run its unistall utility and so i came back to phpBB 2.0.22


Now i would like to install IntegraMod...

I uploaded all the new files, except the config.php file. Then i downloaded this file "phpbb_to_im141.zip" and i uploaded this file "phpbb_to_im141.php" to the install directory.

When i run it, it says me:

[code]  Updating to IntegraMOD2 1.4.1  Information  Database type    ]


What i can do in order to upgrade my phpBB 2.0.22 to the Integra Mod?

Can the problem be resolved? <img>


Thanks to all, guys! i hope u can help me...

[Helter]

this has to be the second time the 141 .script was run because the version info was already in your db. You can edit phpbb_config using phpmyadmin and find the IM version "1.4.1" and change to "1.4.0", then re-run the update .script

[roccogalati]

now it works...

but i can't log in with my admin account, it says everytime:

Line number On/Off | Expand/Contract | Select all

 Sorry, this account has exceeded its log in attempts. It is now locked. If you are the rightfull user, please click below to be redirected to a page to unlock your id.  Click Here to unlock your account.

I try to unlock my nick, but when i login again, it gives me again the same error...

i tryed with others account and it says always the same thing <img>

(i've installed 1.4.0 for the moment, then i'll upgrade to 1.4.1)


in user table, all teh field related to "login attempts" are setted to "0"

[roccogalati]

yep, i run it twice because the first time it gave me the same error...


someone can help me, please?

[zenrei]

did you click on the forgot password link?

it'll email you a temporary password to get you through the door, then once you're in, you can change it

[roccogalati]

yep...

but i doesn't work...


all user accounts are locked!

so i can't go into the ACP


EDIT: when other users tries to log out they receive "invalid session"

EDIT1: when i try to unlock my account, it says me: ok, now u can log in again. But when i try it says me again that my account is locked...

[zenrei]

how are you unlocking it?

[roccogalati]

it says me this:

Line number On/Off | Expand/Contract | Select all

   Sorry, this account has exceeded its log in attempts. It is now locked. If you are the rightfull user, please click below to be redirected to a page to unlock your id.  Click Here to unlock your account.    

it ask my username and my mail, and then the secret answer... then he says me]  Thank you for unlocking your account. You may now login.[/code]

but if i try... it says me that my account is again locked...

at the other users says that their session is invalid...

[zenrei]

have you tried changing your login attempts in the 2 cells in your database?

[zenrei]

in the phpbb_users table

in the cells:

phpBBSecurity_login_tries
user_login_tries

change them to like 1 or 0 and see if that lets you (make them match)

Make a backup of that table before you edit anything, though, jic

[roccogalati]

nothing... i already tried to do this... but there is always the same problem...

i think there is some problem with user/session or cookies...

i deleted my old cookies... but nothing changed...

what can be at this point?

[zenrei]

i found this link:

http://www.integramod.com/forum/viewtop ... cked+admin

maybe that can help you?? Or did you try this already?

[roccogalati]

yes i've already tried it before to open this topic...
but nothing... the problem is still here...

but it's strange... it seems i'm the only one to have this problems <img>



i think it's not a password problems...

i think problem is related to the code of the login attempt... there is a way to delete it?

[zenrei]

i think you're right... for the simple fact that the password sent isn't resetting you.. it's like one part thinks you're locked and the other doesn't or something.

i thought i had read a post talking about disabling the login security.. i'll see if i can find it

[zenrei]

here's a link with an sql query you can run to unlock all accounts... see if that'll help

http://www.integramod.com/forum/viewtopic.php?t=2695

[zenrei]

if you have a backup of your database? maybe your can replace the phpbb_users table and see if it's just corrupted

[roccogalati]

i can't replace my phpbb_users table because it is too large, about 18mb...
but i think it's ok because all fields are right... <img>

banlist is empty and the user login field are setted to "0"

so i'm not explain to me why it tell me that accounts are blocked if the user fields are setted to Zero...

i think there is a problem with ctracker mod or something else... i read a topic on how to remove it, but i can't enter in my ACP, so i can't remove it...

[roccogalati]

Do u think i do better to return to the phpBB base?

<img>

[zenrei]

if you think it's CT messing it up, there has to be a back door way to disable it, i would think

here's a link on how to disable it

http://www.integramod.com/forum/viewtopic.php?t=3437

[roccogalati]

there is a little problem:

i'm using this forum: http://www.integramod.com/forum/dload.p ... file_id=95

i tried to upgrade to 1.4.1 but it gives me the same errors...


the problems is that in this version i've downloaded i don't have any folder named as "ctracker" and in common.php file there is no reference to ctracker

is it normal?



EDIT: i used 1.4.1, i disabled ctracker as de.scripted in that topic, but nothing changed...
all accounts are still locked...

but it's incredible... all user files are setted to "0" so in what way it says that theu are locked... boh! <img>

[zenrei]

i know that if you're upgrading from 140, you have 2 downloads... you have the upgrade folder, but you still have to download the 141 package (that has all the files / folders) as well.

if you only ran the install folder, and didn't upload the boat load of files, you only upgraded the database, not the program itself

[roccogalati]

yep, i did like u said... but the problem didn't solved...

i don't know... i think i'll come back to phpbb vanilla...

in this way i hope to solve all my problems... <img>

[zenrei]

but you said you're missing the CT folder??

that's part of the new upload, though.

have you tried uploading a fresh install to a new folder and importing your data to a fresh database just to see if it runs right?

[.QUACK.Major.Pain]

Did you setup your security page to lock # of admins and moderators.
I found if you have it set to 8 moderators and you actually have 9, they get locked out because you exceeded the amount entered.

[zenrei]

i forgot all about that!!

[roccogalati]

i can't import all the datas to another database because it's too large, about 80mb.

[.QUACK.Major.Pain]

I know I saw mention I think from Helter about everyone banned from site. The admin had to go through his database and manually remove bans.

I wonder if the same thing needs to be done with locked users.

...and your english is very good <img>

[roccogalati]

yep, but my banlist is already empty...

no entries... <img>


i don't know what i can do... i think the better thing it to come back to phpBB vanilla... the only chance to have a forum working again...

[Helter]

try this query from phpmyadmin

Line number On/Off | Expand/Contract | Select all

 UPDATE phpbb_users SET phpBBSecurity_login_tries = '0' WHERE user_id > '-2';

[roccogalati]

already tried

[Helter]

can you dl your database and send me the pphbb_config?
I have fixed this prob for others, but im drawing a blank as to how i did it.
also, add one of the banned users to the file. from phpbb_users
you can zip it and upload it to some obscure place on your webspace and pm me a link to it, then remove it...for security <img>

[roccogalati]

thanks for ur help! <img>

what do u mean with:

add one of the banned users to the file. from phpbb_users

?

actually, i have no banned user...

[Helter]

locked out users

[roccogalati]

U have a new pm! <img>

[Helter]

it appears that phpBBfm asigns user id's a little differently. First there is no anonomous account (user id -1) and your board founder account looks to be user id 1

run this querry in phpmyadmin

Line number On/Off | Expand/Contract | Select all

   INSERT INTO `phpbb_users` VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1169181082, 0, 0, 0.00, NULL, '', '', 0, 0, 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, NULL, 0, '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', 1178175050, 1, 1, 1170410317, 1, 1178747127, 1, '0.0.0.0', 1, 0, 1, 0, 0, '0.0.0.0', '', 0, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 15, 5, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 0, 7, 1, 5, 1, 1, 3, 3, 3, 1, 1, 1, 1, 1, 0, 0, NULL, 15, NULL, 2, 0, 1178080600, 0, 0, 1, 0, 0, 0, 0, '0', '0', '', '', 0, 0);  

using your ftp client, open profilcp/functions_profile.php

find

Line number On/Off | Expand/Contract | Select all

          if ( ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == 2) )  

replace with

Line number On/Off | Expand/Contract | Select all

          if ( ($userdata['user_level'] == ADMIN) && ($userdata['user_id'] == 1) )

this is assuming your account name is "rocco.g" and you are the "Board Founder"

[roccogalati]

Yep!

Now, it works very well!!!


Thanks a lot, Helter! u are great!

[zenrei]

you can upload your database to a new one if you break it up in sections instead of doing it in one huge upload.

[roccogalati]

yep i know...

but i can upload 321kb at max...

my db is about 70mb...

is not human...

[Helter]

have you tried "big dump" ?

http://www.integramod.com/forum/dload.p ... ile_id=140

I use it all the time for huge db's

[roccogalati]

ah! it looks very usefull!

next time i'll try it... thanks a lot! i really need an utility like this!

<img>