stupid telnet program...found the program, so I've now run newnews.pl via telnet. Connects to the server and the right newsgroup, grabs the first 100 messages, when it does to dump them to the database, I'm getting the following error:

Requested 100 messages... 0 not available or rejected.
DBD::mysql::db do failed: You have an error in your SQL syntax near ''No User',9
79507486,'ALISHA has done the following\n____________________________' at line 1
at ./newnews.pl line 419.
Query failed (INSERT IGNORE INTO post (allowsmilie,threadid,username,dateline,pa
getext,visible,msgid,ord) VALUES ('1',,'No User',979507486,'ALISHA has done the
following\n_______________________________________ _\nSlept: 7 Touched: 31750 Dro
pped: 37\n________________________________________\nNetb ios Rulez \\GUYC \\C \\E
SC400 \\C \\ACI \\BOB PUBLIC \\C GATEWAY \\CUSTOMERS \\DOWNLOADS \\MY DOCUMENTS\
n\\MYLABEL \\PROGRAM FILE \\COMPAQ5695 \\MY MUSIC \\MYDOCS \\C \\PAVILLION A \\P
AVILLION C \\backup \\D \\C \\D\n\\E \\C_PAZR1 \\HOME C DRIVE \\TEMP \\C \\C \\C
\\C \\C \\D \\Downloads \\SHARED \\HHC \\HHPROGRAMS \\HHSHARED\n\n..and the wor
ms ate into his brain\n','1','<0e8cc39d915d766e63245db40b0119cb@an on.xg.nu>','0'
)) at ./newnews.pl line 419.

Any ideas here? I'm at a total loss here. It looks like it's having a problem dumping the messages into the post table, but I'm not an SQL expert).

On another note, a couple of things you might want to consider when you do your next documentation update:

1.) The SQL changes (textfile) - There are two usenet_outgoin_log table create commands

2.) You are using the table POST and post interchangably, which is causing errors in the alter table section toward the bottom of the query. Took me awhile to figure that mysql is case sensitive.

3.) You might want to make some recommendations about a mysql client. I'm using phpMyAdmin, and it's great. I couldn't imagine trying to do this stuff manually.

That's it for now! Any suggestions on the above?