Re: [Post-nuke-users] Re: Problem upgrading from old php-nuke

[jim b. <jb...@jb...>]

Hi Jesse!

> Thanks for the quick response Mike.  That fixed my first problem.

Cool. Glad that worked, because those other errors were *totally*
unfamiliar to me. :)

> Now The page is loading but I get this error right after the Welcome to
> Postnuke block:
>
> DB Error: getArticles: 1146: Table 'nuke.osc_news_stories_cat' doesn't exist

Never seen exactly that one before either but that table name sure doesn't
look right. Prefix should be 'nuke_' not 'nuke.'. (I already tossed your
previous message but I'm pretty sure that it said 'nuke'.) Are other table
names similar or is that the only one like that? Or is your prefix
'nuke.osc'?

If yes to prefix nuke.osc just for fun I'd try again without the '.' in
there. Can't recall if it's a legal table name char but it definitely
requires extra coding/consideration when used in a column name. Whether
it's legal or not it's always easier to stick to known legal chars such as
hyphen and underscore.

OK, if it's still broke... :) ...

Aside from checking cookies another thing I do when repetitively trying to
upgrade is to drop and recreate the new database via mysqladmin. I don't
trust -anything- old lying around even vaguely related when trying to
create something new.

> Does anyone know how to find out which version of
> php-nuke a site is running? (Sorry about the OT question)

No, but realated to that maybe it'd be a better idea to upgrade the php-
version of the site to something more current? I'm testing only 5.? (I
forget exactly which.)

> Does anyone know what this table's (stories_cat) ancestry is (was it
> always in php-nuke/post-nuke or was it added to post-nuke based on a
> previous table)?  Maybe I can create an sql statement to convert the old
> table to the new table.

It exists in php- 5.?. The PN conversion scripts are in ~/install. If you
find anything interesting/broken please post it to sourceforge postnuke
bugs.

Have a :) day!

jb

-- 
jim barchuk
jb...@jb...