Topics

User Functions

Events

There are no upcoming events

What's New

Stories

No new stories

Comments last 2 weeks

No new comments

Trackbacks last 2 weeks

No new trackback comments

Links last 2 weeks

No recent new links

NEW FILES last 14 days

No new files

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
 01/19/02 02:51AM (Read 1170 times)  
+----
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?

 
Profile Email
 Quote
Tony
 01/19/02 11:04AM  
AAAAA
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.
 
Profile Email Website
 Quote
theCoobler
 01/20/02 09:36AM  
+----
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

 
Profile Email
 Quote
theCoobler
 01/20/02 09:53AM  
+----
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.

 
Profile Email
 Quote
Anonymous: Anonymous
 02/01/02 09:02AM  



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
Content generated in: 0.38 seconds
New Topic Post Reply

Normal Topic Normal Topic
Sticky Topic Sticky Topic
Locked Topic Locked Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Able to post 
Filtered HTML Allowed 
Censored Content