Page 1 of 1

Manually filled dbase after fresh install, minor problem...

Posted: Thu Dec 22, 2005 9:36 pm
by Olger
Hi there.

I changed to a new hosting provider and had to move my blog to a new server. I decided to make a clean start and do a completely new install (Serendipity 0.9.1). Then i filled the DB tables via sql with the dump from the dbase from the old server.

All works fine, entries are showing, along with the right amount of comments, and the category it was put into. Strange thing however is that the actual comments do not show when the comment link is clicked. Also, the categorie names show up with the entry, but not in the categorie list in the sidebar(plugin). (http://www.leukomteweten.nl/s9y)

Can someone please help me out with where and how the link is made between the comments and the entry tables, and the categorie and entry tables?

I know this is not standard installation proceedure, but it seemed a very good idea when i got started with the whole thing ;)

Thanks everyone, love the project.

Olger.

Re: Manually filled dbase after fresh install, minor problem

Posted: Thu Dec 22, 2005 9:38 pm
by garvinhicking
Which version did you have previously installed? If it was a version lower than 0.9, you did a bad thing by importing the SQL to your new install.

Regards,
Garvin

Posted: Fri Dec 23, 2005 10:42 am
by Olger
Not what i wanted to hear, to be honest ;)

I was runnign Serendipity 0.8.4. Please note I did not import any tables, just the records. And of course not the serendipity_config table.

Any chance I can get this to work? (at least a bit of chalenge, right :oops: )

Posted: Fri Dec 23, 2005 12:00 pm
by garvinhicking
Well, you could have gotten this to work with Serendipity's internal mechanisms. :-)

Do get it right, do this:

1. Kill your current database of the 0.9.1 install

2. Migrate the WHOLE db from your 0.8.4 install. Data AND structure.

3. Edit your 0.9.1 serendipity_config_local.inc.php file [if you can't open the file look at our FAQ and see the fixperm.php script]. Replace the versionInstalled variable from "0.9.1" with "0.8.4".

4. Now go to your s9y admin panel. It will upgrade your install from 0.8.4 to 0.9.1

This will then create the required new tables with propper accounts, and then (I hope) everything should work.

Regards,
Garvin

Posted: Fri Dec 23, 2005 12:53 pm
by Olger
Worth to try, will do this tonight, thanks so far!

* later that night *

Got it!

Had some trouble with old server paths and database user/pw. Also strange enough the serendipity_plugins table was missing.

But it's up and running again now, freshly painted and all. ;)

Thanks very much for the fast support.