Database woes

Having trouble installing serendipity?
Post Reply
scote
Posts: 2
Joined: Sun Aug 27, 2006 3:46 pm

Database woes

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Database woes

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
scote
Posts: 2
Joined: Sun Aug 27, 2006 3:46 pm

Post 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?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply