Having small problem just patched 7.5 and dont how to

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Having small problem just patched 7.5 and dont how to
Robert
CZ Super Newbie
Robert has been a member for over 19 year's 19 Year Member
usa.gif
Gender: Male
Website:
Status: Offline
Joined: Aug 06, 2004
0.01 posts per day
Posts: 38
Points: 1,865
   
Hello,
I just patched 7.5 with the lates patch and i'm not sure how to upgrade the data base with this code
alter table nuke_stories change informant informant varchar(25) not null default '';
alter table nuke_stories change aid aid varchar(25) not null default '';
alter table nuke_autonews change informant informant varchar(25) not null default '';
alter table nuke_autonews change aid aid varchar(25) not null default '';
alter table nuke_reviews change reviewer reviewer varchar(25) default NULL;
alter table nuke_reviews_add change reviewer reviewer varchar(25) not null default '';
alter TABLE nuke_bbsessions ADD COLUMN session_admin tinyint(2) DEFAULT '0' NOT NULL;
update nuke_bbconfig SET config_value='.0.15' where config_name='version';

its not like a regualr sql file i browse and upload it so do i have to open up somethng and change stuff add to them?
Thanks kinda sitting here stuck icon_question.gif


Back to top Reply with quote
#2   re: Having small problem just patched 7.5 and dont how to
echo
CZ Wiz
 Codezwiz Site Donator
echo has been a member for over 20 year's 20 Year Member
Gender: Male
Status: Offline
Joined: Oct 04, 2003
0.15 posts per day
Posts: 1147
Points: 93
   
Just go into your PhPMyAdmin and click on your database name on the left, then click the tab that says"SQL" on the right window pane, then you should see an input box on the very top that says something like"Run SQL query/queries on database YOURDATABASE" copy and paste that code there and hit go.



Back to top Reply with quote
#3   
Robert
CZ Super Newbie
Robert has been a member for over 19 year's 19 Year Member
usa.gif
Gender: Male
Website:
Status: Offline
Joined: Aug 06, 2004
0.01 posts per day
Posts: 38
Points: 1,865
   
Yes i got that going now but have another small problem maybe you might know if you have time to take a look i posted another topic but what the problem is i have a radio block on my site and when i or someone choose the station from drop down menu the popup is small and not showing the player in it it was working fine lastnight till i did this patch upgrade the database is working fine for the radio station its just that popup is not grabbing the popup.php file or something and all files are loaded in its right places thanks i hope you have a clue why icon_sad.gif



Back to top Reply with quote
#4   re: Having small problem just patched 7.5 and dont how to
echo
CZ Wiz
 Codezwiz Site Donator
echo has been a member for over 20 year's 20 Year Member
Gender: Male
Status: Offline
Joined: Oct 04, 2003
0.15 posts per day
Posts: 1147
Points: 93
   
[ Register or login to view links on this board. ]



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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 cannot attach files in this forum
You cannot download files in this forum