Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Insert Back to DB

This is kinda of a semi-stupid question but how do I insert post/post text back into a forum?

Like I use to have Nuke 6.9 but I put a fresh install of CZEnhanced 7.0 and its installed fine. But how do I insert the post back? I went into my phpmyadmin and copied my SQL dump of the posts, categories, post text etc and entered them, but they don't show up? I mean, do I have to manually reconstruct all the categories and then enter the SQL dump of all of them or will it just not work?

I took all the nuke_bb stuff cept for stuff that didn't have dumpdata and the nuke_bbconfig and entered them into my db, some go in but sometimes I get row count is not matching or something like that. I mean I have a lot of post in my old forums and I don't really want to have to re-enter them all or erase them.

So whats the correct way to enter post back into your forums?

Thats why it says it is only for a fresh install. It is very hard to do but can be done. You will have to manually edit each INSERT INTO and add the extra fields to the backup sql file. Best way is to get the table structure for the nuke_bbposts from the CZEnhanced.

This is the table

CREATE TABLE nuke_bbposts (
post_id mediumint(8) unsigned NOT NULL auto_increment,
topic_id mediumint(8) unsigned NOT NULL default '0',
forum_id smallint(5) unsigned NOT NULL default '0',
poster_id mediumint(8) NOT NULL default '0',
post_time int(11) NOT NULL default '0',
poster_ip varchar(8) NOT NULL default '',
post_username varchar(25) default NULL,
enable_bbcode tinyint(1) NOT NULL default '1',
enable_html tinyint(1) NOT NULL default '0',
enable_smilies tinyint(1) NOT NULL default '1',
enable_sig tinyint(1) NOT NULL default '1',
post_edit_time int(11) default NULL,
post_edit_count smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (post_id),
KEY forum_id (forum_id),
KEY topic_id (topic_id),
KEY poster_id (poster_id),
KEY post_time (post_time)
) TYPE=MyISAM;

Ok. Lets do this! Thanks!

Ahh this is too time consuming... Ok I have nuke 7.2 and I also have another CZEnhanced7.0 that has some posts on, but I still get the same errors as if I were going from 6.9 to enhanced when trying to move over post. Is this also not possible?

The CZEnhanced has added mods that no phpnuke version has. Thats why it cant be used to upgrade.

I know that... but I just was moving the SQL statments pertaining to bbposts, bbpostexts and the categories for it... not the whole darn tooting thing
Oh well don't matter.. I am gonna start fresh... Have any themes that will work with 7.2 and phpbb 2.0.7?

most themes with a compatibility rathing of 6.5+ should work just fine. check the downloads section

taut