[ZendTo] Re: Drop-Offs not showing and Statistics empty

[Jules]

Check the sqlite db file is intact and there is data in the dropoffs 
table in particular.
Something like
     cd /var/zendto
     sqlite zendto.sqlite
and then poke that CLI to list the tables and do SQL statements to show 
the contents of the tables.

 From the looks of it, it's finding no drop-offs.

Is there anything in the apache2 logs? You often get useful info in the 
error_log in there.

I haven't seen this symptom before either, so unsure as to what has 
happened.

Jules.

On 07/05/2013 17:41, Scott B. Anderson wrote:
> I had a working zendto setup on Ubuntu server 12.10 a month ago, and something in the updates (I initially thought php 4.4) has made drop-offs not show up and the statistics page has no data.  I'm using sqllite3.  The files are there, with the correct user:group for apache to see them and don't see anything in the apache or zendto logs showing errors like failed to read directory or anything like that.  Everything else works, logins, uploads, sending emails etc.  I did a quick google search and didn't come up with anything on this.  Can anyone point me where to troubleshoot this next, or if they've already done this, what the cause and resolution are?  I'm running zendto 4.11.
>
>
> Scott Anderson
> IT Administrator
>
> ...
>
>
> Jules
>
> -- 
> Julian Field MEng MBCS CITP CEng
>
> 'We face neither East nor West: we face forward.' - Kwame Nkrumah
>
> www.Zend.To
> Twitter: @JulesFM
> PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654