Wednesday, April 29, 2026

How to recover message from Google message app

 > Open google message app

> Click on profile icon and there is trash folder

>Reply the message(9355036914) in the Google Message app and you will see the message in Google Message App

or

If there is no profile icon visible in google message app

> Open any other app like "SMS Organizer" app from Microsoft and you will see all the messages. 


Thursday, April 23, 2026

Error in importing database in drupal - Missing expression. (near "ON" at position 25) - XAMPP - set foreign_key_checks on error

Missing expression. (near "ON" at position 25)

MYSQL

SET FOREIGN_KEY_CHECKS = ON;



Solution:-
Change max_allowed_packet=1 to max_allowed_packet=1024M in MY.ini
in PHP.ini add these four lines
 max_execution_time = 600
max_input_time = 600
memory_limit = 1024M
post_max_size = 1024M
upload_max_filesize=1024M

Also please check below link:-

Friday, April 10, 2026

select random range cell copy in vba excel - copy random cell in excel macro

 Sub Macro3()

    Dim Rng As Range

    Dim randomIdx As Long

   

    ' Set your target range

    Set Rng = Range("K3:K4591")


    ' Initialize the random number generator

    Randomize


    ' Generate a random index between 1 and the total number of cells

    randomIdx = Int(Rnd * Rng.Cells.Count) + 1

    

    ' Select the cell at that index

    Rng.Cells(randomIdx).Select

     Selection.Copy

End Sub


Wednesday, April 8, 2026

How to install drupal - How to run a website made in drupal

 Add this line in settings.php

$config['system.image']['toolkit'] = 'gd';

uncomment this line(for showing error log )

$config['system.logging']['error_level'] = 'verbose'; 

Customize below code

$databases['default']['default'] = array (

  'database' => 'rni_web',              //write data base that is blank, for new installation

  'username' => 'root',

  'password' => '',

  'prefix' => '',

  'host' => 'localhost',

  'port' => '3307',

  'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',

  'driver' => 'mysql',

  'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',

);


1) write data base that is blank, for new installation ( 'database' => 'rni_web',  )

2) after next , you will get errors  of gd than see below link

https://kapooryash.blogspot.com/2026/04/error-while-starting-my-sql-or-appache.html

3) if drupal new install than use it with that database, if website already modified or given by some other person than change database name with backup database(replace  ( 'database' => 'rni_web',  ) with other database)