I guess I didn't realize keywords was a field I added. I really don't remember adding it.
In looking over the files some things weren't imported properly.
I've just spent 9 or 10 reinstalls trying to get it to accept my links.def file:
Code:
%db_def = (
ID => [0, 'numer', 5, 8, 1, '', ''],
Title => [1, 'alpha', 40, 75, 1, '', ''],
URL => [2, 'alpha', 40, 150, 1, '', ''],
Date => [3, 'date', 15, 15, 1, \&get_date, ''],
Category => [4, 'alpha', 0, 150, 1, '', ''],
Description => [5, 'alpha', '40x3', 500, 0, '', ''],
'Copyright Info' => [6, 'alpha', 40, 75, 0, 'Copyright 1999, Digital Postcards (R)', ''],
Keywords => [7, 'alpha', 40, 150, 0, '', ''],
Hits => [8, 'numer', 10, 10, 1, '0', '\d+'],
isNew => [9, 'alpha', 0, 5, 0, 'No', ''],
isPopular => [10, 'alpha', 0, 5, 0, 'No', ''],
Rating => [11, 'numer', 10, 10, 1, 0, '^[\d\.]+$'],
Votes => [12, 'numer', 10, 10, 1, 0, '^\d+$'],
ReceiveMail => [13, 'alpha', 10, 10, 1, 'Yes', 'No|Yes'],
Thumb => [14, 'alpha', 40, 150, 0, '', ''],
Twidth => [15, 'alpha', 5, 5, 0, '', ''],
Theight => [16, 'alpha', 5, 5, 0, '', ''],
Priority => [17, 'alpha', 0, 5, 0, '', 'Yes|No'],
SendCGI => [18, 'alpha', 25, 25, 0, '', ''],
DateAdded => [19, 'date', 15, 15, 0, \&get_date, '']
); # end db_def 's
[/CODE}
But I end up with the following links.def in SQL:
Code:
%db_def = (
ID => ['1', 'INT', '10', '20', '1', '0', '^\d*\.?\d*$'],
Title => ['2', 'CHAR', '40', '100', '1', '', '', '3'],
URL => ['3', 'CHAR', '40', '150', '1', '', ''],
Add_Date => ['4', 'DATE', '20', '20', '1', 'NOW', '^\d{4}\-\d{2}\-\d{2}$'],
Mod_Date => ['5', 'DATE', '20', '20', '1', 'NOW', '^\d{4}\-\d{2}\-\d{2}$'],
CategoryID => ['6', 'INT', '10', '20', '1', '0', '^\d*\.?\d*$'],
Description => ['7', 'CHAR', '40x3', '5000', '0', '', '', '1'],
Contact_Name => ['8', 'CHAR', '40', '50', '0', '', ''],
Contact_Email => ['9', 'CHAR', '40', '50', '0', '', ''],
Hits => ['10', 'SMALLINT', '10', '20', '1', '0', '^\d*\.?\d*$'],
isNew => ['11', 'CHAR', '0', '3', '1', 'No', 'Yes|No'],
isPopular => ['12', 'CHAR', '0', '3', '1', 'No', 'Yes|No'],
Rating => ['13', 'DECIMAL', '10', '20', '1', '0.00', '^\d*\.?\d*$'],
Votes => ['14', 'SMALLINT', '10', '20', '1', '0', '^\d*\.?\d*$'],
ReceiveMail => ['15', 'CHAR', '0', '3', '1', 'Yes', 'Yes|No'],
Copyright_Info => ['16', 'CHAR', '40', '75', '0', '', ''],
Thumb => ['17', 'CHAR', '40', '150', '0', '', ''],
Twidth => ['18', 'INT', '10', '20', '0', '', '^\d*\.?\d*$'],
Theight => ['19', 'INT', '10', '20', '0', '', '^\d*\.?\d*$'],
Priority => ['20', 'CHAR', '5', '5', '0', '', ''],
SendCGI => ['21', 'CHAR', '25', '25', '0', '', '']
);
Code:
I can't get the Keywords field to import at all.