Re: habari 2

0 views
Skip to first unread message

Scott Merrill

unread,
Aug 4, 2007, 8:39:43 AM8/4/07
to "интернет-журнал \"Вне Времени\"", habar...@googlegroups.com
интернет-журнал Вне Времени wrote:
> I downloaded new Habari version but cannot fine upgrade.sql file. What
> should I do to run my blog dmitrykachalov.com/blog again?, please help

Good question.

The manual says this in the "upgrade" section:
Next, you will need to copy the contents of the
upgrade.sql file and run the sql commands.

It seems we forgot to include the upgrade.sql with the zip file you
downloaded.

Attached is an upgrade.sql for MySQL users. In order to use this, you
will need to edit the file, and perform a "find and replace" operation
to replace all instances of "{prefix}" with the table prefix you are
using for your installation of Habari.

--
GPG 9CFA4B35 | ski...@skippy.net | http://skippy.net/

upgrade.sql

Chris J. Davis

unread,
Aug 4, 2007, 6:31:31 PM8/4/07
to habar...@googlegroups.com, "интернет-журнал \"Вне Времени\""
I also have it hosted on my site as a .zip:


INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_posts_by_date', '%^(?P<year>[1,2]{1}[\\d]{3})(?:/(?P<month>[\\d]{2}))?(?:/(?P<day>[\\d]{2}))?(?:/page/(?P<page>\\d+))?/?$%i', '{$year}/({$month}/)({$day}/)(page/{$page}/)', 'UserThemeHandler', 'display_date', '2', '1', '1', 'Displays posts for a specific date.');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_feed_by_type', '/^feed\\/(?P<feed_type>atom|rs[sd])[\\/]?$/i', 'feed/{$feed_type}', 'FeedHandler', 'display_feed', '5', '1', '0', 'Return feed per specified feed type');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('admin', '/^admin[\\/]*(?P<page>[^\\/]*)[\\/]?$/i', 'admin/({$page})', 'AdminHandler', 'admin', '6', '1', '0', 'An admin action');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('userprofile', '/^admin\\/(?P<page>user)\\/(?P<user>[^\\/]+)\\/?$/', 'admin/{$page}/{$user}', 'AdminHandler', 'admin', '4', '1', '1', 'The profile page for a specific user');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('user', '/^user\\/(?P<page>[^\\/]*)[\\/]?$/i', 'user/{$page}', 'UserHandler', '{$page}', '7', '1', '0', 'A user action or display, for instance the login screen');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_posts_by_slug', '%^(?P<slug>[^/]+)(?:/page/(?P<page>\\d+))?/?$%i', '{$slug}(/page/{$page}/)', 'UserThemeHandler', 'display_post', '99', '1', '1', 'Return post matching specified slug');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_entry_by_slug', '%^(?P<slug>[^/]+)(?:/page/(?P<page>\\d+))?/?$%i', '{$slug}(/page/{$page}/)', 'UserThemeHandler', 'display_post', '100', '1', '1', 'Return entry matching specified slug');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_page_by_slug', '%^(?P<slug>[^/]+)(?:/page/(?P<page>\\d+))?/?$%i', '{$slug}(/page/{$page}/)', 'UserThemeHandler', 'display_post', '100', '1', '1', 'Return page matching specified slug');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('index_page', '/^(?:|page\\/(?P<page>\\d+)[\\/]?)$/', '(page/{$page})', 'UserThemeHandler', 'display_home', '1000', '1', '1', 'Homepage (index) display');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('rsd', '/^rsd$/i', 'rsd', 'AtomHandler', 'rsd', '1', '1', '0', 'RSD output');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('introspection', '/^atom$/i', 'atom', 'AtomHandler', 'introspection', '1', '1', '0', 'Atom introspection');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('collection', '/^atom\\/(?P<index>.+)[\\/]?$/i', 'atom/{$index}', 'AtomHandler', 'collection', '1', '1', '0', 'Atom collection');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('search', '/^search(?:\\/(?P<criteria>[^\\/]+))?(?:\\/page\\/(?P<page>\\d+))?$/i', 'search(/{$criteria})(/page/{$page}/)', 'UserThemeHandler', 'search', '8', '1', '1', 'Searches posts');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('comment', '/^(?P<id>[0-9]+)\\/feedback[\\/]?$/i', '{$id}/feedback', 'FeedbackHandler', 'add_comment', '8', '1', '0', 'Adds a comment to a post');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('ajax', '/^ajax\\/(?P<context>[^\\/]+)[\\/]?$/i', 'ajax/{$context}', 'AjaxHandler', 'ajax', '8', '1', '0', 'Ajax handling');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('auth_ajax', '/^auth_ajax\\/(?P<context>[^\\/]+)[\\/]?$/i', 'auth_ajax/{$context}', 'AjaxHandler', 'auth_ajax', '8', '1', '0', 'Authenticated ajax handling');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('entry', '/(?P<slug>[^\\/]+)\\/atom$/i', '{$slug}/atom', 'AtomHandler', 'entry', '8', '1', '0', 'Atom Publishing Protocol');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('entry_comments', '/^(?P<slug>[^\\/]+)\\/atom\\/comments$/i', '{$slug}/atom/comments', 'AtomHandler', 'entry_comments', '8', '1', '0', 'Entry comments');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('comments', '/^atom\\/comments$/i', 'atom/comments', 'AtomHandler', 'comments', '7', '1', '0', 'Entries comments');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('tag_collection', '/^tag\\/(?P<tag>[^\\/]+)\\/atom$/i', 'tag/{$tag}/atom', 'AtomHandler', 'tag_collection', '8', '1', '0', 'Atom Tag Collection');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('display_posts_by_tag', '%^tag/(?P<tag>[^/]*)(?:/page/(?P<page>\\d+))?[/]?$%i', 'tag/{$tag}(/page/{$page}/)', 'UserThemeHandler', 'display_tag', '5', '1', '1', 'Return posts matching specified tag');
INSERT INTO {$prefix}rewrite_rules (name, parse_regex, build_str, handler, action, priority, is_active, rule_class, description) VALUES ('xmlrpc', '%^xmlrpc/?%i', 'xmlrpc', 'XMLRPCServer', 'xmlrpc_call', '8', '1', '0', 'Handle incoming XMLRPC requests.');

sfong15

unread,
Aug 6, 2007, 12:01:28 PM8/6/07
to habari-dev
The sql queries didn't quite work at site5 my hosting. It appears
to work on MAMP.

I overwritten all DR0.1 files with that from DR0.2 keeping just
config.php then ran the sql queries. What I got was a blank site.
Tried reverting back to the old index.php didn't work.

Plan B:
Created a subdomain named h741.sfong.net
uploaded all files
ran installation which was successful, got first post and everything
else included plugins and themes all working
replace config.php with that from DR0.1 site
site works but can't login, got below errors
also 'more' and comment links are working but pagination isn't.
the sql commands didn't quite flush out the DR0.1 rewrite_rules?

Notice: Undefined index: page
#0 in system/classes/url.php:86: RewriteRule->match('user/login')
#1 in system/classes/controller.php:105: URL::parse('user/login')
#2 in index.php:125: Controller::parse_request()

Help?

Reply all
Reply to author
Forward
0 new messages