1
Quote:
Hi.
This is what I find under two error logs for the server. It seems that every time there is a query that times out it is the wiwimod module that does it.
I don't know how to check whether the user database tables are corrupted.
I did not want to fool with it too much until I have rebuilt the site in a different folder or on a new server using a new MySQL database, for fear of losing even the admin profile, I guess.
I do know that I am having some trouble with the templates db. Like there is one template in the content module, if I try to edit the working template file, it tells me that it does not exist, but I know it does because the modifications on that template that are different from the default template are still being rendered in the pages of the site, even after clearing templates_c folder.
I guess I should probably get rid of or reinstall wiwimod. I was using that as a base for a lot of the content of the site and it has over 5500 files in it. So, that is where the XOOPS engine is getting bogged down apparently.
I was suspicious also of the server config, tho, because I had this whole setup on two other webhosts in exactly the same config with MySQL 4.0/4.1 and it worked perfectly and never timed out on the other servers. (Moved the site for reasons unrelated to this problem.)
This engine was installed by fantastico, which I have used often enough, but I also have installed it myself before, so I don't know if that makes any diff or not. I want to mirror the whole thing on another server. Just now am a bit tired, it's a lot of work to set it up, what with uploading all these different modules I have installed, but I guess I could just install the XOOPS engine with the wiwimod and try that out.
Greetings
Glogo
Herko Coomans wrote:
The notices you posted don't have anything to do with any userinfo/user.php scripts. So they can't be a clue to what could be causing this.
Reading through your post I get a suspicion that the user database tables may be corrupted or something. Can you check that?
Can you reproduce the strange behaviour (deleting whole user info, site crashing) with the error logger turned on (system admin -> preferences -> general settings)?
Does the error log of the server give you any clues as to what might be going wrong? I tcould be a misconfiguration on the server level...
Hi.
--------------------------------------------------------------------------------
CPU Exceeded Log For Sun May 13 10:17:22 2007
Sun May 13 10:15:37 2007: used 0.01 seconds of cpu time for HTTP Request: myxoopssite.org : GET /xoops/modules/myhome/ HTTP/1.1
Sun May 13 10:14:48 2007: used 0.01 seconds of cpu time for HTTP Request: myxoopssite.org : POST /xoops/modules/content/admin/index.php HTTP/1.1
Sun May 13 10:15:36 2007: used 0.02 seconds of cpu time for HTTP Request: myxoopssite.org : GET /xoops/index.php HTTP/1.1
Sun May 13 10:17:20 2007: used 68.00 seconds of cpu time for [[mysql query]]
--------------------------------------------------------------------------------
CPU Exceeded Log For Sun May 13 12:02:45 2007
Sun May 13 11:59:24 2007: used 0.01 seconds of cpu time for HTTP Request: myothersite.com : GET /wordpress/?cat=3 HTTP/1.1
Sun May 13 12:01:43 2007: used 0.01 seconds of cpu time for HTTP Request: myxoopssite.org : GET /xoops/xoops.css HTTP/1.1
Sun May 13 12:01:47 2007: used 0.01 seconds of cpu time for HTTP Request: myxoopssite.org : GET /xoops/user.php HTTP/1.1
Sun May 13 12:02:42 2007: used 55.00 seconds of cpu time for [[mysql query]]
----------------------------
from slow queries log
# Sun May 13 12:02:42 2007
# Query_time: 55 Lock_time: 0 Rows_sent: 5 Rows_examined: 30824696
use myxoopssite_xoop1;
SELECT w1.* FROM xoops_wiwimod AS w1 LEFT JOIN xoops_wiwimod AS w2 ON w1.keyword=w2.keyword AND w1.id<w2.id WHERE w2.id IS NULL AND w1.u_id='1' ORDER BY w1.lastmodified DESC LIMIT 0, 5
This is what I find under two error logs for the server. It seems that every time there is a query that times out it is the wiwimod module that does it.
I don't know how to check whether the user database tables are corrupted.
I did not want to fool with it too much until I have rebuilt the site in a different folder or on a new server using a new MySQL database, for fear of losing even the admin profile, I guess.
I do know that I am having some trouble with the templates db. Like there is one template in the content module, if I try to edit the working template file, it tells me that it does not exist, but I know it does because the modifications on that template that are different from the default template are still being rendered in the pages of the site, even after clearing templates_c folder.
I guess I should probably get rid of or reinstall wiwimod. I was using that as a base for a lot of the content of the site and it has over 5500 files in it. So, that is where the XOOPS engine is getting bogged down apparently.
I was suspicious also of the server config, tho, because I had this whole setup on two other webhosts in exactly the same config with MySQL 4.0/4.1 and it worked perfectly and never timed out on the other servers. (Moved the site for reasons unrelated to this problem.)
This engine was installed by fantastico, which I have used often enough, but I also have installed it myself before, so I don't know if that makes any diff or not. I want to mirror the whole thing on another server. Just now am a bit tired, it's a lot of work to set it up, what with uploading all these different modules I have installed, but I guess I could just install the XOOPS engine with the wiwimod and try that out.
Greetings
Glogo