Can't add new blocks

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

I have read several posts on this, but mine problem seems to be unique. So I started a new topic. Please forgive me if I missed this answer somewhere. I will gladly take the flaming for an answer. Smile

I can't add new blocks. Not even included blocks. If I try to add a new block, all "appears" to go fine, but after you hit the save button and the blocks administration screen refreshes, there are NO changes. I can delete blocks, and I can activate/deactivate blocks. I just can't add a new block.

I was running PHP-Nuke 8.1. I downgrade the database to 7.6 and completely wiped out the public_html folder. I then uploaded all the RN files and proceeded to install RN following the instructions in the "how to install" folder. I edited the config.php file, imported the sql files in the SQL/inlcludedinCore/ folder, and renamed the INSTALLATION folder (for now). Everything is working 100% so far. Users are there. Forum is there and working. I just can't add a block.

Please help! Exclamation

Raven · Posted: Wed Sep 09, 2009 10:22 pm

Check your server error log to see if that shows anything. If not then try the following:

In rnconfig.php set the $loglevel to 1. Then try your add block again. Now look at the /html/rnlogs/dblog file to see what errors may be thrown.

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

There wasn't any useful information in the server error log. Just a missing image file that I know about. Here is what I got in the dblog file.

Code:

September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557256' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557263' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557274' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557274' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557277' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557277' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557290' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1136 : Column count doesn't match value count at row 1
SQL was: insert into nuke_blocks values (NULL, '', 'test', '', '', 'l', '10', '1', '3600', '', '', 'block-Sentinel_Side.php', '0', '', '0', 'd', '0', '0')
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557290' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:34 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557290' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:35 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557358' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:35 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557358' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:36 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557379' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:36 pm 1136 : Column count doesn't match value count at row 1
SQL was: insert into nuke_blocks values (NULL, '', 'Test', '', '', 'l', '10', '1', '3600', '', '', 'block-Sample_Block.php', '0', '', '0', 'd', '0', '0')
remote addr: 000.000.000.000
September 9, 2009, 11:36 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557379' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:36 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557380' WHERE user_id='2'
remote addr: 000.000.000.000
September 9, 2009, 11:39 pm 1054 : Unknown column 'lastsitevisit' in 'field list'
SQL was: UPDATE nuke_users SET lastsitevisit='1252557593' WHERE user_id='2'
remote addr: 000.000.000.000

I see the error there now. Not sure how to fix it.. I took out my IP address..

Raven · Posted: Wed Sep 09, 2009 10:59 pm

Looks like you may have missed a step in your upgrade process.

Use phpMyAdmin and issue the following 2 statements, in order, to your nuke_users table. This assumes your $user_prefix = 'nuke'

Code:

ALTER TABLE `nuke_users` ADD `lastsitevisit` INT( 11 ) NOT NULL DEFAULT '0';
UPDATE `nuke_users` SET lastsitevisit = user_lastvisit;

Edited to remove extraneous quote mark

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Raven wrote:

Looks like you may have missed a step in your upgrade process.

Use phpMyAdmin and issue the following 2 statements, in order, to your nuke_users table. This assumes your $user_prefix = 'nuke'

Code:

ALTER TABLE `nuke_users` ADD `lastsitevisit` INT( 11 ) NOT NULL DEFAULT '0';
UPDATE `nuke_users` SET lastsitevisit = user_lastvisit';

Ok I had to add a quote before user_lastvisit. I am getting this error when I import with myPHPadmin.

Code:

Error

SQL query:

ALTER TABLE `nuke_users` ADD `lastsitevisit` INT( 11 ) NOT NULL DEFAULT '0';

MySQL said: Documentation
#1060 - Duplicate column name 'lastsitevisit'

I just checked nuke_users and there is a lastsitevisit field. I dropped it and re imported the data you sent. I didn't get an error that time, but it didn't fix it either.

Could it be a permission problem somewhere?

Raven · Posted: Thu Sep 10, 2009 1:46 am

No, you don't want to add a quote. You need to remove the extraneous quote. And you don't want to drop the other field. Put it back. Hopefully you made a backup because you need the data from the user_lastvisit field.

ALTER TABLE `nuke_users` ADD `lastsitevisit` INT( 11 ) NOT NULL DEFAULT '0';
UPDATE `nuke_users` SET lastsitevisit = user_lastvisit;

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Ok I have a backup, but it is from the 8.1 php-nuke database. For now I have reverted back to that installation. I will attempt the downgrade and switch to RN again this evening.

Thanks for your help Raven. Is there a better guide on downgrading and installing ravennuke? The one included in the RN distro is a little vague and confusing. I had to search for a downgrade script that was actually for 8.0 (which might be my problem). I would be more comfortable with a step by step from you. Smile

I want to keep my forum posts (phpbb 2.0.23) and users, as well as all the data.

Thanks Again!

Raven · Posted: Thu Sep 10, 2009 10:18 am

You're welcome Smile

. We see switching to RN as an upgrade Wink

and afaik the instructions we provide are the best ones we know of. Realistically speaking it's going to be the same process for any application upgrade. It's almost always possible to improve the wording on a subject and we are constantly reviewing our documentation. But for now that's all we have. Is there something in particular that you feel needs improvement? Maybe you can offer up improvements based on your own experience?

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

The biggest thing for me is the whole database change. I have been using php-nuke for a few years, but my php and sql skills and knowledge are not that good. So the manual way of downgrading the database is like greek to me. A script that does this for 8.0/8.1 would be nice. (I have one I found, but who knows if it is doing things right?)

As for the instructions in the "How to Install" section. It is fine, it is more of a issue of me not fully understanding myPHPAdmin and how the database works.

My biggest question is, assuming my downgrade tool works correctly, is the steps.

Here is how I see it.

1 - Downgrade main site database to 7.6

2 - Upgrade to BBtoNuke 2.0.23 (I assume if you currently have 2.0.23 you can skip this step)

3 - Apply RN changes to downgraded 7.6 database (All the .SQL files located in \html\INSTALLATION\sql\includedInCore\)

4 - Apply NukeSentinel changes only located in installSQL.php to downgraded database (I don't mind starting fresh)

5 - Upgrade Database in place - I assume this is already done by applying the SQL files in step 3 above.

6 - Remove/Rename INSTALLATION directory and FTP html folder from RN distro to website. (Keeping custom blocks and config.php) Do I keep config.php or edit the one in the RN distro and use that?

7 - Check permissions (This is explained well, but I noticed in the RN distro there is a .htaccess file in almost every sub-folder. Should I keep it that way? Do I change the permissions on each and every .htaccess file?)

8 - TEST TEST TEST All should be working from this point..

Here is the downgrade file I am using. Maybe you can tell if it truly works.

Code:

<?php

########################################################
# File to Downgrade from PHP-Nuke 8.0 to PHP-Nuke 7.6 #
# After you used this file, you can safely delete it. #
########################################################
# -= 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. #
########################################################
# Made By Platinum @

Only registered users can see links on this board!
Get registered or login to the forums!

#
# for Php Nuke Evolution #
#

Only registered users can see links on this board!
Get registered or login to the forums!

#
# #
########################################################

require_once(dirname(__FILE__) . '/mainfile.php');

$module_name = basename(dirname(__FILE__));

include(dirname(__FILE__) . "/header.php");

global $admin;

if (!is_admin($admin)) {
OpenTable();
echo "<center>Eriþim Reddedildi</center>";
CloseTable();
} else {
$index = 0;

// Table Removal for Anti-Flood System
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_antiflood");

// Table Removal and alteration for Moderated Comments to drop the karma system
$db->sql_query("ALTER TABLE ".$user_prefix."_users Drop karma ");
$db->sql_query("ALTER TABLE ".$user_prefix."_users Drop INDEX karma ");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_comments_moderated");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_pollcomments_moderated");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_reviews_comments_moderated");

// News Comments table alteration for moderation system
$db->sql_query("ALTER TABLE ".$prefix."_comments DROP last_moderation_ip ");

// Surveys Comments table alteration for moderation system
$db->sql_query("ALTER TABLE ".$prefix."_pollcomments DROP last_moderation_ip ");
$db->sql_query("ALTER TABLE ".$prefix."_poll_desc DROP comments ");

// Articles rating system Backdate
$db->sql_query("ALTER TABLE ".$prefix."_stories DROP rating_ip ");

// Topic image field length Decreased
$db->sql_query("ALTER TABLE ".$prefix."_topics CHANGE topicimage topicimage varchar(20) default NULL");

// Forums Table Backdate *
$db->sql_query("UPDATE ".$prefix."_bbconfig SET config_value='.0.22' WHERE config_name='version'");
$db->sql_query("ALTER TABLE ".$prefix."_bbsessions DROP session_admin");

// Banners Table Alteration
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_positions");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_terms");
$db->sql_query("DROP TABLE IF EXISTS ".$prefix."_banner_plans");
$db->sql_query("ALTER TABLE ".$prefix."_banner_clients RENAME nuke_bannerclient");
$db->sql_query("ALTER TABLE ".$prefix."_banner DROP ad_class , DROP ad_code , DROP ad_width , DROP ad_height ");
$db->sql_query("ALTER TABLE ".$prefix."_banner DROP name");
$db->sql_query("ALTER TABLE ".$prefix."_banner DROP position");
$db->sql_query("ALTER TABLE ".$prefix."_banner ADD type tinyint(1) NOT NULL default '0'");

// Countries and Cities Table Drop
// It's used in the banners system and will be used in the future. Very useful for some modules developers

$db->sql_query("DROP TABLE IF EXISTS nuke_cities");

// PHP-Nuke copyright notice modification. (c) year changed.
$db->sql_query("UPDATE ".$prefix."_config SET copyright='<a href=\"http://phpnuke.org\">PHP-Nuke</a> Copyright © 2008 by Francisco Burzi. This is free software, and you may redistribute it under the <a href=\"http://phpnuke.org/files/gpl.txt\">GPL</a>. PHP-Nuke comes with absolutely no warranty, for details, see the <a href=\"http://phpnuke.org/files/gpl.txt\">license</a>.'");

// PHP-Nuke Version Number Update
$db->sql_query("UPDATE ".$prefix."_config SET Version_Num='7.6'");

OpenTable();

echo " PHP-Nuke Update finished! "
."Your Php Nuke Version is now 7.6 "
."You should now delete this Downgrade file from your server. ";

CloseTable();
}

include(dirname(__FILE__) . "/footer.php");

?>

Raven · Posted: Thu Sep 10, 2009 11:37 am

Yes, that process could/should be improved but the MySQL setup's are so diverse it's hard to have a single script to do it all. But we will keep improving Wink

#6 - You must use the RN supplied config.php and just update the db info from your old config.php . The rnconfig.php is a separate config file that must also be present.

#7 - Just leave the .htaccess files and only change the permissions on the root .htaccess and .staccess

Please email, to me, the script you are using to downgrade. Is it by Bob Marion perhaps? If so, it should be correct. Regardless, please zip it up and send it to the following email address, removing all the _

raven
_@_
ravenphpscripts
_._
com

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Ok, email sent. The only downgrade file I have is included in my message. It is from someone named "Platnium" @

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Thu Sep 10, 2009 1:51 pm

Sorry, I didn't see that you included it. Thanks.

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Will you let me know if that script looks complete?

Raven · Posted: Thu Sep 10, 2009 2:12 pm

Yes. But I would go ahead and use it until proven otherwise Wink

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Ok, Like I said, I am going to start completely over again and do the up/downgrade tonight. I will post results afterwards.. Again Raven, thanks for all the help! I know you must just get hammered with questions..

Raven · Posted: Thu Sep 10, 2009 2:38 pm

We (The Team) do but that's why we try to stay on top of all the questions. Without support the best product just dies.

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Ok I followed the steps I listed earlier and did the upgrade. I don't know if the blocks problem is still there or not. I haven't got that far. Now when I log in as a user (not admin) it doesn't "stay" logged in. He says welcome but still has the login box and password block and is calling me anonymous, yet brings me to my "Your Account" page. I CAN login and stay logged in with GOD/Admin acocunt. Also getting this error when I go to "Edit Users" from the admin screen.

ERROR: YOU NEED TO UPDATE YOU DATA BASE TABLE NOW!!
Run rnya.php from the root of your phpnuke installation, update the database tables, and delete the file afterwards!
The version of the module is 2.30.01 and the version of your data base table is

That is all it says it doesn't finish the sentence.

Here is the error log:

Code:

September 11, 2009, 3:25 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_value FROM nuke_users_config WHERE config_name = 'cookiepath'
remote addr: 24.248.222.27
September 11, 2009, 3:25 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_name, config_value FROM nuke_users_config
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_value FROM nuke_users_config WHERE config_name = 'cookiepath'
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_name, config_value FROM nuke_users_config
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_legal_docs' doesn't exist
SQL was: SELECT a.`did`, `doc_name`, `doc_text` FROM `nuke_legal_docs` a, `nuke_legal_text_map` b, `nuke_legal_text` c WHERE a.`did` = b.`did` AND b.`tid` = c.`tid` AND b.`mid` = 2 AND `doc_status` = '1' AND `language` = 'english'
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_legal_docs' doesn't exist
SQL was: SELECT a.`did`, `doc_name`, `doc_text` FROM `nuke_legal_docs` a, `nuke_legal_text_map` b, `nuke_legal_text` c WHERE a.`did` = b.`did` AND b.`tid` = c.`tid` AND b.`mid` = 2 AND `doc_status` = '1' AND `language` = 'english'
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_value FROM nuke_users_config WHERE config_name = 'cookiepath'
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_name, config_value FROM nuke_users_config
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_value FROM nuke_users_config WHERE config_name = 'cookiepath'
remote addr: 24.248.222.27
September 11, 2009, 3:26 pm 1146 : Table 'teamdof_nuke.nuke_users_config' doesn't exist
SQL was: SELECT config_name, config_value FROM nuke_users_config
remote addr: 24.248.222.27

teamdof_nuke is my database name, that doesn't look right there..

Raven · Posted: Fri Sep 11, 2009 10:35 pm

My guess is that the script is strictly for Evolution.

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Ok, I think I have fixed alot of what was going on. I am getting one error I can't seem to beat.

This one:

September 12, 2009, 1:36 am 1136 : Column count doesn't match value count at row 1
SQL was: insert into nuke_blocks values (NULL, '', 'test', '', '', 'c', '1', '1', '3600', '', '', 'block-Sample_Block.php', '0', '', '0', 'd', '0', '0')

Palbin · Posted: Sat Sep 12, 2009 1:02 am

What is the structure of your blocks table? Sounds like you have extra columns.

hamrdeye · Hangin' Around Joined: Aug 20, 2008 Posts: 28

Well I am all fixed now. I basically made a new database and then compared to structure of the users table and blocks table. I was missing a field in users 'lastsitevisit' was not there. I was also missing bb_sessions all the SEO tables. I don't know where in the upgrade process those are added, but I followed as close as I could several times and I dont see them in any of the sql files you are suppose to add to your existing database. I had to take the code out of the core.sql file. If I ran the setup.sql it would drop all my data. So shouldn't there be another file in the includedinCore folder to add the RN stuff?