Fresh install of 8 with 7 database

[markheath]

My ISP managed to delete all the files off my web space two days ago, but apparently the MySQL data is still intact.

Should I restore 0.7.1 first and then upgrade to 0.8 when it arrives, or would it be easier to just install 0.8 and connect it to my database? Does the upgrade mechanism expect any 0.7.1 PHP files to be available?

thanks
Mark

[garvinhicking]

It would make no difference whether to install 0.7.1 or 0.8.

In any case, you need to create the file serendipity_config_local.inc.php MANUALLY before launching the SErendipity upgradet. Use those contents for the file:

Code: Select all

<?php
	/*
	  Serendipity configuration file
	  Written on Thu, 07 Apr 2005 16:03:58 +0200
	*/

	$serendipity['versionInstalled']  = '0.8-beta6';
	$serendipity['dbName']            = 'serendipity';
	$serendipity['dbPrefix']          = 'serendipity_MERGE_';
	$serendipity['dbHost']            = 'localhost';
	$serendipity['dbUser']            = 'root';
	$serendipity['dbPass']            = 'password';
	$serendipity['dbType']            = 'mysql';
	$serendipity['dbPersistent']      = false;

	// End of Serendipity configuration file
	// You can place your own special variables after here:
?>

There of course you need to insert your valid SQL account data. Backup your SQL DB before upgrading!

Regards,
Garvin

[Guest]

thanks Gavin

the serendipity_config_local file was the one and only file I had not been able to backup from the server before the data was lost (for some reason my ftp client wouldn't let me download it), so its nice to know what its contents are supposed to be.

I'll give this a try tonight (hopefully v0.8 will be ready for me to download)

By the way, it would be nice if the installation instructions included a few Linux commands for dummies (tar -zxvf, chmod 777 etc). Every time I reinstall serendipity I end up searching forums for the right syntax.

[ChadGeidel]

I b0rked my install (7.1) (please don't ask - suffice it to say that all files were deleted), but maintained the sql database, so I decided to just install 8 release and see if it would upgrade everything. Unfortunately I didn't read this post. 8*(

Anyway - everything seemed to go well with the install (it found that I had an existing database and didn't create a new one) and the installer said it was successful. However when I go to my home page, I get this error:

Code: Select all

Query failed:

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.email

                    , e.body, e.extended
                    
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                    
                    WHERE isdraft = 'false' AND e.timestamp <= '1115350525'
                    GROUP BY e.id
                    ORDER BY timestamp DESC
                     LIMIT 10

/ Unknown column 'a.realname' in 'field list'

Any ideas?

My email is chad_geidel (at hotmail)

[garvinhicking]

It seems that Serendipity did not run its database updates. This happens if you install serendipity into an existing database. You need to edit your serendipity_config_local.inc.php as shown above - insert a $serendipity['versionInstalled'] = '0.7.1'; into the file and then go to your blog; the upgrader will be called and perform the upgrades frmo 0.7.1 Database to 0.8

Best regards,Garvin