Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 09:13 pm EDT

Geeklog Forums

1054: Unknown column 'deleted' in 'where clause'


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
 Quote

Status: offline

Dirk

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

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
 Quote

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
 Quote

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

Anonymous

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

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
 Quote

Anonymous

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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany

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

 Quote

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
 Quote

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

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
"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
 Quote

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
 Quote

All times are EDT. The time is now 09:13 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content