Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 01:47 pm EDT

Geeklog Forums

1.3.1 - Unknown column...


dippe

Anonymous
I made a fresh install of 1.3.1. I get this error when trying to change the name of a (any) block. 1054: Unknown column 'help' in 'field list' What's wrong?
 Quote

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
Location:Urbandale, Iowa
Read the article about the help field a few down from this one on the homepage. ----- The reason people blame things on previous generations is that there's only one other choice.
The reason people blame things on previous generations is that there's only one other choice.
 Quote

theCoobler

Anonymous
I have the same problem? And I can't find 'the other' post... Is it me? Let me look for it again, but if someone could reply a solution to this thread, I'd be gratefull
 Quote

theCoobler

Anonymous
I appears that the column 'help' is missing in the block table in your mySQL database. I traced the variable and noticed it was inserted into table 'blocks', column 'help'. So in order to fix the problem, add a column: field: help, type: varchar(96), Null: yes WARNING: this is *my* solution, I haven't thoroughly tested it, so if you want to make sure nothing goes wrong, wait until one of the developers has confirmed.
 Quote

Anonymous

Anonymous
Here's the way to add the field for the newbie in all of us: mysql> use geeklog; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> alter table blocks -> add help VARCHAR(128) default NULL; Query OK, 7 rows affected (0.00 sec) Records: 7 Duplicates: 0 Warnings: 0
 Quote

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