Codezwiz >> Forums >> General PHP Nuke Help >> How Do I run db update.php

Thank you for your help.

What I did, now is installed phpBB on a different sever and ran the db_updat.php. It works. So then I copy the SQL to my nuke server. it works.

Because I was having problem with SQL, the coding.. I guess I figured out the solution

Nice job, a lot of times it just takes some creativity and willingness to experiment.

Can you post the SQL here? I want to give this a shot in my Nuke test site- Thanks!

It worked when its on phpBB, but when I tried to put it on my nuke, I can not write or view comments. So I am still working on it. So here is the SQL. Let me know if you figure it out before me

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 08, 2006 at 06:09 PM
-- Server version: 4.0.16
-- PHP Version: 4.4.1
--
-- Database: `nuke_maxx`
--

-- --------------------------------------------------------

--
-- Table structure for table `comments_config`
--

CREATE TABLE `comments_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;

--
-- Dumping data for table `comments_config`
--

INSERT INTO `comments_config` VALUES ('comments_per_page', '15');
INSERT INTO `comments_config` VALUES ('comments_on_mini', '3');
INSERT INTO `comments_config` VALUES ('view_order', 'DESC');
INSERT INTO `comments_config` VALUES ('auth_owner', '3');
INSERT INTO `comments_config` VALUES ('auth_all', '0');
INSERT INTO `comments_config` VALUES ('auth_reg', '2');
INSERT INTO `comments_config` VALUES ('auth_mod', '5');

-- --------------------------------------------------------

--
-- Table structure for table `users_comments`
--

CREATE TABLE `users_comments` (
`comment_id` mediumint(8) unsigned NOT NULL auto_increment,
`user_id` mediumint(8) unsigned NOT NULL default '0',
`poster_id` mediumint(8) NOT NULL default '0',
`poster_ip` varchar(8) NOT NULL default '',
`poster_username` varchar(25) NOT NULL default '',
`comments` text NOT NULL,
`time` int(11) default NULL,
`enable_html` tinyint(1) unsigned NOT NULL default '0',
`enable_bbcode` tinyint(1) unsigned NOT NULL default '0',
`enable_smilies` tinyint(1) unsigned NOT NULL default '0',
`bbcode_uid` varchar(10) NOT NULL default '',
PRIMARY KEY (`comment_id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users_comments`
--