Welcome to Geeklog, Anonymous Wednesday, October 09 2024 @ 11:11 am 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
http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com
11
9
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
http://www.etegration.com.sg
http://www.itcow.com
http://www.ministryofhosting.com
13
9
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
12
12
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.
13
10
Quote
Anonymous
Anonymous
Different computer, different session, everything's fine.
Somewhere in all the logging in/out, I must have freaked it out somehow.
8
7
Quote
Anonymous
Anonymous
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.
13
14
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?
8
16
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
8
9
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!
11
9
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
11
16
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
17
16
Quote
All times are EDT. The time is now 11:11 am.
- 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