Codezwiz >> Forums >> General PHP Nuke Help >> problems after updating to 7.0

Yes telli i try and me and its works but only for blocks no for modules.
Nice job mate

I tried to follow this thread to fix mine as best as possible. I am a big time novice, in other words I really shouldn't be screwing around in the SQL database at all. I do have a backup that I made before I started, though I wouldn't have the slightest clue on how to restore it.

Anyway, after trying these suggestions, including changing my nuke_blocks to what was posted here earlier (here's my current dump)

# phpMyAdmin SQL Dump
# version 2.5.2
# [ Register or login to view links on this board. ]
#
# Host: localhost
# Generation Time: Feb 09, 2004 at 12:20 AM
# Server version: 4.0.15
# PHP Version: 4.2.3
#
# Database : `jlouisvi_nuke`
#

# --------------------------------------------------------

#
# Table structure for table `nuke_blocks`
#
# Creation: Feb 09, 2004 at 12:19 AM
# Last update: Feb 09, 2004 at 12:19 AM
#

CREATE TABLE `nuke_blocks` (
`bid` int(10) NOT NULL auto_increment,
`bkey` varchar(15) NOT NULL default '',
`title` varchar(60) NOT NULL default '',
`content` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`bposition` char(1) NOT NULL default '',
`weight` int(10) NOT NULL default '1',
`active` int(1) NOT NULL default '1',
`refresh` int(10) NOT NULL default '0',
`time` varchar(14) NOT NULL default '0',
`blanguage` varchar(30) NOT NULL default '',
`blockfile` varchar(255) NOT NULL default '',
`view` int(1) NOT NULL default '0',
PRIMARY KEY (`bid`),
KEY `bid` (`bid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `nuke_blocks`
#

And using the blocks.php file found earlier in this thread. I still cannot add any new blocks. My site is still up, but only the NEWS section down the middle is available and it's streatched from one side to the other because some of these steps have removed my blocks completely. heh...

PLEASE HELP.

grrrrrrrrrrr I need a stiff drink.

Oh, using PHP_NUKE 7.0 and the original problem was that I could not add any new blocks. No errors, just couldn't add them.

Run this query:

CREATE TABLE nuke_blocks (
bid int(10) NOT NULL auto_increment,
bkey varchar(15) NOT NULL default '',
title varchar(60) NOT NULL default '',
content text NOT NULL,
url varchar(200) NOT NULL default '',
bposition char(1) NOT NULL default '',
weight int(10) NOT NULL default '1',
active int(1) NOT NULL default '1',
refresh int(10) NOT NULL default '0',
time varchar(14) NOT NULL default '0',
blanguage varchar(30) NOT NULL default '',
blockfile varchar(255) NOT NULL default '',
view int(1) NOT NULL default '0',
expire varchar(14) NOT NULL default '0',
action varchar(1) NOT NULL,
PRIMARY KEY (bid),
KEY bid (bid),
KEY title (title)
) TYPE=MyISAM;

#
# Volcar la base de datos para la tabla `nuke_blocks`
#

INSERT INTO nuke_blocks VALUES (1, '', 'Modules', '', '', 'l', 1, 1, 0, '', '', 'block-Modules.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (2, 'admin', 'Administration', '<big>�</big> <a href="admin.php">Administration</a> \r\n<big>�</big> <a href="admin.php?op=adminStory">NEW Story</a> \r\n<big>�</big> <a href="admin.php?op=create">Change Survey</a> \r\n<big>�</big> <a href="admin.php?op=content">Content</a> \r\n<big>�</big> <a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, 0, 'd');
INSERT INTO nuke_blocks VALUES (3, '', 'Who\'s Online', '', '', 'l', 3, 1, 0, '', '', 'block-Who_is_Online.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (4, '', 'Search', '', '', 'l', 4, 0, 3600, '', '', 'block-Search.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (5, '', 'Languages', '', '', 'l', 5, 1, 3600, '', '', 'block-Languages.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (6, '', 'Random Headlines', '', '', 'l', 6, 0, 3600, '', '', 'block-Random_Headlines.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (7, '', 'Amazon', '', '', 'l', 7, 1, 3600, '', '', 'block-Amazon.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (8, 'userbox', 'User\'s Custom Box', '', '', 'r', 1, 1, 0, '', '', '', 1, 0, 'd');
INSERT INTO nuke_blocks VALUES (9, '', 'Categories Menu', '', '', 'r', 2, 0, 0, '', '', 'block-Categories.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (10, '', 'Survey', '', '', 'r', 3, 1, 3600, '', '', 'block-Survey.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (11, '', 'Login', '', '', 'r', 4, 1, 3600, '', '', 'block-Login.php', 3, 0, 'd');
INSERT INTO nuke_blocks VALUES (12, '', 'Big Story of Today', '', '', 'r', 5, 1, 3600, '', '', 'block-Big_Story_of_Today.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (13, '', 'Old Articles', '', '', 'r', 6, 1, 3600, '', '', 'block-Old_Articles.php', 0, 0, 'd');
INSERT INTO nuke_blocks VALUES (14, '', 'Information', ' <center>\r\n<a href="http://phpnuke.org"><img src="images/powered/phpnuke.gif" border="0" alt="Powered by PHP-Nuke" title="Powered by PHP-Nuke" width="88" height="31"></a>\r\n \r\n<a href="http://validator.w3.org/check/referer"><img src="images/html401.gif" width="88" height="31" alt="Valid HTML 4.01!" title="Valid HTML 4.01!" border="0"></a>\r\n \r\n<a href="http://jigsaw.w3.org/css-validator"><img src="images/css.gif" width="88" height="31" alt="Valid CSS!" title="Valid CSS!" border="0"></a></center> ', '', 'r', 7, 1, 0, '', '', '', 0, 0, 'd');

OMG! I've been sitting here for 3 hours and 6 beers reading this thread and many others like it trying to decifer all this and all that.... I FINALLY ask for help and within a few minutes you post my solution.... IT WORKS! IT"s ALIVE!

Thank you so very much. I owe you a cold one.

Glad you got it fixed up!