it doesnt matter that you reinstalled the database.
what i am saying is that you reinstalled the files.
by default the query in the admin_pm/common/mailing_functions.php file does not include the ORDER BY CLAUSE
the code for the query is:
$query_AudienceMembers = sprintf('SELECT pm1_users.UserID AS UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserEmailVerified, UserRegistrationDate, UserIP, UserPhone, UserFax, UserCountry, UserAddress, UserAddress2, UserGroupID, UserSubscribed, AudienceID, MailingSent FROM pm1_users INNER JOIN pm1_mailing_audience_members ON pm1_users.UserID = pm1_mailing_audience_members.UserID INNER JOIN pm1_mailings ON pm1_mailings.MailingID = pm1_mailing_audience_members.MailingID WHERE pm1_mailings.MailingID = %s'.( ($unsentOnly)? ' AND pm1_mailing_audience_members.MailingSent = 0' : ''), GetSQLValueString($mailingID, 'int'));
so by executing your SQL:
SELECT pm1_users.UserID AS UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserEmailVerified, UserRegistrationDate, UserIP, UserPhone, UserFax, UserCountry, UserAddress, UserAddress2, UserGroupID, UserSubscribed, AudienceID, MailingSent FROM pm1_users INNER JOIN pm1_mailing_audience_members ON pm1_users.UserID = pm1_mailing_audience_members.UserID INNER JOIN pm1_mailings ON pm1_mailings.MailingID = pm1_mailing_audience_members.MailingID WHERE pm1_mailings.MailingID = 41 AND pm1_mailing_audience_members.MailingSent = 0 ORDER BY UserID DESC
using the ORDER BY Clause, you are not using the same order as is used in the admin_pm/common/mailing_functions.php
you have 2 options:
1) Edit the recordset in the admin_pm/common/mailing_functions.php file to add the order by clause
$query_AudienceMembers = sprintf('SELECT pm1_users.UserID AS UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserEmailVerified, UserRegistrationDate, UserIP, UserPhone, UserFax, UserCountry, UserAddress, UserAddress2, UserGroupID, UserSubscribed, AudienceID, MailingSent FROM pm1_users INNER JOIN pm1_mailing_audience_members ON pm1_users.UserID = pm1_mailing_audience_members.UserID INNER JOIN pm1_mailings ON pm1_mailings.MailingID = pm1_mailing_audience_members.MailingID WHERE pm1_mailings.MailingID = %s'.( ($unsentOnly)? ' AND pm1_mailing_audience_members.MailingSent = 0 ORDER BY UserID DESC' : ''), GetSQLValueString($mailingID, 'int'));
or 2) Dont use the order by clause in your query:
SELECT pm1_users.UserID AS UserID, UserEmail, UserFirstName, UserLastName, UserCity, UserState, UserZip, UserEmailVerified, UserRegistrationDate, UserIP, UserPhone, UserFax, UserCountry, UserAddress, UserAddress2, UserGroupID, UserSubscribed, AudienceID, MailingSent FROM pm1_users INNER JOIN pm1_mailing_audience_members ON pm1_users.UserID = pm1_mailing_audience_members.UserID INNER JOIN pm1_mailings ON pm1_mailings.MailingID = pm1_mailing_audience_members.MailingID WHERE pm1_mailings.MailingID = 41 AND pm1_mailing_audience_members.MailingSent = 0
