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 |
Quick Actions
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';