Solved Bugs

1. Articles in “Needs Review” were not visible in Needs Review Page to the editor and publisher

   • Go to Structure >> Views >> Workbench Moderation : Content >> Edit
   • Select the “Needs Review page” Tab
   • Go to Advanced >> Query settings >> select “Disable SQL rewriting” option

2. Communities were private by default. Content was not visible to non-members. Solution : Install “Organic groups access control” module

   • Install of access control and enable it
   • Go to Configuration >> OG field settings >> Bundle = “Community” , Fields = “Group Visibility">> Add field
   • Go to Content type >> Edit Community >> Manage Fields >> Add “Group Visibility” field Now the creator can select “private” or “public” option while creating a Community

3. Apache Solr Attachments PDOException SQLError 1171. For SQL 5.7 a change in schema is required to enable 'not null' entries.

   • Get the patch file from https://www.drupal.org/node/2803667 or use the one here.
   • Paste the patch in the sites/all/modules/apachesolr_attachments/
   • Apply the patch to the apachesolr_attachments.install file with the following command
   • patch apachesolr_attachments.install -i {pathfile}.patch

4. FTP installation error:

   Command to give permissions to the apache user www-data for the drupal files :

   sudo chown -R www-data:www-data /var/www/html/drupal

5. Error while saving a quiz with quiz_userpoints addon.

   Error: Call to undefined function bootstrap_form_process() in form_builder() (line 1871 of /var/www/html/portal /includes/form.inc).

   sudo nano /etc/php/7.0/cli/php.ini

   Description: Updated max_input_vars to 3000. It had a default value of 1000. This var limits the count of input variables in a form to protect the server from a DOS attack for example. My drupal setup had surpassed this limit hence increasing the limit to 3000 solved the problem.

   One problem i faced was to locate the correct php.ini file for my apache server and these links will help someone facing the issue.

   • Path to correct php.ini file
   • Function to echo correct php.ini file that is loaded

6. MLTag Error:

   • PDOException: SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL;

     Solution: Apply patch from https://www.drupal.org/node/2840153. This error is for Mysql 5.7 were a not null has to be specified at the time of creation of the table.

   • Notice: Undefined index: in mltag_form_alter() (line 183 of mltag.module)

     Solution: Enable Translation for Tag field.

   • Undeclared function porterstemmer_stem in mltag.module

     Solution: include the line below as the first line,

     Module_load_include ('inc', 'porterstemmer', 'includes/standard-stemmer');

     in the sites/all/modules/mltag/includes/stopwords.inc function sentenceRemoveStopwords($sentences).