Welcome to Geeklog Monday, May 20 2013 @ 12:21 AM EDT
|
||||||||
![]() |
Forum Index > Support > General Geeklog Support |
New Topic
|
Post Reply
|
1.3.1 - Unknown column... |
|||
| dippe |
|
||||||
![]() ![]() ![]() ![]() ![]() Newbie Status: offline ![]() Registered: 01/19/02 Posts: 1 |
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? |
||||||
|
|||||||
| Tony |
|
||||||
![]() ![]() ![]() ![]() ![]() Admin ![]() Status: offline ![]() Registered: 12/17/01 Posts: 405 |
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. |
||||||
|
|||||||
| theCoobler |
|
||||||
![]() ![]() ![]() ![]() ![]() Newbie Status: offline ![]() Registered: 01/20/02 Posts: 2 |
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
|
||||||
|
|||||||
| theCoobler |
|
||||||
![]() ![]() ![]() ![]() ![]() Newbie Status: offline ![]() Registered: 01/20/02 Posts: 2 |
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. |
||||||
|
|||||||
| 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 |
||||||
|
|||||||
| Content generated in: 0.38 seconds |
|
|
|