Page 1 of 1

Database woes

Posted: Sun Aug 27, 2006 3:55 pm
by scote
Hi all,

I am trying to do my initial setup of Serendipity. After the setup screen, I get this:

Checking to see if the database and tables already exists... they do not
Creating default database setup... Done
Creating primary author 'scote'... Done
Setting default template...

INSERT INTO serendipity_config (name,value,authorid) values ('template', 'carl_contest', '0')

/ Table 'ibdata1.serendipity_config' doesn't exist Done
Installing default plugins... Done
Attempting to write .htaccess file...... Done

INSERT INTO serendipity_config (name,value,authorid) values ('serendipityPath', 'C:/Program Files/Apache Software Foundation/Apache2.2/htdocs/serendipity/', '0')

/ Table 'ibdata1.serendipity_config' doesn't exist

...
...
and it gives like 20 errors like this.

Does anyone know what I'm doing wrong?

Sean

Re: Database woes

Posted: Sun Aug 27, 2006 7:12 pm
by garvinhicking
Hi!

Which database type and version are you using? Are any serendipity_* tables created?

Which version are you trying to install of s9y?

Regards,
Garvin

Posted: Mon Aug 28, 2006 2:45 am
by scote
I am using MySQL 5 and s9y 1.0.1. Honestly, I'm not a database guy, so I don't even know how to check the contents yet, but from the error messages, it doesn't look like any are being created successfully. I'm going to start reading the MySQL doc now. Any thoughts in the mean-time?

Posted: Mon Aug 28, 2006 12:46 pm
by garvinhicking
Hi!

Maybe you could install a tool like phpMyAdmin to browse the database?

An empty database must exist for s9y to successfully install iteself. And the user that you entered in the credentials for mysql must have CREATE privileges to create tables!

HTH,
Garvin