Posted on: 01/19/02 02:51am
By: Anonymous (dippe)
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?
Your answer
Posted on: 01/19/02 11:04am
By: Tony
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.
Your answer
Posted on: 01/20/02 09:36am
By: Anonymous (theCoobler)
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
Here's something
Posted on: 01/20/02 09:53am
By: Anonymous (theCoobler)
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.
adding help field to blocks table
Posted on: 02/01/02 09:02am
By: 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