Page 1 of 2
I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Wed Nov 14, 2007 6:28 pm
by pbrady
Hi,
I am having a very strange problem with FEU Group settings.
When I initially installed FEU I created a set of properties (name, email), a group (UserInput) and selected the proper order for UserInput properties (name, email) as well as marking them both "Required".
Once done, I had all this working with login and selfregistration. However, after the fact, I created additional groups for pending, basedocs, and restricted in order to control how users access info on my site. The immediate problem I had was that I was unable to change the properties of the pending, basedocs and restricted groups. I could not mark any of the fields as "Required" (name, email) and as such, could not assign a default group in SelfRegistration to anything other than "UserInput".
So, I deleted the other groups, and renamed UserInput group to "newuser" group. But when I went to reset the properties of this renamed group to required and specify the sort order, I now get the same error that I got for the pending, basedocs and restricted groups: I am not able to save changes to the "newuser" group.
Consequently, my self registration and login does not work since they depend on a valid group with properties.
Is this a known bug? Is there a workaround for this?
I have tried deleting all properties and groups and recreated them only to get the same problem.
Help?
I am using CMSMS 1.2 on Debian Etch 4.0 Linux with the following config:
MySQL = 5.0.32
PHP = 4.4.4
Apache = 2.2.3
CMSMailer = 1.73.11
FrontEndUsers = 1.3
CustomContent = 1.4.10
SelfRegistration = 1.1.2
-Paul
Re: I broke the FEU group functionality
Posted: Wed Nov 14, 2007 6:47 pm
by moorezilla
I had an issue where I changed the numbers in the order fields and I broke frontendusers. I ended up just restoring the database to get it back. Probably not the answer you wanted to get... sorry.
Re: I broke the FEU group functionality
Posted: Wed Nov 14, 2007 6:59 pm
by pbrady
No.
There has to be a better solution. I cannot restore my DB every time I have issues with FEU.
UPDATE: I also de-installed and reinstalled FEU. To no avail...same problem.
Any other workarounds?
-p
Re: I broke the FEU group functionality
Posted: Wed Nov 14, 2007 8:04 pm
by pbrady
I have discovered something that may be significant, but I'm not sure how to resolve or fix this.
I accessed my CMS database using phpmyadmin.
I exported all values to the broken version of the FEU by exporting all cms_module_feusers_* tables in the database.
I restored the database to a version I have last night. I then exported on the cms_module_feusers_* tables only from this version of the database too.
I compared the two versions of all cms_module_feusers_* and noticed a few differences. Nothing seemed earth shattering...
However, this got me thinking about the first Groups you create when you set up FEU.
When I restored the database, this worked fine. But when I simply "modified" the name of the group from UserInput to newusers, it totally broke FEU groups. After that change you can no longer save any properties values. They are all stuck at "off" which means you can not use selfregistration or customcontent at all since they both require properties assigned and sorted to work properly.
For what it's worth, this is what I discovered.
I'm not a developer, but this sounds like a bug.
-paul
Re: I broke the FEU group functionality
Posted: Thu Nov 15, 2007 12:30 am
by calguy1000
I'll check out renaming groups tonite
Re: I broke the FEU group functionality
Posted: Thu Nov 15, 2007 12:38 am
by calguy1000
Okay, I in the latest SVN version of FEU
I renamed a group twice (the same group). then I created a new group, then I renamed it, no problems.
Though I did notice that I am not stopping illegal characters in the group name, so I should fix that.... otherwise there'll be some weird errors if you put things like $ or > into the group names, or sometimes even spaces.
Re: I broke the FEU group functionality
Posted: Thu Nov 15, 2007 2:56 pm
by pbrady
Thank you very much.
Will all this new code be in the 1.3.1 version when you release it? Will that happen this week?
Thanks again! Your modules are awesome!
Re: I broke the FEU group functionality
Posted: Thu Nov 15, 2007 3:26 pm
by calguy1000
Yeah, I'm just waiting to make sure I've got as many of the bugs fixed as I can reasonably get.
Re: I broke the FEU group functionality
Posted: Thu Nov 15, 2007 4:58 pm
by moorezilla
As long as feu is under review, I have some suggestions for a future release.
Would you have a look at the help file for the sort order for groups. It's a little unclear to me how it works, and once when I changed the numbers, it fired a warning and that changing the sort order could render fields unavailable, and then it did just that.
As an example, I have two groups, one for pending and one for intranet. When I look at either group, there are three added fields of information: email, last_name, and first_name, which I added for people registering through self registration.
What's weird is, if I go back under frontendusers and view the groups, the sortorder number for each of the three fields is set to zero. Changing this zero results in the warning and I then lose the ability to access these fields from, say, the change your settings link.
In a nutshell: how is the sort order numbering supposed to work, why does it seem to break when the default zeroes are changed, and can we add this information to the help file for the frontendusers module.
Lastly, if it's easy, could we make the csv file that is exported export in a format that can then be imported as is back into feu? Right now it needs editing first; I believe it needs column titles added; maybe something else? Also, when the csv file is made, it seems to put all users in both pending and intranet, even after they've been removed from pending, if that makes sense.
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Thu Nov 15, 2007 5:24 pm
by calguy1000
Export/Import
-----------------------
In a moment of clear thought (they don't happen that often) I thought that it would be better to get rid of the csv stuff all together, and just go with xml format. then the names of the properties, etc, could be matched up easier. and you would be able to directly import an xml file that FEU exported. I don't know when I'll get to it though.
Sort Order
-----------------
The sort order in the add/edit group pages is used to control the order that properties are displayed to users in the change settings dialog, and when adding/editing a user. It's purely used to control the order that the properties are returned from the database. Nothing more. So that you can have your 'first name' field directly above your 'last name' field independant of when you created them.
Its weird that they are all zeros for you and you're getting warnings. I'll try this out ASAP, but as an aside maybe you could turn debug mode on and see if FEU is spitting out any warnings/errors/notices for you. There may be something weird going on and I'd like to eliminate 'weird' things in 1.3.1.
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Thu Nov 15, 2007 7:37 pm
by moorezilla
Ok... I know this is more than anyone wants... but... my debug = this... lol... let me know if I can cut this down for you.
Code: Select all
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '18'<br>
Error (0): <br>
Debug: (0.159663) - (8627040)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.15999) - (8629256)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.160218) - (8629944)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.160503) - (8630928)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.160756) - (8631516)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.160966) - (8631736)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.16123) - (8632096)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.161478) - (8632396)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.161686) - (8632560)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.161928) - (8633296)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid=0<br>
Error (0): <br>
Debug: (0.162179) - (8633768)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.162437) - (8634212)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.162645) - (8634376)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.16461) - (8662944)
<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC<br>
Error (0): <br>
Debug display of 'Start Loading Hierarchy Manager':(0.202337) - (9093076)
Debug display of 'starting tree':(0.2024) - (9093520)
Debug: (0.204812) - (9215516)
file needs loading
Debug: (0.206322) - (9341608)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy<br>
Error (0): <br>
Debug display of 'ending tree':(0.210737) - (9593924)
Debug display of 'End Loading Hierarchy Manager':(0.210791) - (9568788)
Debug: (0.210836) - (9568956)
start findNodeByTag
Debug: (0.210897) - (9569044)
end findNodeByTag
Debug: (0.211018) - (9569284)
load properties called
Debug: (0.211237) - (9571104)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.211381) - (9575832)
load properties called
Debug: (0.211583) - (9575924)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '15'<br>
Error (0): <br>
Debug: (0.212346) - (9666484)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.212622) - (9668092)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.212844) - (9668528)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.213144) - (9669100)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.213421) - (9669332)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.213633) - (9669656)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.213896) - (9669948)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.214145) - (9670252)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.214355) - (9670416)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.214595) - (9670824)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid=0<br>
Error (0): <br>
Debug: (0.214849) - (9671180)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.215106) - (9671656)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195152978<br>
Error (0): <br>
Debug: (0.215317) - (9671820)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.223265) - (9668236)
start global_content_get_template
Debug: (0.224857) - (9735200)
<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'randadimage'<br>
Error (0): <br>
Debug: (0.225087) - (9743188)
end global_content_get_template
Debug: (0.22515) - (9743188)
start global_content_get_timestamp
Debug: (0.225209) - (9743188)
end global_content_get_timestamp
Debug: (0.229877) - (9820416)
<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'news'<br>
Error (0): <br>
Debug: (0.230012) - (9820984)
start findNodeByTag
Debug: (0.230586) - (9820984)
end findNodeByTag
Debug: (0.230817) - (9821660)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '99'<br>
Error (0): <br>
Debug: (0.232791) - (9827216)
<br>
(mysql):
SELECT count(mn.news_id) as count
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'jobs') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:26:18') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:26:18')) <br>
Error (0): <br>
Debug: (0.235128) - (9838076)
<br>
(mysql):
SELECT
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'jobs') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:26:18') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:26:18')) ORDER BY news_date desc<br>
Error (0): <br>
Debug: (0.235613) - (9842016)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '232' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.239033) - (9955576)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '202' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.240423) - (9957900)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '192' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.259703) - (10050832)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'News' and template_name = 'summaryjobsum'<br>
Error (0): <br>
Debug: (0.259995) - (10052248)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'News' and template_name = 'summaryjobsum'<br>
Error (0): <br>
Debug: (0.266298) - (9911560)
<br>
(mysql): SELECT * FROM cms_content WHERE (type='content' OR type='link')
AND default_content != 1 AND active = 1 AND show_in_menu = 1
ORDER BY modified_date DESC LIMIT 10<br>
Error (0): <br>
Debug: (0.266438) - (9911808)
start findNodeByTag
Debug: (0.266843) - (9911944)
end findNodeByTag
Debug: (0.267066) - (9911644)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '184'<br>
Error (0): <br>
Debug: (0.26745) - (9912276)
start findNodeByTag
Debug: (0.268081) - (9912276)
end findNodeByTag
Debug: (0.268268) - (9912260)
start findNodeByTag
Debug: (0.268406) - (9912348)
end findNodeByTag
Debug: (0.268623) - (9912612)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '182'<br>
Error (0): <br>
Debug: (0.268963) - (9913448)
start findNodeByTag
Debug: (0.269537) - (9913448)
end findNodeByTag
Debug: (0.269749) - (9913716)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '62'<br>
Error (0): <br>
Debug: (0.270091) - (9915224)
start findNodeByTag
Debug: (0.270534) - (9915224)
end findNodeByTag
Debug: (0.270743) - (9915400)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '117'<br>
Error (0): <br>
Debug: (0.271081) - (9917732)
start findNodeByTag
Debug: (0.271405) - (9917732)
end findNodeByTag
Debug: (0.271615) - (9917908)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '53'<br>
Error (0): <br>
Debug: (0.271951) - (9920940)
start findNodeByTag
Debug: (0.272029) - (9920940)
end findNodeByTag
Debug: (0.272208) - (9921216)
start findNodeByTag
Debug: (0.27264) - (9921400)
end findNodeByTag
Debug: (0.272852) - (9922112)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '124'<br>
Error (0): <br>
Debug: (0.273206) - (9925536)
start findNodeByTag
Debug: (0.273658) - (9925680)
end findNodeByTag
Debug: (0.273869) - (9926216)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '185'<br>
Error (0): <br>
Debug: (0.274104) - (9929592)
load properties called
Debug: (0.274292) - (9930304)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '185'<br>
Error (0): <br>
Debug: (0.274571) - (9930828)
start findNodeByTag
Debug: (0.274864) - (9930828)
end findNodeByTag
Debug: (0.277259) - (9858980)
<br>
(mysql): SELECT c.css_text, c.css_id, c.css_name, c.media_type, UNIX_TIMESTAMP(c.modified_date) AS mtime FROM cms_css c, cms_css_assoc ac WHERE ac.assoc_type='template' AND ac.assoc_to_id = 18 AND ac.assoc_css_id = c.css_id ORDER BY ac.create_date<br>
Error (0): <br>
Debug: (0.278737) - (9864792)
<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
Error (0): <br>
Debug: (0.281111) - (9865148)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '57'<br>
Error (0): <br>
Debug display of 'Start of Menu Manager Display':(0.282412) - (9933040)
Debug: (0.283424) - (9939524)
load properties called
Debug: (0.28364) - (9941504)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '171'<br>
Error (0): <br>
Debug: (0.283948) - (9942396)
load properties called
Debug: (0.284133) - (9943172)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '181'<br>
Error (0): <br>
Debug display of 'End of Menu Manager Display':(0.328284) - (9974028)
Debug: (0.329346) - (9962816)
<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'news'<br>
Error (0): <br>
Debug: (0.329479) - (9962996)
start findNodeByTag
Debug: (0.330061) - (9962996)
end findNodeByTag
Debug: (0.330976) - (10004880)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'<br>
Error (0): <br>
Debug: (0.331248) - (10005392)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'<br>
Error (0): <br>
Debug: (0.334863) - (9908464)
start findNodeByTag
Debug: (0.334938) - (9908464)
end findNodeByTag
Debug display of 'Start of Menu Manager Display':(0.335994) - (9976368)
Debug: (0.336064) - (9976368)
start findNodeByTag
Debug: (0.336122) - (9976456)
end findNodeByTag
Debug: (0.336451) - (9976564)
<br>
(mysql): SELECT * FROM cms_content WHERE hierarchy = '00001'<br>
Error (0): <br>
Debug: (0.336575) - (9976740)
start findNodeByTag
Debug: (0.336634) - (9976740)
end findNodeByTag
Debug display of 'End of Menu Manager Display':(0.35846) - (9978896)
Debug: (0.36059) - (10020688)
<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'news'<br>
Error (0): <br>
Debug: (0.360721) - (10021156)
start findNodeByTag
Debug: (0.361289) - (10021156)
end findNodeByTag
Debug: (0.363618) - (10026876)
<br>
(mysql):
SELECT count(mn.news_id) as count
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'General' OR mnc.news_category_name = 'Athletics' OR mnc.news_category_name = 'Deadlines' OR mnc.news_category_name = 'Academics' OR mnc.news_category_name = 'School Events' OR mnc.news_category_name = 'Students of the Month' OR mnc.news_category_name = 'Honor Roll' OR mnc.news_category_name = 'Student Information' OR mnc.news_category_name = 'Clubs' OR mnc.news_category_name = 'Faculty') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:26:18') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:26:18')) <br>
Error (0): <br>
Debug: (0.366311) - (10031068)
<br>
(mysql):
SELECT
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'General' OR mnc.news_category_name = 'Athletics' OR mnc.news_category_name = 'Deadlines' OR mnc.news_category_name = 'Academics' OR mnc.news_category_name = 'School Events' OR mnc.news_category_name = 'Students of the Month' OR mnc.news_category_name = 'Honor Roll' OR mnc.news_category_name = 'Student Information' OR mnc.news_category_name = 'Clubs' OR mnc.news_category_name = 'Faculty') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:26:18') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:26:18')) ORDER BY news_date desc LIMIT 0, 6<br>
Error (0): <br>
Debug: (0.366865) - (10031336)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '251' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.368291) - (10033624)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '250' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.369679) - (10034700)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '247' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.371066) - (10035996)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '246' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.372448) - (10038164)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '245' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.373841) - (10040200)
part two to follow
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Thu Nov 15, 2007 7:37 pm
by moorezilla
Code: Select all
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '243' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.375833) - (10080256)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'News' and template_name = 'summary_dflt'<br>
Error (0): <br>
Debug: (0.376116) - (10081140)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'News' and template_name = 'summary_dflt'<br>
Error (0): <br>
Debug: (0.390614) - (9982000)
<br>
(mysql): SELECT * from cms_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'<br>
Error (0): <br>
Debug: (0.391563) - (10023460)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'<br>
Error (0): <br>
Debug: (0.391849) - (10023696)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'<br>
Error (0): <br>
Debug: (0.401315) - (9980952)
<br>
(mysql): SELECT username, password, active, first_name, last_name, admin_access, email FROM cms_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.403981) - (10022160)
start global_content_get_template
Debug: (0.40419) - (10023352)
<br>
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM cms_htmlblobs WHERE htmlblob_name = 'footer'<br>
Error (0): <br>
Debug: (0.404419) - (10024088)
end global_content_get_template
Debug: (0.404483) - (10024088)
start global_content_get_timestamp
Debug: (0.404541) - (10024088)
end global_content_get_timestamp
Debug: (0.408225) - (9900340)
calling user tag add_news_title_to_page_title from event ContentPostRender
Debug: (0.408495) - (9900452)
<br>
(mysql): SELECT userplugin_id, code FROM cms_userplugins WHERE userplugin_name = 'add_news_title_to_page_title'<br>
Error (0): <br>
Debug is on. Redirecting disabled... Please click this link to continue.
http://chs.chelseaschools.com/chs/intranet.htm
Debug: (0.00708) - (545832)
loading smarty
Debug: (0.011474) - (808240)
loading adodb
Debug: (0.012956) - (887308)
loading page functions
Debug: (0.01567) - (1031268)
loading content functions
Debug: (0.018237) - (1207128)
loading pageinfo functions
Debug: (0.018806) - (1235352)
loading translation functions
Debug: (0.019244) - (1252620)
loading events functions
Debug: (0.020593) - (1335396)
done loading files
Debug: (0.02935) - (2019656)
<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.032722) - (2086516)
<br>
(mysql): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.039645) - (2517412)
<br>
(mysql): SELECT * FROM cms_modules WHERE admin_only = 0 ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.112673) - (7050016)
Debug: (0.113635) - (7017956)
<br>
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by, t.template_id, t.encoding, t.modified_date AS t_date FROM cms_templates t INNER JOIN cms_content c ON c.template_id = t.template_id WHERE (c.content_alias = '112' OR c.content_id = '112') AND c.active = 1<br>
Error (0): <br>
Debug: (0.113915) - (7018192)
<br>
(mysql): SELECT MAX(modified_date) AS thedate FROM cms_content c<br>
Error (0): <br>
Debug display of 'Load Content Operations':(0.114344) - (7018364)
Debug display of 'End Load Content Operations':(0.120936) - (7420512)
Debug: (0.12299) - (7551596)
<br>
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM cms_templates WHERE template_id = '22'<br>
Error (0): <br>
Debug: (0.138623) - (8627576)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.138929) - (8629792)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.139135) - (8630480)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.139412) - (8631464)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.139665) - (8632052)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.139875) - (8632272)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.140138) - (8632632)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.140385) - (8632936)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.140594) - (8633100)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.14084) - (8633836)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid=0<br>
Error (0): <br>
Debug: (0.141094) - (8634308)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.141341) - (8634752)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.141549) - (8634916)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.143523) - (8663496)
<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC<br>
Error (0): <br>
Debug: (0.185461) - (8999940)
<br>
(mysql): SELECT c.css_text, c.css_id, c.css_name, c.media_type, UNIX_TIMESTAMP(c.modified_date) AS mtime FROM cms_css c, cms_css_assoc ac WHERE ac.assoc_type='template' AND ac.assoc_to_id = 22 AND ac.assoc_css_id = c.css_id ORDER BY ac.create_date<br>
Error (0): <br>
Debug display of 'Start Loading Hierarchy Manager':(0.18577) - (8999816)
Debug display of 'starting tree':(0.185819) - (9000092)
Debug: (0.188135) - (9119436)
file needs loading
Debug: (0.189626) - (9243440)
<br>
(mysql): SELECT * FROM cms_content WHERE parent_id = -1 ORDER BY hierarchy<br>
Error (0): <br>
Debug display of 'ending tree':(0.194036) - (9494832)
Debug display of 'End Loading Hierarchy Manager':(0.19409) - (9469696)
Debug: (0.195298) - (9479212)
<br>
(mysql): SELECT * FROM cms_content WHERE default_content = 1<br>
Error (0): <br>
Debug: (0.196711) - (9480316)
load properties called
Debug: (0.196916) - (9481332)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '181'<br>
Error (0): <br>
Debug: (0.198483) - (9482128)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '137'<br>
Error (0): <br>
Debug display of 'Start of Menu Manager Display':(0.199815) - (9555672)
Debug: (0.20081) - (9567432)
load properties called
Debug: (0.20102) - (9570072)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '171'<br>
Error (0): <br>
Debug display of 'End of Menu Manager Display':(0.224535) - (9660380)
Debug: (0.227985) - (9790264)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'<br>
Error (0): <br>
Debug: (0.228277) - (9790772)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'<br>
Error (0): <br>
Debug: (0.2319) - (9694268)
start findNodeByTag
Debug: (0.23254) - (9694268)
end findNodeByTag
Debug display of 'Start of Menu Manager Display':(0.233595) - (9762532)
Debug: (0.233666) - (9762532)
start findNodeByTag
Debug: (0.234282) - (9762628)
end findNodeByTag
Debug: (0.234598) - (9762868)
<br>
(mysql): SELECT * FROM cms_content WHERE hierarchy = '00010'<br>
Error (0): <br>
Debug: (0.23472) - (9763212)
start findNodeByTag
Debug: (0.235331) - (9763212)
end findNodeByTag
Debug: (0.235766) - (9763408)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '158'<br>
Error (0): <br>
Debug: (0.236314) - (9764684)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '165'<br>
Error (0): <br>
Debug: (0.23684) - (9767528)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '141'<br>
Error (0): <br>
Debug: (0.237363) - (9771268)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '116'<br>
Error (0): <br>
Debug: (0.23767) - (9773656)
load properties called
Debug: (0.237873) - (9774964)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '116'<br>
Error (0): <br>
Debug: (0.238253) - (9777592)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '146'<br>
Error (0): <br>
Debug: (0.238489) - (9780528)
load properties called
Debug: (0.238681) - (9781836)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '146'<br>
Error (0): <br>
Debug: (0.239159) - (9783188)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '155'<br>
Error (0): <br>
Debug: (0.239691) - (9788808)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '131'<br>
Error (0): <br>
Debug: (0.240219) - (9794656)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '183'<br>
Error (0): <br>
Debug: (0.240448) - (9798736)
load properties called
Debug: (0.240642) - (9800240)
<br>
(mysql): SELECT * FROM cms_content_props WHERE content_id = '183'<br>
Error (0): <br>
Debug display of 'End of Menu Manager Display':(0.262396) - (9820700)
Debug: (0.264558) - (9865344)
<br>
(mysql): SELECT * FROM cms_content WHERE content_alias = 'news'<br>
Error (0): <br>
Debug: (0.264687) - (9865780)
start findNodeByTag
Debug: (0.265255) - (9865780)
end findNodeByTag
Debug: (0.265479) - (9866064)
<br>
(mysql): SELECT * FROM cms_content WHERE content_id = '99'<br>
Error (0): <br>
Debug: (0.267675) - (9872028)
<br>
(mysql):
SELECT count(mn.news_id) as count
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'General' OR mnc.news_category_name = 'Athletics' OR mnc.news_category_name = 'Deadlines' OR mnc.news_category_name = 'Academics' OR mnc.news_category_name = 'School Events' OR mnc.news_category_name = 'Students of the Month' OR mnc.news_category_name = 'Honor Roll' OR mnc.news_category_name = 'Student Information' OR mnc.news_category_name = 'Faculty') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:36:04') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:36:04')) <br>
Error (0): <br>
Debug: (0.270301) - (9875816)
<br>
(mysql):
SELECT
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
(mnc.news_category_name = 'General' OR mnc.news_category_name = 'Athletics' OR mnc.news_category_name = 'Deadlines' OR mnc.news_category_name = 'Academics' OR mnc.news_category_name = 'School Events' OR mnc.news_category_name = 'Students of the Month' OR mnc.news_category_name = 'Honor Roll' OR mnc.news_category_name = 'Student Information' OR mnc.news_category_name = 'Faculty') AND ( IFNULL(start_time, '1969-12-31 19:00:01') < '2007-11-15 14:36:04') AND (( IFNULL(end_time, '1969-12-31 19:00:01') = '1969-12-31 19:00:01') OR (end_time > '2007-11-15 14:36:04')) ORDER BY news_date desc LIMIT 0, 6<br>
Error (0): <br>
Debug: (0.270798) - (9876424)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '251' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.272176) - (9879684)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '250' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.273543) - (9881752)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '246' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.274916) - (9884184)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '245' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.276285) - (9886188)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '243' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.27764) - (9888440)
<br>
(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '241' ORDER BY B.item_order<br>
Error (0): <br>
Debug: (0.279237) - (9932628)
<br>
(mysql): SELECT content from cms_module_templates WHERE module_name = 'News' and template_name = 'summary_dflt'<br>
Error (0): <br>
Debug: (0.27951) - (9933740)
<br>
(mysql): SELECT modified_date from cms_module_templates WHERE module_name = 'News' and template_name = 'summary_dflt'<br>
Error (0): <br>
Debug: (0.293281) - (9790804)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.293575) - (9791004)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.293792) - (9791168)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.296827) - (9911736)
<br>
(mysql): SELECT sitepref_value from cms_siteprefs WHERE sitepref_name = 'Captcha_mapi_pref_active_lib'<br>
Error (0): <br>
Debug: (0.297176) - (9912532)
<br>
(mysql): UPDATE cms_siteprefs SET sitepref_value = 'hncaptcha' WHERE sitepref_name = 'Captcha_mapi_pref_active_lib'<br>
Error (0): <br>
Debug: (0.306924) - (10166120)
<br>
(mysql): SELECT u.* FROM cms_module_feusers_users u WHERE u.username='moorea' AND u.password='75bde0d81e682c549cc7ecfeaa2dcfe6'<br>
Error (0): <br>
Debug: (0.307388) - (10166460)
<br>
(mysql): SELECT * FROM cms_module_feusers_users WHERE username='moorea'<br>
Error (0): <br>
Debug: (0.307906) - (10167060)
<br>
(mysql): SELECT * FROM cms_module_feusers_users
WHERE id = '1' AND expires > '\'2007-11-15 14:36:04\''<br>
Error (0): <br>
Debug: (0.309899) - (10167924)
<br>
(mysql): INSERT INTO cms_module_feusers_loggedin (sessionid,lastused,userid)
VALUES ('d78f5dfcd9b71ab083950a87dcdd6a20',1195155364,'1')<br>
Error (0): <br>
Debug: (0.310325) - (10168116)
<br>
(mysql): INSERT INTO cms_module_feusers_history VALUES ('1','d78f5dfcd9b71ab083950a87dcdd6a20','login','2007-11-15 14:36:04','172.20.38.29')<br>
Error (0): <br>
Debug: (0.313009) - (10255012)
<br>
(mysql): INSERT INTO cms_adminlog (timestamp, user_id, username, item_id, item_name, action) VALUES (1195155364,'1','chsadmin',0,'Frontend User Management','Frontend User Login: moorea')<br>
Error (0): <br>
Debug: (0.31338) - (10254924)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.313637) - (10255180)
<br>
(mysql): DELETE FROM cms_module_feusers_loggedin WHERE lastused<1195153564<br>
Error (0): <br>
Debug: (0.313924) - (10255504)
<br>
(mysql): SELECT * FROM cms_module_feusers_loggedin WHERE sessionid='d78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.314217) - (10256236)
<br>
(mysql): UPDATE cms_module_feusers_loggedin SET lastused = 1195155364 where sessionid = 'd78f5dfcd9b71ab083950a87dcdd6a20'<br>
Error (0): <br>
Debug: (0.314548) - (10256316)
<br>
(mysql): SELECT * FROM cms_module_feusers_belongs WHERE userid='1'<br>
Error (0): <br>
Debug: (0.314792) - (10256500)
<br>
(mysql): SELECT * FROM cms_module_feusers_groups WHERE id='2'<br>
Error (0): <br>
Debug: (0.31497) - (10256776)
start findNodeByTag
Debug: (0.315612) - (10256776)
end findNodeByTag
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Thu Nov 15, 2007 8:50 pm
by calguy1000
is that from the 'edit group' page?
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Thu Nov 15, 2007 9:16 pm
by moorezilla
ok... i turned on debug and i couldn't login, so i turned it off and logged in and went to the edit groups page, and then turned debug on and hit refresh. this is what i get:
Code: Select all
Debug: (1.3E-5) - (467316)
loading smarty
Debug: (0.004365) - (729660)
loading adodb
Debug: (0.005816) - (808720)
loading page functions
Debug: (0.008522) - (952688)
loading content functions
Debug: (0.011043) - (1128544)
loading pageinfo functions
Debug: (0.011597) - (1156720)
loading translation functions
Debug: (0.01202) - (1173940)
loading events functions
Debug: (0.013353) - (1256848)
done loading files
Debug: (0.021966) - (1941180)
<br>
(mysql): SELECT sitepref_name, sitepref_value from cms_siteprefs<br>
Error (0): <br>
Debug: (0.025302) - (2008048)
<br>
(mysql): SELECT * FROM cms_userplugins<br>
Error (0): <br>
Debug: (0.042687) - (2575420)
<br>
(mysql): SELECT * FROM cms_modules ORDER BY module_name<br>
Error (0): <br>
Debug display of 'End of include':(0.11542) - (7104944)
Debug: (0.115511) - (7069572)
Session found. Moving on...
Debug: (0.115572) - (7069760)
Session found. Moving on...
Debug: (0.115825) - (7071244)
<br>
(mysql): SELECT preference, value FROM cms_userprefs WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.121057) - (7415748)
Session found. Moving on...
Debug: (0.121137) - (7416016)
Session found. Moving on...
Debug: (0.122965) - (7513540)
Session found. Moving on...
Debug: (0.124441) - (7576228)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.124721) - (7578196)
<br>
(mysql): SELECT DISTINCT permission_name FROM cms_user_groups ug INNER JOIN cms_group_perms gp ON gp.group_id = ug.group_id INNER JOIN cms_permissions p ON p.permission_id = gp.permission_id WHERE ug.user_id = '1'<br>
Error (0): <br>
Debug: (0.125605) - (7587956)
Session found. Moving on...
Debug: (0.125807) - (7588480)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.12665) - (7606792)
Session found. Moving on...
Debug: (0.126851) - (7607712)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.128282) - (7648848)
Session found. Moving on...
Debug: (0.128475) - (7649836)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.130901) - (7716084)
Session found. Moving on...
Debug: (0.131097) - (7716484)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.131406) - (7717036)
Session found. Moving on...
Debug: (0.131597) - (7717144)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.132537) - (7717864)
Session found. Moving on...
Debug: (0.132729) - (7718556)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.133207) - (7719428)
Session found. Moving on...
Debug: (0.133403) - (7720248)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.134844) - (7741704)
Session found. Moving on...
Debug: (0.135052) - (7743008)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.135688) - (7744656)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.135951) - (7744888)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.136201) - (7745120)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.137758) - (7810156)
<br>
(mysql): SELECT htmlblob_id FROM cms_additional_htmlblob_users WHERE user_id = '1'<br>
Error (0): <br>
Debug: (0.138041) - (7811144)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.138331) - (7811384)
<br>
(mysql): SELECT content_id FROM cms_content WHERE owner_id = '1'<br>
Error (0): <br>
Debug: (0.139152) - (7814188)
<br>
(mysql): SELECT user_id,content_id FROM cms_additional_users<br>
Error (0): <br>
Debug: (0.139693) - (7814532)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.139951) - (7814764)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.140202) - (7814996)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.140463) - (7815228)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.140713) - (7815460)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.140971) - (7815692)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.141222) - (7815924)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.14148) - (7816156)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.141731) - (7816384)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.141993) - (7816616)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.142246) - (7816848)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.1425) - (7817080)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.14275) - (7817308)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.143007) - (7817536)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.143256) - (7817768)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.14351) - (7818000)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.143761) - (7818228)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.144019) - (7818460)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.144289) - (7818812)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.144552) - (7819164)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.144804) - (7819456)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.145063) - (7819748)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.156725) - (7987688)
Session found. Moving on...
Debug: (0.156961) - (7987540)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.157086) - (7988036)
Session found. Moving on...
Debug: (0.157274) - (7987772)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.157388) - (7988276)
Session found. Moving on...
Debug: (0.157575) - (7988012)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.157688) - (7988516)
Session found. Moving on...
Debug: (0.157873) - (7988352)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.157985) - (7988848)
Session found. Moving on...
Debug: (0.158171) - (7988684)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.158283) - (7989180)
Session found. Moving on...
Debug: (0.158469) - (7989020)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.158582) - (7989516)
Session found. Moving on...
Debug: (0.158767) - (7989356)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.15888) - (7989852)
Session found. Moving on...
Debug: (0.159066) - (7989588)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.15918) - (7990084)
Session found. Moving on...
Debug: (0.159366) - (7989820)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.159483) - (7990316)
Session found. Moving on...
Debug: (0.15967) - (7990156)
<br>
(mysql): SELECT ug.user_id FROM cms_user_groups ug
WHERE ug.user_id = '1' AND ug.group_id = 1<br>
Error (0): <br>
Debug: (0.16598) - (8344408)
<br>
(mysql): SELECT * FROM cms_module_feusers_groups WHERE id = '2'<br>
Error (0): <br>
Debug: (0.169424) - (8465912)
<br>
(mysql): SELECT * FROM cms_module_feusers_propdefn ORDER by name ASC<br>
Error (0): <br>
Debug: (0.169698) - (8467696)
<br>
(mysql): SELECT * FROM cms_module_feusers_grouppropmap
WHERE group_id = '2' ORDER BY sort_key DESC<br>
Error (0): <br>
Debug: (0.183329) - (9232676)
<br>
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC<br>
Error (0): <br>
Re: I broke the FEU group functionality [solved - waiting for FEU 1.3.1 fixes]
Posted: Mon Nov 26, 2007 6:03 pm
by pbrady
Hi Calguy!
Sorry to be a pest...just wondering when you might release 1.3.1 of FEU?
Hope you had a great Thanksgiving holiday!
Best,
-Paul