ItemStats Freezes my site

This mod will allow any part of DragonFly that uses bbcode to be able to use ItemStats
No longer maintained

ItemStats Freezes my site

Postby KaguraS » Sun Feb 24, 2008 1:12 pm

I have item stats in my DF 9.2, but when I try to put an item, and make a preview of the post... the system freezes like 10 minutes, and no one can access the website in a while... what do you think it's happening?
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am

ItemStats Freezes my site

Postby zanix » Sun Feb 24, 2008 1:27 pm

Could be that itemstats is hanging on the data retrieval, and thus freezing the page

I would check your server error log
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

ItemStats Freezes my site

Postby KaguraS » Sun Feb 24, 2008 10:55 pm

do you refer to the cpg_error.log ?, if is it, is clean do not have data in, and CHMOD is 622
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am

ItemStats Freezes my site

Postby zanix » Sun Feb 24, 2008 11:08 pm

Inside your hosts control panel, there should be a link to logs or error logs or something similar
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

ItemStats Freezes my site

Postby KaguraS » Mon Feb 25, 2008 5:20 am

my host doesnt provides that info, in the control panel :|
User avatar
KaguraS
WR.net Apprentice
WR.net Apprentice
 
Posts: 40
Joined: Wed Feb 20, 2008 8:44 am

Re: ItemStats Freezes my site

Postby petrakid » Fri Mar 28, 2008 4:33 am

I receive an error log via email whenever there is a problem on my website. I, too, am experiencing the same problem. It appears that when the item between the or [icon][/icon] is type incorrectly, or if itemstats cannot locate the item in the query, it freezes the database. I receive an error in my email that says this"

On /Forums/viewtopic/t=63.html
While executing query "SELECT g.group_id, g.group_name, g.group_single_user FROM cms_bbgroups AS g INNER JOIN cms_bbuser_group AS ug ON (ug.group_id=g.group_id AND ug.user_id=54 AND ug.user_pending=0)"

the following error occured: MySQL server has gone away


I've experienced this error before in other situations - and it always has to do with query issues or loops of some sort. It happened in the first version of wowroster's armory sync for me.

I just tested this again, and sure enough, when I typed in the correct text OR if the item I typed in IS on allakazam's website, it works fine. When it is not, it locks.

Is there something in the code that is supposed to cancel the query after a few seconds if nothing is found?
User avatar
petrakid
WR.net Apprentice
WR.net Apprentice
 
Posts: 53
Joined: Sat Jul 07, 2007 7:34 am

ItemStats Freezes my site

Postby zanix » Fri Mar 28, 2008 4:41 am

I dunno, I just patch up Itemstats to work in DF
I don't know the detailed inner-workings of it
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

ItemStats Freezes my site

Postby petrakid » Sat Mar 29, 2008 8:55 am

Well you're doing a good job on the porting - I'm going to check into this some more and see if I can find out what the problem is/if there's a fix for it.
User avatar
petrakid
WR.net Apprentice
WR.net Apprentice
 
Posts: 53
Joined: Sat Jul 07, 2007 7:34 am


Return to ItemStatsDF

Who is online

Users browsing this forum: No registered users and 0 guests

cron