Hey DobePhat,

Just tried out logging in incorrectly, and thankfully I was redirected to /user.php.

I hope it stays that way, hehe.

Thanks for the heads up BTW, later.

I just was conversing with Herve and he gave me a tip that worked for him:

Quote:

It did...so far. If I don't reply back to this thread, then it did the job. Thanks a bunch Herve.

My issue has arisen again, arrrgh!

More info to come, after I finish picking my hair up off the floor.

Great post Tobias, you helped me out a lot. Thanks.

OK

@Tom & Catz
Did the search, deleted the user, tried to login, no luck.

I also cleared templates_c and deleted cache\adminmenu, no luck.

With some great advice from Aph3x I emptied the _sessions table and it worked.

Thank you Catz, Tom, and Aph3x for your advice.

Last question; with _sessions being frozen, could it have been malicious or just one of those things?

P.S.
Welcome back Catz.

I did a check of my tables and all were ok except xoops_session which gives the cryptic response "in use". I checked all my table and they all gave the response "ok" except xoops_session which gave "Table is already up to date".

Is this normal?

Which tables specifically am I looking at? Also what would a corrupt table look like? I can make my way around PHP Admin well enough, just my SQL parsing isn't the greatest.

My admin account has miraculously stopped logging in. Top it off I cannot register as a new user. These problems seemed to begin back on the 16th of April after user wzza##### registered. I can't be certain of this as being related but it's quite a coincidence.

I've recently been doing some adjustments to my site and .htaccess file. I've copied a working copy of this file from a recent backup and still this problem persists.

Also the config seemed to be stuck in php5 aven after I removed the addhandler line code in .htaccess locking in php5. I've since locked it in back down to php4 since using php5 also gave me login issues.

Can anyone help me remedy this issue?

My Info:

Website URL:
http://kainaistudies.com

XOOPS Version:
XOOPS 2.0.17

XOOPS Theme:
7dana-jane

XOOPS Template Set:
default

PHP Version:
4.4.8

MySQL Version:
5.0.45-community

Server Software:
Apache/1.3.41 (Unix) mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a

User's Browser:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14

BTW,

Here is a snippet from the reply I received from my web host tech sup:

Quote:

Thanks Fellas.

Thanks John, here's the phpinfo.php readout with the extra code in .htaccess:

PHP Version 5.2.4

System Linux pass61.dizinc.com 2.6.9-55.0.12.ELsmp #1 SMP Fri Nov 2 12:38:56 EDT 2007 x86_64
Build Date Feb 5 2008 08:23:23
Configure Command './configure' '--enable-pic' '--with-libdir=lib64' '--prefix=/usr/local/php5' '--exec-prefix=/usr/local/php5' '--program-suffix=5' '--with-xml' '--enable-bcmath' '--with-iconv' '--enable-calendar' '--with-curl' '--with-dom=/opt/xml2/' '--with-dom-xslt=/opt/xslt/' '--with-dom-exslt=/opt/xslt/' '--enable-exif' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt=/opt/libmcrypt/' '--with-mhash=/opt/mhash/' '--enable-trans-sid' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pspell' '--enable-xslt' '--with-xslt-sablot' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--enable-wddx' '--with-xmlrpc' '--enable-soap' '--with-soap' '--with-zlib' '--enable-force-cgi-redirect' '--enable-pdo' '--with-pdo-sqlite' '--with-sqlite' '--with-pdo-mysql'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/php5/lib
Loaded Configuration File /usr/local/php5/lib/php.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, data, http, ftp, compress.zlib, https, ftps
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, zlib.*

And here it is without:

PHP Version 4.4.8

System Linux pass61.dizinc.com 2.6.9-55.0.12.ELsmp #1 SMP Fri Nov 2 12:38:56 EDT 2007 x86_64
Build Date Feb 5 2008 08:00:59
Configure Command './configure' '--enable-bcmath' '--enable-calendar' '--enable-discard-path' '--enable-exif' '--enable-ftp' '--enable-gd-native-ttf' '--enable-libxml' '--enable-magic-quotes' '--enable-mbstring' '--enable-sockets' '--enable-wddx' '--enable-xslt' '--enable-zend-multibyte' '--prefix=/usr' '--with-curl=/opt/curlssl/' '--with-dom=/opt/xml2/' '--with-dom-exslt=/opt/xslt/' '--with-dom-xslt=/opt/xslt/' '--with-expat-dir=/usr' '--with-freetype-dir=/usr' '--with-gd' '--with-gettext' '--with-iconv' '--with-imap=/opt/php_with_imap_client/' '--with-imap-ssl=/usr' '--with-jpeg-dir=/usr' '--with-kerberos' '--with-libdir=lib64' '--with-libxml-dir=/opt/xml2/' '--with-mcrypt=/opt/libmcrypt/' '--with-mhash=/opt/mhash/' '--with-mime-magic' '--with-mysql=/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-openssl=/usr' '--with-openssl-dir=/usr' '--with-pic' '--with-png-dir=/usr' '--with-pspell' '--with-ttf' '--with-xmlrpc' '--with-xpm-dir=/usr/X11R6' '--with-xslt-sablot=/opt/sablot/' '--with-zlib' '--with-zlib-dir=/usr'
Server API CGI
Virtual Directory Support disabled
Configuration File (php.ini) Path /home/kainaist/public_html/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20050606
Debug Build no
Zend Memory Manager enabled
Thread Safety disabled
Registered PHP Streams php, http, ftp, https, ftps, compress.zlib

======================

Is this info acceptable for dissection of my problem? There was a ton more below this.

Thanks.