Menu

#29 Incorrect datatype in table

open
nobody
None
5
2002-09-14
2002-09-14
No

Version: 1.10.3

Symptom:

You cannot set "default group to view" to "ALL
GROUPS" in Bookmarks Preferences. When you do
the setting does not "stick".

Cause:

The data type in twig_bookmarks_prefs.viewgrp is:
int(11) NOT NULL default '0'

And it should be:
varchar(10) NOT NULL default '0'

Fix:

You can fix this on existing installations by dropping the
column and recreating it with the proper datatype.

For new installations, edit the file
setup/twiggi.table.mysql and change the properties of
the field before

Discussion


Log in to post a comment.