[1, 14:40:39] SELECT * FROM sakila.actor LIMIT 0, 1000 : Running... [1, 14:40:40] SELECT * FROM sakila.actor LIMIT 0, 1000 : Fetching... [1, 14:40:40] SELECT * FROM sakila.actor LIMIT 0, 1000 : 200 row(s) returned [2, 14:41:05] SELECT * FROM sakila.actor LIMIT 0, 1000 : Running... [2, 14:41:05] SELECT * FROM sakila.actor LIMIT 0, 1000 : Fetching... [2, 14:41:05] SELECT * FROM sakila.actor LIMIT 0, 1000 : 200 row(s) returned [3, 14:41:57] Apply changes to Matrimony: Preparing... [3, 14:42:22] Applying changes to matrimony...: [3, 14:42:22] : Changes applied to matrimony [3, 14:42:24] Apply changes to Matrimony: Changes applied [4, 14:58:16] Apply changes to Profile: Preparing... [4, 15:00:49] Applying changes to profile...: [4, 15:02:29] Applying changes to profile...: [4, 15:02:29] : Changes applied to profile [4, 15:02:43] Apply changes to Profile: Changes applied [1, 15:03:34] SELECT * FROM PROFILE LIMIT 0, 1000 : Running... [1, 15:03:35] SELECT * FROM PROFILE LIMIT 0, 1000 : Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. [2, 15:03:57] SELECT * FROM matrimony.profile LIMIT 0, 1000 : Running... [2, 15:03:57] SELECT * FROM matrimony.profile LIMIT 0, 1000 : Fetching... [2, 15:03:57] SELECT * FROM matrimony.profile LIMIT 0, 1000 : 0 row(s) returned [3, 15:04:15] EXPLAIN SELECT * FROM matrimony.profile: Executing [3, 15:04:15] EXPLAIN SELECT * FROM matrimony.profile: OK [4, 15:04:15] EXPLAIN FORMAT=JSON SELECT * FROM matrimony.profile: Executing [4, 15:04:15] EXPLAIN FORMAT=JSON SELECT * FROM matrimony.profile: OK [5, 15:24:26] Apply changes to Album: Preparing... [5, 15:25:07] Applying changes to album...: [5, 15:25:12] : Changes applied to album [5, 15:25:22] Apply changes to Album: Changes applied [6, 15:25:30] SELECT * FROM matrimony.album LIMIT 0, 1000 : Running... [6, 15:25:30] SELECT * FROM matrimony.album LIMIT 0, 1000 : Fetching... [6, 15:25:31] SELECT * FROM matrimony.album LIMIT 0, 1000 : 0 row(s) returned [7, 15:27:49] Apply changes to Album: Preparing... [7, 15:27:53] Apply changes to Album: No changes detected [1, 17:39:34] SELECT * FROM matrimony.viewlog LIMIT 0, 1000 : Running... [1, 17:39:34] SELECT * FROM matrimony.viewlog LIMIT 0, 1000 : Fetching... [1, 17:39:34] SELECT * FROM matrimony.viewlog LIMIT 0, 1000 : 0 row(s) returned [2, 17:39:49] SELECT * FROM matrimony.userdetails LIMIT 0, 1000 : Running... [2, 17:39:49] SELECT * FROM matrimony.userdetails LIMIT 0, 1000 : Fetching... [2, 17:39:49] SELECT * FROM matrimony.userdetails LIMIT 0, 1000 : 0 row(s) returned [3, 17:39:54] SELECT * FROM matrimony.usertype LIMIT 0, 1000 : Running... [3, 17:39:54] SELECT * FROM matrimony.usertype LIMIT 0, 1000 : Fetching... [3, 17:39:54] SELECT * FROM matrimony.usertype LIMIT 0, 1000 : 0 row(s) returned [4, 17:43:56] Apply changes to _SYNTAX_ERROR: Preparing... [4, 17:44:09] Applying changes to _SYNTAX_ERROR...: [4, 17:45:04] Apply changes to _SYNTAX_ERROR: Error 1064: 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 '@fromProfileID varchar(12),@toProfileID varchar(12)) BEGIN delete from ExpressIn' at line 1 SQL Statement: CREATE PROCEDURE `deleteExistiongFromExpressInterest` (@fromProfileID varchar(12),@toProfileID varchar(12)) BEGIN delete from ExpressInterest where FromProfileId=@fromProfileID and ToProfileId=@toProfileID END [5, 17:48:29] Apply changes to deleteExistiongFromExpressInterest: Preparing... [5, 17:48:34] Applying changes to deleteExistiongFromExpressInterest...: [5, 17:48:34] : Changes applied to deleteExistiongFromExpressInterest [5, 17:48:36] Apply changes to deleteExistiongFromExpressInterest: Changes applied [6, 18:58:09] Apply changes to GetContactInfo: Preparing... [6, 18:58:11] Applying changes to GetContactInfo...: [6, 18:58:11] : Changes applied to GetContactInfo [6, 18:58:12] Apply changes to GetContactInfo: Changes applied [7, 19:09:01] Apply changes to GetCountOfActiveUserByLoggedProfileID: Preparing... [7, 19:09:03] Applying changes to GetCountOfActiveUserByLoggedProfileID...: [7, 19:09:18] Apply changes to GetCountOfActiveUserByLoggedProfileID: Error 1313: RETURN is only allowed in a FUNCTION SQL Statement: CREATE PROCEDURE `GetCountOfActiveUserByLoggedProfileID` () BEGIN declare cnt int; set cnt= (select COUNT(*) from Profile where IsActive='false'); return cnt; END [8, 19:15:43] Apply changes to GetCountOfActiveUserByLoggedProfileID: Preparing... [8, 19:15:45] Applying changes to GetCountOfActiveUserByLoggedProfileID...: [8, 19:15:45] : Changes applied to GetCountOfActiveUserByLoggedProfileID [8, 19:15:46] Apply changes to GetCountOfActiveUserByLoggedProfileID: Changes applied [9, 19:18:50] Apply changes to GetCountOfInActiveUserByLoggedProfileID: Preparing... [9, 19:18:52] Applying changes to GetCountOfInActiveUserByLoggedProfileID...: [9, 19:18:52] : Changes applied to GetCountOfInActiveUserByLoggedProfileID [9, 19:18:54] Apply changes to GetCountOfInActiveUserByLoggedProfileID: Changes applied [10, 19:37:07] Apply changes to GetCountOfOnlineUserByLoggedProfileID: Preparing... [10, 19:37:09] Applying changes to GetCountOfOnlineUserByLoggedProfileID...: [10, 19:37:09] : Changes applied to GetCountOfOnlineUserByLoggedProfileID [10, 19:37:10] Apply changes to GetCountOfOnlineUserByLoggedProfileID: Changes applied [11, 19:48:11] Apply changes to GetCountOfOnlineUserByLoggedProfileID: Preparing... [11, 19:48:11] Apply changes to GetCountOfOnlineUserByLoggedProfileID: No changes detected [12, 19:48:13] Apply changes to GetCountOfOnlineUserByLoggedProfileID: Preparing... [12, 19:48:13] Apply changes to GetCountOfOnlineUserByLoggedProfileID: No changes detected [1, 01:09:59] Apply changes to GetCountOfTotalUserByLoggedProfileID: Preparing... [1, 01:10:02] Applying changes to GetCountOfTotalUserByLoggedProfileID...: [1, 01:10:02] : Changes applied to GetCountOfTotalUserByLoggedProfileID [1, 01:10:04] Apply changes to GetCountOfTotalUserByLoggedProfileID: Changes applied [2, 01:23:15] Apply changes to GetDataFromTables: Preparing... [2, 01:23:27] Applying changes to GetDataFromTables...: [2, 01:23:27] : Changes applied to GetDataFromTables [2, 01:23:28] Apply changes to GetDataFromTables: Changes applied [1, 12:59:06] Could not connect, server may not be running.: Can't connect to MySQL server on '127.0.0.1' (10061) [1, 13:00:41] use matrimony: Running... [1, 13:00:41] use matrimony: 0 row(s) affected [2, 13:00:56] select * from album LIMIT 0, 1000 : Running... [2, 13:00:56] select * from album LIMIT 0, 1000 : Fetching... [2, 13:00:56] select * from album LIMIT 0, 1000 : 0 row(s) returned [3, 13:13:49] Apply changes to GetDataInPercentage: Preparing... [3, 13:13:54] Applying changes to GetDataInPercentage...: [3, 13:13:54] : Changes applied to GetDataInPercentage [3, 13:13:56] Apply changes to GetDataInPercentage: Changes applied [4, 13:19:31] Apply changes to GetDefaultSearchGrid: Preparing... [4, 13:19:33] Applying changes to GetDefaultSearchGrid...: [4, 13:19:33] : Changes applied to GetDefaultSearchGrid [4, 13:19:34] Apply changes to GetDefaultSearchGrid: Changes applied [5, 13:19:54] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [5, 13:19:54] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATENAME does not exist [6, 13:20:08] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [6, 13:20:08] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATENAME does not exist [7, 13:20:19] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [7, 13:20:19] SELECT (RTRIM((DATENAME(DD,CREATEDATE))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATENAME does not exist [8, 13:27:27] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [8, 13:27:27] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATENAME(YY,CREATEDATE))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATEPART does not exist [9, 13:28:14] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [9, 13:28:14] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATEPART does not exist [10, 13:29:46] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [10, 13:29:46] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATEPART(MM,CREATEDATE))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATEPART does not exist [11, 13:35:53] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [11, 13:35:53] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_Gender' in 'where clause' [12, 13:36:00] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC: Running... [12, 13:36:00] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC: Error Code: 1054. Unknown column 'p_Gender' in 'where clause' [13, 13:36:03] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [13, 13:36:03] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = p_Gender ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_Gender' in 'where clause' [14, 13:36:22] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [14, 13:36:22] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Fetching... [14, 13:36:22] SELECT (RTRIM((DATE_FORMAT(CREATEDATE, '%D'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%m'))+'/'+ RTRIM(DATE_FORMAT(CREATEDATE, '%Y'))) )AS 'REGISTER DATE', FULLNAME AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= G.PROFILEID) AS CITY, CASTE,EDUCATION,OCCUPATION, G.PROFILEID FROM GENERALDETAIL G WHERE G.GENDER = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : 0 row(s) returned [15, 13:38:39] Apply changes to GetDefaultSearchGrid: Preparing... [15, 13:38:41] Applying changes to GetDefaultSearchGrid...: [15, 13:38:41] : Changes applied to GetDefaultSearchGrid [15, 13:38:43] Apply changes to GetDefaultSearchGrid: Changes applied [16, 15:03:13] CREATE TEMPORARY TABLE TEMP1 ( REGISTERDATE DATETIME, NAME VARCHAR(80), AGE INT, HEIGHT VARCHAR(3), CITY VARCHAR(50), EDUCATION VARCHAR(80), OCCUPATION VARCHAR(50), PROFILEID VARCHAR(12) ): Running... [16, 15:03:13] CREATE TEMPORARY TABLE TEMP1 ( REGISTERDATE DATETIME, NAME VARCHAR(80), AGE INT, HEIGHT VARCHAR(3), CITY VARCHAR(50), EDUCATION VARCHAR(80), OCCUPATION VARCHAR(50), PROFILEID VARCHAR(12) ): 0 row(s) affected [17, 15:03:33] select * from TEMP1 LIMIT 0, 1000 : Running... [17, 15:03:33] select * from TEMP1 LIMIT 0, 1000 : Fetching... [17, 15:03:33] select * from TEMP1 LIMIT 0, 1000 : 0 row(s) returned [18, 15:45:47] select (Rtrim((datename(dd,g.CreateDate))+'/'+ Rtrim(datepart(mm,g.CreateDate))+'/'+ Rtrim(datename(yy,g.CreateDate))) )As 'Register Date', FullName As 'Name', (datepart(yy,getdate()) - datepart(yy,BirthOfDate)) as 'Age', RTrim (HeightFeet)+'.'+ RTrim (HeightInch )+'"' as Height, (select city from ContactDetail where ProfileId= G.ProfileId) as City, Caste,Education,Occupation,g.ProfileId from GeneralDetail G inner join ContactDetail c on g.ProfileId=c.ProfileId where c.City = @City and g.Gender=@Gender and g.Caste=@Caste and g.Religion=@Religion ORDER BY G.CreateDate desc, G.caste asc LIMIT 0, 1000 : Running... [18, 15:45:47] select (Rtrim((datename(dd,g.CreateDate))+'/'+ Rtrim(datepart(mm,g.CreateDate))+'/'+ Rtrim(datename(yy,g.CreateDate))) )As 'Register Date', FullName As 'Name', (datepart(yy,getdate()) - datepart(yy,BirthOfDate)) as 'Age', RTrim (HeightFeet)+'.'+ RTrim (HeightInch )+'"' as Height, (select city from ContactDetail where ProfileId= G.ProfileId) as City, Caste,Education,Occupation,g.ProfileId from GeneralDetail G inner join ContactDetail c on g.ProfileId=c.ProfileId where c.City = @City and g.Gender=@Gender and g.Caste=@Caste and g.Religion=@Religion ORDER BY G.CreateDate desc, G.caste asc LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.datename does not exist [19, 16:10:23] Apply changes to GetDefaultSearchGridAndGetSearchDefaultGrid: Preparing... [19, 16:10:25] Applying changes to GetDefaultSearchGridAndGetSearchDefaultGrid...: [19, 16:10:25] : Changes applied to GetDefaultSearchGridAndGetSearchDefaultGrid [19, 16:10:27] Apply changes to GetDefaultSearchGridAndGetSearchDefaultGrid: Changes applied [20, 16:18:30] Apply changes to GetEmailByUserName: Preparing... [20, 16:18:33] Applying changes to GetEmailByUserName...: [20, 16:18:33] : Changes applied to GetEmailByUserName [20, 16:18:34] Apply changes to GetEmailByUserName: Changes applied [21, 16:21:53] Apply changes to GetExistingMsg: Preparing... [21, 16:21:55] Applying changes to GetExistingMsg...: [21, 16:21:55] : Changes applied to GetExistingMsg [21, 16:21:56] Apply changes to GetExistingMsg: Changes applied [22, 17:11:43] Apply changes to GetExpressInterestCountByLoggedProfileID: Preparing... [22, 17:11:45] Applying changes to GetExpressInterestCountByLoggedProfileID...: [22, 17:11:54] Apply changes to GetExpressInterestCountByLoggedProfileID: Error 1313: RETURN is only allowed in a FUNCTION SQL Statement: CREATE PROCEDURE `GetExpressInterestCountByLoggedProfileID` ( IN LoggedProfileID varchar(12) ) BEGIN declare cnt int; select COUNT(*) INTO cnt from ExpressInterest where ToProfileId = LoggedProfileID; return cnt; END [23, 19:20:45] Apply changes to GetExpressInterestCountByLoggedProfileID: Preparing... [23, 19:20:47] Applying changes to GetExpressInterestCountByLoggedProfileID...: [23, 19:20:47] : Changes applied to GetExpressInterestCountByLoggedProfileID [23, 19:20:48] Apply changes to GetExpressInterestCountByLoggedProfileID: Changes applied [24, 19:24:06] Apply changes to GetExpressInterestGrid: Preparing... [24, 19:24:09] Applying changes to GetExpressInterestGrid...: [24, 19:24:09] : Changes applied to GetExpressInterestGrid [24, 19:24:10] Apply changes to GetExpressInterestGrid: Changes applied [25, 19:25:00] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [25, 19:25:00] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATEPART(YY,GETDATE()) - DATEPART(YY,BIRTHOFDATE)) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1305. FUNCTION matrimony.DATEPART does not exist [26, 19:26:37] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : Running... [26, 19:26:37] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : Fetching... [26, 19:26:37] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : 1 row(s) returned [27, 19:26:57] SELECT DATE_FORMAT(NOW(), '%YY') LIMIT 0, 1000 : Running... [27, 19:26:57] SELECT DATE_FORMAT(NOW(), '%YY') LIMIT 0, 1000 : Fetching... [27, 19:26:58] SELECT DATE_FORMAT(NOW(), '%YY') LIMIT 0, 1000 : 1 row(s) returned [28, 19:27:07] SELECT DATE_FORMAT(NOW(), '%y') LIMIT 0, 1000 : Running... [28, 19:27:07] SELECT DATE_FORMAT(NOW(), '%y') LIMIT 0, 1000 : Fetching... [28, 19:27:07] SELECT DATE_FORMAT(NOW(), '%y') LIMIT 0, 1000 : 1 row(s) returned [29, 19:27:12] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : Running... [29, 19:27:13] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : Fetching... [29, 19:27:13] SELECT DATE_FORMAT(NOW(), '%Y') LIMIT 0, 1000 : 1 row(s) returned [30, 19:28:42] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [30, 19:28:42] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_ToProfileID' in 'where clause' [31, 19:29:00] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = 1 ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [31, 19:29:00] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = 1 ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Fetching... [31, 19:29:00] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = 1 ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : 0 row(s) returned [32, 19:30:16] Apply changes to GetExpressInterestGrid: Preparing... [32, 19:30:17] Applying changes to GetExpressInterestGrid...: [32, 19:30:17] : Changes applied to GetExpressInterestGrid [32, 19:30:19] Apply changes to GetExpressInterestGrid: Changes applied [33, 19:33:47] Apply changes to GetFamilyInfo: Preparing... [33, 19:33:48] Applying changes to GetFamilyInfo...: [33, 19:33:48] : Changes applied to GetFamilyInfo [33, 19:33:50] Apply changes to GetFamilyInfo: Changes applied [34, 22:17:08] SELECT 'C1Count',COUNT(MartialStatus) as 'cnt' FROM GeneralDetail WHERE MartialStatus ='' or MartialStatus is not null and ProfileId=@profileID UNION SELECT 'C2Count',COUNT(Manglik) as 'cnt' FROM GeneralDetail WHERE Manglik ='' and ProfileId=@profileID UNION SELECT 'C3Count',COUNT(Rashi) as 'cnt' FROM GeneralDetail WHERE Rashi ='' and ProfileId=@profileID UNION SELECT 'C4Count',COUNT(Nadi) as 'cnt' FROM GeneralDetail WHERE Nadi ='' and ProfileId=@profileID UNION SELECT 'C5Count',COUNT(Nakshatra) as 'cnt' FROM GeneralDetail WHERE Nakshatra ='' and ProfileId=@profileID UNION SELECT 'C6Count',COUNT(Gan) as 'cnt' FROM GeneralDetail WHERE Gan ='' and ProfileId=@profileID UNION SELECT 'C7Count',COUNT(Gotra) as 'cnt' FROM GeneralDetail WHERE Gotra ='' and ProfileId=@profileID UNION SELECT 'C8Count',COUNT(KulDaivat) as 'cnt' FROM GeneralDetail WHERE KulDaivat ='' and ProfileId=@profileID UNION SELECT 'C9Count',COUNT(Religion) as 'cnt' FROM GeneralDetail WHERE Religion ='' and ProfileId=@profileID UNION SELECT 'C10Count',COUNT(Caste) as 'cnt' FROM GeneralDetail WHERE Caste ='' and ProfileId=@profileID UNION SELECT 'C11Count',COUNT(SubCaste) as 'cnt' FROM GeneralDetail WHERE SubCaste ='' and ProfileId=@profileID UNION SELECT 'C12Count',COUNT(Diet) as 'cnt' FROM GeneralDetail WHERE Diet ='' and ProfileId=@profileID UNION SELECT 'C13Count',COUNT(Hobbies) as 'cnt' FROM GeneralDetail WHERE Hobbies ='' and ProfileId=@profileID UNION SELECT 'C14Count',COUNT(EducationArea) as 'cnt' FROM GeneralDetail WHERE EducationArea ='' and ProfileId=@profileID UNION SELECT 'C16Count',COUNT(Education) as 'cnt' FROM GeneralDetail WHERE Education ='' and ProfileId=@profileID UNION SELECT 'C17Count',COUNT(Occupation) as 'cnt' FROM GeneralDetail WHERE Occupation ='' and ProfileId=@profileID UNION SELECT 'C18Count',COUNT(AnualIncome) as 'cnt' FROM GeneralDetail WHERE AnualIncome ='' and ProfileId=@profileID UNION SELECT 'C19Count',COUNT(HeightFeet) as 'cnt' FROM GeneralDetail WHERE HeightFeet ='' and ProfileId=@profileID UNION SELECT 'C20Count',COUNT(HeightInch) as 'cnt' FROM GeneralDetail WHERE HeightInch ='' and ProfileId=@profileID UNION SELECT 'C21Count',COUNT(Weight) as 'cnt' FROM GeneralDetail WHERE Weight ='' and ProfileId=@profileID UNION SELECT 'C22Count',COUNT(BodyType) as 'cnt' FROM GeneralDetail WHERE BodyType ='' and ProfileId=@profileID UNION SELECT 'C23Count',COUNT(PhysicalStatus) as 'cnt' FROM GeneralDetail WHERE PhysicalStatus ='' and ProfileId=@profileID UNION SELECT 'C24Count',COUNT(Looks) as 'cnt' FROM GeneralDetail WHERE Looks ='' and ProfileId=@profileID UNION SELECT 'C25Count',COUNT(Complexion) as 'cnt' FROM GeneralDetail WHERE Complexion ='' and ProfileId=@profileID UNION SELECT 'C26Count',COUNT(EyeColor) as 'cnt' FROM GeneralDetail WHERE EyeColor ='' and ProfileId=@profileID UNION SELECT 'C27Count',COUNT(HairColor) as 'cnt' FROM GeneralDetail WHERE HairColor ='' and ProfileId=@profileID UNION SELECT 'C28Count',COUNT(BloodGroup) as 'cnt' FROM GeneralDetail WHERE BloodGroup ='' and ProfileId=@profileID UNION SELECT 'C29Count',COUNT(ContactLens) as 'cnt' FROM GeneralDetail WHERE ContactLens ='' or ContactLens ='No' and ProfileId=@profileID UNION SELECT 'C30Count',COUNT(ProfileCreatedBy) as 'cnt' FROM GeneralDetail WHERE ProfileCreatedBy ='' or ProfileCreatedBy ='Unspecified' and ProfileId = 1: Running... [34, 22:17:08] SELECT 'C1Count',COUNT(MartialStatus) as 'cnt' FROM GeneralDetail WHERE MartialStatus ='' or MartialStatus is not null and ProfileId=@profileID UNION SELECT 'C2Count',COUNT(Manglik) as 'cnt' FROM GeneralDetail WHERE Manglik ='' and ProfileId=@profileID UNION SELECT 'C3Count',COUNT(Rashi) as 'cnt' FROM GeneralDetail WHERE Rashi ='' and ProfileId=@profileID UNION SELECT 'C4Count',COUNT(Nadi) as 'cnt' FROM GeneralDetail WHERE Nadi ='' and ProfileId=@profileID UNION SELECT 'C5Count',COUNT(Nakshatra) as 'cnt' FROM GeneralDetail WHERE Nakshatra ='' and ProfileId=@profileID UNION SELECT 'C6Count',COUNT(Gan) as 'cnt' FROM GeneralDetail WHERE Gan ='' and ProfileId=@profileID UNION SELECT 'C7Count',COUNT(Gotra) as 'cnt' FROM GeneralDetail WHERE Gotra ='' and ProfileId=@profileID UNION SELECT 'C8Count',COUNT(KulDaivat) as 'cnt' FROM GeneralDetail WHERE KulDaivat ='' and ProfileId=@profileID UNION SELECT 'C9Count',COUNT(Religion) as 'cnt' FROM GeneralDetail WHERE Religion ='' and ProfileId=@profileID UNION SELECT 'C10Count',COUNT(Caste) as 'cnt' FROM GeneralDetail WHERE Caste ='' and ProfileId=@profileID UNION SELECT 'C11Count',COUNT(SubCaste) as 'cnt' FROM GeneralDetail WHERE SubCaste ='' and ProfileId=@profileID UNION SELECT 'C12Count',COUNT(Diet) as 'cnt' FROM GeneralDetail WHERE Diet ='' and ProfileId=@profileID UNION SELECT 'C13Count',COUNT(Hobbies) as 'cnt' FROM GeneralDetail WHERE Hobbies ='' and ProfileId=@profileID UNION SELECT 'C14Count',COUNT(EducationArea) as 'cnt' FROM GeneralDetail WHERE EducationArea ='' and ProfileId=@profileID UNION SELECT 'C16Count',COUNT(Education) as 'cnt' FROM GeneralDetail WHERE Education ='' and ProfileId=@profileID UNION SELECT 'C17Count',COUNT(Occupation) as 'cnt' FROM GeneralDetail WHERE Occupation ='' and ProfileId=@profileID UNION SELECT 'C18Count',COUNT(AnualIncome) as 'cnt' FROM GeneralDetail WHERE AnualIncome ='' and ProfileId=@profileID UNION SELECT 'C19Count',COUNT(HeightFeet) as 'cnt' FROM GeneralDetail WHERE HeightFeet ='' and ProfileId=@profileID UNION SELECT 'C20Count',COUNT(HeightInch) as 'cnt' FROM GeneralDetail WHERE HeightInch ='' and ProfileId=@profileID UNION SELECT 'C21Count',COUNT(Weight) as 'cnt' FROM GeneralDetail WHERE Weight ='' and ProfileId=@profileID UNION SELECT 'C22Count',COUNT(BodyType) as 'cnt' FROM GeneralDetail WHERE BodyType ='' and ProfileId=@profileID UNION SELECT 'C23Count',COUNT(PhysicalStatus) as 'cnt' FROM GeneralDetail WHERE PhysicalStatus ='' and ProfileId=@profileID UNION SELECT 'C24Count',COUNT(Looks) as 'cnt' FROM GeneralDetail WHERE Looks ='' and ProfileId=@profileID UNION SELECT 'C25Count',COUNT(Complexion) as 'cnt' FROM GeneralDetail WHERE Complexion ='' and ProfileId=@profileID UNION SELECT 'C26Count',COUNT(EyeColor) as 'cnt' FROM GeneralDetail WHERE EyeColor ='' and ProfileId=@profileID UNION SELECT 'C27Count',COUNT(HairColor) as 'cnt' FROM GeneralDetail WHERE HairColor ='' and ProfileId=@profileID UNION SELECT 'C28Count',COUNT(BloodGroup) as 'cnt' FROM GeneralDetail WHERE BloodGroup ='' and ProfileId=@profileID UNION SELECT 'C29Count',COUNT(ContactLens) as 'cnt' FROM GeneralDetail WHERE ContactLens ='' or ContactLens ='No' and ProfileId=@profileID UNION SELECT 'C30Count',COUNT(ProfileCreatedBy) as 'cnt' FROM GeneralDetail WHERE ProfileCreatedBy ='' or ProfileCreatedBy ='Unspecified' and ProfileId = 1: Fetching... [34, 22:17:08] SELECT 'C1Count',COUNT(MartialStatus) as 'cnt' FROM GeneralDetail WHERE MartialStatus ='' or MartialStatus is not null and ProfileId=@profileID UNION SELECT 'C2Count',COUNT(Manglik) as 'cnt' FROM GeneralDetail WHERE Manglik ='' and ProfileId=@profileID UNION SELECT 'C3Count',COUNT(Rashi) as 'cnt' FROM GeneralDetail WHERE Rashi ='' and ProfileId=@profileID UNION SELECT 'C4Count',COUNT(Nadi) as 'cnt' FROM GeneralDetail WHERE Nadi ='' and ProfileId=@profileID UNION SELECT 'C5Count',COUNT(Nakshatra) as 'cnt' FROM GeneralDetail WHERE Nakshatra ='' and ProfileId=@profileID UNION SELECT 'C6Count',COUNT(Gan) as 'cnt' FROM GeneralDetail WHERE Gan ='' and ProfileId=@profileID UNION SELECT 'C7Count',COUNT(Gotra) as 'cnt' FROM GeneralDetail WHERE Gotra ='' and ProfileId=@profileID UNION SELECT 'C8Count',COUNT(KulDaivat) as 'cnt' FROM GeneralDetail WHERE KulDaivat ='' and ProfileId=@profileID UNION SELECT 'C9Count',COUNT(Religion) as 'cnt' FROM GeneralDetail WHERE Religion ='' and ProfileId=@profileID UNION SELECT 'C10Count',COUNT(Caste) as 'cnt' FROM GeneralDetail WHERE Caste ='' and ProfileId=@profileID UNION SELECT 'C11Count',COUNT(SubCaste) as 'cnt' FROM GeneralDetail WHERE SubCaste ='' and ProfileId=@profileID UNION SELECT 'C12Count',COUNT(Diet) as 'cnt' FROM GeneralDetail WHERE Diet ='' and ProfileId=@profileID UNION SELECT 'C13Count',COUNT(Hobbies) as 'cnt' FROM GeneralDetail WHERE Hobbies ='' and ProfileId=@profileID UNION SELECT 'C14Count',COUNT(EducationArea) as 'cnt' FROM GeneralDetail WHERE EducationArea ='' and ProfileId=@profileID UNION SELECT 'C16Count',COUNT(Education) as 'cnt' FROM GeneralDetail WHERE Education ='' and ProfileId=@profileID UNION SELECT 'C17Count',COUNT(Occupation) as 'cnt' FROM GeneralDetail WHERE Occupation ='' and ProfileId=@profileID UNION SELECT 'C18Count',COUNT(AnualIncome) as 'cnt' FROM GeneralDetail WHERE AnualIncome ='' and ProfileId=@profileID UNION SELECT 'C19Count',COUNT(HeightFeet) as 'cnt' FROM GeneralDetail WHERE HeightFeet ='' and ProfileId=@profileID UNION SELECT 'C20Count',COUNT(HeightInch) as 'cnt' FROM GeneralDetail WHERE HeightInch ='' and ProfileId=@profileID UNION SELECT 'C21Count',COUNT(Weight) as 'cnt' FROM GeneralDetail WHERE Weight ='' and ProfileId=@profileID UNION SELECT 'C22Count',COUNT(BodyType) as 'cnt' FROM GeneralDetail WHERE BodyType ='' and ProfileId=@profileID UNION SELECT 'C23Count',COUNT(PhysicalStatus) as 'cnt' FROM GeneralDetail WHERE PhysicalStatus ='' and ProfileId=@profileID UNION SELECT 'C24Count',COUNT(Looks) as 'cnt' FROM GeneralDetail WHERE Looks ='' and ProfileId=@profileID UNION SELECT 'C25Count',COUNT(Complexion) as 'cnt' FROM GeneralDetail WHERE Complexion ='' and ProfileId=@profileID UNION SELECT 'C26Count',COUNT(EyeColor) as 'cnt' FROM GeneralDetail WHERE EyeColor ='' and ProfileId=@profileID UNION SELECT 'C27Count',COUNT(HairColor) as 'cnt' FROM GeneralDetail WHERE HairColor ='' and ProfileId=@profileID UNION SELECT 'C28Count',COUNT(BloodGroup) as 'cnt' FROM GeneralDetail WHERE BloodGroup ='' and ProfileId=@profileID UNION SELECT 'C29Count',COUNT(ContactLens) as 'cnt' FROM GeneralDetail WHERE ContactLens ='' or ContactLens ='No' and ProfileId=@profileID UNION SELECT 'C30Count',COUNT(ProfileCreatedBy) as 'cnt' FROM GeneralDetail WHERE ProfileCreatedBy ='' or ProfileCreatedBy ='Unspecified' and ProfileId = 1: 29 row(s) returned [35, 22:20:31] Apply changes to GetGeneralDetailCount: Preparing... [35, 22:20:33] Applying changes to GetGeneralDetailCount...: [35, 22:20:33] : Changes applied to GetGeneralDetailCount [35, 22:20:34] Apply changes to GetGeneralDetailCount: Changes applied [36, 22:23:08] SELECT (DATE_FORMAT(NOW(), '%YY')) LIMIT 0, 1000 : Running... [36, 22:23:08] SELECT (DATE_FORMAT(NOW(), '%YY')) LIMIT 0, 1000 : Fetching... [36, 22:23:08] SELECT (DATE_FORMAT(NOW(), '%YY')) LIMIT 0, 1000 : 1 row(s) returned [37, 22:23:12] SELECT (DATE_FORMAT(NOW(), '%Y')) LIMIT 0, 1000 : Running... [37, 22:23:12] SELECT (DATE_FORMAT(NOW(), '%Y')) LIMIT 0, 1000 : Fetching... [37, 22:23:12] SELECT (DATE_FORMAT(NOW(), '%Y')) LIMIT 0, 1000 : 1 row(s) returned [38, 22:27:27] Apply changes to GetGeneralInfo: Preparing... [38, 22:27:29] Applying changes to GetGeneralInfo...: [38, 22:27:29] : Changes applied to GetGeneralInfo [38, 22:27:30] Apply changes to GetGeneralInfo: Changes applied [39, 22:30:00] Apply changes to GetImage: Preparing... [39, 22:30:02] Applying changes to GetImage...: [39, 22:30:02] : Changes applied to GetImage [39, 22:30:04] Apply changes to GetImage: Changes applied [40, 22:33:59] Apply changes to GetImageUrl: Preparing... [40, 22:34:01] Applying changes to GetImageUrl...: [40, 22:34:01] : Changes applied to GetImageUrl [40, 22:34:02] Apply changes to GetImageUrl: Changes applied [41, 22:40:07] Apply changes to GetInboxCountByLoggedProfileID: Preparing... [41, 22:40:08] Applying changes to GetInboxCountByLoggedProfileID...: [41, 22:40:09] : Changes applied to GetInboxCountByLoggedProfileID [41, 22:40:10] Apply changes to GetInboxCountByLoggedProfileID: Changes applied [42, 22:43:01] SELECT REPLACE(fromProfileID, p_LoginProfileID, 'Me') as [From], Replace(toProfileID, p_LoginProfileID, 'Me') as[To], [Message], createdate as[Date], Replace(fromProfileID + toProfileID, p_LoginProfileID, '') as ProfileID from inbox where (fromProfileID = p_LoginProfileID or toProfileID = p_LoginProfileID) and ReplyFlag ='Accept' order by createdate desc: Running... [42, 22:43:01] SELECT REPLACE(fromProfileID, p_LoginProfileID, 'Me') as [From], Replace(toProfileID, p_LoginProfileID, 'Me') as[To], [Message], createdate as[Date], Replace(fromProfileID + toProfileID, p_LoginProfileID, '') as ProfileID from inbox where (fromProfileID = p_LoginProfileID or toProfileID = p_LoginProfileID) and ReplyFlag ='Accept' order by createdate desc: Error Code: 1064. 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 '[From], Replace(toProfileID, p_LoginProfileID, 'Me') as[To], [Message], cr' at line 1 [43, 22:43:45] SELECT REPLACE(fromProfileID, 1, 'Me') as [From], Replace(toProfileID, 1, 'Me') as[To], [Message], createdate as[Date], Replace(fromProfileID + toProfileID, 1, '') as ProfileID from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc: Running... [43, 22:43:45] SELECT REPLACE(fromProfileID, 1, 'Me') as [From], Replace(toProfileID, 1, 'Me') as[To], [Message], createdate as[Date], Replace(fromProfileID + toProfileID, 1, '') as ProfileID from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc: Error Code: 1064. 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 '[From], Replace(toProfileID, 1, 'Me') as[To], [Message], createdate as[Dat' at line 1 [44, 22:45:17] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : Running... [44, 22:45:17] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : Fetching... [44, 22:45:18] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : 0 row(s) returned [45, 22:45:38] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : Running... [45, 22:45:38] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : Fetching... [45, 22:45:38] SELECT REPLACE(fromProfileID, 1, 'Me') as 'From', Replace(toProfileID, 1, 'Me') as 'To', 'Message', createdate as 'Date', Replace(fromProfileID + toProfileID, 1, '') as 'ProfileID' from inbox where (fromProfileID = 1 or toProfileID = 1) and ReplyFlag ='Accept' order by createdate desc LIMIT 0, 1000 : 0 row(s) returned [46, 22:48:38] Apply changes to GetInboxGrid: Preparing... [46, 22:48:40] Applying changes to GetInboxGrid...: [46, 22:48:40] : Changes applied to GetInboxGrid [46, 22:48:41] Apply changes to GetInboxGrid: Changes applied [1, 00:44:42] SELECT CAST(now() AS char) LIMIT 0, 1000 : Running... [1, 00:44:43] SELECT CAST(now() AS char) LIMIT 0, 1000 : Fetching... [1, 00:44:43] SELECT CAST(now() AS char) LIMIT 0, 1000 : 1 row(s) returned [2, 00:44:52] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : Running... [2, 00:44:53] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : Fetching... [2, 00:44:53] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : 1 row(s) returned [3, 00:45:06] SELECT CAST(now() AS varchar), now(): Running... [3, 00:45:06] SELECT CAST(now() AS varchar), now(): Error Code: 1064. 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 'varchar), now()' at line 1 [4, 00:45:16] SELECT CAST(now() AS int), now(): Running... [4, 00:45:16] SELECT CAST(now() AS int), now(): Error Code: 1064. 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 'int), now()' at line 1 [5, 00:45:26] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : Running... [5, 00:45:26] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : Fetching... [5, 00:45:26] SELECT CAST(now() AS char), now() LIMIT 0, 1000 : 1 row(s) returned [6, 00:50:58] Apply changes to GetLastRecordDate: Preparing... [6, 00:51:00] Applying changes to GetLastRecordDate...: [6, 00:51:00] : Changes applied to GetLastRecordDate [6, 00:51:01] Apply changes to GetLastRecordDate: Changes applied [7, 00:59:03] Apply changes to GetPartnerInfo: Preparing... [7, 00:59:05] Applying changes to GetPartnerInfo...: [7, 00:59:05] : Changes applied to GetPartnerInfo [7, 00:59:07] Apply changes to GetPartnerInfo: Changes applied [8, 01:00:10] Apply changes to GetPhoto: Preparing... [8, 01:00:12] Applying changes to GetPhoto...: [8, 01:00:12] : Changes applied to GetPhoto [8, 01:00:14] Apply changes to GetPhoto: Changes applied [9, 01:03:30] Apply changes to GetProfileIDByUserName: Preparing... [9, 01:03:32] Applying changes to GetProfileIDByUserName...: [9, 01:03:32] : Changes applied to GetProfileIDByUserName [9, 01:03:34] Apply changes to GetProfileIDByUserName: Changes applied [1, 08:14:45] Apply changes to GetProfileInfo: Preparing... [1, 08:14:47] Applying changes to GetProfileInfo...: [1, 08:14:48] : Changes applied to GetProfileInfo [1, 08:14:49] Apply changes to GetProfileInfo: Changes applied [2, 08:18:55] Apply changes to GetSearchCityGrid: Preparing... [2, 08:18:56] Applying changes to GetSearchCityGrid...: [2, 08:18:56] : Changes applied to GetSearchCityGrid [2, 08:18:58] Apply changes to GetSearchCityGrid: Changes applied [3, 08:19:18] Apply changes to GetSearchCityGrid: Preparing... [3, 08:19:19] Applying changes to GetSearchCityGrid...: [3, 08:19:19] : Changes applied to GetSearchCityGrid [3, 08:19:21] Apply changes to GetSearchCityGrid: Changes applied [4, 08:20:18] Apply changes to GetSearchCityGrid: Preparing... [4, 08:20:20] Applying changes to GetSearchCityGrid...: [4, 08:20:20] : Changes applied to GetSearchCityGrid [4, 08:20:21] Apply changes to GetSearchCityGrid: Changes applied [5, 08:23:02] SELECT date_format(CreateDate, '%d') LIMIT 0, 1000 : Running... [5, 08:23:02] SELECT date_format(CreateDate, '%d') LIMIT 0, 1000 : Error Code: 1054. Unknown column 'CreateDate' in 'field list' [6, 08:23:14] SELECT date_format(NOW(), '%d') LIMIT 0, 1000 : Running... [6, 08:23:14] SELECT date_format(NOW(), '%d') LIMIT 0, 1000 : Fetching... [6, 08:23:14] SELECT date_format(NOW(), '%d') LIMIT 0, 1000 : 1 row(s) returned [7, 08:23:33] SELECT date_format(NOW(), '%D') LIMIT 0, 1000 : Running... [7, 08:23:33] SELECT date_format(NOW(), '%D') LIMIT 0, 1000 : Fetching... [7, 08:23:33] SELECT date_format(NOW(), '%D') LIMIT 0, 1000 : 1 row(s) returned [8, 08:24:33] SELECT date_format(NOW(), '%M') LIMIT 0, 1000 : Running... [8, 08:24:33] SELECT date_format(NOW(), '%M') LIMIT 0, 1000 : Fetching... [8, 08:24:34] SELECT date_format(NOW(), '%M') LIMIT 0, 1000 : 1 row(s) returned [9, 08:37:00] SELECT date_format(NOW(), '%m') LIMIT 0, 1000 : Running... [9, 08:37:00] SELECT date_format(NOW(), '%m') LIMIT 0, 1000 : Fetching... [9, 08:37:00] SELECT date_format(NOW(), '%m') LIMIT 0, 1000 : 1 row(s) returned [10, 08:37:31] SELECT date_format(NOW(), '%y') LIMIT 0, 1000 : Running... [10, 08:37:31] SELECT date_format(NOW(), '%y') LIMIT 0, 1000 : Fetching... [10, 08:37:32] SELECT date_format(NOW(), '%y') LIMIT 0, 1000 : 1 row(s) returned [11, 08:37:36] SELECT date_format(NOW(), '%yy') LIMIT 0, 1000 : Running... [11, 08:37:36] SELECT date_format(NOW(), '%yy') LIMIT 0, 1000 : Fetching... [11, 08:37:36] SELECT date_format(NOW(), '%yy') LIMIT 0, 1000 : 1 row(s) returned [12, 08:37:43] SELECT date_format(NOW(), '%Y') LIMIT 0, 1000 : Running... [12, 08:37:43] SELECT date_format(NOW(), '%Y') LIMIT 0, 1000 : Fetching... [12, 08:37:43] SELECT date_format(NOW(), '%Y') LIMIT 0, 1000 : 1 row(s) returned [13, 10:50:55] Apply changes to _SYNTAX_ERROR: Preparing... [13, 10:50:59] Apply changes to _SYNTAX_ERROR: Cancelled [14, 10:51:02] Apply changes to _SYNTAX_ERROR: Preparing... [14, 10:51:14] Applying changes to _SYNTAX_ERROR...: [14, 10:51:16] Apply changes to _SYNTAX_ERROR: Error 1064: 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 'ELSE THEN SELECT (Rtrim((datename(dd,CreateDate))+'/'+ Rtrim(' at line 24 SQL Statement: CREATE PROCEDURE `GetSearchDefaultGrid` ( p_Gender varchar(5), p_Religion varchar(50), p_Caste varchar(256) ) BEGIN IF(p_Caste !='Any' ) THEN SELECT (Rtrim((DATE_FORMAT(CreateDate, '%d'))+'/'+ Rtrim(DATE_FORMAT(CreateDate, '%m'))+'/'+ Rtrim(DATE_FORMAT(CreateDate, '%Y'))) )As 'Register Date', FullName As 'Name', (datepart(yy,getdate()) - datepart(yy,BirthOfDate)) as 'Age', RTrim (HeightFeet)+'.'+ RTrim (HeightInch )+'"' as Height, (select city from ContactDetail where ProfileId= G.ProfileId) as City, (select Image from ProfileMaster where ProfileId=g.ProfileId) as Image, Caste,Education,Occupation, G.ProfileId FROM GeneralDetail G where g.Gender = p_Gender and g.Caste = p_Caste ORDER BY CreateDate desc; END IF; ELSE THEN SELECT (Rtrim((datename(dd,CreateDate))+'/'+ Rtrim(datepart(mm,CreateDate))+'/'+ Rtrim(datename(yy,CreateDate))) )As 'Register Date', FullName As 'Name', (datepart(yy,getdate()) - datepart(yy,BirthOfDate)) as 'Age', RTrim (HeightFeet)+'.'+ RTrim (HeightInch )+'"' as Height, (select city from ContactDetail where ProfileId= G.ProfileId) as City, (select Image from ProfileMaster where ProfileId=g.ProfileId) as Image, Caste,Education,Occupation, G.ProfileId FROM GeneralDetail G where g.Gender=@Gender ORDER BY CreateDate desc; END IF; END [15, 10:51:43] Apply changes to _SYNTAX_ERROR: Preparing... [15, 10:51:46] Apply changes to _SYNTAX_ERROR: [1, 11:26:06] Apply changes to GetSearchDefaultGrid: Preparing... [1, 11:26:08] Applying changes to GetSearchDefaultGrid...: [1, 11:26:08] : Changes applied to GetSearchDefaultGrid [1, 11:26:10] Apply changes to GetSearchDefaultGrid: Changes applied [2, 12:19:33] Apply changes to GetSearchGrid: Preparing... [2, 12:19:35] Applying changes to GetSearchGrid...: [2, 12:19:35] : Changes applied to GetSearchGrid [2, 12:19:36] Apply changes to GetSearchGrid: Changes applied [3, 12:54:29] Apply changes to GetSearchProfileIDGrid: Preparing... [3, 12:54:31] Applying changes to GetSearchProfileIDGrid...: [3, 12:54:31] : Changes applied to GetSearchProfileIDGrid [3, 12:54:32] Apply changes to GetSearchProfileIDGrid: Changes applied [4, 13:23:39] Apply changes to GetSendMsgCount: Preparing... [4, 13:23:40] Applying changes to GetSendMsgCount...: [4, 13:23:40] : Changes applied to GetSendMsgCount [4, 13:23:42] Apply changes to GetSendMsgCount: Changes applied [5, 13:26:57] Apply changes to GetSendMsgCountByLoggedProfileID: Preparing... [5, 13:26:58] Applying changes to GetSendMsgCountByLoggedProfileID...: [5, 13:26:58] : Changes applied to GetSendMsgCountByLoggedProfileID [5, 13:27:00] Apply changes to GetSendMsgCountByLoggedProfileID: Changes applied [6, 13:33:38] Apply changes to GetSendMsgGrid: Preparing... [6, 13:33:40] Applying changes to GetSendMsgGrid...: [6, 13:33:40] : Changes applied to GetSendMsgGrid [6, 13:33:41] Apply changes to GetSendMsgGrid: Changes applied [7, 13:35:06] Apply changes to GetSentRequestGender: Preparing... [7, 13:35:08] Applying changes to GetSentRequestGender...: [7, 13:35:08] : Changes applied to GetSentRequestGender [7, 13:35:10] Apply changes to GetSentRequestGender: Changes applied [8, 13:38:46] Apply changes to GetSessionInfo: Preparing... [8, 13:38:48] Applying changes to GetSessionInfo...: [8, 13:38:48] : Changes applied to GetSessionInfo [8, 13:38:49] Apply changes to GetSessionInfo: Changes applied [9, 14:23:09] Apply changes to GetUserIDByUserName: Preparing... [9, 14:23:10] Applying changes to GetUserIDByUserName...: [9, 14:23:10] : Changes applied to GetUserIDByUserName [9, 14:23:11] Apply changes to GetUserIDByUserName: Changes applied [10, 14:31:05] Apply changes to GetViewLogCount: Preparing... [10, 14:31:07] Applying changes to GetViewLogCount...: [10, 14:31:34] Apply changes to GetViewLogCount: Error 1582: Incorrect parameter count in the call to native function 'DATEDIFF' SQL Statement: CREATE PROCEDURE `GetViewLogCount` ( p_ProfileID varchar(12), p_TimeFormat int, p_LogCount int ) BEGIN IF (p_TimeFormat = 1) THEN SELECT COUNT(ToProfileId) INTO p_LogCount FROM ViewLog WHERE ToProfileId = p_ProfileID; END IF; IF (p_TimeFormat = 2) THEN SELECT COUNT(ToProfileId) INTO p_LogCount FROM ViewLog v WHERE v.ToProfileId = p_ProfileID AND CreateDate >= (SELECT DATEADD(wk,DATEDIFF(wk,7,v.CreateDate),0)); END IF; IF (p_TimeFormat = 3) THEN SELECT COUNT(ToProfileId) INTO p_LogCount FROM ViewLog v WHERE v.ToProfileId = p_ProfileID AND CreateDate >= (SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,v.CreateDate),0))); END IF; END [11, 14:36:56] SELECT DATEDIFF(NOW(), 7) LIMIT 0, 1000 : Running... [11, 14:36:57] SELECT DATEDIFF(NOW(), 7) LIMIT 0, 1000 : Fetching... [11, 14:36:57] SELECT DATEDIFF(NOW(), 7) LIMIT 0, 1000 : 1 row(s) returned [12, 14:37:12] SELECT DATEDIFF(7, NOW()) LIMIT 0, 1000 : Running... [12, 14:37:12] SELECT DATEDIFF(7, NOW()) LIMIT 0, 1000 : Fetching... [12, 14:37:12] SELECT DATEDIFF(7, NOW()) LIMIT 0, 1000 : 1 row(s) returned [13, 14:37:18] SELECT DATEDIFF(WEEK, NOW()) LIMIT 0, 1000 : Running... [13, 14:37:18] SELECT DATEDIFF(WEEK, NOW()) LIMIT 0, 1000 : Error Code: 1054. Unknown column 'WEEK' in 'field list' [14, 14:37:48] SELECT DATEDIFF(NOW()-1 , NOW()) LIMIT 0, 1000 : Running... [14, 14:37:48] SELECT DATEDIFF(NOW()-1 , NOW()) LIMIT 0, 1000 : Fetching... [14, 14:37:49] SELECT DATEDIFF(NOW()-1 , NOW()) LIMIT 0, 1000 : 1 row(s) returned [15, 14:37:56] SELECT DATEDIFF(NOW()-2 , NOW()) LIMIT 0, 1000 : Running... [15, 14:37:56] SELECT DATEDIFF(NOW()-2 , NOW()) LIMIT 0, 1000 : Fetching... [15, 14:37:56] SELECT DATEDIFF(NOW()-2 , NOW()) LIMIT 0, 1000 : 1 row(s) returned [16, 14:38:07] SELECT DATEDIFF(NOW(), NOW()-2) LIMIT 0, 1000 : Running... [16, 14:38:07] SELECT DATEDIFF(NOW(), NOW()-2) LIMIT 0, 1000 : Fetching... [16, 14:38:07] SELECT DATEDIFF(NOW(), NOW()-2) LIMIT 0, 1000 : 1 row(s) returned [17, 14:38:26] SELECT DATEDIFF(NOW(), '01/09/2015') LIMIT 0, 1000 : Running... [17, 14:38:26] SELECT DATEDIFF(NOW(), '01/09/2015') LIMIT 0, 1000 : Fetching... [17, 14:38:26] SELECT DATEDIFF(NOW(), '01/09/2015') LIMIT 0, 1000 : 1 row(s) returned [18, 14:39:28] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate LIMIT 0, 1000 : Running... [18, 14:39:28] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate LIMIT 0, 1000 : Fetching... [18, 14:39:28] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate LIMIT 0, 1000 : 1 row(s) returned [19, 14:42:02] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate SELECT DATE_ADD(NOW(), INTERVAL WEEK): Running... [19, 14:42:02] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate SELECT DATE_ADD(NOW(), INTERVAL WEEK): Error Code: 1064. 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 'SELECT DATE_ADD(NOW(), INTERVAL WEEK)' at line 3 [20, 14:42:36] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate SELECT DATE_ADD('2014-11-30', INTERVAL WEEK): Running... [20, 14:42:36] SELECT DATEDIFF('2014-11-30','2014-11-29') AS DiffDate SELECT DATE_ADD('2014-11-30', INTERVAL WEEK): Error Code: 1064. 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 'SELECT DATE_ADD('2014-11-30', INTERVAL WEEK)' at line 3 [21, 14:42:45] SELECT DATE_ADD('2014-11-30', INTERVAL WEEK): Running... [21, 14:42:45] SELECT DATE_ADD('2014-11-30', INTERVAL WEEK): Error Code: 1064. 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 ')' at line 1 [22, 14:43:07] SELECT DATE_ADD('2014-11-30', INTERVAL 1 WEEK) LIMIT 0, 1000 : Running... [22, 14:43:07] SELECT DATE_ADD('2014-11-30', INTERVAL 1 WEEK) LIMIT 0, 1000 : Fetching... [22, 14:43:07] SELECT DATE_ADD('2014-11-30', INTERVAL 1 WEEK) LIMIT 0, 1000 : 1 row(s) returned [23, 14:53:03] Apply changes to GetViewLogCount: Preparing... [23, 14:53:04] Applying changes to GetViewLogCount...: [23, 14:53:04] : Changes applied to GetViewLogCount [23, 14:53:06] Apply changes to GetViewLogCount: Changes applied [24, 15:05:48] Apply changes to _SYNTAX_ERROR: Preparing... [24, 15:05:51] Apply changes to _SYNTAX_ERROR: Cancelled [25, 18:04:53] Apply changes to ResetDatabase: Preparing... [25, 18:04:55] Applying changes to ResetDatabase...: [25, 18:04:55] : Changes applied to ResetDatabase [25, 18:04:57] Apply changes to ResetDatabase: Changes applied [26, 18:10:00] Apply changes to SaveApplicationException: Preparing... [26, 18:10:02] Applying changes to SaveApplicationException...: [26, 18:10:02] : Changes applied to SaveApplicationException [26, 18:10:03] Apply changes to SaveApplicationException: Changes applied [27, 18:11:15] Apply changes to SaveApplicationException: Preparing... [27, 18:11:17] Applying changes to SaveApplicationException...: [27, 18:11:17] : Changes applied to SaveApplicationException [27, 18:11:18] Apply changes to SaveApplicationException: Changes applied [28, 18:13:44] Apply changes to SaveApplicationLog: Preparing... [28, 18:13:46] Applying changes to SaveApplicationLog...: [28, 18:13:46] : Changes applied to SaveApplicationLog [28, 18:13:47] Apply changes to SaveApplicationLog: Changes applied [29, 18:23:41] Apply changes to SaveContactInfo: Preparing... [29, 18:23:43] Applying changes to SaveContactInfo...: [29, 18:23:43] : Changes applied to SaveContactInfo [29, 18:23:44] Apply changes to SaveContactInfo: Changes applied [1, 23:17:22] Apply changes to SaveExpressInterest: Preparing... [1, 23:17:25] Applying changes to SaveExpressInterest...: [1, 23:17:25] : Changes applied to SaveExpressInterest [1, 23:17:26] Apply changes to SaveExpressInterest: Changes applied [1, 00:24:11] Apply changes to SaveFamilyInfo: Preparing... [1, 00:24:12] Applying changes to SaveFamilyInfo...: [1, 00:24:12] : Changes applied to SaveFamilyInfo [1, 00:24:14] Apply changes to SaveFamilyInfo: Changes applied [2, 00:38:10] Apply changes to SaveGeneralInfo: Preparing... [2, 00:38:11] Applying changes to SaveGeneralInfo...: [2, 00:38:11] : Changes applied to SaveGeneralInfo [2, 00:38:12] Apply changes to SaveGeneralInfo: Changes applied [3, 00:40:21] Apply changes to SaveInboxInfo: Preparing... [3, 00:40:23] Applying changes to SaveInboxInfo...: [3, 00:40:23] : Changes applied to SaveInboxInfo [3, 00:40:24] Apply changes to SaveInboxInfo: Changes applied [4, 00:49:44] Apply changes to SavePartnerInfo: Preparing... [4, 00:49:45] Applying changes to SavePartnerInfo...: [4, 00:49:45] : Changes applied to SavePartnerInfo [4, 00:49:47] Apply changes to SavePartnerInfo: Changes applied [5, 00:56:01] Apply changes to SaveProfileInfo: Preparing... [5, 00:56:02] Applying changes to SaveProfileInfo...: [5, 00:56:02] : Changes applied to SaveProfileInfo [5, 00:56:04] Apply changes to SaveProfileInfo: Changes applied [6, 00:57:38] Apply changes to SaveSendMsg: Preparing... [6, 00:57:39] Applying changes to SaveSendMsg...: [6, 00:57:39] : Changes applied to SaveSendMsg [6, 00:57:41] Apply changes to SaveSendMsg: Changes applied [7, 01:02:37] Apply changes to SaveUserDetailsInfo: Preparing... [7, 01:02:39] Applying changes to SaveUserDetailsInfo...: [7, 01:02:39] : Changes applied to SaveUserDetailsInfo [7, 01:02:40] Apply changes to SaveUserDetailsInfo: Changes applied [8, 01:04:25] Apply changes to SaveUserLoginHistoryInfo: Preparing... [8, 01:04:27] Applying changes to SaveUserLoginHistoryInfo...: [8, 01:04:27] : Changes applied to SaveUserLoginHistoryInfo [8, 01:04:29] Apply changes to SaveUserLoginHistoryInfo: Changes applied [9, 01:08:53] Apply changes to SaveUsermembershipInfo: Preparing... [9, 01:08:54] Applying changes to SaveUsermembershipInfo...: [9, 01:08:54] : Changes applied to SaveUsermembershipInfo [9, 01:08:56] Apply changes to SaveUsermembershipInfo: Changes applied [10, 01:11:23] Apply changes to SaveViewLogInfo: Preparing... [10, 01:11:24] Applying changes to SaveViewLogInfo...: [10, 01:11:24] : Changes applied to SaveViewLogInfo [10, 01:11:25] Apply changes to SaveViewLogInfo: Changes applied [11, 01:13:10] Apply changes to UpdatePhoto: Preparing... [11, 01:13:11] Applying changes to UpdatePhoto...: [11, 01:13:11] : Changes applied to UpdatePhoto [11, 01:13:13] Apply changes to UpdatePhoto: Changes applied [12, 01:14:39] Apply changes to CustomerNumber: Preparing... [12, 01:14:41] Applying changes to CustomerNumber...: [12, 01:14:41] : Changes applied to CustomerNumber [12, 01:14:42] Apply changes to CustomerNumber: Changes applied [13, 01:24:51] Apply changes to GetNextProfileId: Preparing... [13, 01:24:52] Applying changes to GetNextProfileId...: [13, 01:24:52] : Changes applied to GetNextProfileId [13, 01:24:54] Apply changes to GetNextProfileId: Changes applied [14, 01:28:31] Apply changes to _SYNTAX_ERROR: Preparing... [14, 01:28:33] Apply changes to _SYNTAX_ERROR: Cancelled [15, 01:34:55] Apply changes to _SYNTAX_ERROR: Preparing... [15, 01:34:56] Apply changes to _SYNTAX_ERROR: Cancelled [16, 01:38:28] Apply changes to _SYNTAX_ERROR: Preparing... [16, 01:38:29] Apply changes to _SYNTAX_ERROR: Cancelled [17, 01:45:41] Apply changes to IsProfileView: Preparing... [17, 01:45:42] Applying changes to IsProfileView...: [17, 01:45:42] : Changes applied to IsProfileView [17, 01:45:43] Apply changes to IsProfileView: Changes applied [1, 18:19:44] INTERRUPT: Running... [1, 18:19:44] INTERRUPT: OK - Query already completed [2, 21:34:27] desc album: Running... [2, 21:34:27] desc album: Fetching... [2, 21:34:27] desc album: 6 row(s) returned [3, 21:39:29] desc profile: Running... [3, 21:39:29] desc profile: Fetching... [3, 21:39:29] desc profile: 8 row(s) returned [4, 21:42:24] desc contactdetail: Running... [4, 21:42:24] desc contactdetail: Fetching... [4, 21:42:24] desc contactdetail: 13 row(s) returned [5, 21:43:59] Apply changes to album: Preparing... [5, 21:44:02] Applying changes to album...: [5, 21:44:04] : Changes applied to album [5, 21:44:05] Apply changes to album: Changes applied [6, 21:44:13] desc album: Running... [6, 21:44:13] desc album: Fetching... [6, 21:44:13] desc album: 6 row(s) returned [7, 21:51:40] desc applicationexception: Running... [7, 21:51:40] desc applicationexception: Fetching... [7, 21:51:40] desc applicationexception: 9 row(s) returned [8, 21:52:26] desc ApplicationException: Running... [8, 21:52:26] desc ApplicationException: Fetching... [8, 21:52:26] desc ApplicationException: 9 row(s) returned [9, 21:52:32] DESC APPLICATIONEXCEPTION: Running... [9, 21:52:32] DESC APPLICATIONEXCEPTION: Fetching... [9, 21:52:32] DESC APPLICATIONEXCEPTION: 9 row(s) returned [10, 21:53:03] DESC applicationlog: Running... [10, 21:53:03] DESC applicationlog: Fetching... [10, 21:53:03] DESC applicationlog: 7 row(s) returned [11, 21:54:04] DESC EXPRESSINTEREST: Running... [11, 21:54:04] DESC EXPRESSINTEREST: Fetching... [11, 21:54:04] DESC EXPRESSINTEREST: 5 row(s) returned [12, 21:54:46] DESC FAMILYDETAIL: Running... [12, 21:54:46] DESC FAMILYDETAIL: Fetching... [12, 21:54:46] DESC FAMILYDETAIL: 15 row(s) returned [13, 21:55:45] DESC GENERALDETAIL: Running... [13, 21:55:45] DESC GENERALDETAIL: Fetching... [13, 21:55:45] DESC GENERALDETAIL: 38 row(s) returned [14, 21:56:38] DESC inbox: Running... [14, 21:56:38] DESC inbox: Fetching... [14, 21:56:38] DESC inbox: 7 row(s) returned [15, 21:58:37] Apply changes to inbox: Preparing... [15, 21:58:39] Applying changes to inbox...: [15, 21:58:40] : Changes applied to inbox [15, 21:58:41] Apply changes to inbox: Changes applied [16, 21:58:47] DESC inbox: Running... [16, 21:58:47] DESC inbox: Fetching... [16, 21:58:47] DESC inbox: 7 row(s) returned [17, 21:59:10] DESC livechatdetails: Running... [17, 21:59:10] DESC livechatdetails: Fetching... [17, 21:59:10] DESC livechatdetails: 10 row(s) returned [18, 21:59:58] DESC PARTNEREXPECTATION: Running... [18, 21:59:58] DESC PARTNEREXPECTATION: Fetching... [18, 21:59:58] DESC PARTNEREXPECTATION: 23 row(s) returned [19, 22:02:48] DESC sendmsg: Running... [19, 22:02:48] DESC sendmsg: Fetching... [19, 22:02:48] DESC sendmsg: 5 row(s) returned [20, 22:03:28] DESC SETTINGS: Running... [20, 22:03:28] DESC SETTINGS: Fetching... [20, 22:03:28] DESC SETTINGS: 9 row(s) returned [21, 22:04:03] DESC sysdiagrams: Running... [21, 22:04:03] DESC sysdiagrams: Fetching... [21, 22:04:04] DESC sysdiagrams: 5 row(s) returned [22, 22:04:13] DESC USERDETAILS: Running... [22, 22:04:13] DESC USERDETAILS: Fetching... [22, 22:04:14] DESC USERDETAILS: 23 row(s) returned [23, 22:05:07] DESC USERLOGINHISTORY: Running... [23, 22:05:07] DESC USERLOGINHISTORY: Fetching... [23, 22:05:07] DESC USERLOGINHISTORY: 4 row(s) returned [24, 22:05:42] DESC USERMEMBERSHIP: Running... [24, 22:05:42] DESC USERMEMBERSHIP: Fetching... [24, 22:05:42] DESC USERMEMBERSHIP: 21 row(s) returned [25, 22:06:37] DESC USERTYPE: Running... [25, 22:06:37] DESC USERTYPE: Fetching... [25, 22:06:37] DESC USERTYPE: 7 row(s) returned [26, 22:07:09] DESC VIEWLOG: Running... [26, 22:07:09] DESC VIEWLOG: Fetching... [26, 22:07:09] DESC VIEWLOG: 5 row(s) returned [27, 22:27:29] Apply changes to User_Type: Preparing... [27, 22:27:31] Applying changes to User_Type...: [27, 22:27:31] : Changes applied to User_Type [27, 22:27:33] Apply changes to User_Type: Changes applied [28, 22:27:46] DESC User_Type: Running... [28, 22:27:46] DESC User_Type: Fetching... [28, 22:27:46] DESC User_Type: 2 row(s) returned [29, 22:28:02] Apply changes to UserType: Preparing... [29, 22:28:03] Applying changes to UserType...: [29, 22:28:04] : Changes applied to UserType [29, 22:28:05] Apply changes to UserType: Changes applied [30, 22:28:08] DESC User_Type: Running... [30, 22:28:08] DESC User_Type: Error Code: 1146. Table 'matrimony.user_type' doesn't exist [31, 22:28:12] DESC UserType: Running... [31, 22:28:12] DESC UserType: Fetching... [31, 22:28:12] DESC UserType: 2 row(s) returned [32, 22:30:49] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Running... [32, 22:30:49] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Fetching... [32, 22:30:49] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : 0 row(s) returned [33, 22:31:24] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Running... [33, 22:31:24] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Fetching... [33, 22:31:24] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : 0 row(s) returned [34, 22:31:29] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Running... [34, 22:31:29] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Fetching... [34, 22:31:29] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : 0 row(s) returned [35, 22:32:00] Refresh Recordset: There are pending changes. Please commit or rollback first. [36, 22:32:01] Refresh Recordset: There are pending changes. Please commit or rollback first. [37, 22:32:01] Refresh Recordset: There are pending changes. Please commit or rollback first. [38, 22:32:37] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Running... [38, 22:32:37] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : Fetching... [38, 22:32:37] SELECT * FROM matrimony.UserType LIMIT 0, 1000 : 2 row(s) returned [1, 07:36:11] Apply changes to SubscriptionDetails: Preparing... [1, 07:36:14] Applying changes to SubscriptionDetails...: [1, 07:36:14] : Changes applied to SubscriptionDetails [1, 07:36:16] Apply changes to SubscriptionDetails: Changes applied [2, 07:36:35] DESC SubscriptionDetails: Running... [2, 07:36:35] DESC SubscriptionDetails: Fetching... [2, 07:36:35] DESC SubscriptionDetails: 6 row(s) returned [3, 07:38:26] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : Running... [3, 07:38:26] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : Fetching... [3, 07:38:26] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : 0 row(s) returned [4, 07:39:37] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : Running... [4, 07:39:37] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : Fetching... [4, 07:39:37] SELECT * FROM SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [1, 18:57:03] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [1, 18:57:03] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_ToProfileID' in 'where clause' [2, 18:57:13] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = '1' ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [2, 18:57:13] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = '1' ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Fetching... [2, 18:57:13] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = '1' ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : 0 row(s) returned [3, 22:47:57] Apply changes to MatrimonyDB: Preparing... [3, 22:48:03] Applying changes to MatrimonyDB...: [3, 22:48:04] : Changes applied to MatrimonyDB [3, 22:48:05] Apply changes to MatrimonyDB: Changes applied [4, 22:51:37] Apply changes to UserType: Preparing... [4, 22:51:44] Applying changes to UserType...: [4, 22:51:45] : Changes applied to UserType [4, 22:51:46] Apply changes to UserType: Changes applied [5, 22:52:09] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Running... [5, 22:52:09] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Fetching... [5, 22:52:09] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : 0 row(s) returned [6, 22:52:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Running... [6, 22:52:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Fetching... [6, 22:52:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : 0 row(s) returned [7, 22:53:04] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Running... [7, 22:53:04] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Fetching... [7, 22:53:04] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : 3 row(s) returned [8, 22:53:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Running... [8, 22:53:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Fetching... [8, 22:53:16] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : 3 row(s) returned [9, 00:56:16] Apply changes to AgentRegn: Preparing... [9, 00:56:19] Applying changes to AgentRegn...: [9, 00:56:26] Apply changes to AgentRegn: Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL Statement: CREATE TABLE `MatrimonyDB`.`AgentRegn` ( `AgentID` INT NOT NULL AUTO_INCREMENT COMMENT '', `AgentEmailID` VARCHAR(20) NOT NULL COMMENT '', `AgentPassword` VARCHAR(12) NOT NULL COMMENT '', `AgentFirstName` VARCHAR(30) NOT NULL COMMENT '', `AgentMiddleName` VARCHAR(20) NULL COMMENT '', `AgentLastName` VARCHAR(30) NOT NULL COMMENT '', `AgentMobileNum` VARCHAR(10) NOT NULL COMMENT '', `AgentAltNum` VARCHAR(10) NULL COMMENT '', `AgentAddress` VARCHAR(256) NOT NULL COMMENT '', `TermAndConditionFlag` TINYINT(1) NOT NULL COMMENT '', `AgentRegnDate` DATETIME NOT NULL DEFAULT NOW() COMMENT '', PRIMARY KEY (`AgentEmailID`) COMMENT '') [10, 01:32:52] Apply changes to AgentRegn: Preparing... [10, 01:32:54] Applying changes to AgentRegn...: [10, 01:33:05] Apply changes to AgentRegn: Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL Statement: CREATE TABLE `MatrimonyDB`.`AgentRegn` ( `AgentID` INT NOT NULL AUTO_INCREMENT COMMENT '', `AgentEmailID` VARCHAR(20) NOT NULL COMMENT '', `AgentPassword` VARCHAR(12) NOT NULL COMMENT '', `AgentFirstName` VARCHAR(30) NOT NULL COMMENT '', `AgentMiddleName` VARCHAR(20) NULL COMMENT '', `AgentLastName` VARCHAR(30) NOT NULL COMMENT '', `AgentMobileNum` VARCHAR(10) NOT NULL COMMENT '', `AgentAltNum` VARCHAR(10) NULL COMMENT '', `AgentAddress` VARCHAR(256) NOT NULL COMMENT '', `TermAndConditionFlag` TINYINT(1) NOT NULL COMMENT '', `AgentRegnDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', PRIMARY KEY (`AgentEmailID`) COMMENT '') [11, 01:33:17] Apply changes to AgentRegn: Preparing... [11, 01:33:20] Applying changes to AgentRegn...: [11, 01:33:28] Apply changes to AgentRegn: Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL Statement: CREATE TABLE `MatrimonyDB`.`AgentRegn` ( `AgentID` INT NOT NULL AUTO_INCREMENT COMMENT '', `AgentEmailID` VARCHAR(20) NOT NULL COMMENT '', `AgentPassword` VARCHAR(12) NOT NULL COMMENT '', `AgentFirstName` VARCHAR(30) NOT NULL COMMENT '', `AgentMiddleName` VARCHAR(20) NULL COMMENT '', `AgentLastName` VARCHAR(30) NOT NULL COMMENT '', `AgentMobileNum` VARCHAR(10) NOT NULL COMMENT '', `AgentAltNum` VARCHAR(10) NULL COMMENT '', `AgentAddress` VARCHAR(256) NOT NULL COMMENT '', `TermAndConditionFlag` TINYINT(1) NOT NULL COMMENT '', `AgentRegnDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', PRIMARY KEY (`AgentEmailID`) COMMENT '') [12, 01:34:03] Apply changes to AgentRegn: Preparing... [12, 01:34:16] Applying changes to AgentRegn...: [12, 01:34:16] : Changes applied to AgentRegn [12, 01:34:17] Apply changes to AgentRegn: Changes applied [13, 01:40:40] Apply changes to SubscriptionDetails: Preparing... [13, 01:40:44] Apply changes to SubscriptionDetails: [14, 01:40:49] Apply changes to SubscriptionDetails: Preparing... [14, 01:40:54] Apply changes to SubscriptionDetails: [15, 01:41:04] Apply changes to SubscriptionDetails: Preparing... [15, 01:41:06] Applying changes to SubscriptionDetails...: [15, 01:41:06] : Changes applied to SubscriptionDetails [15, 01:41:07] Apply changes to SubscriptionDetails: Changes applied [16, 01:41:23] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [16, 01:41:23] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [16, 01:41:23] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 0 row(s) returned [17, 01:42:33] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [17, 01:42:33] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [17, 01:42:33] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [18, 01:45:39] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [18, 01:45:39] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.expressinterest' doesn't exist [19, 01:45:47] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [19, 01:45:47] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = p_ToProfileID ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.expressinterest' doesn't exist [1, 00:51:49] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Running... [1, 00:51:49] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : Fetching... [1, 00:51:50] SELECT * FROM MatrimonyDB.UserType LIMIT 0, 1000 : 3 row(s) returned [2, 00:57:00] Apply changes to SubscriptionDetails: Preparing... [2, 00:57:05] Apply changes to SubscriptionDetails: Selected name conflicts with existing table `SubscriptionDetails`. [3, 00:57:35] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [3, 00:57:35] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [3, 00:57:35] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [4, 00:57:46] DROP TABLE `MatrimonyDB`.`SubscriptionDetails`: Running... [4, 00:57:46] DROP TABLE `MatrimonyDB`.`SubscriptionDetails`: 0 row(s) affected [5, 00:57:49] Apply changes to SubscriptionDetails: Preparing... [5, 00:57:51] Applying changes to SubscriptionDetails...: [5, 00:57:52] : Changes applied to SubscriptionDetails [5, 00:57:53] Apply changes to SubscriptionDetails: Changes applied [6, 00:57:58] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [6, 00:57:58] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [6, 00:57:58] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 0 row(s) returned [1, 21:04:45] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [1, 21:04:46] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [1, 21:04:46] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [2, 21:18:38] Apply changes to UserRegn: Preparing... [2, 21:18:44] Applying changes to UserRegn...: [2, 21:18:59] Apply changes to UserRegn: Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key SQL Statement: CREATE TABLE `MatrimonyDB`.`UserRegn` ( `UserID` INT NOT NULL AUTO_INCREMENT COMMENT '', `ProfileID` VARCHAR(12) NOT NULL COMMENT '', `EmailID` VARCHAR(15) NOT NULL COMMENT '', `AgentID` INT NULL COMMENT '', `SubscriptionCode` VARCHAR(12) NULL COMMENT '', `Password` VARCHAR(12) NOT NULL COMMENT '', `FirstName` VARCHAR(30) NOT NULL COMMENT '', `MiddleName` VARCHAR(20) NULL COMMENT '', `LastName` VARCHAR(30) NOT NULL COMMENT '', `Gender` VARCHAR(1) NOT NULL COMMENT '', `Dt_of_Birth` DATETIME NOT NULL COMMENT '', `Age` INT NOT NULL COMMENT '', `MotherTongue` VARCHAR(30) NOT NULL COMMENT '', `MaritalStatus` VARCHAR(20) NOT NULL COMMENT '', `Country` VARCHAR(20) NOT NULL COMMENT '', `City` VARCHAR(20) NOT NULL COMMENT '', `MobileNum` VARCHAR(10) NOT NULL COMMENT '', `LandlineNum` VARCHAR(10) NULL COMMENT '', `TermsAndConditionFlag` INT NOT NULL COMMENT '', `FollowUpPreference` VARCHAR(30) NULL COMMENT '', `UserRegistrationDate` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '', PRIMARY KEY (`ProfileID`, `EmailID`) COMMENT '', INDEX `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID` ASC) COMMENT '', INDEX `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode` ASC) COMMENT '', CONSTRAINT `FK_UserRegn_AgentRegn.AgentID` FOREIGN KEY (`AgentID`) REFERENCES `MatrimonyDB`.`AgentRegn` (`AgentID`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_UserRegn_SubscriptionDetails.SubscriptionCode` FOREIGN KEY (`SubscriptionCode`) REFERENCES `MatrimonyDB`.`SubscriptionDetails` (`SubscriptionCode`) ON DELETE NO ACTION ON UPDATE NO ACTION) COMMENT = 'This table is the base table, where user\'s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.' [3, 21:26:09] Apply changes to UserRegn: Preparing... [3, 21:26:11] Applying changes to UserRegn...: [3, 21:26:12] : Changes applied to UserRegn [3, 21:26:13] Apply changes to UserRegn: Changes applied [4, 21:26:51] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [4, 21:26:52] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [4, 21:26:52] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 0 row(s) returned [5, 21:36:09] Apply changes to Profile: Preparing... [5, 21:36:10] Applying changes to Profile...: [5, 21:36:10] : Changes applied to Profile [5, 21:36:12] Apply changes to Profile: Changes applied [6, 21:42:11] Apply changes to ProfileRenewal: Preparing... [6, 21:42:14] Apply changes to ProfileRenewal: [7, 21:42:17] Apply changes to ProfileRenewal: Preparing... [7, 21:42:19] Applying changes to ProfileRenewal...: [7, 21:42:19] : Changes applied to ProfileRenewal [7, 21:42:21] Apply changes to ProfileRenewal: Changes applied [8, 21:47:33] Apply changes to PaymentDetails: Preparing... [8, 21:47:35] Applying changes to PaymentDetails...: [8, 21:47:36] : Changes applied to PaymentDetails [8, 21:47:37] Apply changes to PaymentDetails: Changes applied [9, 21:48:21] Apply changes to ProfileRenewal: Preparing... [9, 21:48:23] Applying changes to ProfileRenewal...: [9, 21:48:24] : Changes applied to ProfileRenewal [9, 21:48:26] Apply changes to ProfileRenewal: Changes applied [10, 22:02:34] Apply changes to UserProfileReligionAstrology: Preparing... [10, 22:02:36] Applying changes to UserProfileReligionAstrology...: [10, 22:02:36] : Changes applied to UserProfileReligionAstrology [10, 22:02:41] Apply changes to UserProfileReligionAstrology: Changes applied [11, 22:11:06] Apply changes to UserProfileEducationOccupationDetails: Preparing... [11, 22:11:08] Applying changes to UserProfileEducationOccupationDetails...: [11, 22:11:08] : Changes applied to UserProfileEducationOccupationDetails [11, 22:11:10] Apply changes to UserProfileEducationOccupationDetails: Changes applied [12, 22:15:35] Apply changes to UserProfilePhysicalDetails: Preparing... [12, 22:15:37] Applying changes to UserProfilePhysicalDetails...: [12, 22:15:37] : Changes applied to UserProfilePhysicalDetails [12, 22:15:39] Apply changes to UserProfilePhysicalDetails: Changes applied [13, 22:18:57] Apply changes to UserProfileContactDetails: Preparing... [13, 22:18:59] Applying changes to UserProfileContactDetails...: [13, 22:19:00] : Changes applied to UserProfileContactDetails [13, 22:19:00] Apply changes to UserProfileContactDetails: Changes applied [14, 22:23:56] Apply changes to UserProfileFamilyDetails: Preparing... [14, 22:23:59] Applying changes to UserProfileFamilyDetails...: [14, 22:23:59] : Changes applied to UserProfileFamilyDetails [14, 22:24:00] Apply changes to UserProfileFamilyDetails: Changes applied [15, 22:31:36] Apply changes to UserProfilePartnerPreference: Preparing... [15, 22:31:37] Applying changes to UserProfilePartnerPreference...: [15, 22:31:38] : Changes applied to UserProfilePartnerPreference [15, 22:31:39] Apply changes to UserProfilePartnerPreference: Changes applied [16, 23:54:50] Apply changes to UserProfileLifestyle: Preparing... [16, 23:54:51] Applying changes to UserProfileLifestyle...: [16, 23:54:51] : Changes applied to UserProfileLifestyle [16, 23:54:52] Apply changes to UserProfileLifestyle: Changes applied [17, 23:59:34] Apply changes to UserProfileAlbum: Preparing... [17, 23:59:35] Applying changes to UserProfileAlbum...: [17, 23:59:36] : Changes applied to UserProfileAlbum [17, 23:59:37] Apply changes to UserProfileAlbum: Changes applied [18, 00:02:40] Apply changes to AdminAlbumImageVerification: Preparing... [18, 00:02:42] Applying changes to AdminAlbumImageVerification...: [18, 00:02:42] : Changes applied to AdminAlbumImageVerification [18, 00:02:43] Apply changes to AdminAlbumImageVerification: Changes applied [19, 00:04:14] Apply changes to ExpressInterest: Preparing... [19, 00:04:15] Applying changes to ExpressInterest...: [19, 00:04:16] : Changes applied to ExpressInterest [19, 00:04:17] Apply changes to ExpressInterest: Changes applied [20, 00:06:48] Apply changes to ExpressInterest: Preparing... [20, 00:06:50] Applying changes to ExpressInterest...: [20, 00:06:51] : Changes applied to ExpressInterest [20, 00:06:52] Apply changes to ExpressInterest: Changes applied [1, 02:26:00] Apply changes to Inbox: Preparing... [1, 02:26:01] Applying changes to Inbox...: [1, 02:26:02] : Changes applied to Inbox [1, 02:26:03] Apply changes to Inbox: Changes applied [1, 08:48:36] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [1, 08:48:37] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [1, 08:48:37] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 0 row(s) returned [2, 09:36:27] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Running... [2, 09:36:27] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Fetching... [2, 09:36:27] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : 0 row(s) returned [3, 09:36:53] SELECT * FROM MatrimonyDB.UserProfileContactDetails LIMIT 0, 1000 : Running... [3, 09:36:53] SELECT * FROM MatrimonyDB.UserProfileContactDetails LIMIT 0, 1000 : Fetching... [3, 09:36:53] SELECT * FROM MatrimonyDB.UserProfileContactDetails LIMIT 0, 1000 : 0 row(s) returned [1, 01:04:08] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [1, 01:04:09] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [1, 01:04:09] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 0 row(s) returned [1, 21:45:47] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [1, 21:45:47] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [1, 21:45:48] SELECT * FROM UserRegn LIMIT 0, 1000 : 0 row(s) returned [2, 21:49:11] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R, MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId: Running... [2, 21:49:11] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R, MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId: Error Code: 1064. 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 'ON R.ProfileId = P.ProfileId' at line 7 [3, 21:50:22] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Running... [3, 21:50:22] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.usermembership' doesn't exist [4, 21:50:35] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Running... [4, 21:50:35] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.usermembership' doesn't exist [5, 21:50:42] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Running... [5, 21:50:42] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId WHERE um.UserName = p_UserName LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_UserName' in 'where clause' [6, 21:50:53] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId LIMIT 0, 1000 : Running... [6, 21:50:53] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId LIMIT 0, 1000 : Fetching... [6, 21:50:53] SELECT um.UserName,um.Password,um.EmailId,ud.UserId, (SELECT gender FROM GeneralDetail WHERE ProfileId = (SELECT ProfileId FROM Profile p WHERE p.UserId=ud.UserId)) AS gender, (SELECT p.ProfileId FROM Profile p WHERE p.UserId=ud.UserId) AS ProfileID, (SELECT p.RequestLimit FROM Profile p WHERE p.UserId= ud.UserId) AS RequestLimit FROM Usermembership um INNER JOIN UserDetails ud ON um.UserId=ud.UserId LIMIT 0, 1000 : 0 row(s) returned [7, 21:51:26] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId=P.ProfileId LIMIT 0, 1000 : Running... [7, 21:51:26] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId=P.ProfileId LIMIT 0, 1000 : Fetching... [7, 21:51:26] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId=P.ProfileId LIMIT 0, 1000 : 0 row(s) returned [8, 21:51:35] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : Running... [8, 21:51:35] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : Fetching... [8, 21:51:35] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : 0 row(s) returned [9, 21:52:33] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : Running... [9, 21:52:33] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : Fetching... [9, 21:52:33] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId LIMIT 0, 1000 : 0 row(s) returned [10, 21:53:05] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = '' LIMIT 0, 1000 : Running... [10, 21:53:05] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = '' LIMIT 0, 1000 : Fetching... [10, 21:53:06] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = '' LIMIT 0, 1000 : 0 row(s) returned [11, 21:54:20] Apply changes to GetLoginInfo: Preparing... [11, 21:54:23] Applying changes to GetLoginInfo...: [11, 21:54:23] : Changes applied to GetLoginInfo [11, 21:54:24] Apply changes to GetLoginInfo: Changes applied [12, 21:55:51] exec GetLoginInfo(''): Running... [12, 21:55:51] exec GetLoginInfo(''): Error Code: 1064. 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 'exec GetLoginInfo('')' at line 1 [13, 21:56:00] EXECUTE GetLoginInfo(''): Running... [13, 21:56:00] EXECUTE GetLoginInfo(''): Error Code: 1064. 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 '('')' at line 1 [14, 21:56:03] EXECUTE GetLoginInfo(''): Running... [14, 21:56:03] EXECUTE GetLoginInfo(''): Error Code: 1064. 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 '('')' at line 1 [15, 21:56:09] GetLoginInfo(''): Running... [15, 21:56:09] GetLoginInfo(''): Error Code: 1064. 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 'GetLoginInfo('')' at line 1 [16, 22:22:46] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [16, 22:22:46] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [16, 22:22:46] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 0 row(s) returned [17, 22:24:17] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '07/12/1981', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1406: Data too long for column 'EmailID' at row 1 [18, 22:24:51] Apply changes to UserRegn: Preparing... [18, 22:24:53] Applying changes to UserRegn...: [18, 22:24:54] : Changes applied to UserRegn [18, 22:24:55] Apply changes to UserRegn: Changes applied [19, 22:25:09] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '07/12/1981', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1292: Incorrect datetime value: '07/12/1981' for column 'Dt_of_Birth' at row 1 [20, 22:25:36] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '07-Dec-1981', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1292: Incorrect datetime value: '07-Dec-1981' for column 'Dt_of_Birth' at row 1 [21, 22:26:06] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '12/07/1981', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1292: Incorrect datetime value: '12/07/1981' for column 'Dt_of_Birth' at row 1 [22, 22:26:38] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', 'Dec 07, 1981', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1292: Incorrect datetime value: 'Dec 07, 1981' for column 'Dt_of_Birth' at row 1 [23, 22:28:04] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '1981-12-07', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', 'Y', 'Email'): 1366: Incorrect integer value: 'Y' for column 'TermsAndConditionFlag' at row 1 [24, 22:28:43] INSERT INTO `MatrimonyDB`.`UserRegn` (`ProfileID`, `EmailID`, `SubscriptionCode`, `Password`, `FirstName`, `MiddleName`, `LastName`, `Gender`, `Dt_of_Birth`, `Age`, `MotherTongue`, `MaritalStatus`, `Country`, `City`, `MobileNum`, `TermsAndConditionFlag`, `FollowUpPreference`) VALUES ('1001', 'nikhil.satam@gmail.com', '1', 'nikhil', 'Nikhil', 'Prakash', 'Satam', 'M', '1981-12-07', '34', 'Marathi', 'M', 'India', 'Mumbai', '9930213860', '1', 'Email'): 1452: Cannot add or update a child row: a foreign key constraint fails (`matrimonydb`.`userregn`, CONSTRAINT `FK_UserRegn_SubscriptionDetails.SubscriptionCode` FOREIGN KEY (`SubscriptionCode`) REFERENCES `SubscriptionDetails` (`SubscriptionCode`) ON DELETE NO ACTI) [25, 22:29:04] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Running... [25, 22:29:04] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : Fetching... [25, 22:29:04] SELECT * FROM MatrimonyDB.SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [26, 22:29:31] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [26, 22:29:31] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [26, 22:29:31] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 1 row(s) returned [27, 22:29:46] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Running... [27, 22:29:46] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Fetching... [27, 22:29:46] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : 0 row(s) returned [28, 22:29:50] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [28, 22:29:50] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [28, 22:29:50] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 1 row(s) returned [29, 22:29:56] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Running... [29, 22:29:56] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Fetching... [29, 22:29:56] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : 0 row(s) returned [30, 22:30:17] INSERT INTO `MatrimonyDB`.`Profile` (`ProfileId`, `IsActive`, `RequestLimit`, `IsVerified`) VALUES ('1001', 'Y', '0', ''): 1366: Incorrect integer value: 'Y' for column 'IsActive' at row 1 [31, 22:30:31] INSERT INTO `MatrimonyDB`.`Profile` (`ProfileId`, `IsActive`, `RequestLimit`, `IsVerified`) VALUES ('1001', '1', '0', ''): 1366: Incorrect integer value: '' for column 'IsVerified' at row 1 [32, 22:31:08] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [32, 22:31:08] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [32, 22:31:08] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 1 row(s) returned [33, 22:31:08] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Running... [33, 22:31:08] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : Fetching... [33, 22:31:08] SELECT * FROM MatrimonyDB.Profile LIMIT 0, 1000 : 1 row(s) returned [34, 22:31:25] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Running... [34, 22:31:25] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Fetching... [34, 22:31:25] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : 1 row(s) returned [35, 00:18:50] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = 'Y' LIMIT 0, 1000 : Running... [35, 00:18:50] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = 'Y' LIMIT 0, 1000 : Fetching... [35, 00:18:51] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = 'Y' LIMIT 0, 1000 : 0 row(s) returned [36, 00:19:03] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Running... [36, 00:19:03] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Fetching... [36, 00:19:03] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : 1 row(s) returned [37, 00:19:11] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = '1' LIMIT 0, 1000 : Running... [37, 00:19:11] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = '1' LIMIT 0, 1000 : Fetching... [37, 00:19:11] SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = 'nikhil.satam@gmail.com' AND P.IsActive = '1' LIMIT 0, 1000 : 1 row(s) returned [38, 00:19:21] Apply changes to GetLoginInfo: Preparing... [38, 00:19:24] Applying changes to GetLoginInfo...: [38, 00:19:24] : Changes applied to GetLoginInfo [38, 00:19:25] Apply changes to GetLoginInfo: Changes applied [1, 00:43:47] Apply changes to GetLoginInfo: Preparing... [1, 00:43:49] Apply changes to GetLoginInfo: Selected name conflicts with existing procedure `GetLoginInfo`. [2, 00:43:59] Apply changes to GetLoginInfo: Preparing... [2, 00:44:01] Apply changes to GetLoginInfo: Selected name conflicts with existing procedure `GetLoginInfo`. [1, 00:45:03] Apply changes to GetLoginInfo: Preparing... [1, 00:45:04] Apply changes to GetLoginInfo: Selected name conflicts with existing procedure `GetLoginInfo`. [2, 00:47:26] Apply changes to Proc_GetLoginInfo: Preparing... [2, 00:47:28] Applying changes to Proc_GetLoginInfo...: [2, 00:47:28] : Changes applied to Proc_GetLoginInfo [2, 00:47:30] Apply changes to Proc_GetLoginInfo: Changes applied [3, 01:04:56] SELECT * FROM ExpressInterest LIMIT 0, 1000 : Running... [3, 01:04:57] SELECT * FROM ExpressInterest LIMIT 0, 1000 : Fetching... [3, 01:04:57] SELECT * FROM ExpressInterest LIMIT 0, 1000 : 0 row(s) returned [4, 01:09:07] Apply changes to Proc_DeleteExpressInterest: Preparing... [4, 01:09:09] Applying changes to Proc_DeleteExpressInterest...: [4, 01:09:09] : Changes applied to Proc_DeleteExpressInterest [4, 01:09:10] Apply changes to Proc_DeleteExpressInterest: Changes applied [5, 01:16:09] SELECT R.ProfileId AS PROFILE_ID, R.EmailID AS EMAIL_ID, R.MobileNum AS MOBILE_NUMBER, R.LandlineNum AS LANDLINE_NUMBER, C.AltMobNumber AS ALTERNATE_NUMBER, C.WorkPhone AS OFFICE_PHONE, C.WorkExtension AS OFFICE_EXT, C.FacebookProfile AS FACEBOOK_PROFILE, C.LinkedInProfile AS LINKEDIN_PROFILE FROM UserProfileContactDetails C INNER JOIN UserRegn R ON C.ProfileId = R.ProfileId WHERE PROFILEID = '1001' LIMIT 0, 1000 : Running... [5, 01:16:09] SELECT R.ProfileId AS PROFILE_ID, R.EmailID AS EMAIL_ID, R.MobileNum AS MOBILE_NUMBER, R.LandlineNum AS LANDLINE_NUMBER, C.AltMobNumber AS ALTERNATE_NUMBER, C.WorkPhone AS OFFICE_PHONE, C.WorkExtension AS OFFICE_EXT, C.FacebookProfile AS FACEBOOK_PROFILE, C.LinkedInProfile AS LINKEDIN_PROFILE FROM UserProfileContactDetails C INNER JOIN UserRegn R ON C.ProfileId = R.ProfileId WHERE PROFILEID = '1001' LIMIT 0, 1000 : Error Code: 1052. Column 'PROFILEID' in where clause is ambiguous [6, 01:16:34] SELECT R.ProfileId AS PROFILE_ID, R.EmailID AS EMAIL_ID, R.MobileNum AS MOBILE_NUMBER, R.LandlineNum AS LANDLINE_NUMBER, C.AltMobNumber AS ALTERNATE_NUMBER, C.WorkPhone AS OFFICE_PHONE, C.WorkExtension AS OFFICE_EXT, C.FacebookProfile AS FACEBOOK_PROFILE, C.LinkedInProfile AS LINKEDIN_PROFILE FROM UserProfileContactDetails C INNER JOIN UserRegn R ON C.ProfileId = R.ProfileId WHERE R.ProfileId = '1001' LIMIT 0, 1000 : Running... [6, 01:16:34] SELECT R.ProfileId AS PROFILE_ID, R.EmailID AS EMAIL_ID, R.MobileNum AS MOBILE_NUMBER, R.LandlineNum AS LANDLINE_NUMBER, C.AltMobNumber AS ALTERNATE_NUMBER, C.WorkPhone AS OFFICE_PHONE, C.WorkExtension AS OFFICE_EXT, C.FacebookProfile AS FACEBOOK_PROFILE, C.LinkedInProfile AS LINKEDIN_PROFILE FROM UserProfileContactDetails C INNER JOIN UserRegn R ON C.ProfileId = R.ProfileId WHERE R.ProfileId = '1001' LIMIT 0, 1000 : Fetching... [6, 01:16:34] SELECT R.ProfileId AS PROFILE_ID, R.EmailID AS EMAIL_ID, R.MobileNum AS MOBILE_NUMBER, R.LandlineNum AS LANDLINE_NUMBER, C.AltMobNumber AS ALTERNATE_NUMBER, C.WorkPhone AS OFFICE_PHONE, C.WorkExtension AS OFFICE_EXT, C.FacebookProfile AS FACEBOOK_PROFILE, C.LinkedInProfile AS LINKEDIN_PROFILE FROM UserProfileContactDetails C INNER JOIN UserRegn R ON C.ProfileId = R.ProfileId WHERE R.ProfileId = '1001' LIMIT 0, 1000 : 0 row(s) returned [7, 01:18:03] Apply changes to Proc_GetContactInfo: Preparing... [7, 01:18:04] Applying changes to Proc_GetContactInfo...: [7, 01:18:05] : Changes applied to Proc_GetContactInfo [7, 01:18:06] Apply changes to Proc_GetContactInfo: Changes applied [8, 01:21:36] SELECT COUNT(*) INTO ACTIVEUSERCOUNT FROM PROFILE WHERE ISACTIVE = 1: Running... [8, 01:21:36] SELECT COUNT(*) INTO ACTIVEUSERCOUNT FROM PROFILE WHERE ISACTIVE = 1: Error Code: 1327. Undeclared variable: ACTIVEUSERCOUNT [9, 01:21:47] SELECT COUNT(*) ACTIVEUSERCOUNT FROM PROFILE WHERE ISACTIVE = 1 LIMIT 0, 1000 : Running... [9, 01:21:48] SELECT COUNT(*) ACTIVEUSERCOUNT FROM PROFILE WHERE ISACTIVE = 1 LIMIT 0, 1000 : Fetching... [9, 01:21:48] SELECT COUNT(*) ACTIVEUSERCOUNT FROM PROFILE WHERE ISACTIVE = 1 LIMIT 0, 1000 : 1 row(s) returned [10, 01:23:11] Apply changes to Proc_GetActiveUserProfileCount: Preparing... [10, 01:23:13] Applying changes to Proc_GetActiveUserProfileCount...: [10, 01:23:13] : Changes applied to Proc_GetActiveUserProfileCount [10, 01:23:15] Apply changes to Proc_GetActiveUserProfileCount: Changes applied [11, 01:25:52] Apply changes to Proc_GetInActiveUserCount: Preparing... [11, 01:25:53] Applying changes to Proc_GetInActiveUserCount...: [11, 01:25:53] : Changes applied to Proc_GetInActiveUserCount [11, 01:25:55] Apply changes to Proc_GetInActiveUserCount: Changes applied [12, 01:29:40] CREATE TABLE `ApplicationLog` ( `LogID` int(11) NOT NULL AUTO_INCREMENT, `SessionID` varchar(50) NOT NULL, `ProfileId` varchar(12) DEFAULT NULL, `IPAddress` varchar(25) NOT NULL, `Page` varchar(512) NOT NULL, `CreateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `ModifyDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`LogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Running... [12, 01:29:42] CREATE TABLE `ApplicationLog` ( `LogID` int(11) NOT NULL AUTO_INCREMENT, `SessionID` varchar(50) NOT NULL, `ProfileId` varchar(12) DEFAULT NULL, `IPAddress` varchar(25) NOT NULL, `Page` varchar(512) NOT NULL, `CreateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `ModifyDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`LogID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: 0 row(s) affected [13, 01:30:15] SELECT COUNT(*) p_OnlineUserCount FROM APPLICATIONLOG LIMIT 0, 1000 : Running... [13, 01:30:15] SELECT COUNT(*) p_OnlineUserCount FROM APPLICATIONLOG LIMIT 0, 1000 : Fetching... [13, 01:30:15] SELECT COUNT(*) p_OnlineUserCount FROM APPLICATIONLOG LIMIT 0, 1000 : 1 row(s) returned [14, 01:30:24] SELECT * FROM APPLICATIONLOG LIMIT 0, 1000 : Running... [14, 01:30:24] SELECT * FROM APPLICATIONLOG LIMIT 0, 1000 : Fetching... [14, 01:30:24] SELECT * FROM APPLICATIONLOG LIMIT 0, 1000 : 0 row(s) returned [15, 01:32:08] Apply changes to Proc_GetOnlineUserCountOnCurrentDate: Preparing... [15, 01:32:09] Applying changes to Proc_GetOnlineUserCountOnCurrentDate...: [15, 01:32:09] : Changes applied to Proc_GetOnlineUserCountOnCurrentDate [15, 01:32:11] Apply changes to Proc_GetOnlineUserCountOnCurrentDate: Changes applied [1, 01:37:13] select * from UserRegn LIMIT 0, 1000 : Running... [1, 01:37:14] select * from UserRegn LIMIT 0, 1000 : Fetching... [1, 01:37:14] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [2, 01:38:14] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Running... [2, 01:38:14] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Error Code: 1064. 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 '' at line 15 [3, 01:38:34] Apply changes to Proc_GetLoginInfo: Preparing... [3, 01:38:36] Apply changes to Proc_GetLoginInfo: Selected name conflicts with existing procedure `Proc_GetLoginInfo`. [4, 01:42:03] Apply changes to Proc_GetTotalUserProfileCount: Preparing... [4, 01:42:24] Applying changes to Proc_GetTotalUserProfileCount...: [4, 01:42:24] : Changes applied to Proc_GetTotalUserProfileCount [4, 01:42:25] Apply changes to Proc_GetTotalUserProfileCount: Changes applied [1, 01:49:05] Apply changes to Proc_GetDataFromTables: Preparing... [1, 01:49:07] Applying changes to Proc_GetDataFromTables...: [1, 01:49:07] : Changes applied to Proc_GetDataFromTables [1, 01:49:08] Apply changes to Proc_GetDataFromTables: Changes applied [2, 01:56:07] SELECT (RTRIM((DATE_FORMAT(G.CreateDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(CreateDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(CreateDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [2, 01:56:07] SELECT (RTRIM((DATE_FORMAT(G.CreateDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(CreateDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(CreateDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'G.CreateDate' in 'field list' [3, 01:56:47] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [3, 01:56:47] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'HEIGHTFEET' in 'field list' [4, 01:56:54] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', --RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [4, 01:56:54] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', --RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' AS HEIGHT, G.City AS CITY, --CASTE, --EDUCATION, --OCCUPATION, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'HEIGHTFEET' in 'field list' [5, 01:57:03] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Running... [5, 01:57:03] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'CREATEDATE' in 'order clause' [6, 01:57:16] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [6, 01:57:16] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [6, 01:57:17] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName +' ' +G.MiddleName + ' ' +G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [7, 01:58:03] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [7, 01:58:03] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [7, 01:58:03] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [8, 01:58:22] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [8, 01:58:22] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [8, 01:58:22] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [9, 01:58:44] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName || G.MiddleName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [9, 01:58:44] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName || G.MiddleName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [9, 01:58:44] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', G.FirstName ||' ' ||G.MiddleName || ' ' ||G.LastName AS 'NAME', G.FirstName || G.MiddleName, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [10, 02:00:58] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [10, 02:00:58] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [10, 02:00:58] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [11, 02:01:09] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, '-', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [11, 02:01:09] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, '-', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [11, 02:01:09] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, '-', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [12, 02:01:12] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [12, 02:01:12] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [12, 02:01:12] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', G.City AS CITY, G.PROFILEID FROM UserRegn G WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 1 row(s) returned [13, 02:01:42] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : Running... [13, 02:01:42] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : Fetching... [13, 02:01:42] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : 0 row(s) returned [14, 02:03:46] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [14, 02:03:46] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [14, 02:03:46] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 0 row(s) returned [15, 02:04:10] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : Running... [15, 02:04:10] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : Fetching... [15, 02:04:10] SELECT * FROM UserProfilePhysicalDetails LIMIT 0, 1000 : 0 row(s) returned [16, 02:04:27] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Running... [16, 02:04:28] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Fetching... [16, 02:04:28] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : 0 row(s) returned [17, 02:04:47] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, G.Caste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [17, 02:04:47] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, G.Caste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'G.Caste' in 'field list' [18, 02:04:54] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, G.Caste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [18, 02:04:54] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, G.Caste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'G.Caste' in 'field list' [19, 02:05:07] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [19, 02:05:07] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [19, 02:05:07] SELECT * FROM UserRegn LIMIT 0, 1000 : 1 row(s) returned [20, 02:05:23] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Running... [20, 02:05:23] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Fetching... [20, 02:05:24] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : 0 row(s) returned [21, 02:05:52] SELECT * FROM UserProfileReligionAstrology LIMIT 0, 1000 : Running... [21, 02:05:53] SELECT * FROM UserProfileReligionAstrology LIMIT 0, 1000 : Fetching... [21, 02:05:53] SELECT * FROM UserProfileReligionAstrology LIMIT 0, 1000 : 0 row(s) returned [22, 02:07:28] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [22, 02:07:28] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [22, 02:07:28] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 0 row(s) returned [23, 02:07:52] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : Running... [23, 02:07:52] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : Fetching... [23, 02:07:53] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : 0 row(s) returned [24, 02:10:05] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste, E.Occupation FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Running... [24, 02:10:05] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste, E.Occupation FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : Fetching... [24, 02:10:05] SELECT (RTRIM((DATE_FORMAT(G.UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%m'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(G.Dt_of_Birth,'%Y')) AS 'AGE', P.Height AS HEIGHT, G.City AS CITY, G.PROFILEID, R.Caste, R.Subcaste, E.Occupation FROM UserRegn G INNER JOIN UserProfilePhysicalDetails P ON P.ProfileId = G.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE G.Gender = 'M' ORDER BY UserRegistrationDate DESC LIMIT 0, 1000 : 0 row(s) returned [25, 02:10:19] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : Running... [25, 02:10:19] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : Fetching... [25, 02:10:19] SELECT * FROM UserProfileEducationOccupationDetails LIMIT 0, 1000 : 0 row(s) returned [26, 02:12:26] Apply changes to Proc_GetDefaultSearchGrid: Preparing... [26, 02:12:30] Applying changes to Proc_GetDefaultSearchGrid...: [26, 02:12:30] : Changes applied to Proc_GetDefaultSearchGrid [26, 02:12:31] Apply changes to Proc_GetDefaultSearchGrid: Changes applied [1, 01:04:06] Apply changes to Proc_GetDefaultSearchGrid: Preparing... [1, 01:04:09] Apply changes to Proc_GetDefaultSearchGrid: Selected name conflicts with existing procedure `Proc_GetDefaultSearchGrid`. [1, 16:09:04] Apply changes to Proc_GetDefaultSearchGrid: Preparing... [1, 16:09:06] Apply changes to Proc_GetDefaultSearchGrid: Selected name conflicts with existing procedure `Proc_GetDefaultSearchGrid`. [2, 16:52:43] SELECT * FROM matrimony.sendmsg LIMIT 0, 1000 : Running... [2, 16:52:43] SELECT * FROM matrimony.sendmsg LIMIT 0, 1000 : Fetching... [2, 16:52:43] SELECT * FROM matrimony.sendmsg LIMIT 0, 1000 : 0 row(s) returned [3, 16:53:19] SELECT * FROM matrimony.inbox LIMIT 0, 1000 : Running... [3, 16:53:19] SELECT * FROM matrimony.inbox LIMIT 0, 1000 : Fetching... [3, 16:53:19] SELECT * FROM matrimony.inbox LIMIT 0, 1000 : 0 row(s) returned [4, 16:53:36] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Running... [4, 16:53:36] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Fetching... [4, 16:53:37] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : 0 row(s) returned [5, 16:53:40] SELECT * FROM matrimonydb.sendmsg LIMIT 0, 1000 : Running... [5, 16:53:41] SELECT * FROM matrimonydb.sendmsg LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.sendmsg' doesn't exist [6, 16:53:51] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Running... [6, 16:53:51] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Fetching... [6, 16:53:51] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : 0 row(s) returned [7, 16:56:49] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Running... [7, 16:56:49] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : Fetching... [7, 16:56:49] SELECT * FROM matrimonydb.inbox LIMIT 0, 1000 : 0 row(s) returned [8, 16:58:18] Apply changes to Proc_GetExistingMsg: Preparing... [8, 16:58:20] Applying changes to Proc_GetExistingMsg...: [8, 16:58:21] : Changes applied to Proc_GetExistingMsg [8, 16:58:22] Apply changes to Proc_GetExistingMsg: Changes applied [9, 16:58:26] Apply changes to Proc_GetExistingMsg: Preparing... [9, 16:58:26] Apply changes to Proc_GetExistingMsg: No changes detected [10, 16:58:28] Apply changes to Proc_GetExistingMsg: Preparing... [10, 16:58:28] Apply changes to Proc_GetExistingMsg: No changes detected [1, 17:00:51] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : Running... [1, 17:00:51] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : Fetching... [1, 17:00:51] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : 1 row(s) returned [2, 17:00:54] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : Running... [2, 17:00:54] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : Fetching... [2, 17:00:54] select COUNT(*) from ExpressInterest where ToProfileId = '1001' LIMIT 0, 1000 : 1 row(s) returned [3, 17:01:21] Apply changes to Proc_GetCountOfExpressInterestByProfileID: Preparing... [3, 17:01:30] Applying changes to Proc_GetCountOfExpressInterestByProfileID...: [3, 17:01:30] : Changes applied to Proc_GetCountOfExpressInterestByProfileID [3, 17:01:31] Apply changes to Proc_GetCountOfExpressInterestByProfileID: Changes applied [4, 17:03:10] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = '1001' ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Running... [4, 17:03:10] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT FULLNAME FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'NAME', (SELECT CITY FROM CONTACTDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(BIRTHOFDATE, '%Y')) FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'AGE', (SELECT RTRIM (HEIGHTFEET)+'.'+ RTRIM (HEIGHTINCH )+'"' FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE PROFILEID= EI.FROMPROFILEID ) AS 'OCCUPATION' FROM EXPRESSINTEREST EI WHERE TOPROFILEID = '1001' ORDER BY EI.CREATEDATE DESC LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.generaldetail' doesn't exist [5, 17:10:08] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Running... [5, 17:10:09] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT CASTE FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT EDUCATION FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT OCCUPATION FROM GENERALDETAIL WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.generaldetail' doesn't exist [6, 17:12:46] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT Caste FROM UserProfileReligionAstrology WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT Degree FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT Occupation FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Running... [6, 17:12:46] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT Caste FROM UserProfileReligionAstrology WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT Degree FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT Occupation FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'G.FirstName' in 'field list' [1, 17:13:01] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn G WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT Caste FROM UserProfileReligionAstrology WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT Degree FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT Occupation FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Running... [1, 17:13:01] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn G WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT Caste FROM UserProfileReligionAstrology WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT Degree FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT Occupation FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : Fetching... [1, 17:13:01] SELECT EI.FROMPROFILEID 'FROM', 'TO' = 'ME', (SELECT CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) FROM UserRegn G WHERE ProfileId= EI.FromProfileId) AS 'NAME', (SELECT CD.City FROM UserProfileContactDetails CD WHERE ProfileId= EI.FromProfileId ) AS 'CITY', (SELECT (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(R.Dt_of_Birth, '%Y')) FROM UserRegn R WHERE ProfileId= EI.FromProfileId ) AS 'AGE', (SELECT PD.Height FROM UserProfilePhysicalDetails PD WHERE ProfileId= EI.FromProfileId ) AS 'HEIGHT', (SELECT Caste FROM UserProfileReligionAstrology WHERE ProfileId= EI.FromProfileId ) AS 'CASTE', (SELECT Degree FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'EDUCATION', (SELECT Occupation FROM UserProfileEducationOccupationDetails WHERE ProfileId= EI.FromProfileId ) AS 'OCCUPATION' FROM ExpressInterest EI WHERE ToProfileId = '1001' ORDER BY EI.Dt_ExpressInterest DESC LIMIT 0, 1000 : 0 row(s) returned [2, 17:14:31] Apply changes to Proc_GetExpressInterestGrid: Preparing... [2, 17:14:33] Applying changes to Proc_GetExpressInterestGrid...: [2, 17:14:33] : Changes applied to Proc_GetExpressInterestGrid [2, 17:14:34] Apply changes to Proc_GetExpressInterestGrid: Changes applied [3, 17:16:36] Apply changes to Proc_GetFamilyInfo: Preparing... [3, 17:16:37] Applying changes to Proc_GetFamilyInfo...: [3, 17:16:37] : Changes applied to Proc_GetFamilyInfo [3, 17:16:39] Apply changes to Proc_GetFamilyInfo: Changes applied [4, 17:20:00] SELECT *, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth, '%Y')) as 'Age' FROM UserRegn WHERE ProfileID = '1001' LIMIT 0, 1000 : Running... [4, 17:20:00] SELECT *, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth, '%Y')) as 'Age' FROM UserRegn WHERE ProfileID = '1001' LIMIT 0, 1000 : Fetching... [4, 17:20:00] SELECT *, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth, '%Y')) as 'Age' FROM UserRegn WHERE ProfileID = '1001' LIMIT 0, 1000 : 1 row(s) returned [5, 17:20:35] Apply changes to Proc_GetGeneralInfo: Preparing... [5, 17:20:36] Applying changes to Proc_GetGeneralInfo...: [5, 17:20:36] : Changes applied to Proc_GetGeneralInfo [5, 17:20:37] Apply changes to Proc_GetGeneralInfo: Changes applied [6, 17:21:36] SELECT Image FROM ProfileMaster WHERE ProfileId = '1001' LIMIT 0, 1000 : Running... [6, 17:21:36] SELECT Image FROM ProfileMaster WHERE ProfileId = '1001' LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.profilemaster' doesn't exist [7, 17:21:56] SELECT Image FROM UserProfileAlbum WHERE ProfileId = '1001' LIMIT 0, 1000 : Running... [7, 17:21:56] SELECT Image FROM UserProfileAlbum WHERE ProfileId = '1001' LIMIT 0, 1000 : Fetching... [7, 17:21:56] SELECT Image FROM UserProfileAlbum WHERE ProfileId = '1001' LIMIT 0, 1000 : 0 row(s) returned [8, 17:22:24] Apply changes to ProcGetImage: Preparing... [8, 17:22:25] Applying changes to ProcGetImage...: [8, 17:22:25] : Changes applied to ProcGetImage [8, 17:22:26] Apply changes to ProcGetImage: Changes applied [9, 17:23:54] select Image from UserProfileAlbum LIMIT 0, 1000 : Running... [9, 17:23:54] select Image from UserProfileAlbum LIMIT 0, 1000 : Fetching... [9, 17:23:54] select Image from UserProfileAlbum LIMIT 0, 1000 : 0 row(s) returned [10, 17:24:25] Apply changes to ProcGetImageUrl: Preparing... [10, 17:24:27] Applying changes to ProcGetImageUrl...: [10, 17:24:27] : Changes applied to ProcGetImageUrl [10, 17:24:28] Apply changes to ProcGetImageUrl: Changes applied [11, 17:28:32] Apply changes to Proc_GetInboxCountReadMessages: Preparing... [11, 17:28:34] Applying changes to Proc_GetInboxCountReadMessages...: [11, 17:28:34] : Changes applied to Proc_GetInboxCountReadMessages [11, 17:28:35] Apply changes to Proc_GetInboxCountReadMessages: Changes applied [1, 19:24:28] SELECT * FROM Inbox WHERE ReadFlag = 'Y' LIMIT 0, 1000 : Running... [1, 19:24:29] SELECT * FROM Inbox WHERE ReadFlag = 'Y' LIMIT 0, 1000 : Fetching... [1, 19:24:29] SELECT * FROM Inbox WHERE ReadFlag = 'Y' LIMIT 0, 1000 : 0 row(s) returned [2, 19:28:42] declare p_LoginProfileID varchar(12): Running... [2, 19:28:42] declare p_LoginProfileID varchar(12): Error Code: 1064. 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 'declare p_LoginProfileID varchar(12)' at line 1 [3, 19:29:15] SELECT REPLACE(FromProfileId, p_LoginProfileID, 'Me') as 'From', REPLACE(ProfileId, p_LoginProfileID, 'Me') as 'To', 'Message', MessageDate as 'Date', Replace(FromProfileId + ProfileId, p_LoginProfileID, '') as 'ProfileID' FROM Inbox WHERE (FromProfileId = p_LoginProfileID or ProfileId = p_LoginProfileID) AND ReadFlag = 'Y' order by MessageDate desc LIMIT 0, 1000 : Running... [3, 19:29:15] SELECT REPLACE(FromProfileId, p_LoginProfileID, 'Me') as 'From', REPLACE(ProfileId, p_LoginProfileID, 'Me') as 'To', 'Message', MessageDate as 'Date', Replace(FromProfileId + ProfileId, p_LoginProfileID, '') as 'ProfileID' FROM Inbox WHERE (FromProfileId = p_LoginProfileID or ProfileId = p_LoginProfileID) AND ReadFlag = 'Y' order by MessageDate desc LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_LoginProfileID' in 'field list' [4, 19:29:49] SELECT REPLACE(FromProfileId, 'Me') as 'From', REPLACE(ProfileId, 'Me') as 'To', 'Message', MessageDate as 'Date', Replace(FromProfileId + ProfileId, '') as 'ProfileID' FROM Inbox WHERE (FromProfileId = '1001' or ProfileId = '1001') AND ReadFlag = 'Y' order by MessageDate desc: Running... [4, 19:29:49] SELECT REPLACE(FromProfileId, 'Me') as 'From', REPLACE(ProfileId, 'Me') as 'To', 'Message', MessageDate as 'Date', Replace(FromProfileId + ProfileId, '') as 'ProfileID' FROM Inbox WHERE (FromProfileId = '1001' or ProfileId = '1001') AND ReadFlag = 'Y' order by MessageDate desc: Error Code: 1064. 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 ') as 'From', REPLACE(ProfileId, 'Me') as 'To', 'Message', MessageDate as 'Dat' at line 2 [5, 19:30:25] SELECT FromProfileId as 'From', ProfileId as 'To', 'Message', MessageDate as 'Date', FromProfileId + ProfileId as 'ProfileID' FROM Inbox WHERE (FromProfileId = '1001' or ProfileId = '1001') AND ReadFlag = 'Y' order by MessageDate desc LIMIT 0, 1000 : Running... [5, 19:30:25] SELECT FromProfileId as 'From', ProfileId as 'To', 'Message', MessageDate as 'Date', FromProfileId + ProfileId as 'ProfileID' FROM Inbox WHERE (FromProfileId = '1001' or ProfileId = '1001') AND ReadFlag = 'Y' order by MessageDate desc LIMIT 0, 1000 : Fetching... [5, 19:30:25] SELECT FromProfileId as 'From', ProfileId as 'To', 'Message', MessageDate as 'Date', FromProfileId + ProfileId as 'ProfileID' FROM Inbox WHERE (FromProfileId = '1001' or ProfileId = '1001') AND ReadFlag = 'Y' order by MessageDate desc LIMIT 0, 1000 : 0 row(s) returned [6, 19:32:57] Apply changes to Proc_GetInboxGrid: Preparing... [6, 19:32:59] Applying changes to Proc_GetInboxGrid...: [6, 19:32:59] : Changes applied to Proc_GetInboxGrid [6, 19:33:01] Apply changes to Proc_GetInboxGrid: Changes applied [7, 19:37:24] SELECT * FROM Inbox LIMIT 0, 1000 : Running... [7, 19:37:24] SELECT * FROM Inbox LIMIT 0, 1000 : Fetching... [7, 19:37:24] SELECT * FROM Inbox LIMIT 0, 1000 : 0 row(s) returned [8, 19:40:07] select * from ExpressInterest LIMIT 0, 1000 : Running... [8, 19:40:08] select * from ExpressInterest LIMIT 0, 1000 : Fetching... [8, 19:40:08] select * from ExpressInterest LIMIT 0, 1000 : 0 row(s) returned [9, 19:42:35] Apply changes to Proc_GetLastRecordDate: Preparing... [9, 19:43:12] Applying changes to Proc_GetLastRecordDate...: [9, 19:43:12] : Changes applied to Proc_GetLastRecordDate [9, 19:43:14] Apply changes to Proc_GetLastRecordDate: Changes applied [1, 20:01:23] select * from UserProfilePartnerPreference LIMIT 0, 1000 : Running... [1, 20:01:23] select * from UserProfilePartnerPreference LIMIT 0, 1000 : Fetching... [1, 20:01:23] select * from UserProfilePartnerPreference LIMIT 0, 1000 : 0 row(s) returned [2, 20:02:04] Apply changes to Proc_GetPartnerInfo: Preparing... [2, 20:02:05] Applying changes to Proc_GetPartnerInfo...: [2, 20:02:05] : Changes applied to Proc_GetPartnerInfo [2, 20:02:07] Apply changes to Proc_GetPartnerInfo: Changes applied [3, 20:03:51] select Image from Profile LIMIT 0, 1000 : Running... [3, 20:03:51] select Image from Profile LIMIT 0, 1000 : Fetching... [3, 20:03:51] select Image from Profile LIMIT 0, 1000 : 1 row(s) returned [4, 20:03:59] select * from Profile where ProfileId = p_ProfileID LIMIT 0, 1000 : Running... [4, 20:03:59] select * from Profile where ProfileId = p_ProfileID LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_ProfileID' in 'where clause' [5, 20:04:03] select * from Profile LIMIT 0, 1000 : Running... [5, 20:04:03] select * from Profile LIMIT 0, 1000 : Fetching... [5, 20:04:03] select * from Profile LIMIT 0, 1000 : 1 row(s) returned [6, 20:07:33] select Image, ThumbImage, CASE WHEN IsVerified = 0 THEN 'UNAPPROVED' WHEN IsVerified = 1 THEN 'APPROVED' ELSE 'PENDING' END AS 'Img_Verification_Status' from Profile where ProfileId = '1001' LIMIT 0, 1000 : Running... [6, 20:07:33] select Image, ThumbImage, CASE WHEN IsVerified = 0 THEN 'UNAPPROVED' WHEN IsVerified = 1 THEN 'APPROVED' ELSE 'PENDING' END AS 'Img_Verification_Status' from Profile where ProfileId = '1001' LIMIT 0, 1000 : Fetching... [6, 20:07:33] select Image, ThumbImage, CASE WHEN IsVerified = 0 THEN 'UNAPPROVED' WHEN IsVerified = 1 THEN 'APPROVED' ELSE 'PENDING' END AS 'Img_Verification_Status' from Profile where ProfileId = '1001' LIMIT 0, 1000 : 1 row(s) returned [7, 20:08:23] Apply changes to Proc_GetProfilePhoto: Preparing... [7, 20:08:24] Applying changes to Proc_GetProfilePhoto...: [7, 20:08:25] : Changes applied to Proc_GetProfilePhoto [7, 20:08:26] Apply changes to Proc_GetProfilePhoto: Changes applied [8, 20:10:11] Select * From Profile LIMIT 0, 1000 : Running... [8, 20:10:11] Select * From Profile LIMIT 0, 1000 : Fetching... [8, 20:10:11] Select * From Profile LIMIT 0, 1000 : 1 row(s) returned [9, 20:10:57] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [9, 20:10:57] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [9, 20:10:57] SELECT * FROM UserRegn LIMIT 0, 1000 : 1 row(s) returned [10, 20:14:05] Apply changes to Proc_GetProfileIDByLoginEmailID: Preparing... [10, 20:14:06] Applying changes to Proc_GetProfileIDByLoginEmailID...: [10, 20:14:06] : Changes applied to Proc_GetProfileIDByLoginEmailID [10, 20:14:08] Apply changes to Proc_GetProfileIDByLoginEmailID: Changes applied [11, 20:15:11] SELECT * FROM Profile LIMIT 0, 1000 : Running... [11, 20:15:11] SELECT * FROM Profile LIMIT 0, 1000 : Fetching... [11, 20:15:11] SELECT * FROM Profile LIMIT 0, 1000 : 1 row(s) returned [12, 20:15:39] SELECT * FROM Profile WHERE PROFILEID = 1001 LIMIT 0, 1000 : Running... [12, 20:15:39] SELECT * FROM Profile WHERE PROFILEID = 1001 LIMIT 0, 1000 : Fetching... [12, 20:15:39] SELECT * FROM Profile WHERE PROFILEID = 1001 LIMIT 0, 1000 : 1 row(s) returned [13, 20:16:36] SELECT * FROM Profile P INNER JOIN UserRegn R ON P.ProfileId = R.ProfileId WHERE R.ProfileId = 1001 LIMIT 0, 1000 : Running... [13, 20:16:37] SELECT * FROM Profile P INNER JOIN UserRegn R ON P.ProfileId = R.ProfileId WHERE R.ProfileId = 1001 LIMIT 0, 1000 : Fetching... [13, 20:16:37] SELECT * FROM Profile P INNER JOIN UserRegn R ON P.ProfileId = R.ProfileId WHERE R.ProfileId = 1001 LIMIT 0, 1000 : 1 row(s) returned [14, 20:18:05] Apply changes to Proc_GetProfileInfo: Preparing... [14, 20:18:07] Applying changes to Proc_GetProfileInfo...: [14, 20:18:08] : Changes applied to Proc_GetProfileInfo [14, 20:18:09] Apply changes to Proc_GetProfileInfo: Changes applied [15, 20:32:09] SELECT (RTRIM((DATE_FORMAT(UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%M'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, C.City AS CITY, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION, G.PROFILEID AS PROFILE_ID FROM UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE C.CITY = p_City AND G.GENDER = p_Gender AND G.CASTE = p_Caste AND G.RELIGION = p_Religion ORDER BY G.CREATEDATE DESC, G.CASTE ASC LIMIT 0, 1000 : Running... [15, 20:32:09] SELECT (RTRIM((DATE_FORMAT(UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%M'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, C.City AS CITY, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION, G.PROFILEID AS PROFILE_ID FROM UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE C.CITY = p_City AND G.GENDER = p_Gender AND G.CASTE = p_Caste AND G.RELIGION = p_Religion ORDER BY G.CREATEDATE DESC, G.CASTE ASC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_City' in 'where clause' [16, 20:32:24] SELECT (RTRIM((DATE_FORMAT(UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%M'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, C.City AS CITY, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION, G.PROFILEID AS PROFILE_ID FROM UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId LIMIT 0, 1000 : Running... [16, 20:32:24] SELECT (RTRIM((DATE_FORMAT(UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%M'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, C.City AS CITY, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION, G.PROFILEID AS PROFILE_ID FROM UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId LIMIT 0, 1000 : Fetching... [16, 20:32:24] SELECT (RTRIM((DATE_FORMAT(UserRegistrationDate, '%D'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%M'))+'/'+ RTRIM(DATE_FORMAT(UserRegistrationDate, '%Y'))) )AS 'REGISTER DATE', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, C.City AS CITY, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION, G.PROFILEID AS PROFILE_ID FROM UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId LIMIT 0, 1000 : 0 row(s) returned [1, 20:36:11] Apply changes to Proc_GetProfileSearchCityGrid: Preparing... [1, 20:36:13] Applying changes to Proc_GetProfileSearchCityGrid...: [1, 20:36:13] : Changes applied to Proc_GetProfileSearchCityGrid [1, 20:36:14] Apply changes to Proc_GetProfileSearchCityGrid: Changes applied [2, 20:40:49] Apply changes to Proc_GetProfileSearchCityGrid: Preparing... [2, 20:40:51] Applying changes to Proc_GetProfileSearchCityGrid...: [2, 20:40:51] : Changes applied to Proc_GetProfileSearchCityGrid [2, 20:40:52] Apply changes to Proc_GetProfileSearchCityGrid: Changes applied [3, 20:43:47] Apply changes to ProcGetSearchDefaultGrid: Preparing... [3, 20:43:49] Applying changes to ProcGetSearchDefaultGrid...: [3, 20:43:49] : Changes applied to ProcGetSearchDefaultGrid [3, 20:43:50] Apply changes to ProcGetSearchDefaultGrid: Changes applied [4, 20:50:39] Apply changes to Proc_GetSearchGrid: Preparing... [4, 20:50:40] Applying changes to Proc_GetSearchGrid...: [4, 20:50:40] : Changes applied to Proc_GetSearchGrid [4, 20:50:41] Apply changes to Proc_GetSearchGrid: Changes applied [5, 20:53:09] Apply changes to Proc_GetSearchProfileIDGrid: Preparing... [5, 20:53:11] Applying changes to Proc_GetSearchProfileIDGrid...: [5, 20:53:11] : Changes applied to Proc_GetSearchProfileIDGrid [5, 20:53:12] Apply changes to Proc_GetSearchProfileIDGrid: Changes applied [6, 20:53:36] Apply changes to Proc_GetSearchDefaultGrid: Preparing... [6, 20:53:38] Applying changes to Proc_GetSearchDefaultGrid...: [6, 20:53:38] : Changes applied to Proc_GetSearchDefaultGrid [6, 20:53:40] Apply changes to Proc_GetSearchDefaultGrid: Changes applied [7, 20:55:06] SELECT COUNT(fromprofileID) FROM Inbox WHERE FromProfileId = '1001' LIMIT 0, 1000 : Running... [7, 20:55:07] SELECT COUNT(fromprofileID) FROM Inbox WHERE FromProfileId = '1001' LIMIT 0, 1000 : Fetching... [7, 20:55:07] SELECT COUNT(fromprofileID) FROM Inbox WHERE FromProfileId = '1001' LIMIT 0, 1000 : 1 row(s) returned [8, 20:55:48] Apply changes to Proc_GetSendMsgCount: Preparing... [8, 20:55:50] Applying changes to Proc_GetSendMsgCount...: [8, 20:55:50] : Changes applied to Proc_GetSendMsgCount [8, 20:55:51] Apply changes to Proc_GetSendMsgCount: Changes applied [9, 20:57:31] Apply changes to Proc_GetSendMsgCountByProfileID: Preparing... [9, 20:57:33] Applying changes to Proc_GetSendMsgCountByProfileID...: [9, 20:57:33] : Changes applied to Proc_GetSendMsgCountByProfileID [9, 20:57:34] Apply changes to Proc_GetSendMsgCountByProfileID: Changes applied [10, 21:02:09] SELECT 'From' = 'Me', sm.toProfileID 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM SendMsg sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Running... [10, 21:02:09] SELECT 'From' = 'Me', sm.toProfileID 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM SendMsg sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Error Code: 1146. Table 'matrimonydb.sendmsg' doesn't exist [11, 21:02:21] SELECT 'From' = 'Me', sm.toProfileID 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Running... [11, 21:02:21] SELECT 'From' = 'Me', sm.toProfileID 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'sm.toProfileID' in 'field list' [12, 21:02:37] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Running... [12, 21:02:37] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = p_fromProfileID ORDER BY sm.createdate DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_fromProfileID' in 'where clause' [13, 21:02:47] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = '1001' ORDER BY sm.createdate DESC LIMIT 0, 1000 : Running... [13, 21:02:47] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = '1001' ORDER BY sm.createdate DESC LIMIT 0, 1000 : Error Code: 1054. Unknown column 'sm.createdate' in 'order clause' [14, 21:03:13] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = '1001' ORDER BY sm.MessageDate DESC LIMIT 0, 1000 : Running... [14, 21:03:13] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = '1001' ORDER BY sm.MessageDate DESC LIMIT 0, 1000 : Fetching... [14, 21:03:13] SELECT 'From' = 'Me', sm.ProfileId 'To', CONCAT(G.FirstName, ' ', G.MiddleName , ' ', G.LastName) AS 'NAME', C.City AS CITY, (DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(Dt_of_Birth,'%Y')) AS 'AGE', PD.Height AS HEIGHT, R.Caste, E.Degree AS EDUCATION, E.Occupation AS OCCUPATION FROM Inbox sm, UserRegn G INNER JOIN UserProfileContactDetails C ON G.PROFILEID=C.PROFILEID INNER JOIN UserProfilePhysicalDetails PD ON G.ProfileId = PD.ProfileId INNER JOIN UserProfileReligionAstrology R ON G.ProfileId = R.ProfileId INNER JOIN UserProfileEducationOccupationDetails E ON G.ProfileId = E.ProfileId WHERE FromProfileId = '1001' ORDER BY sm.MessageDate DESC LIMIT 0, 1000 : 0 row(s) returned [15, 21:03:54] Apply changes to Proc_GetSendMsgGrid: Preparing... [15, 21:03:56] Applying changes to Proc_GetSendMsgGrid...: [15, 21:03:56] : Changes applied to Proc_GetSendMsgGrid [15, 21:03:57] Apply changes to Proc_GetSendMsgGrid: Changes applied [16, 21:04:53] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [16, 21:04:53] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [16, 21:04:53] SELECT * FROM UserRegn LIMIT 0, 1000 : 1 row(s) returned [17, 21:06:08] Apply changes to Proc_GetGenderOfInterestedProfile: Preparing... [17, 21:06:09] Applying changes to Proc_GetGenderOfInterestedProfile...: [17, 21:06:09] : Changes applied to Proc_GetGenderOfInterestedProfile [17, 21:06:10] Apply changes to Proc_GetGenderOfInterestedProfile: Changes applied [18, 21:09:04] COMMIT: Running... [18, 21:09:04] COMMIT: 0 row(s) affected [1, 01:07:24] desc UserRegn: Running... [1, 01:07:24] desc UserRegn: Fetching... [1, 01:07:24] desc UserRegn: 21 row(s) returned [2, 01:07:41] select * from UserRegn LIMIT 0, 1000 : Running... [2, 01:07:41] select * from UserRegn LIMIT 0, 1000 : Fetching... [2, 01:07:41] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [3, 01:08:56] select * from Profile LIMIT 0, 1000 : Running... [3, 01:08:56] select * from Profile LIMIT 0, 1000 : Fetching... [3, 01:08:56] select * from Profile LIMIT 0, 1000 : 1 row(s) returned [4, 01:09:18] select * from UserRegn LIMIT 0, 1000 : Running... [4, 01:09:18] select * from UserRegn LIMIT 0, 1000 : Fetching... [4, 01:09:18] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [5, 01:10:33] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Running... [5, 01:10:33] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_UserName' in 'where clause' [6, 01:10:36] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Running... [6, 01:10:36] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_UserName' in 'where clause' [7, 01:10:49] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Running... [7, 01:10:49] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : Fetching... [7, 01:10:49] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = 'nikhil.satam@gmail.com' LIMIT 0, 1000 : 1 row(s) returned [8, 01:11:08] EXPLAIN SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName: Executing [8, 01:11:08] EXPLAIN SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName: Error Code: 1054 Unknown column 'p_UserName' in 'where clause' [9, 01:11:11] EXPLAIN SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName: Executing [9, 01:11:11] EXPLAIN SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName: Error Code: 1054 Unknown column 'p_UserName' in 'where clause' [10, 01:11:17] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Running... [10, 01:11:17] SELECT Usr.EmailID, Usr.Password, Usr.ProfileId, Usr.Gender, Prof.RequestLimit, Prof.IsActive, Usr.SubscriptionCode FROM UserRegn Usr INNER JOIN Profile Prof ON Usr.ProfileId = Prof.ProfileId WHERE Usr.EmailID = p_UserName LIMIT 0, 1000 : Error Code: 1054. Unknown column 'p_UserName' in 'where clause' [11, 01:11:23] select * from UserRegn LIMIT 0, 1000 : Running... [11, 01:11:23] select * from UserRegn LIMIT 0, 1000 : Fetching... [11, 01:11:23] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [12, 01:13:11] Apply changes to Proc_GetSessionInfo: Preparing... [12, 01:13:13] Applying changes to Proc_GetSessionInfo...: [12, 01:13:13] : Changes applied to Proc_GetSessionInfo [12, 01:13:14] Apply changes to Proc_GetSessionInfo: Changes applied [13, 01:16:51] Apply changes to Proc_GetUserIDByUserName: Preparing... [13, 01:16:52] Applying changes to Proc_GetUserIDByUserName...: [13, 01:16:52] : Changes applied to Proc_GetUserIDByUserName [13, 01:16:54] Apply changes to Proc_GetUserIDByUserName: Changes applied [14, 01:20:04] CREATE TABLE `ApplicationException` ( `ExceptionID` int(11) NOT NULL AUTO_INCREMENT, `ProfileId` varchar(12) DEFAULT NULL, `SourceType` varchar(512) DEFAULT NULL, `Message` varchar(512) DEFAULT NULL, `InnerException` varchar(512) DEFAULT NULL, `StackTrace` longtext, `ExceptionDetail` varchar(512) DEFAULT NULL, `CreateDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `ModifyDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ExceptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Running... [14, 01:20:04] CREATE TABLE `ApplicationException` ( `ExceptionID` int(11) NOT NULL AUTO_INCREMENT, `ProfileId` varchar(12) DEFAULT NULL, `SourceType` varchar(512) DEFAULT NULL, `Message` varchar(512) DEFAULT NULL, `InnerException` varchar(512) DEFAULT NULL, `StackTrace` longtext, `ExceptionDetail` varchar(512) DEFAULT NULL, `CreateDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `ModifyDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ExceptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8: 0 row(s) affected [15, 01:21:56] Apply changes to Proc_SaveApplicationException: Preparing... [15, 01:21:58] Applying changes to Proc_SaveApplicationException...: [15, 01:21:58] : Changes applied to Proc_SaveApplicationException [15, 01:21:59] Apply changes to Proc_SaveApplicationException: Changes applied [16, 01:22:50] Apply changes to Proc_SaveApplicationLog: Preparing... [16, 01:22:52] Applying changes to Proc_SaveApplicationLog...: [16, 01:22:52] : Changes applied to Proc_SaveApplicationLog [16, 01:22:53] Apply changes to Proc_SaveApplicationLog: Changes applied [17, 01:25:14] select * from UserProfileContactDetails LIMIT 0, 1000 : Running... [17, 01:25:14] select * from UserProfileContactDetails LIMIT 0, 1000 : Fetching... [17, 01:25:14] select * from UserProfileContactDetails LIMIT 0, 1000 : 0 row(s) returned [18, 02:11:15] select * from ExpressInterest LIMIT 0, 1000 : Running... [18, 02:11:15] select * from ExpressInterest LIMIT 0, 1000 : Fetching... [18, 02:11:15] select * from ExpressInterest LIMIT 0, 1000 : 0 row(s) returned [19, 02:11:52] desc ExpressInterest: Running... [19, 02:11:52] desc ExpressInterest: Fetching... [19, 02:11:52] desc ExpressInterest: 5 row(s) returned [20, 02:11:58] select * from ExpressInterest LIMIT 0, 1000 : Running... [20, 02:11:58] select * from ExpressInterest LIMIT 0, 1000 : Fetching... [20, 02:11:58] select * from ExpressInterest LIMIT 0, 1000 : 0 row(s) returned [21, 02:12:02] desc ExpressInterest: Running... [21, 02:12:02] desc ExpressInterest: Fetching... [21, 02:12:02] desc ExpressInterest: 5 row(s) returned [22, 02:14:35] Apply changes to Proc_SaveExpressInterest: Preparing... [22, 02:14:36] Applying changes to Proc_SaveExpressInterest...: [22, 02:14:37] : Changes applied to Proc_SaveExpressInterest [22, 02:14:38] Apply changes to Proc_SaveExpressInterest: Changes applied [23, 02:15:35] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Running... [23, 02:15:36] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Fetching... [23, 02:15:36] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : 0 row(s) returned [24, 02:22:22] desc UserProfileFamilyDetails: Running... [24, 02:22:22] desc UserProfileFamilyDetails: Fetching... [24, 02:22:22] desc UserProfileFamilyDetails: 17 row(s) returned [25, 02:28:29] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Running... [25, 02:28:29] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : Fetching... [25, 02:28:29] SELECT * FROM UserProfileFamilyDetails LIMIT 0, 1000 : 0 row(s) returned [26, 02:32:21] Apply changes to Proc_SaveFamilyInfo: Preparing... [26, 02:32:23] Applying changes to Proc_SaveFamilyInfo...: [26, 02:32:23] : Changes applied to Proc_SaveFamilyInfo [26, 02:32:25] Apply changes to Proc_SaveFamilyInfo: Changes applied [27, 02:37:07] CREATE TABLE `UserLoginHistory` ( `LogId` bigint(20) NOT NULL, `UserId` int(11) NOT NULL, `LoginDateTime` datetime(6) NOT NULL, `LogOutTime` datetime(6) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8: Running... [27, 02:37:08] CREATE TABLE `UserLoginHistory` ( `LogId` bigint(20) NOT NULL, `UserId` int(11) NOT NULL, `LoginDateTime` datetime(6) NOT NULL, `LogOutTime` datetime(6) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8: 0 row(s) affected [1, 02:37:55] Apply changes to Proc_SaveUserLoginHistoryInfo: Preparing... [1, 02:37:56] Applying changes to Proc_SaveUserLoginHistoryInfo...: [1, 02:37:56] : Changes applied to Proc_SaveUserLoginHistoryInfo [1, 02:37:58] Apply changes to Proc_SaveUserLoginHistoryInfo: Changes applied [2, 02:38:59] SELECT * FROM Profile LIMIT 0, 1000 : Running... [2, 02:38:59] SELECT * FROM Profile LIMIT 0, 1000 : Fetching... [2, 02:38:59] SELECT * FROM Profile LIMIT 0, 1000 : 1 row(s) returned [3, 02:39:19] DESC Profile: Running... [3, 02:39:19] DESC Profile: Fetching... [3, 02:39:19] DESC Profile: 8 row(s) returned [4, 02:40:06] Apply changes to Proc_UpdatePhoto: Preparing... [4, 02:40:08] Applying changes to Proc_UpdatePhoto...: [4, 02:40:08] : Changes applied to Proc_UpdatePhoto [4, 02:40:09] Apply changes to Proc_UpdatePhoto: Changes applied [1, 20:59:47] DROP DATABASE `MatrimonyDB`: Running... [1, 20:59:50] DROP DATABASE `MatrimonyDB`: 21 row(s) affected [2, 21:00:54] DROP DATABASE `matrimony`: Running... [2, 21:00:56] DROP DATABASE `matrimony`: 20 row(s) affected [3, 21:04:46] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Running... [3, 21:04:47] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. [4, 21:04:57] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Running... [4, 21:04:57] CREATE DEFINER=`root`@`localhost` PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Error Code: 1064. 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 '' at line 15 [5, 21:05:17] CREATE PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Running... [5, 21:05:17] CREATE PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName: Error Code: 1064. 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 '' at line 15 [1, 21:06:25] CREATE PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName END: Running... [1, 21:06:25] CREATE PROCEDURE `Proc_GetLoginInfo`( IN p_UserName varchar(500) ) BEGIN SELECT R.EmailID as LoginID, R.Password as Password, R.ProfileId as ProfileId, P.IsActive as ProfileStatus FROM MatrimonyDB.UserRegn R INNER JOIN MatrimonyDB.Profile P ON R.ProfileId = P.ProfileId WHERE R.EmailID = p_UserName END: Error Code: 1064. 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 'END' at line 16 [1, 21:08:05] Apply changes to Proc_GetLoginInfo: Preparing... [1, 21:08:06] Apply changes to Proc_GetLoginInfo: Selected name conflicts with existing procedure `Proc_GetLoginInfo`. [1, 23:59:33] Apply changes to SP1: Preparing... [1, 23:59:35] Applying changes to SP1...: [1, 23:59:36] : Changes applied to SP1 [1, 23:59:37] Apply changes to SP1: Changes applied [1, 11:34:12] select * from UserRegn LIMIT 0, 1000 : Running... [1, 11:34:12] select * from UserRegn LIMIT 0, 1000 : Fetching... [1, 11:34:12] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [2, 11:51:20] delete from UserRegn: Running... [2, 11:51:20] delete from UserRegn: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. [3, 11:51:40] delete from UserRegn where ProfileId = 1001: Running... [3, 11:51:41] delete from UserRegn where ProfileId = 1001: Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. [1, 11:54:20] delete from UserRegn where ProfileId = 1001: Running... [1, 11:54:20] delete from UserRegn where ProfileId = 1001: Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`matrimonydb`.`profile`, CONSTRAINT `FK_Profile_UserRegn.ProfileID` FOREIGN KEY (`ProfileId`) REFERENCES `UserRegn` (`ProfileID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [2, 11:55:21] Apply changes to UserRegn: Preparing... [2, 11:55:28] Apply changes to UserRegn: [3, 11:55:48] Apply changes to UserRegn: Preparing... [3, 11:55:54] Applying changes to UserRegn...: [3, 11:55:55] : Changes applied to UserRegn [3, 11:55:57] Apply changes to UserRegn: Changes applied [4, 11:56:27] select * from UserRegn LIMIT 0, 1000 : Running... [4, 11:56:27] select * from UserRegn LIMIT 0, 1000 : Fetching... [4, 11:56:28] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [5, 11:56:42] DELETE FROM `MatrimonyDB`.`UserRegn` WHERE `ProfileID`='1001' and`UserID`='2': 1451: Cannot delete or update a parent row: a foreign key constraint fails (`matrimonydb`.`profile`, CONSTRAINT `FK_Profile_UserRegn.ProfileID` FOREIGN KEY (`ProfileId`) REFERENCES `UserRegn` (`ProfileID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [6, 11:57:51] select * from AgentRegn LIMIT 0, 1000 : Running... [6, 11:57:51] select * from AgentRegn LIMIT 0, 1000 : Fetching... [6, 11:57:51] select * from AgentRegn LIMIT 0, 1000 : 0 row(s) returned [7, 11:57:59] select *from SubscriptionDetails LIMIT 0, 1000 : Running... [7, 11:58:00] select *from SubscriptionDetails LIMIT 0, 1000 : Fetching... [7, 11:58:00] select *from SubscriptionDetails LIMIT 0, 1000 : 3 row(s) returned [8, 11:58:05] select * from UserRegn LIMIT 0, 1000 : Running... [8, 11:58:05] select * from UserRegn LIMIT 0, 1000 : Fetching... [8, 11:58:05] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [9, 11:58:53] Apply changes to UserRegn: Preparing... [9, 11:58:55] Applying changes to UserRegn...: [9, 11:58:55] : Changes applied to UserRegn [9, 11:58:57] Apply changes to UserRegn: Changes applied [10, 11:59:05] DELETE FROM `MatrimonyDB`.`UserRegn` WHERE `ProfileID`='1001' and`UserID`='2': 1451: Cannot delete or update a parent row: a foreign key constraint fails (`matrimonydb`.`profile`, CONSTRAINT `FK_Profile_UserRegn.ProfileID` FOREIGN KEY (`ProfileId`) REFERENCES `UserRegn` (`ProfileID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [11, 11:59:26] select * from UserRegn LIMIT 0, 1000 : Running... [11, 11:59:26] select * from UserRegn LIMIT 0, 1000 : Fetching... [11, 11:59:26] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [12, 11:59:43] Apply changes to UserRegn: Preparing... [12, 11:59:43] Apply changes to UserRegn: No changes detected [13, 11:59:49] Apply changes to UserRegn: Preparing... [13, 11:59:49] Apply changes to UserRegn: No changes detected [14, 12:00:07] select * from UserRegn LIMIT 0, 1000 : Running... [14, 12:00:07] select * from UserRegn LIMIT 0, 1000 : Fetching... [14, 12:00:07] select * from UserRegn LIMIT 0, 1000 : 1 row(s) returned [15, 12:00:17] DELETE FROM `MatrimonyDB`.`UserRegn` WHERE `ProfileID`='1001' and`UserID`='2': 1451: Cannot delete or update a parent row: a foreign key constraint fails (`matrimonydb`.`profile`, CONSTRAINT `FK_Profile_UserRegn.ProfileID` FOREIGN KEY (`ProfileId`) REFERENCES `UserRegn` (`ProfileID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [16, 12:00:37] DELETE FROM `MatrimonyDB`.`UserRegn` WHERE `ProfileID`='1001' and`UserID`='2': 1451: Cannot delete or update a parent row: a foreign key constraint fails (`matrimonydb`.`profile`, CONSTRAINT `FK_Profile_UserRegn.ProfileID` FOREIGN KEY (`ProfileId`) REFERENCES `UserRegn` (`ProfileID`) ON DELETE NO ACTION ON UPDATE NO ACTION) [17, 12:01:03] Apply changes to Profile: Preparing... [17, 12:01:05] Applying changes to Profile...: [17, 12:01:05] : Changes applied to Profile [17, 12:01:07] Apply changes to Profile: Changes applied [18, 12:01:18] select * from UserRegn LIMIT 0, 1000 : Running... [18, 12:01:18] select * from UserRegn LIMIT 0, 1000 : Fetching... [18, 12:01:19] select * from UserRegn LIMIT 0, 1000 : 0 row(s) returned [19, 12:01:38] Apply changes to UserRegn: Preparing... [19, 12:01:38] Apply changes to UserRegn: No changes detected [20, 12:04:53] CREATE TABLE `UserRegn` ( `UserID` int(11) NOT NULL, `ProfileID` varchar(12) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`,`UserID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Running... [20, 12:04:53] CREATE TABLE `UserRegn` ( `UserID` int(11) NOT NULL, `ProfileID` varchar(12) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`,`UserID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Error Code: 1063. Incorrect column specifier for column 'ProfileID' [21, 12:05:42] CREATE TABLE `UserRegn` ( `UserID` int(11) NOT NULL, `ProfileID` varchar(12) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Running... [21, 12:05:42] CREATE TABLE `UserRegn` ( `UserID` int(11) NOT NULL, `ProfileID` varchar(12) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Error Code: 1063. Incorrect column specifier for column 'ProfileID' [22, 12:07:08] CREATE TABLE `UserRegn` ( `UserID` varchar(12) NOT NULL, `ProfileID` int(11) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Running... [22, 12:07:08] CREATE TABLE `UserRegn` ( `UserID` varchar(12) NOT NULL, `ProfileID` int(11) NOT NULL AUTO_INCREMENT, `EmailID` varchar(30) NOT NULL, `AgentID` int(11) DEFAULT NULL, `SubscriptionCode` varchar(12) DEFAULT NULL, `Password` varchar(12) NOT NULL, `FirstName` varchar(30) NOT NULL, `MiddleName` varchar(20) DEFAULT NULL, `LastName` varchar(30) NOT NULL, `Gender` varchar(1) NOT NULL, `Dt_of_Birth` datetime NOT NULL, `Age` int(11) NOT NULL, `MotherTongue` varchar(30) NOT NULL, `MaritalStatus` varchar(20) NOT NULL, `Country` varchar(20) NOT NULL, `City` varchar(20) NOT NULL, `MobileNum` varchar(10) NOT NULL, `LandlineNum` varchar(10) DEFAULT NULL, `TermsAndConditionFlag` int(11) NOT NULL, `FollowUpPreference` varchar(30) DEFAULT NULL, `UserRegistrationDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ProfileID`), UNIQUE KEY `ProfileID_UNIQUE` (`ProfileID`), UNIQUE KEY `EmailID_UNIQUE` (`EmailID`), KEY `FK_UserRegn_AgentRegn.AgentID_idx` (`AgentID`), KEY `FK_UserRegn_SubscriptionDetails.SubscriptionCode_idx` (`SubscriptionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table is the base table, where user''s Profile ID will be stored. User registration basic information will be stored in this table. Profile ID will start from 1001 and will be incremented every time, when a new user registers. AgentID and SubscriptionCode are referential columns to AgentRegn and SubscriptionDetails table respectively.': Error Code: 1050. Table 'userregn' already exists [23, 12:09:15] Apply changes to UserRegn: Preparing... [23, 12:09:17] Applying changes to UserRegn...: [23, 12:09:27] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK1_ExpressInterest_UserRegn.ProfileID' of table 'matrimonydb.expressinterest' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [24, 12:10:11] Apply changes to ExpressInterest: Preparing... [24, 12:10:14] Apply changes to ExpressInterest: [25, 12:10:29] Apply changes to ExpressInterest: Preparing... [25, 12:10:31] Applying changes to ExpressInterest...: [25, 12:10:31] : Changes applied to ExpressInterest [25, 12:10:32] Apply changes to ExpressInterest: Changes applied [26, 12:10:37] Apply changes to UserRegn: Preparing... [26, 12:10:38] Applying changes to UserRegn...: [26, 12:10:45] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK1_Inbox_UserRegn.ProfileID' of table 'matrimonydb.inbox' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [27, 12:10:56] Apply changes to Inbox: Preparing... [27, 12:10:58] Applying changes to Inbox...: [27, 12:10:58] : Changes applied to Inbox [27, 12:11:00] Apply changes to Inbox: Changes applied [28, 12:11:04] Apply changes to UserRegn: Preparing... [28, 12:11:06] Applying changes to UserRegn...: [28, 12:11:11] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK_AdminAlbumImageVerification_UserRegn.ProfileID' of table 'matrimonydb.adminalbumimageverification' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [29, 12:11:26] Apply changes to AdminAlbumImageVerification: Preparing... [29, 12:11:27] Applying changes to AdminAlbumImageVerification...: [29, 12:11:28] : Changes applied to AdminAlbumImageVerification [29, 12:11:29] Apply changes to AdminAlbumImageVerification: Changes applied [30, 12:11:34] Apply changes to UserRegn: Preparing... [30, 12:11:35] Applying changes to UserRegn...: [30, 12:11:41] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK_PaymentDetails_UserRegn.ProfileID' of table 'matrimonydb.paymentdetails' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [31, 12:11:53] Apply changes to PaymentDetails: Preparing... [31, 12:11:54] Applying changes to PaymentDetails...: [31, 12:11:55] : Changes applied to PaymentDetails [31, 12:11:56] Apply changes to PaymentDetails: Changes applied [32, 12:12:00] Apply changes to UserRegn: Preparing... [32, 12:12:01] Applying changes to UserRegn...: [32, 12:12:08] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK_ProfileRenewal_UserRegn.ProfileID' of table 'matrimonydb.profilerenewal' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [33, 12:12:24] Apply changes to ProfileRenewal: Preparing... [33, 12:12:25] Applying changes to ProfileRenewal...: [33, 12:12:26] : Changes applied to ProfileRenewal [33, 12:12:26] Apply changes to ProfileRenewal: Changes applied [34, 12:12:29] Apply changes to UserRegn: Preparing... [34, 12:12:31] Applying changes to UserRegn...: [34, 12:12:35] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK_UserProfileAlbum_UserRegn.ProfileID' of table 'matrimonydb.userprofilealbum' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [35, 12:12:46] Apply changes to UserProfileAlbum: Preparing... [35, 12:12:47] Applying changes to UserProfileAlbum...: [35, 12:12:48] : Changes applied to UserProfileAlbum [35, 12:12:50] Apply changes to UserProfileAlbum: Changes applied [36, 12:12:53] Apply changes to UserRegn: Preparing... [36, 12:12:54] Applying changes to UserRegn...: [36, 12:12:58] Apply changes to UserRegn: Error 1833: Cannot change column 'ProfileID': used in a foreign key constraint 'FK_UserProfileContactDetails_UserRegn.ProfileID' of table 'matrimonydb.userprofilecontactdetails' SQL Statement: ALTER TABLE `MatrimonyDB`.`UserRegn` CHANGE COLUMN `UserID` `UserID` VARCHAR(20) NOT NULL COMMENT '' , CHANGE COLUMN `ProfileID` `ProfileID` INT(11) NOT NULL COMMENT '' , CHANGE COLUMN `SubscriptionCode` `SubscriptionCode` VARCHAR(12) NOT NULL COMMENT '' , DROP PRIMARY KEY, ADD PRIMARY KEY (`ProfileID`) COMMENT '', ADD UNIQUE INDEX `UserID_UNIQUE` (`UserID` ASC) COMMENT '', DROP INDEX `ProfileID_UNIQUE` [37, 12:13:08] Apply changes to UserProfileContactDetails: Preparing... [37, 12:13:10] Applying changes to UserProfileContactDetails...: [37, 12:13:10] : Changes applied to UserProfileContactDetails [37, 12:13:11] Apply changes to UserProfileContactDetails: Changes applied [38, 12:13:33] Apply changes to UserProfileEducationOccupationDetails: Preparing... [38, 12:13:34] Applying changes to UserProfileEducationOccupationDetails...: [38, 12:13:34] : Changes applied to UserProfileEducationOccupationDetails [38, 12:13:36] Apply changes to UserProfileEducationOccupationDetails: Changes applied [39, 12:13:45] Apply changes to UserProfileFamilyDetails: Preparing... [39, 12:13:46] Applying changes to UserProfileFamilyDetails...: [39, 12:13:46] : Changes applied to UserProfileFamilyDetails [39, 12:13:47] Apply changes to UserProfileFamilyDetails: Changes applied [40, 12:14:03] Apply changes to UserProfileLifestyle: Preparing... [40, 12:14:04] Applying changes to UserProfileLifestyle...: [40, 12:14:05] : Changes applied to UserProfileLifestyle [40, 12:14:06] Apply changes to UserProfileLifestyle: Changes applied [41, 12:14:17] Apply changes to UserProfilePartnerPreference: Preparing... [41, 12:14:18] Applying changes to UserProfilePartnerPreference...: [41, 12:14:18] : Changes applied to UserProfilePartnerPreference [41, 12:14:19] Apply changes to UserProfilePartnerPreference: Changes applied [42, 12:14:28] Apply changes to UserProfilePhysicalDetails: Preparing... [42, 12:14:29] Applying changes to UserProfilePhysicalDetails...: [42, 12:14:30] : Changes applied to UserProfilePhysicalDetails [42, 12:14:31] Apply changes to UserProfilePhysicalDetails: Changes applied [43, 12:14:41] Apply changes to UserProfileReligionAstrology: Preparing... [43, 12:14:42] Applying changes to UserProfileReligionAstrology...: [43, 12:14:42] : Changes applied to UserProfileReligionAstrology [43, 12:14:43] Apply changes to UserProfileReligionAstrology: Changes applied [44, 12:15:02] Apply changes to UserRegn: Preparing... [44, 12:15:04] Applying changes to UserRegn...: [44, 12:15:04] : Changes applied to UserRegn [44, 12:15:06] Apply changes to UserRegn: Changes applied [45, 12:15:32] Apply changes to UserRegn: Preparing... [45, 12:15:34] Applying changes to UserRegn...: [45, 12:15:35] : Changes applied to UserRegn [45, 12:15:35] Apply changes to UserRegn: Changes applied [46, 12:18:47] Apply changes to UserRegn: Preparing... [46, 12:18:48] Applying changes to UserRegn...: [46, 12:18:48] : Changes applied to UserRegn [46, 12:18:49] Apply changes to UserRegn: Changes applied [47, 12:19:04] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [47, 12:19:04] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [47, 12:19:04] SELECT * FROM UserRegn LIMIT 0, 1000 : 0 row(s) returned [48, 12:20:47] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [48, 12:20:47] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [48, 12:20:47] SELECT * FROM UserRegn LIMIT 0, 1000 : 1 row(s) returned [49, 12:21:11] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [49, 12:21:11] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [49, 12:21:11] SELECT * FROM UserRegn LIMIT 0, 1000 : 1 row(s) returned [50, 12:22:35] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [50, 12:22:35] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [50, 12:22:35] SELECT * FROM UserRegn LIMIT 0, 1000 : 2 row(s) returned [51, 12:22:57] SELECT * FROM UserRegn LIMIT 0, 1000 : Running... [51, 12:22:57] SELECT * FROM UserRegn LIMIT 0, 1000 : Fetching... [51, 12:22:57] SELECT * FROM UserRegn LIMIT 0, 1000 : 2 row(s) returned [52, 13:11:39] SELECT * FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Running... [52, 13:11:39] SELECT * FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Fetching... [52, 13:11:40] SELECT * FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : 1 row(s) returned [53, 13:14:07] Apply changes to UserRegn: Preparing... [53, 13:14:08] Applying changes to UserRegn...: [53, 13:14:08] : Changes applied to UserRegn [53, 13:14:09] Apply changes to UserRegn: Changes applied [54, 13:23:36] SELECT ISNULL(AGENTID, 01) FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Running... [54, 13:23:36] SELECT ISNULL(AGENTID, 01) FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Error Code: 1582. Incorrect parameter count in the call to native function 'ISNULL' [55, 13:25:48] SELECT IFNULL(AGENTID, 01) FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Running... [55, 13:25:48] SELECT IFNULL(AGENTID, 01) FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : Fetching... [55, 13:25:49] SELECT IFNULL(AGENTID, 01) FROM MatrimonyDB.UserRegn WHERE ProfileID = 1001 LIMIT 0, 1000 : 1 row(s) returned [56, 13:26:05] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [56, 13:26:05] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [56, 13:26:05] SELECT * FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 2 row(s) returned [57, 13:26:33] UPDATE `MatrimonyDB`.`UserRegn` SET `AgentID`='NULL' WHERE `ProfileID`='1001': 1366: Incorrect integer value: 'NULL' for column 'AgentID' at row 1 [58, 13:26:46] UPDATE `MatrimonyDB`.`UserRegn` SET `AgentID`='' WHERE `ProfileID`='1001': 1366: Incorrect integer value: '' for column 'AgentID' at row 1 [59, 13:32:15] Apply changes to Proc_QuickRegisterProfile: Preparing... [59, 13:32:17] Applying changes to Proc_QuickRegisterProfile...: [59, 13:32:17] : Changes applied to Proc_QuickRegisterProfile [59, 13:32:18] Apply changes to Proc_QuickRegisterProfile: Changes applied [60, 13:33:44] Apply changes to UserRegn: Preparing... [60, 13:33:45] Applying changes to UserRegn...: [60, 13:33:46] : Changes applied to UserRegn [60, 13:33:47] Apply changes to UserRegn: Changes applied [61, 13:36:52] SELECT STR_TO_DATE(Dt_of_Birth, '%d,%m,%Y'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [61, 13:36:53] SELECT STR_TO_DATE(Dt_of_Birth, '%d,%m,%Y'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [61, 13:36:53] SELECT STR_TO_DATE(Dt_of_Birth, '%d,%m,%Y'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 2 row(s) returned [62, 13:37:05] SELECT STR_TO_DATE(Dt_of_Birth, '%Y,%m,%d'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Running... [62, 13:37:05] SELECT STR_TO_DATE(Dt_of_Birth, '%Y,%m,%d'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : Fetching... [62, 13:37:05] SELECT STR_TO_DATE(Dt_of_Birth, '%Y,%m,%d'), Dt_of_Birth FROM MatrimonyDB.UserRegn LIMIT 0, 1000 : 2 row(s) returned [63, 13:38:37] Apply changes to Proc_QuickRegisterProfile: Preparing... [63, 13:38:39] Applying changes to Proc_QuickRegisterProfile...: [63, 13:38:39] : Changes applied to Proc_QuickRegisterProfile [63, 13:38:40] Apply changes to Proc_QuickRegisterProfile: Changes applied [64, 13:38:55] Apply changes to Proc_QuickRegisterProfile: Preparing... [64, 13:39:20] Applying changes to Proc_QuickRegisterProfile...: [64, 13:39:20] : Changes applied to Proc_QuickRegisterProfile [64, 13:39:22] Apply changes to Proc_QuickRegisterProfile: Changes applied [65, 13:41:41] Apply changes to Proc_QuickRegisterProfile: Preparing... [65, 13:41:42] Applying changes to Proc_QuickRegisterProfile...: [65, 13:41:42] : Changes applied to Proc_QuickRegisterProfile [65, 13:41:43] Apply changes to Proc_QuickRegisterProfile: Changes applied