Forum Index > FlashYourWeb OS Support > Gallery 2 Bridge New Topic Post Reply
 G2Bridge brokes geeklog installation
 |  Printable Version
Anonymous: mmarc__
 December 12 2010 14:32 PM (Read 3431 times)  


Hi,

A strange issue here:

After installing and enabling G2Bridge plugin in geeklog 1.7.1 admin control panel, I can't reload geeklog pages anymore. The error is:

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/system/classes/template.class.php(534) : runtime-created function on line 1

Any idea to solve this?..

Thanks,
- D.


 
Quote
suprsidr
 December 12 2010 15:24 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

Make sure the imageBlock module is enabled in your gallery2.

-s


There will always be...
 
Profile Email Website
Quote
Anonymous: mmarc_
 December 12 2010 16:01 PM  


Hi,

Thanks,

Now it fails with

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/system/lib-mbyte.php on line 209

Do I need to enable any other plugin?

Thanks,
- D.

P.S.: CAPTCHA here constantly fails for chromium browser.


 
Quote
suprsidr
 December 12 2010 16:14 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

You're going to have to look at your server's error logs.
it hangs while converting a string to lower case, which does not help me.

If you need help disabling the plugin, try my tool.


There will always be...
 
Profile Email Website
Quote
Anonymous: mmarc__
 December 12 2010 16:18 PM  


Oh, no! I like G2Bridge, just wanted to investigate an issue. I know how to disable it from mysql by hand.


 
Quote
Anonymous: mmarc__
 December 12 2010 16:30 PM  


Here's what we have in log:

2010/12/13 03:29:25 [error] 19168#0: *499 FastCGI sent in stderr: "PHP Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/system/lib-plugins.php on line 424" while reading response header from upstream, client: 66.249.66.19, server: , request: "GET /G2Bridge/index.php?g2_itemId=323&g2_highlightId=424 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host:

This 66* address is new to me. Does it need to fetch something from foreign address each time g2bridge starts? Why?

- D.


 
Quote
suprsidr
 December 12 2010 16:31 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

I've never tested w/ 1.7.1, although I cannot imagine what changes from 1.7.0 to 1.7.1 would cause your issue.
I'll have to upgrade my test suite.

-s


There will always be...
 
Profile Email Website
Quote
suprsidr
 December 12 2010 16:34 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

This 66* address is new to me. Does it need to fetch something from foreign address each time g2bridge starts? Why?

No, unless you have some link items.

url to your site?


There will always be...
 
Profile Email Website
Quote
suprsidr
 December 12 2010 16:44 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

66.249.66.19 is a googlebot


There will always be...
 
Profile Email Website
Quote
Anonymous: mmarc__
 December 12 2010 16:48 PM  


geophyslab.srcc.msu.ru

Hm, no, I think nothing unusual is linked. Actually, I performed a 1.7.1 geeklog reinstall, with new instance of gallery2, G2Bridge and other stuff on top of the old databases.

I just switched off G2Bridge with

PHP Formatted Code

UPDATE geeklog.gl_plugins SET pi_enabled=0 where pi_name="G2Bridge"
 


to get the geeklog site loading.


 
Quote
suprsidr
 December 12 2010 17:08 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

I've seen your site before. A referral link from either my flashvideo player or mp3 audio player.

Updating my test suite now.

-s


There will always be...
 
Profile Email Website
Quote
suprsidr
 December 12 2010 17:15 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

Upgrade went smooth, no issues.

Please report back if you find the issue so I can update my release.
BTW, what version php?

-s


There will always be...
 
Profile Email Website
Quote
Anonymous: mmarc__
 December 12 2010 17:21 PM  


Thanks, I also remember you kindly help us to get sorted with E2 player - it likely brought you a referral Smile

Now I'm settling on faster machine, looking forward into extending our tiny science-oriented media portal. This time I have to make things in much more structured fashion (rss-es, and etc.), since we have a lot more content ready for publishing.


 
Quote
Anonymous: mmarc__
 December 12 2010 17:23 PM  


Quote by: suprsidr



BTW, what version php?

-s



PHP 5.3.3 (cli) (built: Jul 22 2010 15:58:21)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
with eAccelerator v0.9.6.1, Copyright (c) 2004-2010 eAccelerator, by eAccelerator


 
Quote
Anonymous: mmarc__
 December 12 2010 17:53 PM  


Hm, something new here.

I decided to clean the old G2Bridge record from db, that is there from times of v1.5.0. After that, geeklog does not hang anymore, but fails to perform new G2Bridge install with the following message:

Mon 13 Dec 2010 04:55:39 MSK - Attempting to install the 'G2Bridge' plugin
Mon 13 Dec 2010 04:55:39 MSK - Attempting to create 'G2Bridge Admin' group
Mon 13 Dec 2010 04:55:39 MSK - 1062: Duplicate entry 'G2Bridge Admin' for key 'grp_name'. SQL in question:
Mon 13 Dec 2010 04:55:39 MSK - Error creating plugin group

I guess I have to erase something else...


 
Quote
Anonymous: mmarc__
 December 12 2010 18:15 PM  


Logically, I did both

mysql> DELETE FROM geeklog.gl_plugins where pi_name="G2Bridge";
Query OK, 1 row affected (0.00 sec)

mysql> DELETE FROM geeklog.gl_groups where grp_name="G2Bridge Admin";
Query OK, 1 row affected (0.00 sec)

but it still hangs Evil

I'm now out of ideas.


 
Quote
Anonymous: mmarc__
 January 02 2011 17:16 PM  


Hi again,

I'm continuing to analyze the case of G2Bridge making geeklog to hang constantly with "Script execution time exceeded 30 seconds". With mysqld quieries logging it turns out, engine enters an endless loop of the following two queries:

21 Query SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
21 Query SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all'Wink

- About 20 or 30 similar queries in a sequence, and php shuts down the script.

With G2Bridge disabled, there is no such line at all for the corresponding site loading log.
Just in case it makes sense for any suggestion...


 
Quote
suprsidr
 January 02 2011 19:27 PM  
Forum Admin
Admin

Status: offline

Registered: 12/20/06
Posts: 1221

That query for syndication is made in COM_siteHeader
So lets try to disable our call to plugin_templatesetvars_G2Bridge
and plugin_getheadercode_G2Bridge in G2Bridge functions.inc

Just comment both of those functions out altogether and see if the site runs without them.

If the site runs un-comment each function singularly to see which kill the site and we'll work from there.

BTW if you signup here you'll get notification of my replies and this could progress faster.

-s


There will always be...
 
Profile Email Website
Quote
Anonymous: mmarc__
 January 03 2011 10:44 AM  


OK, after disabling what you said, geeklog is able to modify configuration:

PHP Formatted Code

110103 21:35:21  1592 Connect    geekuser@localhost on
                 1592 Init DB   geeklog
                 1592 Query     SET NAMES 'utf8'
                 1592 Query     SELECT name, value, group_name FROM gl_conf_values WHERE (type <> 'subgroup') AND (type <> 'fieldset')
                 1592 Query     SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
                 1592 Query     SELECT uid FROM gl_sessions WHERE (sess_id = '806524756') AND (start_time > 1294072521) AND (remote_ip = '81.88.120.145')
                 1592 Query     SELECT status FROM gl_users WHERE uid=2
                 1592 Query     UPDATE gl_sessions SET start_time=1294079721 WHERE (sess_id = '806524756')
                 1592 Query     SELECT *,format FROM gl_dateformats,gl_users,gl_userprefs WHERE gl_dateformats.dfid = gl_userprefs.dfid AND gl_userprefs.uid = 2 AND gl_users.uid = 2
                 1592 Query     DELETE FROM gl_sessions WHERE start_time < 1294079421
                 1592 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 2
                 1592 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (13,12,11,10,9,8,7,6,5,4,3,2,1)
                 1592 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (14,15,17,18,20,21,22)
                 1592 Query     SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN (2,4,7,21,22,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)
                 1592 Query     SELECT value FROM gl_vars WHERE name='last_scheduled_run'
                 1592 Query     DELETE FROM gl_speedlimit WHERE (type = 'login') AND (date < UNIX_TIMESTAMP() - 300)
                 1592 Query     SELECT date FROM gl_speedlimit WHERE (type = 'login') AND (ipaddress = '***') ORDER BY date ASC
                 1592 Query     SELECT ((DATE_ADD(created, INTERVAL ttl SECOND) < NOW()) AND ttl > 0) as expired, owner_id, urlfor FROM gl_tokens WHERE token='c336a61c98d004776be802932d2c00bb'
                 1592 Query     DELETE FROM gl_tokens WHERE token = 'c336a61c98d004776be802932d2c00bb'
                 1592 Query     INSERT INTO gl_groups (grp_name, grp_descr) VALUES ('G2Bridge Admin', 'Users in this group can administer the G2Bridge plugin')
                 1592 Query     INSERT INTO gl_features (ft_name, ft_descr)
                    VALUES ('G2Bridge.admin', 'Full access to G2Bridge plugin')
                 1592 Query     INSERT INTO gl_access (acc_ft_id, acc_grp_id) VALUES (43, 30)
                 1592 Query     INSERT INTO gl_group_assignments VALUES (30, NULL, 1)
                 1592 Query     SELECT name, value, group_name FROM gl_conf_values WHERE (type <> 'subgroup') AND (type <> 'fieldset')
                 1592 Query     DELETE FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1592 Query     INSERT INTO gl_plugins (pi_name, pi_version, pi_gl_version, pi_homepage, pi_enabled) VALUES ('G2Bridge', '2.3.9.1', '1.6.1', 'http://www.flashyourweb.com', 1)
                 1592 Quit
 


And what's new and positive - it's now able to reload the admin plugins page, where it stands after installing G2Bridge plugin:

PHP Formatted Code

                 1593 Connect   geekuser@localhost on
                 1593 Init DB   geeklog
                 1593 Query     SET NAMES 'utf8'
                 1593 Query     SELECT name, value, group_name FROM gl_conf_values WHERE (type <> 'subgroup') AND (type <> 'fieldset')
                 1593 Query     SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
                 1593 Query     SELECT uid FROM gl_sessions WHERE (sess_id = '806524756') AND (start_time > 1294072521) AND (remote_ip = '***')
                 1593 Query     SELECT status FROM gl_users WHERE uid=2
                 1593 Query     UPDATE gl_sessions SET start_time=1294079721 WHERE (sess_id = '806524756')
                 1593 Query     SELECT *,format FROM gl_dateformats,gl_users,gl_userprefs WHERE gl_dateformats.dfid = gl_userprefs.dfid AND gl_userprefs.uid = 2 AND gl_users.uid = 2
                 1593 Query     DELETE FROM gl_sessions WHERE start_time < 1294079421
                 1593 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 2
                 1593 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (13,12,11,10,9,8,7,6,5,4,3,2,1)
                 1593 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (14,15,17,18,20,30,21,22)
                 1593 Query     SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN (2,4,7,21,22,30,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)
                 1593 Query     SELECT value FROM gl_vars WHERE name='last_scheduled_run'
                 1593 Query     DELETE FROM gl_speedlimit WHERE (type = 'login') AND (date < UNIX_TIMESTAMP() - 300)
                 1593 Query     SELECT date FROM gl_speedlimit WHERE (type = 'login') AND (ipaddress = '81.88.120.145') ORDER BY date ASC
                 1593 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1593 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1593 Query     SELECT boxes,noboxes FROM gl_userindex WHERE uid = '2'
                 1593 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'all') ORDER BY blockorder,title ASC
                 1593 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1593 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1593 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1593 Query     SELECT tid FROM gl_topics
                 1593 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1593 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1593 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1593 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1593 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1593 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1593 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1593 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1593 Query     SELECT COUNT(*) FROM gl_syndication
                 1593 Query     SELECT COUNT(*) FROM gl_pingservice
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
                 1593 Query     DELETE FROM gl_tokens WHERE (DATE_ADD(created, INTERVAL ttl SECOND) < NOW()) AND (ttl > 0)
                 1593 Query     DELETE FROM gl_tokens WHERE owner_id='2' AND urlfor='/admin/plugins.php?msg=44'
                 1593 Query     INSERT INTO gl_tokens (token, created, owner_id, urlfor, ttl) VALUES ('93ede3072584f349f7b2ffec81965a8d', NOW(), 2, '/admin/plugins.php?msg=44', 1200)
                 1593 Query     SELECT pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage FROM gl_plugins WHERE 1=1
                 1593 Query     SELECT pi_name, pi_version, pi_gl_version, pi_enabled, pi_homepage FROM gl_plugins WHERE 1=1 ORDER BY pi_name ASC LIMIT 0,50
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'staticpages'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'spamx'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'calendar'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'links'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'polls'
                 1593 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_name = 'xmlsitemap'
                 1593 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1593 Quit
 


Previously, there was already a hang here, now it passes fine, but still hangs when I'm trying to navigate anywhere, for example, to the home page:

PHP Formatted Code

110103 21:43:34  1603 Connect   geekuser@localhost on
                 1603 Init DB   geeklog
                 1603 Query     SET NAMES 'utf8'
                 1603 Query     SELECT name, value, group_name FROM gl_conf_values WHERE (type <> 'subgroup') AND (type <> 'fieldset')
                 1603 Query     SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
                 1603 Query     SELECT uid FROM gl_sessions WHERE (sess_id = '806524756') AND (start_time > 1294073014) AND (remote_ip = '81.88.120.145')
                 1603 Query     SELECT passwd FROM gl_users WHERE uid = 2
                 1603 Query     SELECT status FROM gl_users WHERE uid=2
                 1603 Query     DELETE FROM gl_sessions WHERE (start_time < 1294073014)
                 1603 Query     DELETE FROM gl_sessions WHERE uid = '1' AND remote_ip = '***'
                 1603 Query     INSERT INTO gl_sessions (sess_id, uid, start_time, remote_ip) VALUES (967367152, 2, 1294080214, '81.88.120.145')
                 1603 Query     UPDATE gl_userinfo SET lastlogin = UNIX_TIMESTAMP() WHERE uid=2
                 1603 Query     SELECT *,format FROM gl_dateformats,gl_users,gl_userprefs WHERE gl_dateformats.dfid = gl_userprefs.dfid AND gl_userprefs.uid = 2 AND gl_users.uid = 2
                 1603 Query     DELETE FROM gl_sessions WHERE start_time < 1294079914
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 2
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (13,12,11,10,9,8,7,6,5,4,3,2,1)
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (14,15,17,18,20,30,21,22)
                 1603 Query     SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN (2,4,7,21,22,30,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)
                 1603 Query     SELECT value FROM gl_vars WHERE name='last_scheduled_run'
                 1603 Query     SELECT tid FROM gl_topics WHERE archive_flag=1
                 1603 Query     SELECT sp_id,sp_title,sp_content,sp_format,created,modified,sp_hits,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (draft_flag = 0) AND (template_flag = 0) AND (sp_where = 0) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (((owner_id = '2') AND (perm_owner >= 2)) OR ((group_id IN (2,4,7,21,22,30,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)) AND (perm_group >= 2)) OR (perm_members >= 2)) ORDER BY sp_id
                 1603 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1603 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1603 Query     SELECT boxes,noboxes FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1603 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1603 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1603 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1603 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1603 Query     SELECT COUNT(*) FROM gl_syndication
                 1603 Query     SELECT COUNT(*) FROM gl_pingservice
                 1603 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
                 1603 Query     SELECT value FROM gl_vars WHERE name = 'security_check'
                 1603 Query     SELECT COUNT(*) FROM gl_stories WHERE featured = '1'
                 1603 Query     SELECT sp_id,sp_title,sp_content,sp_format,created,modified,sp_hits,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (draft_flag = 0) AND (template_flag = 0) AND (sp_where = 1 OR sp_where = 2) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (((owner_id = '2') AND (perm_owner >= 2)) OR ((group_id IN (2,4,7,21,22,30,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)) AND (perm_group >= 2)) OR (perm_members >= 2)) ORDER BY sp_where,sp_id
                 1603 Query     SELECT maxstories,tids,aids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT fid,type,topic,limits,update_info FROM gl_syndication WHERE is_enabled = 1
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 1
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (2)
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_uid = 1
                 1603 Query     SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND ug_grp_id IN (2)
                 1603 Query     SELECT tid FROM gl_topics WHERE (perm_anon >= 2)
                 1603 Query     SELECT sid FROM gl_stories WHERE draft_flag = 0 AND date <= NOW()  AND (tid IN ('general','seminar','research','conferences')) AND perm_anon > 0 ORDER BY date DESC  LIMIT 10
                 1603 Query     SELECT sid FROM gl_stories WHERE featured = 1 AND draft_flag = 0 AND frontpage = 1 AND date <= NOW() ORDER BY date DESC LIMIT 2
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT sid FROM gl_stories WHERE featured = 1 AND draft_flag = 0 AND tid = 'conferences' AND date <= NOW() ORDER BY date DESC LIMIT 2
                 1603 Query     SELECT sid FROM gl_stories WHERE featured = 1 AND draft_flag = 0 AND tid = 'general' AND date <= NOW() ORDER BY date DESC LIMIT 2
                 1603 Query     SELECT sid FROM gl_stories WHERE featured = 1 AND draft_flag = 0 AND tid = 'research' AND date <= NOW() ORDER BY date DESC LIMIT 2
                 1603 Query     SELECT sid FROM gl_stories WHERE featured = 1 AND draft_flag = 0 AND tid = 'seminar' AND date <= NOW() ORDER BY date DESC LIMIT 2
                 1603 Query     SELECT sid,tid,title,expire,statuscode FROM gl_stories WHERE (expire <= NOW()) AND (statuscode = 11)
                 1603 Query     SELECT STRAIGHT_JOIN s.*, UNIX_TIMESTAMP(s.date) AS unixdate, UNIX_TIMESTAMP(s.expire) as expireunix, u.uid, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1  ORDER BY featured DESC, date DESC LIMIT 0, 10
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories AS s WHERE (date <= NOW()) AND (draft_flag = 0) AND frontpage = 1
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT email,photo FROM gl_users WHERE uid = '3'
                 1603 Query     SELECT sp_id,sp_title,sp_content,sp_format,created,modified,sp_hits,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon,sp_php,sp_inblock,sp_help FROM gl_staticpage WHERE (sp_centerblock = 1) AND (draft_flag = 0) AND (template_flag = 0) AND (sp_where = 3) AND ((sp_tid = 'none') OR (sp_tid = 'all')) AND (((owner_id = '2') AND (perm_owner >= 2)) OR ((group_id IN (2,4,7,21,22,30,11,5,13,12,20,10,8,1,15,14,3,17,6,9,18)) AND (perm_group >= 2)) OR (perm_members >= 2)) ORDER BY sp_id
                 1603 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT tids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT tid,topic,imageurl,meta_description FROM gl_topics ORDER BY sortnum
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW())  GROUP BY tid
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_storysubmission  GROUP BY tid
                 1603 Query     SELECT is_enabled FROM gl_blocks WHERE name='whosonline_block'
                 1603 Query     SELECT DISTINCT gl_sessions.uid,username,fullname,photo,showonline FROM gl_sessions,gl_users,gl_userprefs WHERE gl_users.uid = gl_sessions.uid AND gl_users.uid = gl_userprefs.uid AND start_time >= 1294079914 AND gl_sessions.uid <> 1 ORDER BY username,fullname
                 1603 Query     SELECT COUNT(*) FROM gl_sessions WHERE uid = '1'
                 1603 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1603 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1603 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1603 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1603 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1603 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1603 Query     SELECT COUNT(*) FROM gl_syndication
                 1603 Query     SELECT COUNT(*) FROM gl_pingservice
                 1603 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
110103 21:43:35  1603 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT tids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT tid,topic,imageurl,meta_description FROM gl_topics ORDER BY sortnum
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW())  GROUP BY tid
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_storysubmission  GROUP BY tid
                 1603 Query     SELECT is_enabled FROM gl_blocks WHERE name='whosonline_block'
                 1603 Query     SELECT DISTINCT                  1603 Query     SELECT DISTINCT gl_sessions.uid,username,fullname,photo,showonline FROM gl_sessions,gl_users,
gl_userprefs WHERE gl_users.uid = gl_sessions.uid AND gl_users.uid = gl_userprefs.uid AND start_time >= 1294079915 AND gl_sessions.uid <> 1 ORDER BY username,fullname
                 1603 Query     SELECT COUNT(*) FROM gl_sessions WHERE uid = '1'
                 1603 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1603 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1603 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1603 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1603 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1603 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1603 Query     SELECT COUNT(*) FROM gl_syndication
                 1603 Query     SELECT COUNT(*) FROM gl_pingservice
                 1603 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
                 1603 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT tids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT tid,topic,imageurl,meta_description FROM gl_topics ORDER BY sortnum
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW())  GROUP BY tid
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_storysubmission  GROUP BY tid
                 1603 Query     SELECT is_enabled FROM gl_blocks WHERE name='whosonline_block'
                 1603 Query     SELECT DISTINCT gl_sessions.uid,username,fullname,photo,showonline FROM gl_sessions,gl_users,gl_userprefs WHERE gl_users.uid = gl_sessions.uid AND gl_users.uid = gl_userprefs.uid AND start_time >= 1294079915 AND gl_sessions.uid <> 1 ORDER BY username,fullname
                 1603 Query     SELECT COUNT(*) FROM gl_sessions WHERE uid = '1'
                 1603 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1603 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1603 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1603 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1603 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1603 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1603 Query     SELECT COUNT(*) FROM gl_syndication
                 1603 Query     SELECT COUNT(*) FROM gl_pingservice
                 1603 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
                 1603 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT tids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT tid,topic,imageurl,meta_description FROM gl_topics ORDER BY sortnum
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW())  GROUP BY tid
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_storysubmission  GROUP BY tid
                 1603 Query     SELECT is_enabled FROM gl_blocks WHERE name='whosonline_block'
                 1603 Query     SELECT DISTINCT gl_sessions.uid,username,fullname,photo,showonline FROM gl_sessions,gl_users,gl_userprefs WHERE gl_users.uid = gl_sessions.uid AND gl_users.uid = gl_userprefs.uid AND start_time >= 1294079915 AND gl_sessions.uid <> 1 ORDER BY username,fullname
                 1603 Query     SELECT COUNT(*) FROM gl_sessions WHERE uid = '1'
                 1603 Query     SELECT format, filename, title, language FROM gl_syndication WHERE (header_tid = 'all')
                 1603 Query     SELECT sp_id, sp_label FROM gl_staticpage WHERE (sp_onmenu = 1) AND (draft_flag = 0) AND (template_flag = 0) ORDER BY sp_label
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 1 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_staticpage
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_polltopics
                 1603 Query     SELECT COUNT(*) AS cnt FROM gl_events
                 1603 Query     SELECT tid FROM gl_topics
                 1603 Query     SELECT COUNT(*) AS count FROM gl_storysubmission WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'calendar'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'links'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'polls'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'spamx'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'staticpages'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'G2Bridge'
                 1603 Query     SELECT pi_enabled FROM gl_plugins WHERE pi_name = 'metatags'
                 1603 Query     SELECT COUNT(*) FROM gl_eventsubmission
                 1603 Query     SELECT COUNT(*) AS count FROM gl_stories WHERE (tid IN ('conferences','general','research','seminar'))
                 1603 Query     SELECT COUNT(*) AS count FROM gl_blocks
                 1603 Query     SELECT COUNT(*) AS count FROM gl_topics
                 1603 Query     SELECT COUNT(*) FROM gl_users WHERE status = '3'
                 1603 Query     SELECT COUNT(*) AS count FROM gl_groups
                 1603 Query     SELECT COUNT(*) FROM gl_syndication
                 1603 Query     SELECT COUNT(*) FROM gl_pingservice
                 1603 Query     SELECT COUNT(*) FROM gl_plugins WHERE pi_enabled = '1'
                 1603 Query     UPDATE gl_vars SET value=value+1 WHERE name = 'totalhits'
                 1603 Query     SELECT *,UNIX_TIMESTAMP(rdfupdated) AS date FROM gl_blocks WHERE is_enabled = 1 AND onleft = 0 AND (tid = 'homeonly' OR tid = 'all') ORDER BY blockorder,title ASC
                 1603 Query     SELECT tids FROM gl_userindex WHERE uid = '2'
                 1603 Query     SELECT tid,topic,imageurl,meta_description FROM gl_topics ORDER BY sortnum
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_stories WHERE (draft_flag = 0) AND (date <= NOW())  GROUP BY tid
                 1603 Query     SELECT tid, COUNT(*) AS count FROM gl_storysubmission  GROUP BY tid
                 1603 Query     SELECT is_enabled FROM gl_blocks WHERE name='whosonline_block'
 


- So you see, it is on endless loop, and gets terminated.

Sorry, I failed to find any registration button around, will try more.


 
Quote
mmarc
 January 03 2011 10:54 AM  
Forum Newbie
Newbie

Status: offline

Registered: 06/05/09
Posts: 3

Aha, OK, I've recovered my old account.


 
Profile Email
Quote
Content generated in: 1.62 seconds
New Topic Post Reply



 All times are PST. The time is now 05:04 AM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Anonymous users can post 
HTML Allowed 
Censored Content