[iclozm]

Hi All,

Its great to have my first post help out the community and I really have to say I LOVE PHP NUKE!!!!!!!!!

Lets get right to it. I found some information to fix this issue but none of it worked for me. I had a 3MB database and accumulated a couple of thousand posts and did NOT want to start over with a new DB like some people suggested. Heres what I did to have my cake and eat it too.

If this link doesn't help:
http://phpnuke.org/modules.php?name=PHP-Nuke_HOWTO&page=modules-disappear.html

Then use my method or you will find yourself wiping out your precious DB like this poor fellow and probably losing posts, PMs, etc.
http://www.karakas-online.de/forum/viewtopic.php?t=306

PROBLEM: Modules uploaded via FTP will not show in Administration Modules Menu / Existing modules disappear if name of Folder is changed.

WHATS CAUSING THIS: Its most likely what I did. I started with a PHP Install of 6.X then upgraded to 7.X without updating the MySQL tables. Therefore the module recognition incompatibility is bound to create a nightmare for you.

SOLUTION: Update ONLY the nuke_modules.sql table in your DB using a table from the lastest version you've updated your site to. Best thing is you don't lose any posts or data and everything is in-tact after this fix.

Heres how to do it.

Step one: Create a new DB from the latest Nuke Ver you updated for your website. Use the Nuke.sql from the ver that you are running, not from what you originally installed **** Very important! In my case it was 7.6 (new nuke.sql) from the old 6.X (old nuke.sql file) - At this point do not touch your original database.

Step Two: From the new database that you created you need to download only ONE TABLE. Use PHPMyAdmin and locate your nuke_modules.sql table. WRITE down the number of records that are reported from phpmyadmin. You need to export that and save as file on your desktop.

Now you have the CORRECT SQL Table so that the modules don't disappear and the modules you install will appear in your modules menu.

3) This is the part that will make some uneasy. You need to DELETE your nuke_modules.sql file in your EXISTING database. Your site will temporarily be out of service, probably 5-10 min.

4) This is where the magic happens. You now have your existing database stripped of its nuke_modules.sql table (old SQL setup) and will be replacing it with the new nuke.modules.sql table that is on your desktop. Go ahead and upload the new nuke_modules.sql file that is on your desktop to your existing DB. Input the number of records that the new nuke_modules.sql file has. Now you have literally patched your existing DB with an SQL table from the version of nuke you are running.

Give it a minute or two.

Goto yoursite.com/admin.php and login. Goto your modules menu and you will find everything that wasn't showing up before. TA DA!!!!!! PHP Nuke will automatically detect everyhing in your public_html(root)/modules folder.

Enjoy modules you couldn't find before. Using this method you can keep your entire DB in tact and find the missing modules.

[chris]

And you don't have any other problems, although you did not upgrade your tables thoroughly?

Strange...but thanks for the interesting info anyway!
_________________
Regards

Chris Karakas
www.karakas-online.de

[iclozm]

Oddly enough, the only thing I can't get to work is to increase the max characters of the users signatures. I'm trying to up it from 255 to 350 Haven't spent any time on it though.