Possible comments corruption in Habari 0.6.3 installation

[David Blume]

I have a small Habari 0.6.3 blog at http://david.dlma.com/habari/

It worked really well for a few entries, posts, and comments.  I recently added the Comment Notifier 1.2, (after adding info()) to it. (http://twitter.com/dblume/status/7653697967)

And that worked pretty well, except sometimes when I'd save an update to a page, I'd get a spurious entry in the Comments  Admin panel whose contents seemed to be the page update.  I would usually delete it.

Today, when I go to the admin panel's Dashboard, I now get the welcome message that ends with "This message will disappear next time you visit.", and not the three modules I'd added, "Latest Entries", "Latest Comments", and "Latest Log Activity."  They're gone now.

As a matter of fact, I can only add "Latest Entries" and "Latest Log Activity".  I cannot add "Latest Comments." But the next time I visit the Dashboard, I'll get the welcome message and none of the modules again.

The logs are now filled with the error, "Trying to get property of non-object in system/plugins/coredashmodules/dash_latestcomments.php:6"

I broke up that line, and I think the problem is with $post->pubdate->out( 'M j' ).

I commented that out, then got a problem at the foreach( $latestcomments[$post->id] as $comment) line.

How should I approach this?  I don't know much about PHP or the database I'm using MySQL.

Thanks in advance,

--David

[David]

Update:

I tried adding a comment myself. And that feature does not work
either, although it used to. I used phpmyadmin to look at the
habari__comments table to see if it made it to the table, and it
didn't get added. (There are still only 8 rows, as there were
before. (It's a quiet blog.))

I then selected all tables and had them analyzed, and every Msg_text
is "OK" or "Table is already up to date."

Some tables are empty, like "habari__commentstatus" and
"habari__commenttype". Is that a problem?

I appreciate any clues you may send my way.

--David

On Jan 28, 12:49 am, David Blume <david.bl...@gmail.com> wrote:
> I have a small Habari 0.6.3 blog athttp://david.dlma.com/habari/

[David]

Going back in the logs (oldest at the bottom, so start at Jan 25 and
read up), the first evidence of trouble is here:

(At this point and afterwards, the logs are filled with the
dash_latestcomments.php error.)
Jan 27, 2010 · 23:35 Trying to get property of non-object in system/
plugins/coredashmodules/dash_latestcomments.php:5
Jan 27, 2010 · 23:35 Trying to get property of non-object in system/
plugins/coredashmodules/coredashmodules.plugin.php:144
Jan 27, 2010 · 23:33 Successful login for <me>
Jan 25, 2010 · 10:16 Successful login for <me> (Followed by comment
moderation and deletion. No errors.)
Jan 25, 2010 · 08:39 PDOStatement::execute() [<a
href='pdostatement.execute'>pdostatement.execute</a>]: SQLSTATE
[42000]: Syntax error or access violation: 1064 You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right s
Jan 25, 2010 · 08:33 Successful login for <me>

I'm providing this info because I haven't done anything unusual with
the installation. (I only moderate and delete comments, and compose
pages and entries.) What happened to me could reasonably happen to
other users. I'm just trying to isolate the problem (for everyone)
and fix my installation (for me).

--David

[rick c]

On Jan 28, 3:49 am, David Blume <david.bl...@gmail.com> wrote:
> I have a small Habari 0.6.3 blog athttp://david.dlma.com/habari/

>
> It worked really well for a few entries, posts, and comments.  I recently
> added the Comment Notifier 1.2, (after adding info()) to it. (http://twitter.com/dblume/status/7653697967)
>
> And that worked pretty well, except sometimes when I'd save an update to a
> page, I'd get a spurious entry in the Comments  Admin panel whose contents
> seemed to be the page update.  I would usually delete it.
>
> Today, when I go to the admin panel's Dashboard, I now get the welcome
> message that ends with "This message will disappear next time you visit.",
> and not the three modules I'd added, "Latest Entries", "Latest Comments",
> and "Latest Log Activity."  They're gone now.
>

The welcome message showing up leads me to beiieve that your host just
updated PHP to PHP 5.2.12 or 5.3.1. Those versions of PHP changed the
way database access works. See http://groups.google.com/group/habari-dev/browse_thread/thread/bb64cb7c6fb6aaa3
for more information.

We've been putting together an update to deal with this issue, but it
hasn't been fully tested yet. If you want, you can get the testing
version of the update at http://habariproject.org/dist/habari_makaanga.zip,
and install over your current location. If you do so, make sure you
back up your site first.

Rick

[David]

Thanks, Rick!

Yes, my site is running version 5.2.12 now. Two reactions:

One: Phew, my site's probably not corrupted.

Two: A needless architectural change in the language? That really
bites. Has the PHP dev team responded to the open letter?

Thank you *so much* for following up on this. I really would have
spent the whole night bashing my head against this, with no clue that
the issue was deeper.

--David

On Jan 28, 3:03 pm, rick c <rickcock...@gmail.com> wrote:
> On Jan 28, 3:49 am, David Blume <david.bl...@gmail.com> wrote:
>
> > I have a small Habari 0.6.3 blog athttp://david.dlma.com/habari/
>
> > It worked really well for a few entries, posts, and comments.  I recently
> > added the Comment Notifier 1.2, (after adding info()) to it. (http://twitter.com/dblume/status/7653697967)
>
> > And that worked pretty well, except sometimes when I'd save an update to a
> > page, I'd get a spurious entry in the Comments  Admin panel whose contents
> > seemed to be the page update.  I would usually delete it.
>
> > Today, when I go to the admin panel's Dashboard, I now get the welcome
> > message that ends with "This message will disappear next time you visit.",
> > and not the three modules I'd added, "Latest Entries", "Latest Comments",
> > and "Latest Log Activity."  They're gone now.
>
> The welcome message showing up leads me to beiieve that your host just
> updated PHP to PHP 5.2.12 or 5.3.1. Those versions of PHP changed the

> way database access works. Seehttp://groups.google.com/group/habari-dev/browse_thread/thread/bb64cb...

> for more information.
>
> We've been putting together an update to deal with this issue, but it
> hasn't been fully tested yet. If you want, you can get the testing

> version of the update athttp://habariproject.org/dist/habari_makaanga.zip,

[David]

Post-mortem: To help others who have the same problem, but search for
different terms, I'll add more searchable terms, and what I did to fix
my installation:

Dreamhost did upgrade to to PHP version 5.2.12. The symptom another
Habari user noticed was that tags weren't working correctly.

I only like to update my sandbox on an svn released tag basis. (I'll
stay with 0.6.3 for now.) But this bug was bad enough that I did
manually edit my source files according to the changes here:

https://trac.habariproject.org/habari/ticket/1116

That resolved the issue, and my Habari installation is healthy again.
Thanks!

--David

On Jan 28, 3:03 pm, rick c <rickcock...@gmail.com> wrote:

> On Jan 28, 3:49 am, David Blume <david.bl...@gmail.com> wrote:
>
> > I have a small Habari 0.6.3 blog athttp://david.dlma.com/habari/
> >

> > ... sometimes when I'd save an update to a

> > page, I'd get a spurious entry in the Comments  Admin panel whose contents
> > seemed to be the page update.  I would usually delete it.
> >
> > Today, when I go to the admin panel's Dashboard, I now get the welcome
> > message that ends with "This message will disappear next time you visit.",
> > and not the three modules I'd added, "Latest Entries", "Latest Comments",
> > and "Latest Log Activity."  They're gone now.
>
> The welcome message showing up leads me to beiieve that your host just
> updated PHP to PHP 5.2.12 or 5.3.1. Those versions of PHP changed the

> way database access works. Seehttp://groups.google.com/group/habari-dev/browse_thread/thread/bb64cb...

> for more information.
>
> We've been putting together an update to deal with this issue, but it
> hasn't been fully tested yet. If you want, you can get the testing

> version of the update athttp://habariproject.org/dist/habari_makaanga.zip,

> and install over your current location. If you do so, make sure you
> back up your site first.
>
> Rick
>
>

> > The logs are now filled with the error, "Trying to get property of
> > non-object in system/plugins/coredashmodules/dash_latestcomments.php:6"
>
> > I broke up that line, and I think the problem is with $post->pubdate->out(
> > 'M j' ).
>

> > Thanks in advance,
> > --David

[Chema Molins]

Thanks Rick,

This fixes a problem for me.

Tags were not working anywhere in my site when using $post->tags. Now, with makaanga they do.

Although I have to adapt the theme for 0.6.3 since I had only adapted it to 0.7.

Chemus

--
To post to this group, send email to habari...@googlegroups.com
To unsubscribe from this group, send email to habari-users...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/habari-users