Little help please with upgradedb just patched 7.5 and forum

Worker Joined: May 20, 2004 Posts: 126

Having a small problem patching 7.5 how do i add these from the patch

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 regular sql file upload to run it?

and on my forums when i click it im getting this

Code:

phpBB : Critical Error 





Error creating new session





DEBUG MODE





SQL Error : 1054 Unknown column 'session_admin' in 'field list'





INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('a7c3f68a84310cf560dd729cc927531a', '1', '1117632866', '1117632866', '42d63499', '0', '0', '0')





Line : 203


File : sessions.php

Thanks im at a loss right now in how to add or upgrade the tables

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

You get that error because you haven't applied those patches. Use phpMyAdmin and just load those statements into the SQL window and run them. Or, just run the upgradedb.php file that is included in the download Wink

- You use either/or.

Posted: Wed Jun 01, 2005 12:16 pm

Yea thats working now had some great help but now have a small problem on my site i have a radio block and to choose a station from that block you use the drop down menu and a new small window pops up and starts playing well now it pops up but the player isnt in it and its real small so the person that was helping me couldnt find reason why nor can i he said it might be cause of the security patch? but can you take a look please www.rjrcams.com on left side Live Jams use the drop down menu to see what happens. Thanks Smile

Posted: Wed Jun 01, 2005 3:04 pm

I don't think it has anything to do with the upgrade. Here is the code extracted, cleaned up, and totally w3c 4.01 compliant, and it still doesn't work. Note that I have used a ~ in three places for script (scr~ipt) to allow posting.

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">


<html>


<head>


<title>rjrcams</title>


<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1; Content-Transfer-Encoding: chunked">


<base href="http://www.rjrcams.com/">


<SCR~IPT LANGUAGE="JavaScript" type="text/javascript">





function launch(url) {


  remote = open(url, "", "width=190,height=190,left=0,top=0");


}





</SCR~IPT>


</head>


<body>


<table border="2" cellpadding="0" cellspacing="0" width="170" style="border-left-width: 2; border-right-width: 2; border-bottom-width: 0; border-collapse:collapse;border-color: #000000 #222222 #222222 #000000">


   <tr>


      <td>


         <table border="0" cellpadding="3" cellspacing="0" width="100%" style="border-left-width: 0; border-right-width: 0; border-bottom-width: 0; border-collapse:collapse; border-color:#6D7893;">


            <tr>


               <td height="31" style="background-image:url(themes/StrataGen/images/block_topbg.gif);" align="center"><font class="boxtitle">Live Jams</font>


               </td>


            </tr>


         </table>


      </td>


   </tr>


</table>


<table border="2" cellpadding="3" cellspacing="0" width="170" style="border-left-width: 2; border-right-width: 2; border-bottom-width: 2; border-collapse:collapse;border-color: #000000 #222222 #222222 #000000">


   <tr valign="top">


      <td  style="background-image:url(themes/StrataGen/images/block_back.jpg);">


         <center>


            <img border="0" src='images/internet_radio/radio_on.gif' alt='' />


         </center>


         <br><br><center><br>


         <form name="form" method="post" action="">


            <select name="select" onchange="javascr~ipt:launch('modules.php?name=Internet_Radio3&amp;file=popup&amp;radio='+this.options[this.selectedIndex].value+'&amp;num=')">


               <option>- Select station -</option>


               <option VALUE="20">102.5 WacoTexas Rock</option>


               <option VALUE="13">105.9 RX Cebu Phili,</option>


               <option VALUE="25">80's Grooves  UK</option>


               <option VALUE="15">89.1EnergyCebu,Phili</option>


               <option VALUE="18">90.7 Crossover Cebu</option>


               <option VALUE="12">93.1 MonsterRX,Phili</option>


               <option VALUE="24">98 Rock Fl,Tampa USA</option>


               <option VALUE="16">99.5 DWRT, Phili</option>


               <option VALUE="8">Capital FM</option>


               <option VALUE="21">KHHT L.A. Calif, R&amp;B</option>


               <option VALUE="19">KHYL Sac, Calif, R&amp;B</option>


               <option VALUE="22">KIIS L.A.Calif,Top40</option>


               <option VALUE="14">Mareco_QC FM</option>


               <option VALUE="23">SanFran, HipHop/R&amp;B</option>


               <option VALUE="17">The_Edge</option>


               <option VALUE="9">Virgin Radio</option>


            </select>


         </form>Will load in new window</center>


      </td>


   </tr>


   <tr>


      <td height="31" style="background-image:url(themes/StrataGen/images/block_bottombg.gif);">


      </td>


   </tr>


</table>


</body>


</html>

New Member Joined: Jul 17, 2005 Posts: 2

I had this error becouse i did not upload the upgradedb SQL file Embarassed

Involved Joined: Jul 12, 2005 Posts: 283

Yes, i ran that sql in phpmyadmin, and now it works fine, no more errors Smile