10
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;