Gator

Anonymous
i Get this error..

1054: Unknown column 'is_enabled' in 'field list'

Status: offline

Dirk

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

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

bye, Dirk

Status: offline

Dirk

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

Gator

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

Status: offline

Dirk

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

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?

Status: offline

Dirk

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

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'

Status: offline

Dirk

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

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


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~

Gator

Anonymous
Where can i find this information at?

Status: offline

Dirk

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

bye, Dirk

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

Status: offline

Dirk

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

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.


Status: offline

Dirk

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

Gator

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

Status: offline

Dirk

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

Gator

Anonymous
Fixed the error, thanks!

Page navigation