Serendipity Forums

Posted: **Mon Oct 04, 2004 10:08 pm**

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

Posted: **Tue Oct 05, 2004 7:53 pm**

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

Posted: **Wed Oct 06, 2004 11:57 am**

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

Posted: **Thu Oct 07, 2004 9:02 am**

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

Posted: **Thu Oct 07, 2004 11:05 am**

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

Thanks,
Garvin.

Posted: **Thu Oct 07, 2004 9:45 pm**

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

Posted: **Fri Oct 08, 2004 12:21 pm**

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

Regards,
Garvin.

Posted: **Sat Oct 09, 2004 3:14 pm**

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

Posted: **Sat Oct 09, 2004 6:35 pm**

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
);

Posted: **Mon Oct 11, 2004 10:29 am**

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.

Posted: **Mon Oct 11, 2004 11:34 am**

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

Posted: **Mon Oct 11, 2004 2:17 pm**

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

Serendipity Forums

Comments aren't being posted...

Comments aren't being posted...

Re: Comments aren't being posted...