41
technobia
CPU Utilization 100% with Weblinks
  • 2006/10/22 22:18

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


ENVIRONMENT:
Weblinks 1.13 Installed on XOOPS 2.0.14
I am running this on a Windows 2003 Server with IIS6.0. PHP 5.1.5 and MySQL 4.1.

I have 2084 links in the database and expect this database to be much much larger over the course of the next year at least.

I DEFINATLY have plans to migrate over to the Linux server but I do not have the financial resources to do so at this time. So, with that said I need to make this work as best I can in the short term.

ISSUE:
Accessing the Weblinks module causes the CPU utilization on my server to jump to 100% utilization and stay there. I can browse and search the directory but I can not load the submit a new link form. The form does not come up only a page that is not part of the site theme which only displys the form instructions and not the actual form itself. Debug reports the following:

Fatal error: Maximum execution time of 30 seconds exceeded in C:\...\www\class\database\databasefactory.php on line 25

I assume this error is related to the CUP utilization and the module does not have time to process the request and or query the database.

QUESTIONS:
1. Is this a bug or a limitation in the code with respect to how the module queries the database?
2. What is the largest database I can expect to use efficiently? Currently the links table is at 2.1 mb. With w 2084 links and I am not using all fields. I have almost 300 categories as well
3. The main reason I selected Weblinks is that I need to be able to asset a single link to as many as 4-5 categories. Other modules I have seen do not allow this.
4. If there is another module that would have less overhead requirements on my server how would I migrate the db / data?

THIS IS A HUGE problem for me on a very large site I just launched. I have had to remove the Weblinks “Directory” which is a very important feature of this busy site until, and if, this can be resolved.

I would therefore appreciate some help with this issue as soon as humanly possible.

Thanks so much - Technobia
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



42
technobia
Re: phpAdNew Issues
  • 2006/10/18 20:47

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


I ended up reinstalling PAN with a new database and it works fine in terms of being able to login and configure etc.

I read the How To install article carefully and when I tried pasting in my invocation code into the header of my theme.html, all that shows up is the code not the banner.

I made sure that I replaced the <? php etc. code with <{php}> and <{/php}> at the begining an the end.

This is my second installation and I have gone through everything but can't seem to figure this one out.

Any ideas?
Thanks - Technobia
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



43
technobia
phpAdNew Issues
  • 2006/10/15 20:13

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


I have PAN 2.0.13.1 installed and it was working fine for awhile. I had to upgrade to PHP5.1.6 from PHP4.3.1 and now I can not login to the PAN Ad Manager.

I read a post about resetting the password back to the default 'secret' and I can verify on myPhpAdmin that it was set correctly back to the default, but I am still not able to login.

Doing more research I came across a thread that talked about my issue and PHP5. However not only were they disucssing an earlier versions (2.0.3 & 2.0.7 I think) of PAN but, I found the thread to be rather confusing.

I would be very greatful if soneone would provide some advice and guideance. I really need to get this up and working again I have some banners that the links need to be changed and I can not do so.

I have postes in the PAN Forums as well but there have been no replies.

Thanks!
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



44
technobia
Re: HELP! Cant Access Site!
  • 2006/10/14 20:47

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


Good News! Looks like Protector works. Was testing registration and my IP got blocked. I am good to go now. Is there an IP whitelist?
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



45
technobia
Re: HELP! Cant Access Site!
  • 2006/10/14 19:59

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


Well it appears to be a local issue. None of the machines on my local lan can access the site. I am glad you can however.
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



46
technobia
HELP! Can't Access Site!
  • 2006/10/14 17:05

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


Just launched a XOOPS site 2.0.15 that has been in development for some time. All has been working fine until the site went white this morning and nothing loads I can't even get into the admin area or user.php login page.

I Reset IIS and checked the logs and I do not see anything that I can attribute this to. All my other XOOPS sites I host are running. I can load some HTML pages I have in the site fine but all PHP pages are blank.

I really have no idea where to start to try to figure this one out. I am hoping this may be a local issue. Let me know you can access this sitehttp://cms.pridedepot.com or what I main do to get it up again.

Thanks
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



47
technobia
Re: Blocks don;t display on custom module pages
  • 2006/10/13 1:33

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


Great thanks. That worked. Just missed that little check box on the Edit link for the block!
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



48
technobia
Blocks don;t display on custom module pages
  • 2006/10/12 23:27

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


I have created a custom module and in that module I have the index.php with the following code but I can not display any blocks on that page. Is this possible to do and if so, how?


< ? php
include("../../mainfile.php");
include(XOOPS_ROOT_PATH."/header.php");
?>

Text goes here

<?php
include(XOOPS_ROOT_PATH."/footer.php");
?>
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



49
technobia
Re: XoopsPoll 1.1 & PHP5
  • 2006/10/11 21:37

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


WOO HOO! That worked great! THANKS TOTO!

The files that need to be edited are as follows:

modules/xoopspoll/index.php
modules/xoopspoll/pollresults.php
modules/xoopspoll/admin/index.php

In each file I replaced each incident of:

$HTTP_GET_VARS with $_GET
$HTTP_POST_VARS with $_POST
$HTTP_COOKIE_VARS with $_COOKIE
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!



50
technobia
Re: XoopsPoll 1.1 & PHP5
  • 2006/10/11 20:48

  • technobia

  • Not too shy to talk

  • Posts: 122

  • Since: 2006/4/17


OK thanks. Just to be sure. You are talking about the .php files in the xoopspoll module right?
Thanks, Technobia
www.PrideDEPOT.com
Everybody Has A Right!




TopTop
« 1 2 3 4 (5) 6 7 8 ... 12 »



Login

Who's Online

152 user(s) are online (83 user(s) are browsing Support Forums)


Members: 0


Guests: 152


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