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 On Jan 28, 8:49 am, David <[email protected]> wrote: > 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 <[email protected]> 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. > > > 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 -- To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/habari-users
