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. Beginner's Corner 
  4.  / Can't log in to my sites admin
Register
1
zpyder
Can't log in to my sites admin

  • 2005/8/7 21:28

  • zpyder

  • Just popping in

  • Posts: 9

  • Since: 2005/7/10


Hi all.
I've changed nothing from the last time I accessed my sites admin to make this happen. But basically, even though i am entering the correct username and password, and it says thanks for logging in, it returns me to the main page without any access to my user/admin panels.

If i try to access admin.php it says I don't have access rights. This is in firefox, so I tried IE, and it said something about the user not found, however the details on what I last submitted and posted are still on the server.

Is there any way to fix this? I set up my site so no one else could register, and that admin panels are only shown when you are logged in. So I'm screwed otherwise.
2
Stewdio
Re: Can't log in to my sites admin

  • 2005/8/7 23:01

  • Stewdio

  • Community Support Member

  • Posts: 1560

  • Since: 2003/5/7 1


Two possible fixes for this.

Log into your site VIA FTP and delete your /templates_c directory files.

Second, and most likely, you may have to kill any open sessions found in your MySQL tables.

To do this, go to your database VIA phpMyAdmin. Load up the database you have used for your site and look for a table called xoops_sessions (assuming you have used the default prefix).

Once there, click on browse to see the contents of the table. You will see here a list of IP's that are currently using sessions on your site (this happens irregardless of your preference settings in XOOPS Admin). Go to the bottom of the page and click on select all, then delete all table. Once asked for confirmation, select yes.

To be sure, back up your database first, in case by some unknown force of the universe, you happen to delete the wrong tables.

This should take care of your problem.
XOOPS Community Support
3
zpyder
Re: Can't log in to my sites admin

  • 2005/8/8 6:46

  • zpyder

  • Just popping in

  • Posts: 9

  • Since: 2005/7/10


I've already tried the template_c thing.

I tried the session table, but seem to be getting an error trying to view the contents/open the sessions table:

#1016 - Can't open file: 'xoops_session.MYI' (errno: 145)

Any idea what has happened?
4
zpyder
Re: Cant log in to my sites admin

  • 2005/8/8 21:40

  • zpyder

  • Just popping in

  • Posts: 9

  • Since: 2005/7/10


Oh well. It's still broken.
It's the last straw to be honest. I've stuggled so much with XOOPS and been let down by various bugs that it's going to have be back to the drawing board and another CMS. It's a pity as I've invested so much time and effort and gotten so far with the site.
5
MikeFalcor
Re: Cant log in to my sites admin

  • 2005/8/8 23:21

  • MikeFalcor

  • Just popping in

  • Posts: 33

  • Since: 2005/6/21


Wierd...this has just happened on my site as well. Shoutbox won't work, I can't get to Admin side of Xoops...um...bug?!

My site was working just fine 2 hours ago...I didn't do ANYTHING to it and now...BOOM! Uh...what the hell?
6
MikeFalcor
Re: Cant log in to my sites admin

  • 2005/8/8 23:43

  • MikeFalcor

  • Just popping in

  • Posts: 33

  • Since: 2005/6/21


OK - This went to really bad! I can't admin anything, my shoutbox is broken (says I don't have permission to view it), and I have checked the MySQL DB and all is perfectly fine!

Devs? Oh devs? Some help here!
7
Stewdio
Re: Can't log in to my sites admin

  • 2005/8/9 22:31

  • Stewdio

  • Community Support Member

  • Posts: 1560

  • Since: 2003/5/7 1


Select the table in your database and use the repair function. Once repaired, go in and terminate all the open sessions.

Quote:

zpyder wrote:
I've already tried the template_c thing.

I tried the session table, but seem to be getting an error trying to view the contents/open the sessions table:

#1016 - Can't open file: 'xoops_session.MYI' (errno: 145)

Any idea what has happened?
XOOPS Community Support
8
lameto
Re: Can't log in to my sites admin

  • 2005/8/22 9:54

  • lameto

  • Just popping in

  • Posts: 1

  • Since: 2005/8/22


Quote:

Stewdio wrote:
Select the table in your database and use the repair function. Once repaired, go in and terminate all the open sessions.

Quote:

zpyder wrote:
I've already tried the template_c thing.

I tried the session table, but seem to be getting an error trying to view the contents/open the sessions table:

#1016 - Can't open file: 'xoops_session.MYI' (errno: 145)

Any idea what has happened?



mysqlrepair -u root -p -a xoops2 xoops_sections
Enter password:
xoops2.xoops_sections                              OK
================================================================
mysqlrepair -u root -p  xoops2 xoops_sections
Enter password:
xoops2.xoops_sections                              OK
================================================================

and after all thats shits i see this BIG shit:
050822 12:41:39 /usr/sbin/mysqld: Can't open file: 'xoops_session.MYI'. (errno: 145)

any comments from "superfly" developers?!
9
twipsy20
Re: Can't log in to my sites admin

  • 2005/8/22 11:27

  • twipsy20

  • Just popping in

  • Posts: 81

  • Since: 2005/5/11


I cant not longer also log in as administrator or and user canot also log
what is the problem?


what actually happens is that it returns to the same page after logging it and i can see my user name and password in clear text in the address bar
10
twipsy20
Re: Can't log in to my sites admin

  • 2005/8/22 12:18

  • twipsy20

  • Just popping in

  • Posts: 81

  • Since: 2005/5/11


is there no one in here to help out with the loggin problem?
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

232 user(s) are online (129 user(s) are browsing Support Forums)

Members: 0

Guests: 232

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