PHP Web Host - Quality Web Hosting For All PHP Applications Just Great Software
  Login or Register
 • Home • Downloads • Your Account • Forums • 

View next topic
View previous topic


Google
 
Web RavenPHPScripts (This Site)
Post new topic   Reply to topic
Author Message
gonehaywire
Worker
Worker


Joined: May 20, 2004
Posts: 126

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

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: 15235
Location: Kansas

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

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 Visit poster's website AIM Address Yahoo Messenger
gonehaywire
Worker
Worker


Joined: May 20, 2004
Posts: 126

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

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
Only registered users can see links on this board!
Get registered or login to the forums!
on left side Live Jams use the drop down menu to see what happens. Thanks Smile
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 15235
Location: Kansas

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

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>
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger
mikhail
New Member
New Member


Joined: Jul 17, 2005
Posts: 2

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

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


Joined: Jul 12, 2005
Posts: 249

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

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:       
Post new topic   Reply to topic

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
Forums ©
 

All logos and trademarks in this site are property of their respective owner.
The comments are property of their posters, all the rest © 2002-2008 by Raven
Proud to be listed at Lobo Links Web Directory

You can syndicate our news using the file xml

CSE HTML Validator Helped Clean up This Page! [Valid RSS] valid RSS 2.0 Valid robots.txt Stop Spam Harvesters, Join Project Honey Pot

Website engines core code is © copyright by PHP-Nuke but has been heavily patched and modified by myself and others.
PHP-Nuke is a free software released under the GNU/GPL.


:: fisubice phpbb2 style by Daz :: PHP-Nuke theme by www.nukemods.com ::

:: fisubice Theme Recoded To 100% W3C CSS & HTML 4.01 Transitional Compliance by Raven and 64bitguy ::

:: W3C CSS Compliance Validation :: W3C HTML 4.01 Transitional Compliance Validation ::

zerosum