Codezwiz >> Forums >> General PHP Nuke Help >> Help Can't add blocks

Hope you can help i am running 7.3 and for some reason i can't add my blocks they are in the block list but when you click them to add and after the page refresh they are not added they are still in the list.

Check your blocks table in your Database.
Are these fields there

expire
action
subscription

If not then copy and save this bit of code as update.php and upload it to the root of your site and point your browser to it. It should create those rows for you. Backup your Database first.

<?php

######################################################
# -= WARNING: PLEASE READ =-
#
# NOTE: This file uses config.php to retrieve needed
# variables values. So, to do the upgrade PLEASE copy
# this file in your server root directory and execute
# it from your browser.
######################################################

include("mainfile.php");
global $db;
$db->sql_query("ALTER TABLE ".$prefix."_blocks ADD subscription INT(1) DEFAULT '0' NOT NULL");
$db->sql_query("ALTER TABLE ".$prefix."_blocks ADD expire VARCHAR( 14 ) DEFAULT '0' NOT NULL");
$db->sql_query("ALTER TABLE ".$prefix."_blocks ADD action VARCHAR( 1 ) NOT NULL");
echo "PHP-Nuke Update finished!<br><br>"
."You should now delete this upgrade file from your server.<br><br>";
?>