Status: offline
roc97007
Forum User
Junior
Registered: 12/25/05
Posts: 32
Running Geeklog 1.4.0.sr5-1 on Fedora 10 with the Gallery plugin. I have several geeklog instances on this machine running the same version.
In the recent past I lost the ability to add or change (some) content on one of the sites. I log in as admin, and see the admin menus, so it doesn't appear to be an authentication issue. Other sites on this machine work fine. I have compared settings between working and non-working instances and nothing jumps out at me.
Here's the odd thing: On the broken site, I can change static pages. I have a running blog on the first page which is just a static page that grows without bound. If I add to it, I see the content. But if I try to add a new story or change an existing story, I can preview the changes, and hitting "save" doesn't appear to error out, but the new content is not there. Sometimes when this happens it's a local cache issue, but hitting shift-refresh doesn't help.
Doing a tail -f on the error log while doing a save operation yields the following SQL:
Sun 05 Jul 2009 22:08:42 PDT - SELECT * FROM mnu_index WHERE ((perm_anon >= 3) OR (perm_members >= 2) OR ((group_id = 2) AND (perm_group >= 2)) OR ((group_id = 4) AND (perm_group >= 2)) OR ((group_id = 7) AND (perm_group >= 2)) OR ((group_id = 21) AND (perm_group >= 2)) OR ((group_id = 20) AND (perm_group >= 2)) OR ((group_id = 11) AND (perm_group >= 2)) OR ((group_id = 17) AND (perm_group >= 2)) OR ((group_id = 5) AND (perm_group >= 2)) OR ((group_id = 13) AND (perm_group >= 2)) OR ((group_id = 12) AND (perm_group >= 2)) OR ((group_id = 18) AND (perm_group >= 2)) OR ((group_id = 10) AND (perm_group >= 2)) OR ((group_id = 8) AND (perm_group >= 2)) OR ((group_id = 1) AND (perm_group >= 2)) OR ((group_id = 15) AND (perm_group >= 2)) OR ((group_id = 14) AND (perm_group >= 2)) OR ((group_id = 3) AND (perm_group >= 2)) OR ((group_id = 23) AND (perm_group >= 2)) OR ((group_id = 6) AND (perm_group >= 2)) OR ((group_id = 9) AND (perm_group >= 2)) OR ((group_id = 24) AND (perm_group >= 2)) OR ((owner_id = 2) AND (perm_owner >= 2))) AND (lang = 'english'
ORDER BY m_pos ASC
Sun 05 Jul 2009 22:08:42 PDT - nrows = 8 <> language = english
I don't know if this is an indication of a problem but include it for completeness.
Any ideas?
In the recent past I lost the ability to add or change (some) content on one of the sites. I log in as admin, and see the admin menus, so it doesn't appear to be an authentication issue. Other sites on this machine work fine. I have compared settings between working and non-working instances and nothing jumps out at me.
Here's the odd thing: On the broken site, I can change static pages. I have a running blog on the first page which is just a static page that grows without bound. If I add to it, I see the content. But if I try to add a new story or change an existing story, I can preview the changes, and hitting "save" doesn't appear to error out, but the new content is not there. Sometimes when this happens it's a local cache issue, but hitting shift-refresh doesn't help.
Doing a tail -f on the error log while doing a save operation yields the following SQL:
Sun 05 Jul 2009 22:08:42 PDT - SELECT * FROM mnu_index WHERE ((perm_anon >= 3) OR (perm_members >= 2) OR ((group_id = 2) AND (perm_group >= 2)) OR ((group_id = 4) AND (perm_group >= 2)) OR ((group_id = 7) AND (perm_group >= 2)) OR ((group_id = 21) AND (perm_group >= 2)) OR ((group_id = 20) AND (perm_group >= 2)) OR ((group_id = 11) AND (perm_group >= 2)) OR ((group_id = 17) AND (perm_group >= 2)) OR ((group_id = 5) AND (perm_group >= 2)) OR ((group_id = 13) AND (perm_group >= 2)) OR ((group_id = 12) AND (perm_group >= 2)) OR ((group_id = 18) AND (perm_group >= 2)) OR ((group_id = 10) AND (perm_group >= 2)) OR ((group_id = 8) AND (perm_group >= 2)) OR ((group_id = 1) AND (perm_group >= 2)) OR ((group_id = 15) AND (perm_group >= 2)) OR ((group_id = 14) AND (perm_group >= 2)) OR ((group_id = 3) AND (perm_group >= 2)) OR ((group_id = 23) AND (perm_group >= 2)) OR ((group_id = 6) AND (perm_group >= 2)) OR ((group_id = 9) AND (perm_group >= 2)) OR ((group_id = 24) AND (perm_group >= 2)) OR ((owner_id = 2) AND (perm_owner >= 2))) AND (lang = 'english'
ORDER BY m_pos ASCSun 05 Jul 2009 22:08:42 PDT - nrows = 8 <> language = english
I don't know if this is an indication of a problem but include it for completeness.
Any ideas?