Welcome to Geeklog, Anonymous Friday, November 29 2024 @ 02:44 pm EST
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?
10
13
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.
The reason people blame things on previous generations is that there's only one other choice.
11
11
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
8
13
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.
9
13
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
16
14
Quote
All times are EST. The time is now 02:44 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