I have been installing and uninstalling modules on my site and I am starting to run into problems involving re installing previously disabled modules.  The install script is finding old database tables from previous module installations and is refusing to install.  For some of these modules, there is no 'uninstall' option.  Is there a good way to determine which database table are associated with each module?  I'm looking for a method of discovery or an online list.
123831
Is there a module that lists which tables are created, owned or modified by a particular module?  I need something that can show me what tables are created or modified by when new modules are installed.
83828
It's got to be somewhere in the phpinfo() dump, but I just don't know where.  Is it supposed to be under the "Additional Modules" section?  Somewhere else?  I'm trying to figure out why some extensions don't appear to be loaded, but I don't even know where I should be looking.
89337
I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc.  Do you use flat files with an external version control system?  Triggers? Other software?
79067
I'm been taxed with the task of creating an application that pulls data from our Micros Point of Sales system. The POS is using a Sybase database running on one of our servers. The database schema is very convoluted. I've been able to figure out most of the schema to gain access to the data I need, however, there are a few things still left to find. I know what they are called in the actual POS, but I can't seem to find them anywhere in the database (although I haven't actually looked through all 200+ tables).  I'm wondering if there's any way to run a query to search for a specific string in all the columns in all the tables. BTW, I'm using the "Interactive SQL" application that comes with the Sybase Database Client software to connect to the database.
26033
I'm new to drupal and I need some help.  I created a new module with name user_extra. Which create necessery table when Installing the module.  But I also need to insert some database field in 'users_field_data' table ('user_extra_id' and 'user_office')  In baseFieldDefinitions I wrote all necessery database table fields for user_extra table.   public static function baseFieldDefinitions(EntityTypeInterface $entity_type) {     // Standard field, used as a unique if primary index.     $fields['id'] = BaseFieldDefinition::create('integer')         -&gt;setLabel(t('Unit ID'))         -&gt;setDescription(t('The unit ID.'))         -&gt;setReadOnly(TRUE)         -&gt;setSetting('unsigned', TRUE);      $fields['uuid'] = BaseFieldDefinition::create('uuid')         -&gt;setLabel(t('UUID'))         -&gt;setDescription(t('The unit UUID.'))         -&gt;setReadOnly(TRUE);         .         .         .     $fields['user_info'] = BaseFieldDefinition::create('string')         -&gt;setLabel(t('User Info'))         -&gt;setDescription(t("The User Info"))         -&gt;setSetting('max_length', 255)         -&gt;setDisplayOptions('form', array(           'type' =&gt; 'string_textfield',           'weight' =&gt; 10,         ))         -&gt;setDisplayConfigurable('form', TRUE);      return $fields;      }   When I install the module it inserts all values that I define in baseFieldDefinitions.  But I also need to create 'user_extra_id' and 'user_office' in 'users_field_data' table with setDisplayOptions and setDisplayConfigurable options.  This is the commenting that I made in entity file  /**  * @ContentEntityType(  *   id = "user_extra",  *   label = @Translation("user extra"),  *   handlers = {  *     "storage" = "Drupal\user_extra\UserextraStorage",  *     "storage_schema" = "Drupal\user_extra\UserextraStorageSchema",  *     "access" = "Drupal\user_extra\UserextraAccessControlHandler",  *     "list_builder" = "Drupal\user_extra\UserextraListBuilder",  *     "view_builder" = "Drupal\user_extra\UserextraViewBuilder",  *     "views_data" = "Drupal\user_extra\UserextraViewsData",  *     "form" = {  *       "default" = "Drupal\user_extra\Form\UserextraForm",  *       "add" = "Drupal\user_extra\Form\UserextraAddForm",  *       "edit" = "Drupal\user_extra\Form\UserextraEditForm",  *       "delete" = "Drupal\user_extra\Form\UserextraDeleteForm",  *     }  *   },  *   admin_permission = "administer user_extra",  *   base_table = "user_extra",  *   entity_keys = {  *     "id" = "id",  *     "label" = "name",  *     "uuid" = "uuid",  *   },  *   links = {  *     "canonical" = "/admin/user_extra/{user_extra}",  *     "add-form" = "/admin/user_extra/add",  *     "delete-form" = "/admin/user_extra/{user_extra}/delete",  *     "overview-form" = "/admin/user_extra/${user_extra}/overview",  *     "edit-form" = "/admin/user_extra/{user_extra}",  *     "collection" = "/admin/user_extra",  *     "children" = "/admin/user_extra/{user_extra}/children",  *   },  * )  */
85405
I’m having some trouble in recreating a database with a one-to-many (1:M) relationship between Users and Items. This is pretty straightforward, yes; however, each Item belongs to a certain Category (e.g., a Car, a Boat or a Plane), and each Category has a particular number of attributes, e.g.: Car structure: +----+--------------+--------------+ | PK | Attribute #1 | Attribute #2 | +----+--------------+--------------+  Boat structure: +----+--------------+--------------+--------------+ | PK | Attribute #1 | Attribute #2 | Attribute #3 | +----+--------------+--------------+--------------+  Plane structure: +----+--------------+--------------+--------------+--------------+ | PK | Attribute #1 | Attribute #2 | Attribute #3 | Attribute #4 | +----+--------------+--------------+--------------+--------------+  Because of this diversity in the number of attributes (columns), I initially thought it would be a good idea to create one separate table for each Category, so I would avoid several NULLs and thus making a better use of the indexing. Although it looked great at first, I couldn’t find a way to create the relationship between the Items and the Categories through the database because, at least in my modest experience as a database administrator, when creating Foreign Keys, I inform explicitly a database the table name and column. In the end, I would like a solid structure to store all data, while having all the means to list all attributes of all Items a User may have with one query. I could hardcode dynamic queries with the server-side language, but I feel this is wrong and not very optimal. Additional information These are my responses to MDCCL comments:  1. How many Item Categories of interest are there in your business context, three (i.e., Cars, Boats and Planes) or more?  In fact, it’s very simple: There are only five Categories in total.  2. Will the same Item always belong to the same User (that is, once a given Item has been “assigned” to a certain User it cannot be changed)?  No, they could change. In the fictional scenario of the question, it would be like User A sells Item #1 for User B, so the ownership must be reflected.  3. Are there attributes that are shared by some or all of the Categories?  Not shared but, from memory, I can tell that at least three attributes are present in all Categories.  4. Is there a chance that the cardinality of the relationship between User and Item is many-to-many (M:N) instead of one-to-many (1:M)? For example, in the case of following business rules: A User owns zero-one-or-many Items and An Item is owned by one-to-many Users  No, because Items would describe a physical object. Users will have a virtual copy of them, each one identified by a unique   5. Regarding your following response to one of the question comments:  “In the fictional scenario of the question, it would be like User A sells Item #1 for User B, so the ownership must be reflected.”  It seems that you are planning to keep track of the item ownership evolution, so to speak. In this way, which attributes would you like to store about such phenomenon? Only the modification of the attribute that indicates the specific User who is the Owner of a specific Item?  No, not really. The ownership may change, but I don’t need to keep track of the previous Owner.
13941
Seeing there are various ways to install on Ubuntu. What are the various ways to uninstall items?  Which ways always work? How can I be sure something was uninstalled?
50956
I'm maintaining a database that is being shared by a few systems. Over the years a few of those systems have been deprecated and lots of the tables are actually orphaned. Is there a query I can run to find out which tables have not been used since a certain date?  Thanks.
15336
In SQL Server 2005, is there a way to find users that either don't exist at the server level (an account that was deleted at server level but wasn't disassociated from databases before it was deleted) or accounts that aren't linked (an account may have been deleted at the server level but not db level, then readded but the db level was never cleaned up).  I've got a very messy server and it would be awesome if there was a query to run to find these.
65748
I'm trying to decide on an uninstaller that does before and after system scans.  So far, I've come across these three:   CleanApp (syniumsoftware.com/cleanapp/) - which I saw someone recommend in  Yank (matterform.com/mac_software/uninstaller/index.html) Uninstaller (macmagna.com/)   So I was hoping if anyone on here has any tips or recommendations on these or any others.  Thanks!
121874
I just finished installing mysql-server, and then installed phpmyadmin which came with Apache and PHP. It set it up alright and made a phpMyAdmin database, but I can't seem to find the URL to get to it -- I tried going to  but it doesn't seem to be there.  I can't find the location in any of the manuals, does anyone know where this is located? Thanks.
94333
Every now and then, mostly when looking at a new site, I find myself wanting to know   What's the source of this particular page?  Usually, I end up starting to dig in the menu_router table, and possibly also alias tables. Is there a module that will be helpful in finding and displaying this, and other relevant, information for me?
15590
In Drupal 7, I could manually edit the {system} table in the database to disable a stubbon module.  In my Drupal 8 site, this table is gone.  How can I manually disable a module in Drupal 8?
98303
I'm basically looking for an unattended way to deploy/install the  collection into several Ubuntu boxes. I've searched for PPAs, packages or user scripts but without much luck.  Any advice will be much appreciated. Thanks a lot in advance!
3695
I've done the following:  sudo add-apt-repository ppa:ondrej/php5-5.6 sudo apt-get update sudo apt-get upgrade sudo apt-get install php5 sudo apt-get install libapache2-mod-php5.6 sudo add-apt-repository ppa:ondrej/apache2   When I try to disable the old version of php5 with:  sudo phpdismod php5   I get the error: WARNING: Module php5 ini file doesn't exist under /etc/php/5.6/mods-available  Even if I move the ini file under this directory it gives me the same error.  I don't know what I'm missing??  In general, can someone explain to me how to get my instance to use the newly installed version, as I still seem to have both php directory trees on my instance.  php5/.. and php/5.6
117744
I happen to read through the commented lines in settings.php under the "Database settings" (around line no. 45) the following text:     Some database engines support transactions. In order to enable transaction support for a given database, set the 'transactions' key to TRUE. To disable it, set it to FALSE.   Note that the default value varies by driver.  For MySQL, the default is FALSE since MyISAM tables do not support transactions.   My databases array, auto-generated by Drupal Installer, is the following one:  $databases = array(   'default' =&gt; array(     'default' =&gt; array(       'database' =&gt; 'test_db',       'username' =&gt; 'root',       'password' =&gt; '',       'host' =&gt; 'localhost',       'port' =&gt; '',       'driver' =&gt; 'mysql',       'prefix' =&gt; '',     ),   ), );   Is it true that my site is not transaction aware until I add a key/value, 'transaction' =&gt; TRUE (preferably after 'prefix' =&gt; '') to $databases?
5813
So I'm cleaning out an old computer, and several of the programs it thinks it has were actually installed on an old drive, that's now gone. For some of them, it prompts to get rid of them because it can't find the drive, so that's all well and good.  But, for LibreOffice and a couple of others, it tries to run the LibreOffice Uninstaller, and only quits with a fatal error when the LibreOffice uninstaller can't find the drive.   The difference here is that in the first case, Windows can't even find the drive with the uninstallers on them, so it prompts to remove them; but in the second, its found the uninstallers on the local disk somewhere and is trying to run them, prompting a fatal error when the uninstaller can't find them.  What should I do here? How can I remove what's left of these programs/erase their names from the family tree?  Thanks!  evamvid