You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 314 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Upgrading... Mainfile.php... Side block disapear! [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Shenphen
Lieutenant
Lieutenant


Joined: Oct 29, 2003
Posts: 164


PostPosted: Sat May 22, 2004 4:46 pm Reply with quoteBack to top

I have been upgrading my system to v7.3... It is all done, but at one point the side blocks just disapear!!
The problem is comeing from ONE line in the "mainfile.php"! In the patch, there is this line:
Code:
    $sql = "SELECT bid, bkey, title, content, url, blockfile, view, expire, action, subscription FROM ".$prefix."_blocks WHERE bposition='$pos' AND active='1' $querylang ORDER BY weight ASC";
While I have this line in my current mainfile (which works):
Code:
    $sql = "SELECT bid, bkey, title, content, url, blockfile, view FROM ".$prefix."_blocks WHERE bposition='$pos' AND active='1' $querylang ORDER BY weight ASC";

Any idea how to correct this?
Thank you.
Find all posts by ShenphenView user's profileSend private message
Kelvyn
Sergeant
Sergeant


Joined: Sep 11, 2003
Posts: 118


PostPosted: Mon May 24, 2004 11:20 am Reply with quoteBack to top

lol, I'm actually having this problem with a fresh install of 7.1, lol. Any advice? heh
Find all posts by KelvynView user's profileSend private messageVisit poster's website
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Mon May 24, 2004 11:46 am Reply with quoteBack to top

It's that stoopid subscription service. Rolling Eyes

The sql upgrade you ran more than likely didn't add the stuff to the tables in your database needed for the subscription service, thus no blocks are showing.

check your _blocks table and see if you have the rows called:
expire
action
subscription


Then check your _users table and see if you have a row called
points

if you don't then that may be the problem Wink

If you do then uh errr....

mikem

_________________
Getting Started | My Projects
Find all posts by mikemView user's profileSend private message
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Mon May 24, 2004 11:51 am Reply with quoteBack to top

Kelvyn wrote:
lol, I'm actually having this problem with a fresh install of 7.1, lol. Any advice? heh


hmm...
Where did you download the Nuke package? What installer, if any, are you using?
Are you applying the latest Fix/Security pack from http://www.nukeresources.com to your 7.1 package you downloaded?

Sheesh, I have more questions than you....hehe

mikem

_________________
Getting Started | My Projects
Find all posts by mikemView user's profileSend private message
Shenphen
Lieutenant
Lieutenant


Joined: Oct 29, 2003
Posts: 164


PostPosted: Mon May 24, 2004 12:20 pm Reply with quoteBack to top

Thank you for your answer Smile

mikem wrote:
check your _blocks table and see if you have the rows called:
expire
action
subscription

Hum... I don't have them... Should I add them manually?
Find all posts by ShenphenView user's profileSend private message
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Mon May 24, 2004 1:09 pm Reply with quoteBack to top

This adds the points row to the users table

Code:
ALTER TABLE users ADD points INT( 10 ) DEFAULT '0'


this adds the three rows to the blocks table
Code:
ALTER TABLE blocks ADD subscription INT( 1 ) NOT NULL DEFAULT '0'
ALTER TABLE blocks ADD expire VARCHAR( 14 ) DEFAULT '0' NOT NULL
ALTER TABLE blocks ADD action VARCHAR( 1 ) NOT NULL


Backup your Database first.

I think my MySQL stuff/coding/programming is pretty sad, shakey at best.... Rolling Eyes Wink

_________________
Getting Started | My Projects

Last edited by mikem on Mon May 24, 2004 1:27 pm; edited 1 time in total
Find all posts by mikemView user's profileSend private message
Shenphen
Lieutenant
Lieutenant


Joined: Oct 29, 2003
Posts: 164


PostPosted: Mon May 24, 2004 1:15 pm Reply with quoteBack to top

Oh thankyou thankyou thankyou! Smile
Added, and it works now! Smile
BTW: I had already the "points" in nuke_users... but not the 3 other ones...
Find all posts by ShenphenView user's profileSend private message
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Mon May 24, 2004 1:26 pm Reply with quoteBack to top

Shenphen wrote:
Oh thankyou thankyou thankyou! Smile
Added, and it works now! Smile
BTW: I had already the "points" in nuke_users... but not the 3 other ones...


PHEW! I was hoping that would do it...Happy Nuking! Wink

_________________
Getting Started | My Projects
Find all posts by mikemView user's profileSend private message
Shenphen
Lieutenant
Lieutenant


Joined: Oct 29, 2003
Posts: 164


PostPosted: Mon May 24, 2004 1:28 pm Reply with quoteBack to top

thank you Smile
Find all posts by ShenphenView user's profileSend private message
Kelvyn
Sergeant
Sergeant


Joined: Sep 11, 2003
Posts: 118


PostPosted: Mon May 24, 2004 2:18 pm Reply with quoteBack to top

I do have those tables, but I find your newsletter facinating and would like to subscribe ;P I'm using everything from Nukeresources.com, including nuke 7.1, with the fix, and the 7.1 sql web doohicky. I have the database, install the tables, but when I go to the page I've got no side blocks, just center (even after creating the super admin).

Feel free to say something else that's brilliant and will solve the problem (prefferably mine) hehe, thanks mikem. This happens

(runs off to break something else)
Find all posts by KelvynView user's profileSend private messageVisit poster's website
Kelvyn
Sergeant
Sergeant


Joined: Sep 11, 2003
Posts: 118


PostPosted: Mon May 24, 2004 3:51 pm Reply with quoteBack to top

Ok, I was wrong about one thing, I CAN get 7.0 to work, and did. It's a fresh install of 7.1 that gives me crap. I solved this by installing 7.0, then uploading 7.1, and upgrading.... (laaame). Heh, thanks though Smile
Find all posts by KelvynView user's profileSend private messageVisit poster's website
mikem
Theme Guru
Theme Guru


Joined: Jan 13, 2003
Posts: 1582

Location: Corn fields of Indiana

PostPosted: Mon May 24, 2004 3:53 pm Reply with quoteBack to top

Kelvyn.

How about giving 7.2 a try?
http://phpnuke.org/modules.php?name=Downloads&d_op=viewdownloaddetails&lid=419&ttitle=PHP-Nuke_7.2

Might do the trick... Rolling Eyes

_________________
Getting Started | My Projects
Find all posts by mikemView user's profileSend private message
Kelvyn
Sergeant
Sergeant


Joined: Sep 11, 2003
Posts: 118


PostPosted: Mon May 24, 2004 7:48 pm Reply with quoteBack to top

Working on it as we speak. Just something nasty about 7.1... everything ekse works :p thanks mikem
Find all posts by KelvynView user's profileSend private messageVisit poster's website
egawabegawab
Nuke Cadet
Nuke Cadet


Joined: Feb 09, 2005
Posts: 1


PostPosted: Wed Feb 09, 2005 2:02 am Reply with quoteBack to top

hope you found the solution :)









find the best forex resources

HTTP://WWW.FINDFOREX.COM



HTTP://www.abgz.com
Find all posts by egawabegawabView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next 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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.102 Seconds - 411 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::