How to retrieve a list of modules?

How to retrieve a list of modules in the Admin section->Modules? 

Go to add and manage.  You will see the list of installed modules and the list of modules that are not installed.

All modules are installed

Look, here's what a. Solution needed from SQL.

When did you first note this problem?  Did you upgrade?  Anything that might be associated.

Did you try Un-Installing and Re-Installing all the Modules?

DON'T UNINSTALL THE MODULES,

YOU WILL LOSE ALL DATA!

Please back up your database.

Please, don't do anything until some of the experienced Dolphin users can come in with this. 

Thank you. I will wait for messages from experienced users

I have been here 5+ years and this is one i have never seen before.

Looks like the sys_menu_admin table somehow got restored back to defaults. How i do not know.

But geek_girl asked a question you did not answer, so i will ask the questions again.

What was recently done? Any upgrades? Or is is a new install?

Will be kinda hard to fix this out if we can't figure out what caused it.

The problem began with the fact that some menu in the admin panel was gone. To restore phpAdmin and went to the table sys_menu_admin deleted all the lines. SQL created a query as shown in the file install \ sql \ v71 sys_menu_admin. From the menu, all restored, and the modules were missing.

If i read that correctly, then that's why. As i read this, you ran a query from the original install sql that replaced the sys_menu_admin table.

Not sure what you actually expected that query from the original install to do, but that's what it does. A new install starts with a empty menu because none of the modules are installed. So by running that query you put the menu back to what it was when dolphin was first installed.

Do you have any database backups? There is only 3 ways you are going to get that menu back.

1) Restore the sys_menu_admin table from a database backup from before this happened.

2) Uninstall and re-Install All of the modules. But this method will result in loss of all data for the modules.

3) Hire a professional developer to manually rebuild the missing menu entries for all of your modules.

As Deano stated, if you uninstall the modules, then you will lose all the data; such as photos, and videos and blog posts, and forum posts.

So, I would wait on that one.

As I said, I would go ahead and do a complete backup of the database as it is at this point.  Note: whenever you work on your database, the first step, or at least my first step, is to do a backup.  I know that oops can happen.  If you have a backup of your database before you ran the query, then let us know because that will help tremendously.

My suggestion is do number three, hire someone to rebuild the table.  If your site is important, you risk losing the site as it is now.  It is best to hire an experienced database person who knows Dolphin.

How about a 4th Option.

Take a SQL Insert Statement of the sys_menu_admin Table from a virgin 7.1.4 install to recover the Base Modules to start.

The original Poster hasn't really said if there were any Add-On Modules installed, but those could be recovered by taking the sys_menu_admin SQL Insert portions from the install.sql's for each Add-On Module.

This is how I would do it, but what do I know. :)

Yes. That would at least restore the default dolphin modules.

Now it looks to me from his .JPG Attachments that there might be a couple entries in that Table, so I'm not sure if it might be necessary to Truncate that sys_menu_admin Table first before you run the Virgin SQL Insert.

Good idea, set up a dummy site, install all the Dolphin modules in the installed list.  Then use that to rebuild the list of Dolphin modules.

Then look at the third party modules in the list.  Get the sys_menu_admin sql insert for each module and build a query to then add the third party modules.

If you don't think you have the skills to do this, let us know.

Here is a SQL Insert from a Virgin 7.1.4 Install that I did yesterday for the sys_menu_admin Table.

Thanks to all who responded to my problem. I made inquiries SQL but no change in my images. Here's requests

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'users', '_adm_mmi_users', '{siteAdminUrl}profiles.php', '', 'group col-green1', 'group', '', 2);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'modules', '_adm_mmi_modules', '', '', 'th-large col-red1', 'th-large', '', 3);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(@iParentId, 'manage_modules', '_adm_mmi_manage_modules', '{siteAdminUrl}modules.php', 'Manage and configure integration modules for 3d party scripts', 'plus col-red1', '', '', 1),

(@iParentId, 'flash_apps', '_adm_mmi_flash_apps', '{siteAdminUrl}flash.php', 'Flash Apps administration panel is available here', 'bolt col-red1', '', '', 2);

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'tools', '_adm_mmi_tools', '', '', 'wrench col-green3', 'wrench', '', 4);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(@iParentId, 'mass_mailer', '_adm_mmi_mass_mailer', '{siteAdminUrl}notifies.php', 'Using this function you are able to send a newsletter to your site members', 'envelope col-green3', '', '', 1),

(@iParentId, 'banners', '_adm_mmi_banners', '{siteAdminUrl}banners.php', 'Provides you with the ability to manage banners on your web site', 'flag col-green3', '', '', 4),

(@iParentId, 'ip_blacklist', '_adm_mmi_ip_blacklist', '{siteAdminUrl}ip_blacklist.php', 'IP Blacklist system', 'ban-circle col-green3', '', '', 6),

(@iParentId, 'database_backup', '_adm_mmi_database_backup', '{siteAdminUrl}db.php', 'Make a backup of your site database with this utility', 'download-alt col-green3', '', '', 7),

(@iParentId, 'host_tools', '_adm_mmi_host_tools', '{siteAdminUrl}host_tools.php', 'Admin Host Tools', 'hdd col-green3', '', '', 8),

(@iParentId, 'antispam', '_adm_mmi_antispam', '{siteAdminUrl}antispam.php', 'Antispam Tools', 'legal col-green3', '', '', 9),

(@iParentId, 'sitemap', '_adm_mmi_sitemap', '{siteAdminUrl}sitemap.php', 'Sitemap', 'sitemap col-green3', '', '', 10),

(@iParentId, 'cache', '_adm_mmi_cache', '{siteAdminUrl}cache.php', 'Cache', 'bolt col-green3', '', '', 11);

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'builders', '_adm_mmi_builders', '', '', 'reorder col-red2', 'reorder', '', 5);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(@iParentId, 'navigation_menu', '_adm_mmi_navigation_menu', '{siteAdminUrl}nav_menu_compose.php', 'For top menu items management', 'list col-red2', '', '', 1),

(@iParentId, 'service_menu', '_adm_mmi_service_menu', '{siteAdminUrl}service_menu_compose.php', 'For top service''s menu items management', 'list col-red2', '', '', 2),

(@iParentId, 'bottom_menu', '_adm_mmi_bottom_menu', '{siteAdminUrl}bottom_menu_compose.php', 'For top bottom''s menu items management', 'list col-red2', '', '', 3),

(@iParentId, 'member_menu', '_adm_mmi_member_menu', '{siteAdminUrl}member_menu_compose.php', 'For top member''s menu items management', 'list col-red2', '', '', 4),

(@iParentId, 'admin_menu', '_adm_mmi_admin_menu', '{siteAdminUrl}menu_compose_admin.php', 'For top admin''s menu items management', 'list col-red2', '', '', 5),

(@iParentId, 'profile_fields', '_adm_mmi_profile_fields', '{siteAdminUrl}fields.php', 'For member profile fields management', 'list-alt col-red2', '', '', 10),

(@iParentId, 'pages_blocks', '_adm_mmi_pages_blocks', '{siteAdminUrl}pageBuilder.php', 'Compose blocks for the site pages here', 'th-large col-red2', '', '', 20),

(@iParentId, 'mobile_pages', '_adm_mmi_mobile_pages', '{siteAdminUrl}mobileBuilder.php', 'Mobile pages builder', 'th col-red2', '', '', 21),

(@iParentId, 'predefined_values', '_adm_mmi_predefined_values', '{siteAdminUrl}preValues.php', '', 'list-ol col-red2', '', '', 30);

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'settings', '_adm_mmi_settings', '', '', 'cogs col-blue2', 'cogs', '', 6);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(@iParentId, 'admin_password', '_adm_mmi_admin_password', '{siteAdminUrl}settings.php?cat=ap', 'Change a password for access to administration panel here', 'asterisk col-blue2', '', '', 1),

(@iParentId, 'basic_settings', '_adm_mmi_basic_settings', '{siteAdminUrl}basic_settings.php', 'For managing site system settings', 'cog col-blue2', '', '', 2),

(@iParentId, 'advanced_settings', '_adm_mmi_advanced_settings', '{siteAdminUrl}advanced_settings.php', 'More enhanced settings for your site features', 'cogs col-blue2', '', '', 3),

(@iParentId, 'languages_settings', '_adm_mmi_languages_settings', '{siteAdminUrl}lang_file.php', 'For languages management your website is using and making changes in your website content', 'globe col-blue2', '', '', 4),

(@iParentId, 'membership_levels', '_adm_mmi_membership_levels', '{siteAdminUrl}memb_levels.php', 'For setting up different membership levels, different actions for each membership level and action limits', 'star col-blue2', '', '', 5),

(@iParentId, 'email_templates', '_adm_mmi_email_templates', '{siteAdminUrl}email_templates.php', 'For setting up email texts which are sent from your website to members automatically', 'paste col-blue2', '', '', 6),

(@iParentId, 'templates', '_adm_mmi_templates', '{siteAdminUrl}templates.php', 'Templates management', 'eye-open col-blue2', '', '', 7),

(@iParentId, 'categories_settings', '_adm_mmi_categories_settings', '{siteAdminUrl}categories.php', 'Categories settings', 'folder-close col-blue2', '', '', 15),

(@iParentId, 'watermark', '_adm_mmi_watermark', '{siteAdminUrl}settings.php?cat=16', 'Setting up watermark for media content', 'certificate col-blue2', '', '', 16);

-- Dashboard menu item

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'dashboard', '_adm_mmi_dashboard', '{siteAdminUrl}index.php', '', 'dashboard col-blue3', 'dashboard', '', 1);

SET @iParentId = LAST_INSERT_ID();

INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES

(0, 'license', '_adm_mmi_license', '{siteAdminUrl}license.php', '', 'key col-red3', 'key', '', 7);

SET @iParentId = LAST_INSERT_ID();

The database SQL table sys_modules there, but I can not manage. I look forward to your comments and solutions.

It's not the sys_modules table your changing. That table shows what modules are installed. It's the sys_menu_admin table that's damaged as that is the one that shows the items in that menu that are missing. So do not touch the sys_modules table or you will have more problems.


After the sql is run, dolphins cache must be cleared. Did you do that?

Not anything else we can do. If that failed, you going to need to have a professional look at it.

Yes I cleared the cache

This is what I think you should do.  Stop working on the database yourself.  Seek someone with experience to help you fix this issue.  Leave the modules as they are until you can get someone to fix this.

I've got 25 years experience working as a Computer Consultant. If you send me your login details I can probably straighten this out in about 5 minutes. I'm located in the United States and I live in Lake Havasu City, Arizona. My Company Name is Pro-Data.

If you have not already said yes, I would say yes to this offer and let a professional set things straight.

Syclops , You can write to me the steps to solve my problem.

I'm sorry no, I really don't know exactly what the problem is at this point in time without physically looking at your SQL Table.

It would be simpler and safer to let me do the work myself. 

@ Panfilvo

If you value the site, I would let a professional take a look at it.  If you have some concerns, discuss them with Syclops.  If you end up trashing the database, your site will be gone.

I understand no one has any solutions.

NO, there is a solution but you don't appear to have the skill level; we are not going to recommend anything more at this point.  That is why we are telling you to allow syclops to go in and fix it for you; he does have the skill level and that is the best recommendation in order to get your site back right without damaging anything else.

All I need to see is what is in your current Table, I can probably fix this in 5 minutes. But without taking a look at where you are at I can't write something to tell you how to fix it.

Anecdote.

In the hospital:

The visitor turns to the man that went out of the room in a medical lab coat, "Doctor, you gynecologist?"

A man in a medical lab coat, "I'm a therapist, but I can see"

Who has more ideas?

First, backup your current database.  This is one thing you can try; you might want to have someone to confirm this.  Set up a second site.  On the second site install all the modules you have installed on your current site, including third party modules.  When you have that done, then you can export the table from the second site that holds the list of installed modules, make sure you understand which table, sys_menu_admin; export the sys_menu_admin table.  Backup completely your current working database for your live site; oops can happen and when that does, if you don't have a complete backup your site is trashed and you get the pleasure of starting over.  Once you have a backup of the database, drop the sys_menu_admin table and then import the backup of sys_menu_admin from the second site.  Hopefully that will get all your installed modules back in the list.

Clear the caches.

And this made no sense.  You had offer of help from a professional and turned it down.  Baffles me.

Obviously does not want to let anyone into his server.

I can understand it. I don't let anyone in mine either, but then again, i can fix my own problems.

This situation requires someone look at it to find out what is going on so the situation does not become worse, so there is no choice in this case.

But i am guessing based on his bad analogy, he is saying we are a bunch of unqualified quacks trying to sneak a peek. At least that's how i interpreted it.

I did not mean to offend. Just a moment was like that.

Assume the bad in your address is not necessary. In any case, thanks to all for your participation in decision of my problem.

Hey, I could care less what is in this guys Server and I don't need to do work for free, but I offered. Oh well, his loss.

How many places are you going to get Free Work from a Professional with 25 Years of Computer Consulting Experience?

Answer = 0 

I would say at least one but I am thinking you have probably rescinded the offer.

I would recommend the following answer by Deano:

http://www.boonex.com/forums/topic/How-to-retrieve-a-list-of-modules-.htm#217335

Thank you. Your recommendation and your file sys_menu_admin.sql has helped me. This is a real help.

Syclops, Thank you. Your recommendation and your file sys_menu_admin.sql has helped me. This is a real help