Geeklog Forums

i Get this error..

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

bye, Dirk

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

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

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

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?

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

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

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

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~

Where can i find this information at?

In a current version of phpMyAdmin, that would be the "Structure" tab.

bye, Dirk

heres a link to a screen shot i took of what i think is what you asked:

http://bottle-cap.net/untitled.bmp

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

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.

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

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

Fixed the error, thanks!