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

[<jg...@fl...>]

jim barchuk wrote:

>[snip]
>
>>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'?
>
Actually nuke is the database name, osc_news is the prefix.  It seems 
the upgrade scripts tack on the table names as _table_name.  So I'm 
assuming that the name of the table being inserted is _stories_cat.  I 
tried doing this without prefixes as well which is why I'm assuming that.

>
>[snip]
>
>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.
>
I've been using mysql directly.  I used this:
 mysqldump -u root -p > old_php_nuke_db.sql

to get the original dump.  No on another machine I have been testing it. 
 I basically drop the database after each attempt, re-create it in 
mysql, then do a:
mysql -u root -p < old_php_nuke_db.sql

So I always start with the original database.  Each time I've been 
applying the patches (from php-nuke) and then use the post-nuke 
installer.  It's tedious, but I'm making headway slowly.  I can't 
imagine doing it without all these scripts ;)

>
>
>>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.)
>
I had originally thought of this but thought it would be easier to just 
upgrade from 4.4 since the post-nuke installer is just so darn nice ;) 
 The real problem here is I'm not starting from a known state--I don't 
know what version of php-nuke this is :(

>
>>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
>
That's good to know!  I'll check the php-nuke "upgrade" scripts and see 
if there is something there.  If the table exists there (in php-nuke 
5.x) I should be able to upgrade to that and then convert over and get 
it working.

Thanks again for all your prompt reponses. I guess it shouldn't be 
surprising but it is :)

Jesse