Author Topic: Backup Function Missing Data Tables Error after upgrade 1.82  (Read 1376 times)

sms

  • Posts: 6
    • View Profile
Backup Function Missing Data Tables Error after upgrade 1.82
« on: August 11, 2005, 02:42:12 am »
Hi,

I have just upgrade to 1.82 and the first and the second fix, and when I try to backup my Database I get the Following error:

Optimizing tables... DONE
Writing backup file... DONE
Verifying backup file... ERROR - MISSING DATA TABLES

 
I must also say that I use a mod to move a subscriber from one list to another list after the first sequence is finished, in the daily-xtra.php :

<?php
/* Start LOOP LIST 3 */

 // set list to move users from
 $looplist = '3';

 // get last followup on the list  list($lastfup)=mysql_fetch_row(mysql_query("select seq from lm_follow where list = '$looplist' order by seq desc limit 1",$link));

 // increment by one to match users who are the end of the sequence  $lastfup = $lastfup + 1;

 // get first followup seq and delay  list($firstfup,$firstdel)=mysql_fetch_row(mysql_query("select seq,del from lm_follow where list = '$looplist' order by seq limit 1",$link));

 // update users
 mysql_query("update lm_users set cseq = '$firstfup', cdel = '$firstdel' where list = '$looplist' and cseq = '$lastfup'",$link);

/* End LOOP LIST 3 */
?>



But I do not think that this causes this error message.


Also I would like to mention that the last time I got your help to install the Listmail pro in the new server that I moved to, Dreamhost, but the cron doesn't work. (I do not get a report at each day at the admin's email). When you setup my server you told me that I have setup successfully the cron to the Dreamhost server. Can you please help me, to see what's the problem?
 
Regards
James

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Backup Function Missing Data Tables Error after upgrade 1.82
« Reply #1 on: August 11, 2005, 03:07:09 am »
The backup issue is quite common and should not have anything to do with daily-xtra.php

The backup routine is problematic because I use a "shell" call to a MySQL command-line utility and shell access and limits can vary across hosts.  I will be rewriting the backup routine to be 100% PHP in the near future to eliminate the problem.

I recommend that you do manual backups with PhpMyAdmin, as outlined in this post, until I update the backup process.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting