phpwiki-talk

[Phpwiki-talk] creating new pages with mysql

[Geoff D. <geo...@ya...>]

Hi. 

I'm running 1.2 and mysql, and I need to pull page
content from a non-phpwiki database and create new
phpwiki pages containing the same content. 

I've uploaded some test content to the wiki table in
the database, and updated the wikilinks table to
reflect the new content (i.e., INSERT INTO
wikilink(frompage,topage,) VALUES
('RecentChanges,'MyNewContentPage')

I've confirmed that the tables hold the new stories
and links, but they're not showing up in
RecentChanges, or any of the other pages I've tried to
link the content to. 

What else do I need to change to make sure the new
content is displayed? 

Thanks. 



	
		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com

Re: [Phpwiki-talk] creating new pages with mysql

[Joel U. <uck...@no...>]

Thus spake Geoff Dougherty:
> Hi. 
> 
> I'm running 1.2 and mysql, and I need to pull page
> content from a non-phpwiki database and create new
> phpwiki pages containing the same content. 
> 
> I've uploaded some test content to the wiki table in
> the database, and updated the wikilinks table to
> reflect the new content (i.e., INSERT INTO
> wikilink(frompage,topage,) VALUES
> ('RecentChanges,'MyNewContentPage')
> 
> I've confirmed that the tables hold the new stories
> and links, but they're not showing up in
> RecentChanges, or any of the other pages I've tried to
> link the content to. 
> 
> What else do I need to change to make sure the new
> content is displayed? 
> 
> Thanks. 

I'm looking back at the table structure for 1.2, and I'm not seeing
any obvious thing to do. Are the new pages accessible directly? 

-- 
J.

Re: [Phpwiki-talk] creating new pages with mysql

[Reini U. <rei...@gm...>]

I cannot really help right now, because I'm away
and can only help with tips out of my head.

On 10/16/05, Joel Uckelman <uck...@no...> wrote:
> Thus spake Geoff Dougherty:
> > I'm running 1.2 and mysql, and I need to pull page
> > content from a non-phpwiki database and create new
> > phpwiki pages containing the same content.
> >
> > I've uploaded some test content to the wiki table in
> > the database, and updated the wikilinks table to
> > reflect the new content (i.e., INSERT INTO
> > wikilink(frompage,topage,) VALUES
> > ('RecentChanges,'MyNewContentPage')
> >
> > I've confirmed that the tables hold the new stories
> > and links, but they're not showing up in
> > RecentChanges, or any of the other pages I've tried to
> > link the content to.
> >
> > What else do I need to change to make sure the new
> > content is displayed?

Look at the admin/*.php pages for actions to import content.
And if this fails put your non-sql pages into pgsrc like files
(header can be omitted, just plain-text() and fire up a new wiki
(DELETE FROM wikipages ?) with this pgsrc. This would  be the easiest.

> I'm looking back at the table structure for 1.2, and I'm not seeing
> any obvious thing to do. Are the new pages accessible directly?
--
Reini Urban

Re: [Phpwiki-talk] creating new pages with mysql

[Geoff D. <geo...@ya...>]

The new pages are accessible directly. 

I've tried creating new files in /pgsrc, and that
doesn't seem to fix the problem. 

From what I can tell, the zip import does basically
the same thing that I've done -- add pages to the db.
So I'm not sure that'll have much impact. 

Thanks for the suggestions. 

-GD

--- Reini Urban <rei...@gm...> wrote:

> I cannot really help right now, because I'm away
> and can only help with tips out of my head.
> 
> On 10/16/05, Joel Uckelman <uck...@no...>
> wrote:
> > Thus spake Geoff Dougherty:
> > > I'm running 1.2 and mysql, and I need to pull
> page
> > > content from a non-phpwiki database and create
> new
> > > phpwiki pages containing the same content.
> > >
> > > I've uploaded some test content to the wiki
> table in
> > > the database, and updated the wikilinks table to
> > > reflect the new content (i.e., INSERT INTO
> > > wikilink(frompage,topage,) VALUES
> > > ('RecentChanges,'MyNewContentPage')
> > >
> > > I've confirmed that the tables hold the new
> stories
> > > and links, but they're not showing up in
> > > RecentChanges, or any of the other pages I've
> tried to
> > > link the content to.
> > >
> > > What else do I need to change to make sure the
> new
> > > content is displayed?
> 
> Look at the admin/*.php pages for actions to import
> content.
> And if this fails put your non-sql pages into pgsrc
> like files
> (header can be omitted, just plain-text() and fire
> up a new wiki
> (DELETE FROM wikipages ?) with this pgsrc. This
> would  be the easiest.
> 
> > I'm looking back at the table structure for 1.2,
> and I'm not seeing
> > any obvious thing to do. Are the new pages
> accessible directly?
> --
> Reini Urban
> 
> 
>
-------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content,
> downloads, discussions,
> and more.
> http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
>
https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> 



		
__________________________________ 
Yahoo! Music Unlimited 
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/

Re: [Phpwiki-talk] creating new pages with mysql

[Reini U. <rei...@gm...>]

pgsrc is only imported in, if there exists no page called StartPage or
HomePage (dependent on the version)

So please dump all pages into pgsrc, delete the StartPage and fire up
your wiki again.

On 10/18/05, Geoff Dougherty <geo...@ya...> wrote:
> The new pages are accessible directly.
>
> I've tried creating new files in /pgsrc, and that
> doesn't seem to fix the problem.
>
> From what I can tell, the zip import does basically
> the same thing that I've done -- add pages to the db.
> So I'm not sure that'll have much impact.
>
> Thanks for the suggestions.
>
> -GD
>
> --- Reini Urban <rei...@gm...> wrote:
>
> > I cannot really help right now, because I'm away
> > and can only help with tips out of my head.
> >
> > On 10/16/05, Joel Uckelman <uck...@no...>
> > wrote:
> > > Thus spake Geoff Dougherty:
> > > > I'm running 1.2 and mysql, and I need to pull
> > page
> > > > content from a non-phpwiki database and create
> > new
> > > > phpwiki pages containing the same content.
> > > >
> > > > I've uploaded some test content to the wiki
> > table in
> > > > the database, and updated the wikilinks table to
> > > > reflect the new content (i.e., INSERT INTO
> > > > wikilink(frompage,topage,) VALUES
> > > > ('RecentChanges,'MyNewContentPage')
> > > >
> > > > I've confirmed that the tables hold the new
> > stories
> > > > and links, but they're not showing up in
> > > > RecentChanges, or any of the other pages I've
> > tried to
> > > > link the content to.
> > > >
> > > > What else do I need to change to make sure the
> > new
> > > > content is displayed?
> >
> > Look at the admin/*.php pages for actions to import
> > content.
> > And if this fails put your non-sql pages into pgsrc
> > like files
> > (header can be omitted, just plain-text() and fire
> > up a new wiki
> > (DELETE FROM wikipages ?) with this pgsrc. This
> > would  be the easiest.
> >
> > > I'm looking back at the table structure for 1.2,
> > and I'm not seeing
> > > any obvious thing to do. Are the new pages
> > accessible directly?
> > --
> > Reini Urban