Error trying to go through the setup (From CVS)

Having trouble installing serendipity?
Post Reply
universe
Posts: 3
Joined: Tue Jun 24, 2003 3:07 pm

Error trying to go through the setup (From CVS)

Post by universe »

This is after going to the admin page and trying to fill everything out. I do have a serendipity database created and the username/password is setup to access it and using mysql commands, I am able to login to the database. (IE mysql -u serendipity -p -D serendipity)

Code: Select all

You have an error in your SQL syntax near '1'',mail_trackbacks int(1) default ''1'',email varchar(128) not null default '''' at line 1You have an error in your SQL syntax near '0'',timestamp int(10) unsigned default null,title varchar(150) default null,auth' at line 1Table 'serendipity.serendipity_comments' doesn't existYou have an error in your SQL syntax near '0'',extended text,exflag int(1) default null,author varchar(20) default null,aut' at line 1Table 'serendipity.serendipity_entries' doesn't existYou have an error in your SQL syntax near '0'',link text,name text)' at line 1You have an error in your SQL syntax near '0'',scheme varchar(5),host varchar(128) NOT NULL,port varchar(5),path varchar(25' at line 1You have an error in your SQL syntax near '0'',scheme varchar(5),host varchar(128) NOT NULL,port varchar(5),path varchar(25' at line 1Duplicate key name 'url'You have an error in your SQL syntax near 'right'',sort_order int(4) not null default ''0'',PRIMARY KEY(name))' at line 1Table 'serendipity.serendipity_authors' doesn't exist Done
Table 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't existTable 'serendipity.serendipity_plugins' doesn't exist
Gentoo Linux
Apache 1.3.27-r3
PHP 4.3.1
MySQL 3.23.56
chmod g+wrx serendipity
chown :apache serendipity

Any Ideas?
universe
Posts: 3
Joined: Tue Jun 24, 2003 3:07 pm

Well... ok.....

Post by universe »

Checking the /var/lib/mysql/serendipity/ to see what tables are getting created by the installation.

It appears that only category, config, css, and suppress tables are getting created.

Am I doing something wrong or missing something? Should I just wait for the "official" release?
universe
Posts: 3
Joined: Tue Jun 24, 2003 3:07 pm

Post by universe »

NO SUPPORT FOR ME!...

oh well... I really like the interface you have for serendipity so far.. I guess I will just come back later when you actually release something.

Keep up the good work.
jhermanns
Site Admin
Posts: 378
Joined: Tue Apr 01, 2003 11:28 pm
Location: Berlin, Germany
Contact:

Post by jhermanns »

Hehe, easy easy, you get your support :)

Perhaps the cvs co didn'w work out well, sf has problems withthe anon cvs server at the moment, sometimes things are missing, sometimes the files are way too old...

You'll have to wait another few days, if you want a release. If you feel adventurous, drop me an email and I'll send you the current CVS snapshot...
Chad
Regular
Posts: 6
Joined: Tue Nov 18, 2003 12:03 pm
Location: Bellevue, Nebraska USA
Contact:

Post by Chad »

I am having the exact same problem. Serendepity creates 'serendipity_category', 'serendipity_config','serendipity_css','serendipity_suppress' and that's it. The install page doesn't report any errors and when I click the link to view my newly created blog I get: "Query failed: Table 'chadke.serendipity_entries' doesn't exist"

I've tried both 0.3 and the 200311171337 CVS.

The script that sets up the database appears to not be working in some cases. Unfortunately, in my case, it's not reporting back any errors. Is there a detailed blueprint of how the tables should be set up so I could perhaps do it manually until the issue is resolved?

FreeBSD
Zeus 3.4 (Apache-based)
PHP 4.2.3
MySQL 4.0.12
jhermanns
Site Admin
Posts: 378
Joined: Tue Apr 01, 2003 11:28 pm
Location: Berlin, Germany
Contact:

Post by jhermanns »

weird - I will try to look into this today or tommorrow.
Chad
Regular
Posts: 6
Joined: Tue Nov 18, 2003 12:03 pm
Location: Bellevue, Nebraska USA
Contact:

Post by Chad »

Cool. Let me know if you find and correct the bug so I can give Serendipity another try.
Chad
Regular
Posts: 6
Joined: Tue Nov 18, 2003 12:03 pm
Location: Bellevue, Nebraska USA
Contact:

Post by Chad »

This appears to be a SQL syntax problem (perhaps with the Primay Key syntax). I copied the db.sql file and tried to execute it myself (after replacing {PREFIX} and whatnot). I got all sorts of errors. So, I went to MySQL.com and rewrote the SQL syntax as best I could based upon their online documentation. I'm no SQL expert, but here's the db.sql that worked for me. You may want to compare it with the one in CVS and see if you can find where the bug was/is:

Code: Select all

#
# Table structure for table 'serendipity_authors'
#

CREATE TABLE `serendipity_authors` (
  `authorid` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(20) NULL,
  `password` varchar(32) NULL,
  `mail_comments` int(1) DEFAULT 1 NULL,
  `mail_trackbacks` int(1) DEFAULT 1 NULL,
  `email` varchar(128) NOT NULL,
  PRIMARY KEY (`authorid`)
);

#
# table structure for table 'serendipity_comments'
#

CREATE TABLE serendipity_comments (
  `id` int(10) unsigned 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` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
);

CREATE FULLTEXT INDEX body on serendipity_comments (`body`);

#
# table structure for table 'serendipity_entries'
#

CREATE TABLE serendipity_entries (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(200) DEFAULT NULL,
  `timestamp` int(10) unsigned DEFAULT NULL,
  `body` text,
  `comments` int(4) unsigned DEFAULT 0,
  `trackbacks` int(4) unsigned DEFAULT 0,
  `extended` text,
  `exflag` int(1) DEFAULT NULL,
  `author` varchar(20) DEFAULT NULL,
  `authorid` int(11) DEFAULT NULL,
  `categoryid` int(11) DEFAULT NULL,
  `isdraft` tinyint(1) DEFAULT 0,
  `allow_comments` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
);

CREATE FULLTEXT INDEX entry on serendipity_entries (`title`,`body`,`extended`);

#
# table structure for table 'serendipity_references'
#

CREATE TABLE serendipity_references (
  `id` int(10) unsigned NOT NULL auto_increment,
  `entry_id` int(10) unsigned NOT NULL DEFAULT 0,
  `link` text,
  `name` text,
  PRIMARY KEY (`id`)
);

#
# Table structure for table 'serendipity_exits'
#

CREATE TABLE serendipity_exits (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `day` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `scheme` varchar(5),
  `host` varchar(128) NOT NULL,
  `port` varchar(5),
  `path` varchar(255),
  `query` varchar(255),
  PRIMARY KEY  (`host`,`day`,`entry_id`)
);

#
# Table structure for table 'serendipity_referrers'
#

CREATE TABLE serendipity_referrers (
  `entry_id` int(10) unsigned NOT NULL auto_increment,
  `day` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `scheme` varchar(5),
  `host` varchar(128) NOT NULL,
  `port` varchar(5),
  `path` varchar(255),
  `query` varchar(255),
  PRIMARY KEY  (`host`,`day`,`entry_id`)
);

#
# Table structure for table 'serendipity_css'
#

CREATE TABLE serendipity_css (
  `cssid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(40) DEFAULT NULL,
  `data` text,
  PRIMARY KEY (`cssid`)
);

#
# Table structure for table 'serendipity_config'
#

CREATE TABLE serendipity_config (
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`name`)
);

CREATE TABLE serendipity_suppress (
  `ip` varchar(15) DEFAULT NULL,
  `scheme` varchar(5),
  `host` varchar(128),
  `port` varchar(5),
  `path` varchar(255),
  `query` varchar(255),
  `last` timestamp NOT NULL
);

CREATE UNIQUE INDEX url ON serendipity_suppress (`host`,`ip`);

CREATE TABLE serendipity_plugins (
  `name` varchar(128) NOT NULL,
  `placement` varchar(6) NOT NULL DEFAULT 'right',
  `sort_order` int(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`name`)
);

CREATE TABLE serendipity_category (
  `categoryid` int(10) unsigned NOT NULL auto_increment,
  `category_name` varchar(255) DEFAULT NULL,
  `category_description` text,
  `authorid` int(11) DEFAULT NULL,
  PRIMARY KEY (`categoryid`)
);
Post Reply