2024-07-20 10:06:51 - INFO --> [REQ], Array
(
)

2024-07-20 10:06:51 - INFO --> 'FileName', 191984-1721469549-Institution_Sheet-Sheet1.csv
2024-07-20 10:06:51 - INFO --> 'instituteEntryId', 6
2024-07-20 10:06:51 - INFO --> 'instituteId', 1
2024-07-20 10:06:51 - INFO --> 'FileName', /var/www/html/campaign-manager/backend/script/1/191984-1721469549-Institution_Sheet-Sheet1.csv
2024-07-20 10:22:12 - INFO --> [REQ], Array
(
)

2024-07-20 10:22:12 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:22:12 - INFO --> 'instituteEntryId', 10
2024-07-20 10:22:12 - INFO --> 'instituteId', 1
2024-07-20 10:22:12 - INFO --> 'FileName', /var/www/html/PROJECTS/PANUKA/cms_backend/script/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:23:23 - INFO --> [REQ], Array
(
)

2024-07-20 10:23:23 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:23:23 - INFO --> 'instituteEntryId', 10
2024-07-20 10:23:23 - INFO --> 'instituteId', 1
2024-07-20 10:23:23 - INFO --> 'FileName', /var/www/html/PROJECTS/PANUKA/cms_backend/script/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:23:55 - INFO --> [REQ], Array
(
)

2024-07-20 10:23:55 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:23:55 - INFO --> 'instituteEntryId', 10
2024-07-20 10:23:55 - INFO --> 'instituteId', 1
2024-07-20 10:23:55 - INFO --> 'FileName', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:23:55 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [Gender], Age [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:23:55 - INFO --> select * from Customers where mobile='Mobile'
2024-07-20 10:23:55 - INFO --> insert into Customers (name, mobile, gender, age, city, country, pin, institute_entry_id) values ('Name', 'Mobile', 'Gender', 'Age', 'City', 'Country', 'Pin', '10')
2024-07-20 10:23:55 - INFO --> fileParser, User List Insert Error-mysqli_sql_exception: Unknown column 'age' in 'field list' in /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php:143
Stack trace:
#0 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(143): mysqli_query()
#1 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(90): insertUserDetail()
#2 {main}
2024-07-20 10:26:32 - INFO --> [REQ], Array
(
)

2024-07-20 10:26:32 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:26:32 - INFO --> 'instituteEntryId', 10
2024-07-20 10:26:32 - INFO --> 'instituteId', 1
2024-07-20 10:26:32 - INFO --> 'FileName', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:26:32 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [Gender], Date of Birth [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:26:32 - INFO --> select * from Customers where mobile='Mobile'
2024-07-20 10:26:32 - INFO --> insert into Customers (name, mobile, gender, dob, city, country, pin, institute_entry_id) values ('Name', 'Mobile', 'Gender', 'Age', 'City', 'Country', 'Pin', '10')
2024-07-20 10:26:32 - INFO --> fileParser, User List Insert Error-mysqli_sql_exception: Incorrect integer value: 'Gender' for column 'gender' at row 1 in /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php:143
Stack trace:
#0 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(143): mysqli_query()
#1 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(90): insertUserDetail()
#2 {main}
2024-07-20 10:31:58 - INFO --> [REQ], Array
(
)

2024-07-20 10:31:58 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:31:58 - INFO --> 'instituteEntryId', 10
2024-07-20 10:31:58 - INFO --> 'instituteId', 1
2024-07-20 10:31:58 - INFO --> 'FilePath', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:31:58 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [Gender], Date of Birth [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:31:58 - ERROR --> fileParser, User List Insert Error-mysqli_sql_exception: Incorrect integer value: 'Gender' for column 'gender' at row 1 in /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php:133
Stack trace:
#0 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(133): mysqli_query()
#1 /var/www/html/PROJECTS/PANUKA/cms_backend/script/fileParser.php(88): insertUserDetail()
#2 {main}
2024-07-20 10:33:50 - INFO --> [REQ], Array
(
)

2024-07-20 10:33:50 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:33:50 - INFO --> 'instituteEntryId', 10
2024-07-20 10:33:50 - INFO --> 'instituteId', 1
2024-07-20 10:33:50 - INFO --> 'FilePath', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:33:50 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [0], Date of Birth [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:33:50 - INFO --> Duplicate Entry Found in DB with Mobile [Mobile]
2024-07-20 10:36:50 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:36:50 - INFO --> 'instituteEntryId', 10
2024-07-20 10:36:50 - INFO --> 'instituteId', 1
2024-07-20 10:36:50 - INFO --> 'FilePath', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:36:50 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [0], Date of Birth [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:36:50 - INFO --> Duplicate Entry Found in DB with Mobile [Mobile]
2024-07-20 10:37:14 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:37:14 - INFO --> 'instituteEntryId', 10
2024-07-20 10:37:14 - INFO --> 'instituteId', 1
2024-07-20 10:37:14 - INFO --> 'FilePath', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:37:14 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [Gender], Date of Birth [], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:37:14 - INFO --> Duplicate Entry Found in DB with Mobile [Mobile]
2024-07-20 10:38:32 - INFO --> FileName, 264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:38:32 - INFO --> 'instituteEntryId', 10
2024-07-20 10:38:32 - INFO --> 'instituteId', 1
2024-07-20 10:38:32 - INFO --> 'FilePath', /var/www/html/PROJECTS/PANUKA/cms_backend/uploads/institute/1/264051-1721470803-Institution_Sheet-Sheet1.csv
2024-07-20 10:38:32 - INFO --> Data: Name [Name], Mobile [Mobile], Gender [Gender], Date of Birth [Age], City [City], Country [Country], CourseId [Course Id], Plan Type [Plan Type], Pin [Pin]
2024-07-20 10:38:32 - INFO --> Duplicate Entry Found in DB with Mobile [Mobile]
