Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
I don't see any error message when I go to that site. Has the problem already been fixed? bye, Dirk

Status: offline

etegration

Forum User
Full Member
Registered: 02/20/02
Posts: 179
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

Anonymous

Anonymous
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

Anonymous

Anonymous
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.

Anonymous

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

Anonymous

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

Anonymous

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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073

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


Anonymous

Anonymous
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

infotech

Anonymous
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!

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
"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

dchoriki

Anonymous
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