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. Q and A 
  4.  / login doesnt login
Register
1
wolfk
login doesnt login

  • 2006/3/29 14:20

  • wolfk

  • Just popping in

  • Posts: 5

  • Since: 2006/3/29


Hi,

havent found anything that helped me, if i missed it im sorry.


A few days ago my /var disk got full (i know im stupid:P) causing my server to go berserk ^^ especially mysql.

after cleaning /var i restartet the daemon and apache etc.
everything works again. Great.

only prob is noone can login anymore, if u login on the page u get the message thank u for logging in please wait etc.

then the page reloads and u arent logged in.

any idea's on how to solve this problem?
2
Herko
Re: login doesnt login

  • 2006/3/29 15:02

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


check to make sure the session tables aren't corrupted, and if your mainfile.php still points to the corrects paths.

Herko
3
wolfk
Re: login doesnt login

  • 2006/3/29 16:21

  • wolfk

  • Just popping in

  • Posts: 5

  • Since: 2006/3/29


stupid that i didnt check phpmyadmin before might have helped,

when opening the XOOPS database i get the following error:

Fout

SQL-query: DocumentatieWijzigen

SELECT COUNT( * ) AS num
FROM `5_xoops`.`R9xX7_protector_access`

MySQL retourneerde: Documentatie
#1016 - Can't open file: 'R9xX7_protector_access.MYI' (errno: 145)
4
m0nty
Re: login doesnt login

  • 2006/3/29 16:24

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


your protector module table is corrupt..

use phpmyadmin and do a repair on the protector module table
5
wolfk
Re: login doesnt login

  • 2006/3/29 17:49

  • wolfk

  • Just popping in

  • Posts: 5

  • Since: 2006/3/29


I cant find the table _protector, however i did look in the modules table and repaired the XOOPS protector module, still same error, could it be that this table deleted itself somehow and if so how to get it back? (srry im not used to mysql)
6
m0nty
Re: login doesnt login

  • 2006/3/29 17:56

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


it could be.

R9xX7_protector_access is the table that's either corrupt or missing by the looks of it.

if it's not there at all, then you could try opening the sql file in the protector module sql folder, find the create query in that file and then copy/paste the query into your db (remember to add your XOOPS prefix to the beginning of the query tho..

that should then hopefully create the table and let you in..
7
wolfk
Re: login doesnt login

  • 2006/3/29 18:22

  • wolfk

  • Just popping in

  • Posts: 5

  • Since: 2006/3/29


Seems like the table still exists but that MySQL just cant open it.

when entering the query MySQL gives the error: R9xX7_protector_acces already exists.

if this is so then why
a) cant i c it in the table list
b) is it unable to open it


thanks for ur help so far

EDIT: maybe it would be easier to disable the protector module somehow(dunno how since i cant login) and then once i can login reinstall the module?
8
m0nty
Re: login doesnt login

  • 2006/3/29 19:17

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


are you on linux? or have shell access?

you could try from the commandline.

myisamchk -r /path/to/the/table

where the path would most likely be /var/mysql/......

etc and enter the location to the .myi file.

u might have to stop the mysqld service before you run it tho..
9
wolfk
Re: login doesnt login

  • 2006/3/29 19:54

  • wolfk

  • Just popping in

  • Posts: 5

  • Since: 2006/3/29


thanks a lot for your help.
that did the trick had to do the same for the sessions table once and now it works again. thanks
10
fbs777
Re: login doesnt login

  • 2006/4/1 16:31

  • fbs777

  • Just popping in

  • Posts: 48

  • Since: 2005/1/9 4


Quote:

wolfk wrote:
...noone can login anymore, if u login on the page u get the message thank u for logging in please wait etc.

then the page reloads and u arent logged in.

any idea's on how to solve this problem?
I have the same problem.
In phpmyadmin, after check the tables the erros results are:

Quote:
Problems with indexes of table `xoops_banner`
Warning PRIMARY and INDEX keys should not both be set for column `bid`
Problems with indexes of table `xoops_bb_posts`
Warning More than one INDEX key was created for column `topic_id`
Problems with indexes of table `xoops_bb_topics`
Warning PRIMARY and INDEX keys should not both be set for column `topic_id`
Problems with indexes of table `xoops_config`
Warning More than one INDEX key was created for column `conf_title`
Problems with indexes of table `xoops_newblocks`
Warning More than one INDEX key was created for column `mid`
Problems with indexes of table `xoops_priv_msgs`
Warning PRIMARY and INDEX keys should not both be set for column `msg_id`
Warning More than one INDEX key was created for column `to_userid`
Problems with indexes of table `xoops_ranks`
Warning More than one INDEX key was created for column `rank_min`
Problems with indexes of table `xoops_users`
Warning PRIMARY and INDEX keys should not both be set for column `uid`
Warning More than one INDEX key was created for column `uname`
Problems with indexes of table `xoops_wfs_category`
Warning PRIMARY and INDEX keys should not both be set for column `id`
Problems with indexes of table `xoops_wfschannel`
Warning PRIMARY and INDEX keys should not both be set for column `CID`


So, there is 2 problems:
Warning PRIMARY and INDEX keys should not both be set for column `XYZ`
and
Warning More than one INDEX key was created for column `XYZ`

1 - How can i solve this warnings?
2 - The error "login but not login" is because these warnings?

If help:
XOOPS 2.0.13.2
apache 1.3.34
MySQL 5.0.19-log
PHP 5.1.2

I dont have access to the server (is not a local site), so the only way is by phpmyadmin.

I already run the "repair tables" and "optimize tables".

I deleted the xoops_session and created another one with the code:
Quote:
CREATE TABLE `xoops_session` (
`sess_id` varchar(32) NOT NULL default '',
`sess_updated` int(10) unsigned NOT NULL default '0',
`sess_ip` varchar(15) NOT NULL default '',
`sess_data` text NOT NULL,
PRIMARY KEY (`sess_id`),
KEY `updated` (`sess_updated`)
) ENGINE=MyISAM;

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

126 user(s) are online (80 user(s) are browsing Support Forums)

Members: 0

Guests: 126

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