Geeklog Forums

What is causing it??? what did i do??!! I get 1054: Unknown column 'deleted' in 'where clause' Try visiting http://rssitzone.etegration.com It says that the minute it trys to load the dir /public_html/

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com

I don't see any error message when I go to that site. Has the problem already been fixed? bye, Dirk

Hi Dirk, no it hasn't but i went in on the same day's night and it worked, hope it doesn't do that again, dunno wat happen...thanks anyway.

---

http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com

I'm now getting this message on my system. No clue how it happened or what's going on. Any clue, anyone? http://bob2.ius.edu

OK. It looks to be semi-cookie-related. The problem occurs when a user logs out. Instead of refreshing the page and displaying a no-user page, the 1054 error displays. HOWEVER, if I delete my cookies and reload, everything displays normally ... until I log in and then log out. Hmm.

Different computer, different session, everything's fine. Somewhere in all the logging in/out, I must have freaked it out somehow.

1054: Unknown column 'deleted' in 'where clause' I'm having this one too. Haven't tried to delete my cookies yet, but I'll try.

works ok after removing cookie, but when i login/logout again it shows the dreaded 1054. Is there any fix for this?

I think I found the problem. Can I ask the people who experience this problem to download an updated version of lib-sessions.php and give me some feedback if it helped? The fixed version should work with Geeklog 1.3.5 (all revisions) as well as 1.3.6rc1.

bye, Dirk

No this didn't fix it for me. I'm on v1.3.5sr2. With this, I get the 1054 error right after logging in, instead of when logging out. I revert back to the old lib-sessions.php and now it works again both when logging in and out. Very wierd problem. selk

I have just installed geeklog 1.3.7. I managed the install procedure and the Sq tables seem to have been written. However, when I try to point my browser to http://mitglieb.lycos.de/infotek/geeklog/public_html/index.p hp I get the error message: 1054: Unknown column 'sp_pos' in 'field list' SQL in question: SELECT sp_id, sp_label, sp_pos, group_id, owner_id, perm_owner, perm_group, perm_members, perm_anon FROM gl_staticpage WHERE sp_onmenu = 1 ORDER BY sp_pos I have NOT managed to do anything, including logging on because after clicking on Next (Part 2 of the installation process), it timed out! I have no idea as to what the problem may be and welcome help. Many thanks in advance!

"sp_pos" is not used by the static pages plugin that ships with Geeklog, so I assume you're mixing the extended version 1.2 of that plugin with the "standard" version. Try disabling the plugin by going into MySQL (or phpMyAdmin) and setting pi_enabled for the static pages plugin to 0. That should bring up the site (minus the static pages, of course). bye, Dirk

hey all, i had this problem when upgrading staticpages 1.1 to 1.2 on geeklog 1.3.7. the upgrade instructions say to disable staticpages, replace the old code with the new code and then enable the plugin. this lead to the 1054 error: 1054: Unknown column 'sp_pos' in 'field list' SQL so, i disabled, ran the install script to update the database, enabled and it works! thanks for the pointers in this thread. danny