Comments aren't being posted...

[Martin]

Hey.
I have no idea why, but it seems my comments are being saved as trackbacks. I've received two comments to two different entries and when I check my blog there are no comments but (respectively) one trackback.

What is it that is up?

-m

[Thomas]

Hi,

I just tested the function on your website to see what happens. Sorry for the test entry.

I tried to reconstruct the problem on my own site and actually my quest ended unlucky. Usually the comments on my site should be posted embeded. For trying the same as you I enabled the popup support but I get always the same result.

What version of s9y are you using?

Regards, Thomas

[garvinhicking]

What database are you using? Maybe the default column setting for the 'type' of serendipity_comments is wrong?

[Martin]

Um...
I'm using MySql. Is that what you're wondering? The funny thing is I put up the same build of s9y for a friend of mine and it's working nicely at his site.

Anyway; If you tell me what I should look for I'll see what I can find.

-M

[garvinhicking]

Could you please provide a SQL-dump of your serendipity_comments table, with both data and structure? (can be done with phpMyAdmin)

Thanks,
Garvin.

[Martin]

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 07, 2004 at 09:50 PM
-- Server version: 3.23.49
-- PHP Version: 4.3.1
-- 
-- Database: `******`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `blog_comments`
-- 

CREATE TABLE `blog_comments` (
  `id` int(11) NOT NULL auto_increment,
  `auth_name` text NOT NULL,
  `auth_email` text NOT NULL,
  `auth_url` text NOT NULL,
  `date` text NOT NULL,
  `data` text NOT NULL,
  `uid` text NOT NULL,
  `ext1` text NOT NULL,
  `ext2` text NOT NULL,
  `ext3` text NOT NULL,
  `ext4` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `blog_comments`
-- 

Like so?

-m

[garvinhicking]

Basically, like so, yeah. But the 'comments' table you provided is not the one from serendipity! Looks like another application?

Regards,
Garvin.

[Martin]

Are you sure?
I changed the default prefix to blog_ when I installed Serendipity so this should be it. I checked the dump from blog_entries, and it was clearly the entries from serendipity.

-M

[tadpole]

Take a look at path/to/s9y/sql/db.sql. The structure for the comments table is:

Code: Select all

create table {PREFIX}comments (
  id {AUTOINCREMENT} {PRIMARY},
  entry_id int(10) {UNSIGNED} not null default '0',
  parent_id int(10) {UNSIGNED} not null default '0',
  timestamp int(10) {UNSIGNED} default null,
  title varchar(150) default null,
  author varchar(80) default null,
  email varchar(200) default null,
  url varchar(200) default null,
  ip varchar(15) default null,
  body text,
  type varchar(100) default 'regular',
  subscribed {BOOLEAN},
  status varchar(50) not null
);

[Martin]

Umm...
Okay. I can't see what other table it could possibly be.
I did try to install several other blogs before s9y, so I suppose this can somehow have caused the problems.

Is there any way to quickly reinstall the sql without losing all my data? Seems like that may be the best solution as I'm not really getting anywhere now.

[garvinhicking]

Try to import this SQL dump (backup your table first):

Code: Select all

DROP TABLE IF EXISTS `serendipity_comments`;
CREATE TABLE `serendipity_comments` (
  `id` int(11) NOT NULL auto_increment,
  `entry_id` int(10) unsigned NOT NULL default '0',
  `timestamp` int(10) unsigned default NULL,
  `title` varchar(150) default NULL,
  `author` varchar(80) default NULL,
  `email` varchar(200) default NULL,
  `url` varchar(200) default NULL,
  `ip` varchar(15) default NULL,
  `body` text,
  `type` varchar(100) default 'regular',
  `subscribed` enum('true','false') NOT NULL default 'true',
  `status` varchar(50) NOT NULL default '',
  `parent_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `body` (`body`)
) TYPE=MyISAM

(You may need to adjust the name of the table, I think yours was called 'blog_comments' instead of 'serendipity_comments'.

Regards,
Garvin

[Martin]

Problem is now solved.
I changed the dump you provided to read blog_comments instead of serendipity_comments as that is the prefix I have been using but comments are now posted and shown successfully.

Thank you for your help and patience.

-m