Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.5
Author Message
gonehaywire
Worker
Worker



Joined: May 20, 2004
Posts: 126

PostPosted: Wed Jun 01, 2005 7:36 am Reply with quote

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
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Wed Jun 01, 2005 9:55 am Reply with quote

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.
 
View user's profile Send private message
gonehaywire







PostPosted: Wed Jun 01, 2005 12:16 pm Reply with quote

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
 
Raven







PostPosted: Wed Jun 01, 2005 3:04 pm Reply with quote

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>
 
mikhail
New Member
New Member



Joined: Jul 17, 2005
Posts: 2

PostPosted: Mon Jul 18, 2005 3:33 am Reply with quote

I had this error becouse i did not upload the upgradedb SQL file Embarassed
 
View user's profile Send private message
jjmusicpro
Involved
Involved



Joined: Jul 12, 2005
Posts: 283

PostPosted: Thu Jul 21, 2005 3:27 pm Reply with quote

Yes, i ran that sql in phpmyadmin, and now it works fine, no more errors Smile
 
View user's profile Send private message Visit poster's website
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.5

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 ©