Welcome to Geeklog, Anonymous Wednesday, October 09 2024 @ 12:28 pm EDT
Geeklog Forums
1054: Unknown column 'is_enabled' in 'field list'?
Page navigation
Gator
Anonymous
i Get this error..
1054: Unknown column 'is_enabled' in 'field list'
39
35
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Seriously, please help us help you and give some more information.
What were you doing when that happened? Is that a fresh install or was the site already up and running? Did you install any plugins, change any settings, etc. etc.?
Oh, and which Geeklog version are we talking about?
"is_enabled" is a field in the gl_blocks table and it is supposed to exist ...
bye, Dirk
What were you doing when that happened? Is that a fresh install or was the site already up and running? Did you install any plugins, change any settings, etc. etc.?
Oh, and which Geeklog version are we talking about?
"is_enabled" is a field in the gl_blocks table and it is supposed to exist ...
bye, Dirk
35
35
Quote
Gator
Anonymous
You dont have to be rude about it! its a fresh installation and its geeklog 1.3.8
35
35
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
I wasn't rude, just frustrated.
And I still don't know what you did. Did you even run the install script? As I said, the is_enabled field is part of the gl_blocks table and will be created when you run the install script.
bye, Dirk
And I still don't know what you did. Did you even run the install script? As I said, the is_enabled field is part of the gl_blocks table and will be created when you run the install script.
bye, Dirk
45
32
Quote
Gator
Anonymous
I ran the install script but when it got to the success page it was page cannot be found and how i know it was the success page because of the link but it didnt show. i then checked to see if it was in admin/install and it was. so what do i do now? or does it really matter?
36
34
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Gator: so what do i do now? or does it really matter?
So did you run the install script now (after I told you to do so) or did you before and got the "unknown column" error?
Please be more precise, as I can't see what you're doing from here ...
When the success.php is not found, it means that your setting for $_CONF['site_url'] is not correct. If that's the only error you have now, then you only need to fix that URL setting (and you don't need to run the install script again).
bye, Dirk
39
50
Quote
Gator
Anonymous
I deleted my database, and ran the install script and i got that error. the unkown column 'is_enabled' in 'field list'
36
37
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
That's strange. Can you check what you have in your database now? You should have 39 tables. One of them is gl_blocks, which should have 'is_enabled' as the second field.
If some of the tables or fields are missing, you may have a problem with your MySQL permissions.
bye, Dirk
If some of the tables or fields are missing, you may have a problem with your MySQL permissions.
bye, Dirk
37
36
Quote
Gator
Anonymous
I have 39 tables, i clicked browse gl_blocks and the things that come up then are:
user_block
admin_block
section_block
poll_block
events_block
whats_new_block
first_block
whosonline_block
older_stories
secuirty_check
user_block
admin_block
section_block
poll_block
events_block
whats_new_block
first_block
whosonline_block
older_stories
secuirty_check
36
28
Quote
Status: offline
exaurdon
Forum User
Regular Poster
Registered: 08/13/03
Posts: 107
I have 39 tables, i clicked browse gl_blocks and the things that come up then are:
user_block
admin_block
section_block
poll_block
events_block
whats_new_block
first_block
whosonline_block
older_stories
secuirty_check
This is the list of blocks you currently have in yoursystem. What is more important is what columns exist int eh database, so while you have provided the contents fo hte table, we also need to know the structure of the database. This would be a list of which columns are in the table, what the type of each column is, etc... (This is sometimes also called a database schema)
If you could check which columns exist, it may allow us to know where your problem lies.
Thanks,
Exaurdon~
46
38
Quote
Gator
Anonymous
Where can i find this information at?
37
33
Quote
Gator
Anonymous
heres a link to a screen shot i took of what i think is what you asked:
http://bottle-cap.net/untitled.bmp
http://bottle-cap.net/untitled.bmp
38
37
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Hmm, interesting - haven't seen that one before.
While all the other fields seem to be there, 'is_enabled' is obviously missing. Not sure what could be causing this ...
What version of MySQL is this? phpMyAdmin should tell you the version on its index page, below the "Welcome to phpMyAdmin" headline.
Also, do you have a field called 'is_default' in table "gl_topics"? It has the same type as the missing 'is_enabled' field, so maybe your version of MySQL doesn't like something there.
And did you get any errors during the install?
bye, Dirk
While all the other fields seem to be there, 'is_enabled' is obviously missing. Not sure what could be causing this ...
What version of MySQL is this? phpMyAdmin should tell you the version on its index page, below the "Welcome to phpMyAdmin" headline.
Also, do you have a field called 'is_default' in table "gl_topics"? It has the same type as the missing 'is_enabled' field, so maybe your version of MySQL doesn't like something there.
And did you get any errors during the install?
bye, Dirk
39
36
Quote
Gator
Anonymous
No errors during install..
I have MySQL 4.0.15-standard
I do have is_default.. dont know if this means anything but it says unsigned under the attributes part of it.
I have MySQL 4.0.15-standard
I do have is_default.. dont know if this means anything but it says unsigned under the attributes part of it.
35
32
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Well, I have no idea why that field is missing. Let's try and add it manually. In phpMyAdmin
If you get an error, write it down (and post it here) or make a screenshot.
If all goes well, try to call up your site now.
Hope that helps.
bye, Dirk
- go to the gl_blocks table
- click on the "Structure" tab
- scroll down to where it says "Add new field: [1] [At End of Table]"
- click the "Go" button
- on the new screen, from left to right enter or select from the dropdown such that it reads: [is_enabled] [TINYINT] [1] [UNSIGNED] [not null] [1]
- leave the rest of the line alone (nothing selected from the "Extra" dropdown)
- click "save"
If you get an error, write it down (and post it here) or make a screenshot.
If all goes well, try to call up your site now.
Hope that helps.
bye, Dirk
42
38
Quote
Gator
Anonymous
that works but noen of the links or images work..
38
37
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Gator: that works but noen of the links or images work..
Sounds like the typical (but simple) problem with the URL now. Make sure $_CONF['site_url'] points to where your index.php resides.
bye, Dirk
36
33
Quote
Gator
Anonymous
Fixed the error, thanks!
43
33
Quote
Page navigation
All times are EDT. The time is now 12:28 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