Welcome to Geeklog Tuesday, September 22 2020 @ 03:14 am 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'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
grumpy
Quote by Gator: i Get this error..

That's nice. Do you want fries with that?

bye, Dirk
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 Quote

Gator

Anonymous
You dont have to be rude about it! its a fresh installation and its geeklog 1.3.8
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 Quote

Gator

Anonymous
stressed
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?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 Quote

Gator

Anonymous
envious
I deleted my database, and ran the install script and i got that error. the unkown column 'is_enabled' in 'field list'
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 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

 Quote

Status: offline

exaurdon

Forum User
Regular Poster
Registered: 13/08/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~
 Quote

Gator

Anonymous
Where can i find this information at?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
In a current version of phpMyAdmin, that would be the "Structure" tab.

bye, Dirk
 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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 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.

 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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

  • 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"
You should be taken back to the "Structure" tab with a message saying "Table gl_blocks has been altered."

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
 Quote

Gator

Anonymous
that works but noen of the links or images work..
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/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
 Quote

Gator

Anonymous
Fixed the error, thanks!
 Quote

Page navigation

All times are EDT. The time is now 03:14 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