Approval Process Diagnostics

Purpose: This page helps diagnose issues with the institute approval process.
Database Status
Database Connection Connected
Database Provider Pomelo.EntityFrameworkCore.MySql
Connection String Server=172.16.5.36;Database=temp_test;User=developer;Password=Urgw5Sk@NW$BT3T3;port=8567;CharSet=utf8mb4;AllowPublicKeyRetrieval=true;SslMode=none;ConnectionTimeout=30;MaxPoolSize=100;MinPoolSize=5
Table Status
Institutes Table Does Not Exist
Sequence Table Does Not Exist
Sequence Table Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'last_value int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id' at line 3
Institute Statistics
Institutes Table Does Not Exist
Sequence Table Does Not Exist
Sequence Table Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'last_value int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id' at line 3
Institute Count 12
Approved Institutes 12
Pending Institutes 0
Error Information
Sequence Table Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'last_value int(11) NOT NULL DEFAULT 0, PRIMARY KEY (id' at line 3
Common Issues and Solutions

Issue: The institute_code_sequence table doesn't exist.

Solution: Run this SQL script:

CREATE TABLE IF NOT EXISTS `institute_code_sequence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `last_value` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT IGNORE INTO `institute_code_sequence` (`id`, `last_value`) VALUES (1, 0);

Issue: Cannot connect to the database.

Solutions:

  • Check if the database server is running
  • Verify the connection string in appsettings
  • Check network connectivity to the database server
  • Verify database user permissions

Issue: Database user doesn't have required permissions.

Solution: Grant the following permissions to the database user:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP 
ON temp_test.* TO 'developer'@'any_host';