12
Quote:
While the site is online? What will that do?
karuna wrote:
turn on the mysql&block debug to see where these queries come from
While the site is online? What will that do?
13
Ok the site is now down more oftn than not and it seems like a clean install is the only way out
if i am to take a new XOOPS installation and use a backup from the current database, could that 'infest' the new xoops? Guess not but doesnt hurt asking ^^
oh and i havent tried with persistent connection yet. what about that?
if i am to take a new XOOPS installation and use a backup from the current database, could that 'infest' the new xoops? Guess not but doesnt hurt asking ^^
oh and i havent tried with persistent connection yet. what about that?
14
Quote:
Ads, Affiliates and Smilies are all custom blocks. Plain HTML, no XOOPS or db stuff.
I removed the Poll now lets see if that helps. T.T My guess would be theme.html....
ajaxbr wrote:
Try removing the Poll block (could be checking against dupe votes?). Also, try turning off Adverts, New Members and Affiliates one at a time.
Wait, is that huge image list at left a module? A menu module? if it is, there you go...
Good luck
Ads, Affiliates and Smilies are all custom blocks. Plain HTML, no XOOPS or db stuff.
I removed the Poll now lets see if that helps. T.T My guess would be theme.html....
15
Hmm now with the original file its back down to 0.817 Seconds | 57 Queries for me. Could be just another caper though. A said before the number of querries seems to go up and down for no obvious reason these last few weeks. t.t
16
Quote:
Yeah I know I was going to post the same right now. Today I'm getting things like 170.288 Seconds | 20972 Queries.
News v1.1
NewBB v1
Cant be NewBB imho, 0.157 Seconds | 49 Queries there.
The only change I did to News (apart from templates) that I can think of is that I removed the news category link in the title bar. There might have been others I dont remember now though.
I also changed some things in misc.php and one file in kernel or class to change the way tables are done by XOOPS (globally). When you enter blocks or some module's preferences in the Admin area the page displayed there will show the changes. Like I added the links "back to main" and "top" to the bottom of every table that is generated by XOOPS (not templated) and they also show in the admin area now. I did this ages ago though.
EDIT: Found it: \class\xoopsform\themeform.php
I'll gonna try with an unaltered backup now and see if that changes anything.
brash wrote:
When I first load the page I get this;
Quote:
Page generated in 0.436 Seconds | 52 Queries
However after clicking the "main" link a few times I get this;
Quote:
Page generated in 44.839 Seconds | 18278 Queries
You've got a SERIOUS quiries monster in there somewhere. This kind of load WILL NOT be coming from the XOOPS core (otherwise their would be a lot more compliants), which pretty much leaves us with modules. Can you list exactly what version of the News and NewBB modules you are using Skythe? Have you made any modifications?
Yeah I know I was going to post the same right now. Today I'm getting things like 170.288 Seconds | 20972 Queries.
News v1.1
NewBB v1
Cant be NewBB imho, 0.157 Seconds | 49 Queries there.
The only change I did to News (apart from templates) that I can think of is that I removed the news category link in the title bar. There might have been others I dont remember now though.
I also changed some things in misc.php and one file in kernel or class to change the way tables are done by XOOPS (globally). When you enter blocks or some module's preferences in the Admin area the page displayed there will show the changes. Like I added the links "back to main" and "top" to the bottom of every table that is generated by XOOPS (not templated) and they also show in the admin area now. I did this ages ago though.
EDIT: Found it: \class\xoopsform\themeform.php
I'll gonna try with an unaltered backup now and see if that changes anything.
18
Okay so the only way to remove edit / delete is to remove <{$story.adminlink}> from the template? grr :(
Thanks a lot mithrandir!
Thanks a lot mithrandir!
19
Quote:
I think it was Dave_L's script. The # of querries have gone down to 30 for me too now that I removed it. Oo
@LazyBadger
I'm seeing the same thing when not logged in. You cant actually edit or delete, but Id really like to remove it of course. Any ideas? How does this work anyway, I thought it would generate and store 1 page for each visitor based on their ranks. Not my admin version for everyone...
Mithrandir wrote:
Sorry - missed that one.
I get
Quote:Page generated in 0.354 Seconds | 32 Queries
as anonymous. Where do you reach 1000+ queries? Is it only when logged in?
I think it was Dave_L's script. The # of querries have gone down to 30 for me too now that I removed it. Oo
@LazyBadger
I'm seeing the same thing when not logged in. You cant actually edit or delete, but Id really like to remove it of course. Any ideas? How does this work anyway, I thought it would generate and store 1 page for each visitor based on their ranks. Not my admin version for everyone...
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|