XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


(1) 2 »


1
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/19 18:40

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


I'b back.

Ok, I instaled fresh new XOOPS 2.0.14. on localhost, add all modules and mods, complete database and it works fine.

I can normaly repair and optimize database.

Does anybody have problem with database repairing and optimizing for large tables ?

Also, when I install fresh Xoops, tables have prefix xoops_, and in my XOOPS (upgraded one) they have prefix table_xoops_

Is there a problem ?

Also, the database on localhost has 22,5MB, on host it has 20,6MB....
Topic | Forum


2
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/16 20:08

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Quote:
Bender wrote:
Ok, here we go.

First to be said news is a very common and widely used module. If this were a general problem of the module there should(!) be more reports of this kind of issue.

Not guaranteed but more likely therefore this is caused by the configuration of your server in combination with this specific version of XOOPS or news module or some problem with the database.


Could be.
Just for sure: how much the "keywords" and description" take time in database operating?

Now what i would do is this:

Quote:
- download the site. set it up locally using Xampp for example and see if it shows the same behavior


Ok, I'll try to do it.

Quote:
- setup another fresh XOOPS on your webserver into a subdomain and (separate) database and see if it also happens there

- dump a copy of the news tables into that test setup again checking if it happens also

This should give some more clues in which direction to continue searching.


Well, first I setup a fresh 2.0.14 with 1.44 in a new database (empty one), and everything work fine.
Also, some more tips. It works well in the morning, but lousy during the evening.

Quote:
Also you said you had troubles when upgrading and messed around in the database manually if i am not mistaken. Did you try to optimize/repair tables afterwards?


This is a problem. Some big tables I ussualy can't repair, and "stories" is big (20 MB). When I do it, base colapse and nothin woorks for several minutes.
Ok, I'll add this: "stories" encrease their size each time i post na new article a lot. Then I must perform optimize, and after that base crashed and become unreachable for several minutes, then it appears with decreased size.
Topic | Forum


3
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/16 20:00

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Quote:

davidl2 wrote:
Please remember that we're volunteers, and we may be working or sleeping during the few hours in between your posts...


Those were two days. And I reported this several days ago.
Ok, never mind.
Topic | Forum


4
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/16 18:33

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Such a great assistance...
Topic | Forum


5
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/14 13:10

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


It all started with news 1.44 installation, so this isn't a problem. Images are linked from the site, and from the web. Problem is in module, it starts slowly, and it slows down the entire XOOPS, as well as other applications.

If You red this

XOOPS took 20.866 seconds to load.
XOOPS Boot took 1.261 seconds to load.
Module init took 0.152 seconds to load.
XOOPS output init took 17.364 seconds to load.
Module display took 1.908 seconds to load.
Page rendering took 0.166 seconds to load.

You'll see that the XOOPS is the problem, not the images, images are catched in the browser. You may register and try to submit the news (Podnesi vijest), You'll see that the problem is in XOOPS output.
Topic | Forum


6
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/14 11:24

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Does anybody need more info?
Topic | Forum


7
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/13 13:45

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Thanks.
Today, same thing.

From phpDebug

Timers
XOOPS took 20.866 seconds to load.
XOOPS Boot took 1.261 seconds to load.
Module init took 0.152 seconds to load.
XOOPS output init took 17.364 seconds to load.
Module display took 1.908 seconds to load.
Page rendering took 0.166 seconds to load.


XOOPS took 10.435 seconds to load.
XOOPS Boot took 1.538 seconds to load.
Module init took 0.082 seconds to load.
XOOPS output init took 8.513 seconds to load.
Module display took 0.286 seconds to load.
Page rendering took 0.006 seconds to load.

One error:
Notice: Undefined variable: numrows in file /modules/xoopspartners/blocks/partners.php line 86
Topic | Forum


8
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/12 22:30

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Ok, i removed the lines from "forum".

How about this:

Notice: Undefined variable: numrows in file /modules/xoopspartners/blocks/partners.php line 86

This is line 86.

86 if (($numrows <= $NumberPartners) or (!$random) ) {
87 return $PartnersId;
88 exit();
Topic | Forum


9
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/12 22:08

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Ok, I ran phpDebug.
Got this after news submiting.

All errors (5) queries (65) blocks (35) extra (0) timers (5)


Under all errors:
Notice: Use of undefined constant _FORUM - assumed '_FORUM' in file /modules/forum/xoops_version.php line 8
Notice: Use of undefined constant _FORUM - assumed '_FORUM' in file /modules/forum/xoops_version.php line 10
Notice: Constant _MB_TITLE already defined in file /modules/xoopspartners/language/english/blocks.php line 35
Notice: Undefined variable: numrows in file /modules/xoopspartners/blocks/partners.php line 86
Notice: Constant _MSW_B_INTHE already defined in file /modules/ms_weather/language/english/blocks.php line 36

Under timers:
Timers
XOOPS took 1.306 seconds to load.
XOOPS Boot took 0.082 seconds to load.
Module init took 0.049 seconds to load.
XOOPS output init took 1.025 seconds to load.
Module display took 0.150 seconds to load.
Topic | Forum


10
zagreb1
Re: Slow XOOPS after installing news 1.44

  • 2006/8/12 21:02

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


http://www.nemacenzure.com/portal/

Notification was disabled.
Topic | Forum



TopTop
(1) 2 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

136 user(s) are online (71 user(s) are browsing Support Forums)

Members: 0

Guests: 136

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