Upgrading... Mainfile.php... Side block disapear!

Lieutenant Joined: Oct 29, 2003 Posts: 164

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.

Sergeant Joined: Sep 11, 2003 Posts: 118

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

Posted: Mon May 24, 2004 11:46 am

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

Posted: Mon May 24, 2004 11:51 am

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

Lieutenant Joined: Oct 29, 2003 Posts: 164

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?

Posted: Mon May 24, 2004 1:09 pm

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

Lieutenant Joined: Oct 29, 2003 Posts: 164

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...

Posted: Mon May 24, 2004 1:26 pm

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

Lieutenant Joined: Oct 29, 2003 Posts: 164

thank you

Sergeant Joined: Sep 11, 2003 Posts: 118

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)

Sergeant Joined: Sep 11, 2003 Posts: 118

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

Posted: Mon May 24, 2004 3:53 pm

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

Sergeant Joined: Sep 11, 2003 Posts: 118

Working on it as we speak. Just something nasty about 7.1... everything ekse works :p thanks mikem

Nuke Cadet Joined: Feb 09, 2005 Posts: 1

hope you found the solution :)

find the best forex resources

HTTP://WWW.FINDFOREX.COM

HTTP://www.abgz.com