Help with Subscribe2 Problem

[Scouter Dave]

I've been using Subscribe2 for about a year and I have been quite pleased with the program thus far. Now I having a problem when I try to pack the database. I've tried deleting the user to no avail.

I get the following msg when I try to pack the database:

System Administration: Pack Data Files and Cleanup
- Tidying Lists Table
- Tidying Messages
- Removing old Admin Session records...
- Zapping deleted Templates...
- Zapping deleted Subscribers..
Runtime error in db.mvc @ [00000019:00000010]: Line 700: MvPACK: Index 'list-1e.mvx0000000E' was created with the UNIQUE flag and the key 'swdeXXXX@sbcglobal.net' already exists in the index file

-----------------

Other than the error message, the program seems to be working ok, but I haven't checked all functions as of yet.

Any ideas how I can fix this?

[dotCOM_host]

You'll have to edit the user database with a proper DBF editor, remove the duplicate entry, and then pack database files again. Repeat if it complains about more duplicates. This should work in most cases, but if you start getting some other errors while packing - you may need a bit more advanced database cleanup service. There are a few developers and hosts that offer this service - check if yours does...

Remember to make a backup of any files you are changing, BEFORE you change them, in case you mess something up even worse than it already is.

[Scouter Dave]

I thought about trying to edit a database, but could not find any files with a "dbf" extension. I suspect it's compiled in the db.mvc or index.mvc files. I do not know how to edit these.

[dotCOM_host]

Look in your mivadata/subscribe2/ directory - that's where the dbf and mvx files for Subscribe2 are located (ie: not in your public html folder).