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, 57 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 - Nuke7.0 Modules not showing FIX [ ]
 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
nexusgroove
Private
Private


Joined: Nov 11, 2003
Posts: 37


PostPosted: Fri Jan 02, 2004 2:01 pm Reply with quoteBack to top

OK.

I can explain this in a dummy proof of a way....



go into to ur PHPMY ADMIN

go into the nuke_modules and click on browse

this will popup on the top;

Image


ok. I'm not the PHP king here I just stay at a Holiday Inn Express.....

when u see people talking about the
Quote:
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);
the part [$i]', '0', '0', '1')", only covers 3 tables of the db. witch will cause a problem not letting new added mods to appear.

so if u see that u have 5 tables your code will have to be ajusted to [$i]', '0', '0', '1', '1', '0')", on both admin/module/module.php Line # 47 and blocks/block_module.php line # 96

refer to the phpmyadmin and count the active|view|inmenu|mod_group|mcid


so mine has 5 numbers but the string show
Quote:
$i]', '0', '0', '1')", $dbi);
3

so all u have to do is fix this string
in my case' my string to work right is this, notice 5 #'s in my module.php
Quote:
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '0', '0')", $dbi);


and now it works fine.

and for the blocks/block_module same change
Quote:
$db->sql_query("INSERT INTO ".$prefix."_modules VALUES (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '1', '0')");


should be on line #96 in the script.



summry....


goto phpmyadmin and see how many
active view inmenu mod_group mcid
0 1 1 0 0 = 5 tables some of u might have less tables U have to check it in phpmyadmin!!!

and make the chages. maybe some of you will have less or more.. Like I said I'm now a PHP pro but I did I sleep at a holiday Inn Express. Smile

here is a picture tp help understand:



Image

I hope this help. it worked for me 100% all new modsare added automaticly[img]

Happy Holidays. if u want a copy of mu module.php and block_module.php..
I will sent at ur request.




Thanks and have a great 2004 year..




NexusGroove
www.groovemiami.com

aol/aim= nexusgroove
Find all posts by nexusgrooveView user's profileSend private message
Daniel-cmw
Site Admin
Site Admin


Joined: Mar 02, 2003
Posts: 1662

Location: The UK!

PostPosted: Fri Jan 02, 2004 2:51 pm Reply with quoteBack to top

Thanks, but this is a fix we have been giving for ages and has been posted before.

_________________
Read Me
Find all posts by Daniel-cmwView user's profileSend private message
telli
Support Mod
Support Mod


Joined: Aug 21, 2003
Posts: 335


PostPosted: Fri Jan 02, 2004 3:05 pm Reply with quoteBack to top

Well Daniel trying to search these Forums is like looking for a needle in a hay stack! So for others who dont have this fix THANK YOU for posting it.

Telli

There are quite a few versions of this fix available and many other mods that people have in their nuke_modules table so this is by far the best explanation for the newbies.

_________________
[img]http://www.codezwiz.com/extern.php?get=sig[/img]
http://www.codezwiz.com
PHPNuke Themes
$3.99 500 MB Storage & 20 GIG Trans w/ NO limit MYSQL
Click Me
Find all posts by telliView user's profileSend private message
nexusgroove
Private
Private


Joined: Nov 11, 2003
Posts: 37


PostPosted: Fri Jan 02, 2004 3:47 pm Reply with quoteBack to top

yeah I know... i seen many fixes out there..

but none worked for me.... and I am a newbie... so I tried to explain it in a newbe format....

the code that I found on the thread was,

Code:
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '0')", $dbi);


and wasn't working for me I was just missing just one more #.....

Just wanted to help those that are not masters of PHP and SQL....

here is the link to the zip that contains my module.php and block_module.php with instructions..



http://www.groovemiami.com/xsile/modules.php?name=Downloads&d_op=viewdownload&cid=2
Find all posts by nexusgrooveView user's profileSend private message
lost2
Sergeant
Sergeant


Joined: Nov 01, 2003
Posts: 136

Location: BANNED

PostPosted: Wed Jan 21, 2004 7:19 am Reply with quoteBack to top

i don't have that last MCID column Sad what am i doin wrong ?

_________________
B4nN3d
Find all posts by lost2View user's profileSend private messageSend e-mail
RoadKill
Nuke Cadet
Nuke Cadet


Joined: May 31, 2003
Posts: 9


PostPosted: Thu Feb 05, 2004 2:47 pm Reply with quoteBack to top

This should be a sticky, if it isn't already. It took me hours to find a fix for this. I tried the other fixes and none of them were working. I just tried this one and it worked perfectly. Nexusgroove, you are my hero. Thank you.
Find all posts by RoadKillView user's profileSend private messageVisit poster's websiteICQ Number
indigo_kore
Nuke Cadet
Nuke Cadet


Joined: Feb 20, 2004
Posts: 9


PostPosted: Thu Feb 19, 2004 11:22 pm Reply with quoteBack to top

Thank you so much nexusgroove, especially the pics. I tried using the search function and couldn't find it. I agree, this should be a sticky.
Find all posts by indigo_koreView user's profileSend private message
Daniel-cmw
Site Admin
Site Admin


Joined: Mar 02, 2003
Posts: 1662

Location: The UK!

PostPosted: Fri Feb 20, 2004 1:00 am Reply with quoteBack to top

I agree, its being asked allot lately. We will see if people actually read it.


Stuck.

_________________
Read Me
Find all posts by Daniel-cmwView user's profileSend private message
Neph
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 12


PostPosted: Mon Feb 23, 2004 8:36 pm Reply with quoteBack to top

The fix worked for the modules part, but I don't seem to see the line

$db->sql_query("INSERT INTO ".$prefix."_modules VALUES (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '1', '0')");

in the blocks.php. So I sit with my site idle unable to add blocks. Sad
Find all posts by NephView user's profileSend private message
ironcats
Nuke Cadet
Nuke Cadet


Joined: Feb 25, 2004
Posts: 4


PostPosted: Wed Feb 25, 2004 8:41 am Reply with quoteBack to top

lost2 wrote:
i don't have that last MCID column Sad what am i doin wrong ?


me 2 what should we do??
Find all posts by ironcatsView user's profileSend private message
Jeruvy
Lieutenant
Lieutenant


Joined: Jul 09, 2003
Posts: 293


PostPosted: Sat Feb 28, 2004 9:19 am Reply with quoteBack to top

This STICKY is useless. The instructions are not very clear, and with the patches I've seen the lines don't even match up.

This FIX needs to be updated, and noted that it affects BLOCKS AND MODULES, not one or the other...

J.

_________________
J.
j e r u v y a t y a h o o d o t c o m
Find all posts by JeruvyView user's profileSend private messageICQ Number
Jeruvy
Lieutenant
Lieutenant


Joined: Jul 09, 2003
Posts: 293


PostPosted: Sat Feb 28, 2004 9:28 am Reply with quoteBack to top

nexusgroove wrote:
OK.

I can explain this in a dummy proof of a way....


Better work harder...since November this bug is much bigger...


Quote:

go into to ur PHPMY ADMIN

go into the nuke_modules and click on browse

this will popup on the top;

Image


Too bad you site is down...

Quote:

ok. I'm not the PHP king here I just stay at a Holiday Inn Express.....

when u see people talking about the
Quote:
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1')", $dbi);
the part [$i]', '0', '0', '1')", only covers 3 tables of the db. witch will cause a problem not letting new added mods to appear.


No, I don't see this line....Where is it?

Quote:

so if u see that u have 5 tables your code will have to be ajusted to [$i]', '0', '0', '1', '1', '0')", on both admin/module/module.php Line # 47 and blocks/block_module.php line # 96


Line 47:
Code:
function modules() {


Line 96:
Code:
            }


So which lines are they?


Quote:

refer to the phpmyadmin and count the active|view|inmenu|mod_group|mcid


In my case I have 4, active, view, inmenu and mcid.

Quote:

so mine has 5 numbers but the string show
Quote:
$i]', '0', '0', '1')", $dbi);
3

so all u have to do is fix this string
in my case' my string to work right is this, notice 5 #'s in my module.php
Quote:
sql_query("insert into ".$prefix."_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '0', '0')", $dbi);


and now it works fine.

and for the blocks/block_module same change
Quote:
$db->sql_query("INSERT INTO ".$prefix."_modules VALUES (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '1', '0')");


should be on line #96 in the script.


Except I am not certain which lines are being modified as the patches and other mods have tampered with this. So it needs a clear explanation so people do not undo there patches.


I think we need someone with a bit more expertise than either of us to advise us the correct method to repair this.

J.
Find all posts by JeruvyView user's profileSend private messageICQ Number
Jeruvy
Lieutenant
Lieutenant


Joined: Jul 09, 2003
Posts: 293


PostPosted: Sat Feb 28, 2004 9:58 am Reply with quoteBack to top

I guess I should try to explain myself here. Ok here is one of the confuxing aspects of this problem. I'm sure its just that I don't fully understand what this code is doing and I'm hoping to gain some insight into this important part of the package.

This first section is from the default 7.0 distribution package:
Code:

   OpenTable();
    echo "<br><center><font class=\"option\">"._MODULESADDONS."</font><br><br>"
   ."<font class=\"content\">"._MODULESACTIVATION."</font><br><br>"
   .""._MODULEHOMENOTE."<br><br>"._NOTINMENU."<br><br>"
   ."<form action=\"admin.php\" method=\"post\">"
        ."<table border=\"1\" align=\"center\" width=\"90%\"><tr><td align=\"center\" bgcolor=\"$bgcolor2\">"
   ."<b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CUSTOMTITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._VIEW."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._GROUP."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
    $main_m = sql_query("select main_module from ".$prefix."_main", $dbi);
    list($main_module) = sql_fetch_row($main_m, $dbi);
    $result = sql_query("select mid, title, custom_title, active, view, inmenu, mod_group from ".$prefix."_modules order by title ASC", $dbi);
    while (list($mid, $title, $custom_title, $active, $view, $inmenu, $mod_group) = sql_fetch_row($result, $dbi)) {
        $mid = intval($mid);


This is my 'moshed' version from 6.8 thru the patches:
Code:

 OpenTable();
    echo "<br><center><font class=\"option\">"._MODULESADDONS."</font><br><br>"
   ."<font class=\"content\">"._MODULESACTIVATION."</font><br><br>"
   .""._MODULEHOMENOTE."<br><br>"._NOTINMENU."<br><br>"
   ."<form action=\"admin.php\" method=\"post\">"
        ."<table border=\"1\" align=\"center\" width=\"90%\"><tr><td align=\"center\" bgcolor=\"$bgcolor2\">"
   ."<b>"._TITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._CUSTOMTITLE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._VIEW."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
    $main_m = sql_query("select main_module from ".$prefix."_main", $dbi);
    list($main_module) = sql_fetch_row($main_m, $dbi);
    $result = sql_query("select mid, title, custom_title, active, view, inmenu, mcid from ".$prefix."_modules order by title ASC", $dbi);
    while(list($mid, $title, $custom_title, $active, $view, $inmenu, $mcid) = sql_fetch_row($result, $dbi)) {


So outside of the code differences I see a change in how this is evaluated. I don't see how this could be a problem but perhaps it is?

The old way would look at $mcid as part of it's evaluation, and now it uses $mod_group. Is there a bigger problem ignoring the $mod_group field?

The reason I ask is that I have been pretty successful at making 7.0 work without the addition of groups and point system. But I may have damaged my code in the process. My reviews into the blocks sections indicate everything is fine, but I never reviewed the modules and now I'm seeing major differences.

J.
Find all posts by JeruvyView user's profileSend private messageICQ Number
gear
Captain
Captain


Joined: May 14, 2003
Posts: 579

Location: Mid-Cities

PostPosted: Sat Feb 28, 2004 11:06 am Reply with quoteBack to top

The only fault I see with his explanation is he should have said "around line ##". Noone looks for the line number anywayz, they do a text search. I, like many others, was having problems getting 6.x version modules to show upon installation to 7.0. I, again like many others, followed his fix almost to the letter (except for the line numbers as explained above), and haven't had any problems since.

But then the patches came out and negated the need for the modifications -- unless you have the 5 fields Wink.

g
Find all posts by gearView user's profileSend private messageVisit poster's website
Jeruvy
Lieutenant
Lieutenant


Joined: Jul 09, 2003
Posts: 293


PostPosted: Sat Feb 28, 2004 12:58 pm Reply with quoteBack to top

Yea, I agree. But it didn't fix it for me. I've since reviewed the changes in modules and they are working fine. Adding Blocks however are still the problem for me.

I did think that it was a problem with a sql file I ran (assuming the ones with upgrades I may have ran without reviewing thoroughly...I should know better...) and putting the concepts learned in this thread to see if one of my tables wasn't matching up properly.

Sure enough, nuke_blocks had two additional fields that wasn't being updated in the course of blocksadd() events. Of course these were the new 7.0 fields 'expire' and 'action'. I removed these two fields and everything is back to normal.

Anyways I've at least assured myself that other than some self-conflicted confusion this patch method works fine, I just have to review sql files better Embarassed

J.
Find all posts by JeruvyView user's profileSend private messageICQ Number
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
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.266 Seconds - 144 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::