Blocks not updateing...**SOLVED/FIXED**

Client Joined: Dec 24, 2004 Posts: 194 Location: Michigan

blocks won't update if edited and new blocks are not saved when selected from the drop down menu...

rnlog info

Code:

Column count doesn't match value count at row 1


SQL was: insert into nuke_blocks values (NULL, '', 'Calendar', '', '', 'd', '5', '1', '3600', '', '', 'block-GCalendar_Center.php', '0', '', '0', 'd', '0')

Table Info from my DB

Code:

Field Type Collation Attributes Null Default Extra Action 


  bid int(10)   No  auto_increment 


bkey varchar(15) latin1_swedish_ci  No                 


  title varchar(60) latin1_swedish_ci  No                 


  content text latin1_swedish_ci  No                 


  url varchar(200) latin1_swedish_ci  No                 


  bposition char(1) latin1_swedish_ci  No                 


  weight int(10)   No 1                


  active int(1)   No 1                


  refresh int(10)   No 0                


  time varchar(14) latin1_swedish_ci  No 0                


  blanguage varchar(30) latin1_swedish_ci  No                 


  blockfile varchar(255) latin1_swedish_ci  No                 


  view int(1)   No 0                


  expire varchar(14) latin1_swedish_ci  No 0                


  action char(1) latin1_swedish_ci  No                 


  subscription int(1)   No 0

registered · Posted: Tue Mar 25, 2008 9:32 pm

mds, looks as though you missed an upgrade along the way. You are missing the groups field. You may need to run the following through phpMyAdmin:

ALTER TABLE $prefix.`_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE $prefix.`_message` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE $prefix.`_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

Posted: Tue Mar 25, 2008 9:34 pm

Sorry, replace $prefix.` with whatever your prefix is, but make sure to get the ` in the right place. For example, if your prefix is "nuke", it should be:

ALTER TABLE `nuke_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE `nuke_message` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE `nuke_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

Posted: Wed Mar 26, 2008 7:48 pm

Quote:

mds, looks as though you missed an upgrade along the way. You are missing the groups field. You may need to run the following through phpMyAdmin:

ALTER TABLE $prefix.`_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE $prefix.`_message` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE $prefix.`_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

That would explain another error when trying to update blocks that said something bout missing field "groups" blah blah blah and i thought it was some left over code somewhere cause the blocks table did not show a "groups" so i compared it to the rn 2.20.2 rncore sql and there is nothing there either in the blocks table that shows groups ....so thats where i couldnt figure it out...heres a copy of the rnsql blocks table that i have..

Code:




DROP TABLE IF EXISTS $prefix.`_blocks`;


CREATE TABLE IF NOT EXISTS $prefix.`_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` char(1) NOT NULL default '', `subscription` int(1) NOT NULL default '0', PRIMARY KEY  (`bid`), KEY `title` (`title`) ) TYPE=MyISAM;





INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Modules', '', '', 'l', 1, 1, 0, '', '', 'block-Modules.php', 0,  '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, 'admin', 'Administration', '<strong><big>&middot;</big></strong>&nbsp;<a href="admin.php">Administration</a><br />\r\n<strong><big>&middot;</big></strong>&nbsp;<a href="admin.php?op=adminStory">NEW Story</a><br />\r\n<strong><big>&middot;</big></strong>&nbsp;<a href="admin.php?op=create">Change Survey</a><br />\r\n<strong><big>&middot;</big></strong>&nbsp;<a href="admin.php?op=content">Content</a><br />\r\n<strong><big>&middot;</big></strong>&nbsp;<a href="admin.php?op=logout">Logout</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Who''s Online', '', '', 'l', 3, 1, 0, '', '', 'block-Who_is_Online.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Search', '', '', 'l', 4, 0, 3600, '', '', 'block-Search.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Languages', '', '', 'l', 5, 1, 3600, '', '', 'block-Languages.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Random Headlines', '', '', 'l', 6, 0, 3600, '', '', 'block-Random_Headlines.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Site Info v2.2.2 ©', '', '', 'l', 7, 1, 3600, '', '', 'block-User_Info.php', 0, 0, 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, 'userbox', 'User''s Custom Box', '', '', 'r', 1, 1, 0, '', '', '', 1, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Categories Menu', '', '', 'r', 2, 0, 0, '', '', 'block-Categories.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Survey', '', '', 'r', 3, 1, 3600, '', '', 'block-Survey.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Login', '', '', 'r', 4, 0, 3600, '', '', 'block-Login.php', 3, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Big Story of Today', '', '', 'r', 5, 1, 3600, '', '', 'block-Big_Story_of_Today.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Old Articles', '', '', 'r', 6, 1, 3600, '', '', 'block-Old_Articles.php', 0, '0', 'd', 0);


INSERT INTO $prefix.`_blocks` VALUES (NULL, '', 'Information', '<br /><center><span class="content">\r\n<a href="http://ravenphpscripts.com"><img src="images/powered/RavenWebServices.gif" border="0" alt="Powered by RavenNuke(tm)" title="Powered by RavenNuke(tm)" width="88" height="31" /></a></span></center><br />', '', 'r', 7, 0, 0, '', '', '', 0, '0', 'd', 0);

Quote:

Sorry, replace $prefix.` with whatever your prefix is, but make sure to get the ` in the right place. For example, if your prefix is "nuke", it should be:

ALTER TABLE `nuke_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE `nuke_message` ADD `groups` TEXT NOT NULL AFTER `view`;
ALTER TABLE `nuke_modules` ADD `groups` TEXT NOT NULL AFTER `view`;

i appreciate that claification on the $prefix change to nuke_...i made this mistake and couldnt figure out why i got errors when running it in the sql tab.....lol..i got my answer here and remembered it....lesson learned there Very Happy

....maybe this will fix my irritating groups block as well that displays mulitple times of the same thing.....

Posted: Wed Mar 26, 2008 7:50 pm

mds, it is in the 2.20.01... you just have to look for the ALTER statements towards the bottom... Wink

Posted: Wed Mar 26, 2008 8:04 pm

ahhhhhh ok there it is Thank You under _nsngr_users table..........i also found another ALTER...will check into that 1 as well just to make sure the changes were made.....

Thanks a million ....

Posted: Wed Mar 26, 2008 8:13 pm

allright on a roll now the
ALTER TABLE `nuke_blocks` ADD `groups` TEXT NOT NULL AFTER `view`;

was the answer the rest returned the duplicate error message....which meant tho's changes had been made.....

Posted: Thu Mar 27, 2008 6:04 am

Odd that the first one didn't take. I wonder why. Was this really a fresh install? If not, can you explain the upgrade path you took? Thanks. Just trying to tie-off to make sure we don't have an issue in our upgrade script... I'm actually working on that script at the moment, so its good timing.

Posted: Thu Mar 27, 2008 7:04 pm

No this was not a fresh install it was an upgrade on a site thats been online since 2004....which i stopped at nuke 7.6 then when RN distro came out i made the switch and have just upgraded ever since....i think this was actually a left over issue from one of the other upgrades , that when i upgraded actually was notified that the blocks table had not been updated sucessfully and said "i'll get back to that" and never did and forgot about it....
i don't have a lot of blocks or do much with them on my site so the bug went un-noticed till the addition of the calendar and some of the new add-ons and tried to add the new blocks...
I actually have a couple more things that are not right as well..all from previous upgrades that i havn't posted about yet...but my site works and i am the only admin but there just lil things that i'm trying to get "cleaned up" that i have been pushing off ....
i dont think theres anything wrong with the current script i ran the upgrade without issues everything said it was completed sucessfully and trust me if anybody is going to have a problem with something it will be me lol lol lol

YOU ALL KEEP UP THE EXCELLENT WORK !!!!! WITHOUT YOU GUYS I DON'T KNOW WHERE I'DE BE RIGHT NOW....( prolly going to find some hair transplant DR., shopping for my million'th computer lmao)