Setting up an old wbesite project

[iori]

Hello folks.

I was making an website a little while ago using Mamp, with serendipity controlling the layout of one of the pages (embedded blog). Since I started this I have formatted and fresh installed my system. Now that I am coming back to the project I gotta figure out how to get it going again.

The Mamp side is fine, I get the site to work, but unfortunately I didn't back up the whole Mamp directory, just the website itself. So I am missing the original database. When I trying using the site with my original serendipity folder I get a Query Fail error followed by some script. As follows:

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.username AS loginname,
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
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1231969800 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15

/ No database selected


I guess the big question is... Can I recover this with minimal work, or will I have to rebuild everything? The data itself wasn't important, more so the embedded layout and such, the design is all I cared about. Any help would be greatly appreciated.

Cheers
Scott

[garvinhicking]

Hi!

Check your serendpity_config_local.inc.php file. It seems the mentioned database there is no longer existing.

Regards,
Garvin

[iori]

Fantastic!

Thanks a lot Garvin that did the trick. It brought back the page and the embedded blog. Now I just gotta redo the design of it.

Cheers
Scott