XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Cannot login after update 2.0.13 => 2.2 - help!
Register
1
schwob
Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 22:21

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


Hello XOOPS gurus, I'm in deep trouble:
after upgrading from 2.0.13 to 2.2 following all instructions (I hope), I cannot login to my site anymore (using my administrator account). It behaves as if I enter the wrong password - but it's correct!
I had disabled access to my site before the upgrade (restricted access to administrators).
Now each login attempt falls back to the login page with the "site closed" message.
I wonder if this may be related to the language setting "German" which has been active before starting the upgrade?
I have root access to my server so I can do changes in the database - if I knew what and where ...
Please help ... thanks.
2
m0nty
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 22:38

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


did you run the upgrade script?

xoopsupdate.php
3
schwob
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 22:45

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


I did - however, there I might have made a mistake: I loaded URL www.mysite.com/xoopsupdate.php only once and immediately clicked "Submit" - now I realized the instructions say I should have reloaded this page once... Now I cannot get to it again - I always get redirected to the "site closed" screen.
4
rowdie
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:11

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


ok, then maybe check your database.

Look for the database table called [xoopsprefix]_users

See if there is a field called 'loginname'.

If it's there, then check to see whether it's empty for the webmaster user. If it's empty, put your user name in that field.

If the loginname field is missing altogether you could make a temporary one, just to get through the login process.

lets first see if that's necessary...
5
schwob
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:20

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


I had a look:

mysql> SELECT * FROM `xoops_users` WHERE loginname='markus';
ERROR 1054: Unknown column 'loginname' in 'where clause'
mysql>

("markus" is my admin user)

mysql> SELECT * FROM `xoops_users` WHERE uname='markus';
=> lists the account details

=> so the user is not completely missing but there is no loginname field

How can I create it manually (I know some SQL basics but I have no idea about the XOOPS database structures ...)?
6
rowdie
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:27

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I was thinking that it might have something to do with the site being closed. You could first try opening it, running the xoopsupdate.php script again, then closing it.

to open your site:
UPDATE xoops_config SET conf_value=0 WHERE conf_name = 'closesite'

closing it again is conf_value=1


or to add the extra field to your users table:

ALTER TABLE xoops_users ADD `loginname` VARCHAR( 25 ) NOT NULL AFTER `uid`
7
schwob
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:42

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


rowdie, you are great!

opening the site and running xoopsupdate.php script again was a very good idea. I can get back in now! MANY THANKS!

However, the home page is empty, just the menus on the left hand side (other sections seem ok at a first glance). Another quick idea?
8
rowdie
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:46

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I'm very pleased to hear that it worked

I don't know what the problem with blocks might be, I'm afraid. Sorry, can't help you there.

It is blocks that you're missing from the front page, isn't it? Or did you have a module set as start page?

Rowd
9
schwob
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:53

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


anyway, thanks again.
yes, blocks from the front page which is my default startup page.

maybe someone else has an idea why the blocks on the home page may have disappeared? I will browse the other forums and posts as well ...
10
rowdie
Re: Cannot login after update 2.0.13 => 2.2 - help!

  • 2005/7/30 23:56

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I'm going to examine the xoopsupdate.php script... if I find anything about your blocks I'll post again in this thread.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

162 user(s) are online (105 user(s) are browsing Support Forums)

Members: 0

Guests: 162

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits