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:-

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

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)

Error while starting My sql or Appache in Xampp server

 https://webolute.com/blog/programming/this-may-be-due-to-a-blocked-port-missing-dependencies/

and for My sql, use below steps

Open the XAMPP Control Panel and click Config next to MySQL, then select my.ini.

Find the lines port=3306 (usually in two places) and change them to port=3307.

next step

If going to localhost:8000 get error than change the config.inc.php, enter the password in string $cfg['Servers'][$i]['password'] = 'root';

and change

$cfg['Servers'][$i]['controluser'] = 'pma'; to  $cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = '';$cfg['Servers'][$i]['controluser'] = 'root';

=========================================

C:/xampp/php/php.ini

C:/xampp/apache/conf/httpd.conf

C:/xampp/mysql/bin/my.ini

C:/xampp/phpMyAdmin/config.inc.php

These above 4 files are changed.

C:/xampp/phpMyAdmin/config.inc.php

/* Authentication type and info */

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = 'root';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */

$cfg['Servers'][$i]['host'] = '127.0.0.1:3306';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = 'root';

and for xampp server- default password is blank

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['extension'] = 'mysqli';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */

$cfg['Servers'][$i]['host'] = '127.0.0.1:3307';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = '';

 

=======================

C:/xampp/mysql/bin/my.ini - How to change the port of Mysql in xampp

port=3306

socket="C:/xampp/mysql/mysql.sock"

# Here follows entries for some specific programs 

# The MySQL server

default-character-set=utf8mb4

[mysqld]

port=3306

socket="C:/xampp/mysql/mysql.sock"

basedir="C:/xampp/mysql"

C:/xampp/apache/conf/httpd.conf(How to change port of Appache server in xampp) 

For changing https port

Listen 80 -- change here

ServerName localhost:80

C:/xampp/php/php.ini

if getting error "plugin does not exist. Valid plugin IDs for Drupal\Core\ImageToolkit\ImageToolkitManager are: gd in Drupal\Core\Plugin\DefaultPluginManager-"

1) Press Ctrl + F and search for ;extension=gd.

2) Remove the semicolon (;) at the beginning of the line so it looks like this: extension=gd.

3) restart xaamp server

and

Add or uncomment the following line in your php.ini file: zend_extension=opcache.

Verify Settings: Ensure opcache.enable=1 is set in your php.ini.

c:\xampp\apache\conf\extra\httpd-ssl.conf

SSL port 4443

c:\xampp\apache\conf\extra\httpd-xampp.conf

if appache is not running than change this file.

c:\xampp\mysql\bin\my.ini

port=3307

C:\xampp\htdocs\PRGIWebsitedrupal\sites\default\settings.php

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

For more drupal settings, please see link below.

https://kapooryash.blogspot.com/2026/04/how-to-install-drupal-how-to-run.html

Note:- In settings.php file port can be 3306 of Mysql workbench client and In My.ini port can be different(3307) because appache server my sql is different and mysql workbench is different.

System.InvalidOperationException: ExecuteScalar: Connection property has not been initialized.

 This error comes when you write below code:-

using (SqlCommand cmd=new SqlCommand("SELECT TOP 1 [FileID]  FROM [UploadFiles] order by Fileid desc"))

and not passed con as second parameter in SqlCommand. Use below code

using (SqlCommand cmd=new SqlCommand("SELECT TOP 1 [FileID]  FROM [UploadFiles] order by Fileid desc", con))

also you have to add below line

cmd.CommandType = System.Data.CommandType.Text;

If error occurs in visual studio that iisexpress.exe access is denied and you build the web site it shows no error but it is having error

Than Run visual studio as administrator 

A network-related or instance-specific error occurred while establishing a connection to SQL Server. Error

>First open services.msc from wondow + r (Window Services)

> Then right click on sql server (SQL express)

>go to Properties. 

Then go to Log On tab and select Local System account. 

Click on Ok button and start the service.

iis http error 404.3 – not found (add a mime map)

https://superuser.com/questions/1218375/turn-windows-features-on-or-off-opens-server-manager

https://www.revelation.com/WebHelp/OpenInsight%2010%20O4W%202.0%20Quick%20Start%20Guide/O4W_008.jpg

https://www.webhosting.uk.com/kb/iis-http-error-404-3-not-found-add-a-mime-map/

https://stackoverflow.com/questions/6425442/http-error-404-3-not-found-in-iis-7-5

https://kb.blackbaud.com/knowledgebase/Article/52195

https://stackoverflow.com/questions/7083533/http-er

Error Image below:-

ror-404-17-not-found

Error in ASP.Net Application - Cannot continue the execution because the session is in the kill state

 

Error External table is not in the expected format, while uploading excel file in ASP.NET C#

 Use Firefox instead of Chrome