Regenerate archive pages?

I've imported my blog from serpintity (sql hack)
Now everything works! but archive:

All the entires have correct links to pages like:
http://localhos
t:5555/archives/2006/9 with correct content, but when i
click on a
page:
http://localhost:5555
/2006/9/24 it says error, when i manualy create a
entry i get a file in
the archive directory, but obvisly this isnt the case for
the sql
scripted entires, any way to "regenerate" em from
db?

/K


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

On 10/30/06, Kvark <piotr.fernandezgmail.com> wrote:
>
> I've imported my blog from serpintity (sql hack)
> Now everything works! but archive:
>
> All the entires have correct links to pages like:
> http://localhos
t:5555/archives/2006/9 with correct content, but when i
> click on a
> page:
> http://localhost:5555
/2006/9/24 it says error, when i manualy create a
> entry i get a file in
> the archive directory, but obvisly this isnt the case
for the sql
> scripted entires, any way to "regenerate" em
from db?
>

What's the error?  Can you pastie a stack trace please? 
(check your
log/production.log or log/development.log file).

One thing to keep in mind is the archive url goes by the
published
date.So /archives/2006/9 will look for all articles in the
home
section published in sept of 2006.

-- 
Rick Olson
http://weblog.techno-
weenie.net
http://mephistoblog.com

--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

When i say error i mean the error page, from template, lemme
quick look
in the log.

log says:

Processing MephistoController#dispatch (for 127.0.0.1 at
2006-10-30
20:57:28) [GET]
  Parameters: {"action"=>"dispatch",
"controller"=>"mephisto",
"path"=>["2006", "9",
"21"]}
Completed in 0.07800 (12 reqs/sec) | Rendering: 0.00000 (0%)
| DB:
0.00000 (0%) | 404 NotFound [http://localhost/2006/9/21
]

Please not that this is sql scripted entires, since i want
to bring the
archives with me from my old blog. If i manually create a
entry using
admin a page is generated in:
public2005130 with the title .html

So the mechanism to generate this page is what im looking
for. The
entires works just fine as well ass the list of all archive
/ month,
but when i click on the archive is when the problem starts.


Thanks
K


/K


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

When i say error i mean the error page, from template, lemme
quick look
in the log.

log says:

Processing MephistoController#dispatch (for 127.0.0.1 at
2006-10-30
20:57:28) [GET]
  Parameters: {"action"=>"dispatch",
"controller"=>"mephisto",
"path"=>["2006", "9",
"21"]}
Completed in 0.07800 (12 reqs/sec) | Rendering: 0.00000 (0%)
| DB:
0.00000 (0%) | 404 NotFound [http://localhost/2006/9/21
]

Please not that this is sql scripted entires, since i want
to bring the
archives with me from my old blog. If i manually create a
entry using
admin a page is generated in:
public2005130 with the title .html

So the mechanism to generate this page is what im looking
for. The
entires works just fine as well ass the list of all archive
/ month,
but when i click on the archive is when the problem starts.


Thanks
K


/K


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

My sql hack, maybe it will give additional information,
since i had to
"reverse engineer" the db

           dbMephi.execute("INSERT INTO
`assigned_sections`
(`id`,`article_id`,`section_id`,`position`) VALUES  ("+
id+ ","+ id+
",1,"+ id+ ") ");
                dbMephi.execute("INSERT INTO
`content_versions`
(`id`,`content_id`,`version`,`article_id`,`user_id`,`title`,
`permalink`,`excerpt`,`body`,`excerpt_html`,`body_html`,`cre
ated_at`,`updated_at`,`published_at`,`author`,`author_url`,`
author_email`,`author_ip`,`comments_count`,`updater_id`,`ver
sioned_type`,`site_id`,`approved`,`comment_age`,`filter`,`us
er_agent`,`referrer`)
VALUES  ("+ id+ ",NULL,1,"+ id+
",1,'" + theTitle + "','" + theTitle +
"','','" + theBody + "','','" + theBody
+
"','"+theDateTime+"','"+theDateTime+&quo
t;','"+theDateTime+"',NULL,NULL,NULL,NULL,0,1,'Art
icle',1,0,30,NULL,NULL,NULL)");
                dbMephi.execute("INSERT INTO `contents`
(`id`,`article_id`,`user_id`,`title`,`permalink`,`excerpt`,`
body`,`excerpt_html`,`body_html`,`created_at`,`updated_at`,`
published_at`,`type`,`author`,`author_url`,`author_email`,`a
uthor_ip`,`comments_count`,`updater_id`,`version`,`site_id`,
`approved`,`comment_age`,`filter`,`user_agent`,`referrer`)
VALUES  ("+ id+ ",NULL,1,'" + theTitle +
"','" + theTitle + "','','" +
theBody + "','','" + theBody +
"','"+theDateTime+"','"+theDateTime+&quo
t;','"+theDateTime+"','Article',NULL,NULL,NULL,NUL
L,0,1,1,1,0,30,NULL,NULL,NULL)");
                dbMephi.execute("INSERT INTO `events`
(`id`,`mode`,`user_id`,`article_id`,`title`,`body`,`created_
at`,`author`,`comment_id`,`site_id`)
VALUES  ("+ id+ ",'publish',1,"+ id+
",'" + theTitle + "','" + theBody
+ "','"+theDateTime+"',NULL,NULL,1)");


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

My sql hack, maybe it will give additional information,
since i had to
"reverse engineer" the db

           dbMephi.execute("INSERT INTO
`assigned_sections`
(`id`,`article_id`,`section_id`,`position`) VALUES  ("+
id+ ","+ id+
",1,"+ id+ ") ");
                dbMephi.execute("INSERT INTO
`content_versions`
(`id`,`content_id`,`version`,`article_id`,`user_id`,`title`,
`permalink`,`excerpt`,`body`,`excerpt_html`,`body_html`,`cre
ated_at`,`updated_at`,`published_at`,`author`,`author_url`,`
author_email`,`author_ip`,`comments_count`,`updater_id`,`ver
sioned_type`,`site_id`,`approved`,`comment_age`,`filter`,`us
er_agent`,`referrer`)
VALUES  ("+ id+ ",NULL,1,"+ id+
",1,'" + theTitle + "','" + theTitle +
"','','" + theBody + "','','" + theBody
+
"','"+theDateTime+"','"+theDateTime+&quo
t;','"+theDateTime+"',NULL,NULL,NULL,NULL,0,1,'Art
icle',1,0,30,NULL,NULL,NULL)");
                dbMephi.execute("INSERT INTO `contents`
(`id`,`article_id`,`user_id`,`title`,`permalink`,`excerpt`,`
body`,`excerpt_html`,`body_html`,`created_at`,`updated_at`,`
published_at`,`type`,`author`,`author_url`,`author_email`,`a
uthor_ip`,`comments_count`,`updater_id`,`version`,`site_id`,
`approved`,`comment_age`,`filter`,`user_agent`,`referrer`)
VALUES  ("+ id+ ",NULL,1,'" + theTitle +
"','" + theTitle + "','','" +
theBody + "','','" + theBody +
"','"+theDateTime+"','"+theDateTime+&quo
t;','"+theDateTime+"','Article',NULL,NULL,NULL,NUL
L,0,1,1,1,0,30,NULL,NULL,NULL)");
                dbMephi.execute("INSERT INTO `events`
(`id`,`mode`,`user_id`,`article_id`,`title`,`body`,`created_
at`,`author`,`comment_id`,`site_id`)
VALUES  ("+ id+ ",'publish',1,"+ id+
",'" + theTitle + "','" + theBody
+ "','"+theDateTime+"',NULL,NULL,1)");


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

On 10/30/06, Kvark <piotr.fernandezgmail.com> wrote:
>
> When i say error i mean the error page, from template,
lemme quick look
> in the log.
>
> log says:
>
> Processing MephistoController#dispatch (for 127.0.0.1
at 2006-10-30
> 20:57:28) [GET]
>   Parameters:
{"action"=>"dispatch",
"controller"=>"mephisto",
> "path"=>["2006", "9",
"21"]}
> Completed in 0.07800 (12 reqs/sec) | Rendering: 0.00000
(0%) | DB:
> 0.00000 (0%) | 404 NotFound [http://localhost/2006/9/21
]
>
> Please not that this is sql scripted entires, since i
want to bring the
> archives with me from my old blog. If i manually create
a entry using
> admin a page is generated in:
> public2005130 with the title .html
>
> So the mechanism to generate this page is what im
looking for. The
> entires works just fine as well ass the list of all
archive / month,
> but when i click on the archive is when the problem
starts.

That's not a valid mephisto page.  That's probably why it's
404ing.
You'll either need a full permalink or an archive url like
/archives/YYYY/MM.


-- 
Rick Olson
http://weblog.techno-
weenie.net
http://mephistoblog.com

--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

On 10/30/06, Kvark <piotr.fernandezgmail.com> wrote:
>
> When i say error i mean the error page, from template,
lemme quick look
> in the log.
>
> log says:
>
> Processing MephistoController#dispatch (for 127.0.0.1
at 2006-10-30
> 20:57:28) [GET]
>   Parameters:
{"action"=>"dispatch",
"controller"=>"mephisto",
> "path"=>["2006", "9",
"21"]}
> Completed in 0.07800 (12 reqs/sec) | Rendering: 0.00000
(0%) | DB:
> 0.00000 (0%) | 404 NotFound [http://localhost/2006/9/21
]
>
> Please not that this is sql scripted entires, since i
want to bring the
> archives with me from my old blog. If i manually create
a entry using
> admin a page is generated in:
> public2005130 with the title .html
>
> So the mechanism to generate this page is what im
looking for. The
> entires works just fine as well ass the list of all
archive / month,
> but when i click on the archive is when the problem
starts.

That's not a valid mephisto page.  That's probably why it's
404ing.
You'll either need a full permalink or an archive url like
/archives/YYYY/MM.


-- 
Rick Olson
http://weblog.techno-
weenie.net
http://mephistoblog.com

--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

Figured it out, permalinks cant have spaces, there for my
script now
replaces  " " with "-" and working.
Thanks for help.


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---

Figured it out, permalinks cant have spaces, there for my
script now
replaces  " " with "-" and working.
Thanks for help.


--~--~---------~--~----~------------~-------~--~----~
Mephisto: http://mephistoblog.com |
Mephisto Help: http://mephisto.stikipad
.com

To post to this group, send email to MephistoBloggooglegroups.com
To unsubscribe from this group, send email to
MephistoBlog-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/MephistoBlog
-~----------~----~----~----~------~----~------~--~---