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



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



13
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 ...)?



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



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



16
schwob
Re: how to delete all postings of a specific user ?
  • 2004/1/16 9:45

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


before I try: would this delete only this user's postings ? or would all subsequent replies be deleted, too ?



17
schwob
Re: how to delete all postings of a specific user ?
  • 2004/1/16 9:38

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


would this delete all his postings, too ?!
of course this would be perfect ... didn't even think of this ...



18
schwob
how to delete all postings of a specific user ?
  • 2004/1/16 8:14

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


hi,
I would like to delete all postings of a specific user who is abusing my forum. I'm currently running XOOPS 2.0.5.
I hope it could be done by just running a smart SQL command like "delete ... from ... where user = ..." but I have no idea about the details. Is it enough to delete records from just one table or do I have to touch multiple tables ? Will the remaining thread structure "survive" such an operation ?
many thanks.




TopTop
« 1 (2)



Login

Who's Online

181 user(s) are online (146 user(s) are browsing Support Forums)


Members: 0


Guests: 181


more...

Donat-O-Meter

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

Latest GitHub Commits