Forumlar / Cotonti / Support / major php crash???

12>>>

Draeghonov
#1 2009-10-11 14:48
Hey guys, I have THE weirdest error you'll see in ages!!!!!

Last night, after the restart of my website on Contoti, all was well.
The first sign of trouble, was when ppl tried the minichat: NO refresh, but it redirected to the minichat page after the post...
Then, someone noticed that the forums were... gone...
We have the recent items plugin, and ALL the forumposts are still showing, but when you click on the forum button, the forumsections are empty.
Weird: in the forums configuration in the admin panel, the structure is still there...
Also: When you click on one of the topics on the index in the recent forumposts section, you'll only see the textbox.
When you make a post, nothing happens...
Try to click on the "users" button: empty page, but the users arre there....

I have my test site, so I uploaded the sql file from my live site to that. Same problems, except for the minichat that does work...

Has anyone heard of such an error?
If so, can you please post a solution?
Thing is, Contoti's great, and we do NOT want to start over again...
Thanks in advance, Dave

Added 1 hour 1 minute later:

Okay, small update:

I made a backup of the current sql, just in case.
I dropped all ols sql tables, and installed a fresh one.
Guess what?
EVERYTHING worked...

I have reset it to the "troubled state", because I don't feel like loosing the users, pfs, forums again.
The minichat also works when the sql was restored.
If I have to install a fresh sql:
What boxes should be ticked in sql manager, to save the users?

I prefer the structure to be repaired, installing a new sql goes too far, I really need advise :)

Bu konu Draeghonov tarafından düzenlendi(2009-10-11 15:49, 14 yıllar önce)
SunChase
#2 2009-10-11 18:50
i think that this phenomenons where caused by the server.
Sounds like a bad connection to the database.Try looking at the hosters site - maybe they are doing some repairs.

but if you want to export all the users from the old db you should export such tables:
sed_users
to export the forum:
sed_forum_posts
sed_forum_sections
sed_forum_structure
sed_forum_topics
if you have special user groups:
sed_groups
sed_groups_users
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Draeghonov
#3 2009-10-11 21:28
Thank you for your response :)

I have received an email from my server: they will look into the matter on -=monday=-
I don't have that much patience...
Anyways, we have exported the users with success: the forums cause problems again, so we had to restart... Fortunately there were only 60 posts :)
SunChase
#4 2009-10-11 21:56
tell me more about the forum troubleshooting
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Draeghonov
#5 2009-10-11 22:25
If I understand you correct:

On the index page, the recnt forumposts show all the posts.
But when you clicked them, they directed us to empty pages with only a textboxer in it...
There were a few more issues...

Also, The Usergallery caused a lot of trouble:
apparently, minichat and usergallery do NOT work together...
Same goes for media library:
Whenever new items are posted, I get logged out.
So I'm really afraid of the whole gallery issue on my site...
SunChase
#6 2009-10-11 22:50
earlier you said that you had only 60 posts in the forum.How many posts did you have on one topic?
i'm asking this cause in the past i saw a similar problem when a topic had 11 posts and in the settings it was allowed only 10 per page.

Speaking on media libraries and ect.I think you should run your site on a localhost,install a clean copy of cotonti and test all of your plugins on the default skin.If you find some errors - try to turnoff each plugin one by one till you find the cause of the problems
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Mynt
#7 2009-10-11 23:44
I tried to recreate the issue with alot of factors just to see if I could.

So far my testing showed this:

-There is no timeout feature for the board. If your host has an issue with multiple threads going to the database it may be caused by the php ini settings. I lowered my phpini settings down to 1mb to just test it, then simucasted 4000 connections on the forums. The only dump error is as follows:

FIREBUGpro REPORT: c:\HARDYheron\~USR\MARK\TEMP\CONT\HOME\
FIREBUGpro DUMP:
CONNECTION IS TIMING OUT. 
MySQL LISTENER SENT OUT THIS MESSAGE TO X-HTTP HOST: 
"CACHE INVOLVED IS IN EXCESS OF RESOURCES. CONNECTION TIMED OUT"
RESULT: PAGE LOAD TIME ERROR
TIME: 618SECONDS WAIT TIME 2ms(REFRESH)
RESULT: TIMEOUT - NON 404. CONNECTION RETRY DENIED BY MySQL CONNECTION

Mysql dropped these errors for me:
Incoming connection from "localhost" denied with permissions 
using localhost @ password:yes. Authentication OK : 
User defined tables resource overflow of 5992881 bytes,
 memmory allowed of 8279981227 bytes.

There is no die after a certian amount of time, so it kept trying, but once the connection is killed the first time there was nothing to load because it hung on authentication again. Suggestion I think is to place a kill timer in the table lookup?
"I only sleep when I know I won't miss a thing."
Draeghonov
#8 2009-10-12 01:36
# SunChase : earlier you said that you had only 60 posts in the forum.How many posts did you have on one topic?
i'm asking this cause in the past i saw a similar problem when a topic had 11 posts and in the settings it was allowed only 10 per page.

Speaking on media libraries and ect.I think you should run your site on a localhost,install a clean copy of cotonti and test all of your plugins on the default skin.If you find some errors - try to turnoff each plugin one by one till you find the cause of the problems

I have set the maximum topics per page to 500; I guess I'll be safe then :)
And about mediagallery: I had it running on a testsite, but no probs there...


Added 1 hour 26 minutes later:

# Mynt :

There is no die after a certian amount of time, so it kept trying, but once the connection is killed the first time there was nothing to load because it hung on authentication again. Suggestion I think is to place a kill timer in the table lookup?

interesting, but I'm a n00b at scripting, can u show me how that is done?

Bu konu Draeghonov tarafından düzenlendi(2009-10-12 03:04, 14 yıllar önce)
SunChase
#9 2009-10-12 03:04
i really doubt that this was caused by the pagination.Last time i saw it on seditio(elder of cotonti).The settings for post pagination are located in "admin.php?m=config&n=edit&o=core&p=forums"

I think you should test the site on localhost again.But this time with the used database and the entire copy of your site(that is in the internet).If you want help with the testing - write to me by ICQ cause it will be difficult to do give you advices by forum
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Draeghonov
#10 2009-10-13 04:00
In uw htacces file heeft u het volgende staan DirectoryIndex index.php dit dient u te verwijderen danwel te veranderen in: DirectoryIndex index.php index.html

This is the answer I got.
I don't even need to translate it: completely useless.....
The htaccess I had in the root was empty, and the htaccess in the skins folder is the default that comes with Contoti...
Besides, they told me to change something to what it already is...

Ah well, I have noticed an improvement in stability, so I'll leave it at that for now.
Thanks to Tefra, and his db-tools:
That "simple" plugin offers waaaaaaaaaaaaaaay more peace of mind than the technicians of my server....
SunChase
#11 2009-10-13 17:15
strange.By default the server doesnt give access to the htaccess.
I really dont know why the skin folder has its own htaccess,but try deleting it
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
pieter
#12 2009-10-13 17:24
Hello guys, for the contest I made a test domain with the new skins.

Now I got the same problem.
http://contest.broens.be/

In header you can see the pages, but in list you see nothing.
Forum, same problem.

Added 9 minutes later:

I checked it. For the skin of STAM I had to reconfigure recentitems.
recentitems.php

File=recentitems
Hooks=index.tags
Tags=index.tpl:{PLUGIN_LATESTPAGES},{PLUGIN_LATESTTOPICS}
to
File=recentitems
Hooks=header.tags
Tags=header.tpl:{PLUGIN_LATESTPAGES},{PLUGIN_LATESTTOPICS}

and reinstall plugin
After this I got the problem.

When I put it back original, problem is gone.

@Draeghonov: have you reconfigured the recentitems plugin?

Added 1 minute later:

Is this a common problem?
Is this a bug?
... can we help you ...

Bu konu pieter tarafından düzenlendi(2009-10-13 17:36, 14 yıllar önce)
SunChase
#13 2009-10-13 22:48
pieter, tell in details what is the problem.Winter started to early so i'm to cold to think :)
[url=http://ka13.orgfree.com]KA13[/url] - The essence of creativity
Draeghonov
#14 2009-10-14 00:11
@SunChase:
this is in the htaccess in the skins directory:

<Files *.tpl>
order deny,allow
deny from all
</Files>

That's a measure to prevent the skins from being stolen ;)
@Pieter:
No, recent itmes is used as the plugin came: index.tpl usage.

Maybe, just maybe:
The problems I had with the usergallery were because I had used the latest version, with older files, to try to make the slideshow work...
Also, the avatar reflection is irritating as hell: slow loading times.
Maybe thet's the reason why I had such an epic fail:
slimbox image resizer, usergallery and avatar reflection all used together...

I have no idea about all this.
But I do know, that since the restart all is working as smooth as silk :)
pieter
#15 2009-10-14 01:08
You can see if I change the rescentitems like I indicated above the problem.

Goto: http://contest.broens.be/index.php
demo / demo

Even users-list don't work.
All skins have the problem. The 3 from the contest and sed-light.
If you or Trustmaster/Kilandor need a admin-account, let me know.
... can we help you ...

12>>>