Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

V1.11-> Bad name Error

Oct 28, 2000, 11:23 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Oct 28, 2000, 11:23 AM
Views: 3740
Shortcut
Quote Reply
V1.11-> Bad name Error
I have searched the forum archives (only found two threads where the Bad name error was discussed, but in different contexts than what I am dealing with) and I also searched MySQL web site for info on Bad name errors to no avail.

I am attempting to add records into a table called Jobs_Validate in another database than the main Links database.

Here is the error I receive:

In Reply To:

DBSQL (2065): Fatal Error: Error loading Config file '/absolute/path/to/defs/career/Jobs_Validate.def'. Reason: Parse Error: Bad name after LONGTEXT' at /absolute/path/to/defs/career/Jobs_Validate.def line 39, <INC> chunk 154. at /bin/addjobs.cgi line 255


Here is line 38 - 54 in the Jobs_Validate.def file:

In Reply To:

CurrencyID => ['20','SMALLINT', '10, '20', '1', '', ''],
Benefits => ['21','LONGTEXT','40x3','500','0','', ''],
RemoveDate => ['22','SMALLINT', '3', '3', '1', '', ''],
Add_Date => ['23','DATE', '20', '20', '1', 'NOW', '^\d{4}\-\d{2}\-\d{2}$'],
Mod_Date => ['24','DATE', '20', '20', '1', 'NOW', '^\d{4}\-\d{2}\-\d{2}$'],
Hits => ['25','SMALLINT','10', '20','0','', ''],
ReceiveRes => ['26','ENUM', '1','1','1','Y','Y|N'],
Active => ['27','ENUM', '1','1','1','Y','Y|N'],
Mode => ['28','ENUM', '0','8', '1', 'Validate', 'Validate|Modify']
);

%db_select_fields = ( Mode => 'Validate,Modify');
%db_checkbox_fields = ();
%db_radio_fields = ( ReceiveRes => 'Y,N',
Active => 'Y,N');

1;


Here is line 255 in the addjobs.cgi script:

In Reply To:

$val = new Links::DBSQL $LINKS{admin_root_path} . "/defs/career/Jobs_Validate.def";


I have browsed the Jobs_Validate.def file over and over again and I cannot see what could be causing the error.

Any thoughts or suggestions for fixing the error are greatly appreciated.

Thanks in advance.

Regards,

Eliot Lee
Subject Author Views Date
Thread V1.11-> Bad name Error Stealth 3740 Oct 28, 2000, 11:23 AM
Thread Re: V1.11-> Bad name Error 		Robert 3691 Oct 28, 2000, 3:34 PM
Thread Re: V1.11-> Bad name Error 		Stealth 3659 Oct 28, 2000, 4:45 PM
Thread Re: V1.11-> Bad name Error 		pugdog 3654 Oct 28, 2000, 6:58 PM
Thread Re: V1.11-> Bad name Error 		Stealth 3634 Oct 28, 2000, 10:45 PM
Post Re: V1.11-> Bad name Error 		pugdog 3634 Oct 28, 2000, 11:00 PM