Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues
Author Message
mds
Client


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

PostPosted: Tue Mar 25, 2008 8:34 pm Reply with quote

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


Last edited by mds on Wed Mar 26, 2008 8:14 pm; edited 1 time in total 
View user's profile Send private message
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Tue Mar 25, 2008 9:32 pm Reply with 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`;

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
montego
PostPosted: Tue Mar 25, 2008 9:34 pm Reply with 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`;
 
mds
PostPosted: Wed Mar 26, 2008 7:48 pm Reply with quote

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.....


Last edited by mds on Wed Mar 26, 2008 7:51 pm; edited 1 time in total 
montego
PostPosted: Wed Mar 26, 2008 7:50 pm Reply with quote

mds, it is in the 2.20.01... you just have to look for the ALTER statements towards the bottom... Wink
 
mds
PostPosted: Wed Mar 26, 2008 8:04 pm Reply with quote

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 ....
 
mds
PostPosted: Wed Mar 26, 2008 8:13 pm Reply with quote

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.....
 
montego
PostPosted: Thu Mar 27, 2008 6:04 am Reply with quote

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.
 
mds
PostPosted: Thu Mar 27, 2008 7:04 pm Reply with quote

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)
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> RN v2.20.00 - All Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©