File: /home/cafsindia/tmp/sess_bc26af4cf5cad015cb7375272a522421
PMA_token |s:32:"273f605b5c654b713674466d54633b25"; HMAC_secret |s:16:"jk!|>*`L9.iymxEM";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1778421017;}encryption_key|s:32:"�@� !�,��o��U�X��i�|�-�";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:1:{s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1778420533;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1778420533;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1778225437;s:9:"userprefs";a:1:{s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:25:"server_1_cpses_cadxx4xlw9";a:12:{s:17:"is_create_db_priv";b:1;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:6:"groups";s:30:"dbs_where_create_table_allowed";a:43:{i:0;s:13:"collman\_hrms";i:1;s:8:"spa\_crm";i:2;s:12:"redmine\_new";i:3;s:6:"zensys";i:4;s:7:"cafscrm";i:5;s:15:"cafsindia\_hrms";i:6;s:15:"hrms\_patroniss";i:7;s:6:"groups";i:8;s:16:"cafsindia\_login";i:9;s:20:"redmine\_development";i:10;s:30:"cafsindia\_dhanasekarankknagar";i:11;s:15:"hrms\_cafsindia";i:12;s:17:"cafsindia\_otlpav";i:13;s:14:"wp\_orthovijay";i:14;s:8:"lifemaze";i:15;s:3:"crm";i:16;s:15:"cafsindia\_test";i:17;s:18:"cafsindia\_website";i:18;s:7:"cafsrms";i:19;s:13:"redmine\_test";i:20;s:12:"uvdesk\_cafs";i:21;s:13:"redmine\_prod";i:22;s:13:"rebardnd\_dev";i:23;s:15:"cafsindia\_prod";i:24;s:16:"cafsindia\_fro45";i:25;s:8:"allyhrms";i:26;s:12:"redmine\_pms";i:27;s:11:"goeazit\_db";i:28;s:22:"cafsindia\_development";i:29;s:12:"cafs\_wealth";i:30;s:17:"cafsindia\_hkfjra";i:31;s:13:"web\_amazeing";i:32;s:17:"cafsindia\_mfgoyx";i:33;s:6:"quizzy";i:34;s:16:"pothys\_hrms\_db";i:35;s:19:"sblttweb\_wordpress";i:36;s:28:"cafsindia\_cafsindia\_otlpav";i:37;s:17:"refimacservicecrm";i:38;s:22:"cafsindia\_rmscafsjobs";i:39;s:14:"ntc\_logistics";i:40;s:18:"cafsinfotech\_live";i:41;s:5:"cattr";i:42;s:29:"cafsindia\_medlocker\_backend";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}}}tmpval|a:14:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:0:{}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:7:"cafsrms";s:5:"query";a:10:{s:32:"20c730a407e55dc6d5a7e7d393557eff";a:8:{s:3:"sql";s:35:"DROP PROCEDURE IF EXISTS `sp_a_run`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"e69cc1031ea78a915dcb56e603978819";a:8:{s:3:"sql";s:42:"DROP PROCEDURE IF EXISTS `sp_a_table_info`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"7483a8d9759649212241b004b63cf729";a:8:{s:3:"sql";s:50:"DROP PROCEDURE IF EXISTS `sp_chart_setting_search`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"8d34d1c756cdcda951a8ae61b6f9d1b6";a:8:{s:3:"sql";s:39:"DROP PROCEDURE IF EXISTS `sp_cond_crud`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"f447e02c00fbaff5aa0be081672668c7";a:8:{s:3:"sql";s:54:"DROP PROCEDURE IF EXISTS `sp_utilities_setting_search`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"f7ae79df8e65e14876c52d33604d9477";a:8:{s:3:"sql";s:52:"DROP PROCEDURE IF EXISTS `sp_form_view_setting_crud`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"3e339208a338d75f8a7ba679c0d802c3";a:8:{s:3:"sql";s:48:"DROP PROCEDURE IF EXISTS `sp_custom_form_search`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"3cf3b2bb5977f53ad58c1714013baa76";a:8:{s:3:"sql";s:49:"DROP PROCEDURE IF EXISTS `sp_form_setting_search`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"9c57673395fe5078bb941c10c7345c98";a:8:{s:3:"sql";s:50:"DROP PROCEDURE IF EXISTS `sp_print_setting_search`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"8e95b9e4e4b58b15da620facef1137f6";a:8:{s:3:"sql";s:47:"DROP PROCEDURE IF EXISTS `sp_form_setting_crud`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}Import_message|a:2:{s:7:"message";s:1682:"<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>Static analysis:</strong></p><p>3 errors were found during analysis.</p><p><ol><li>Unrecognized statement type. (near "IF" at position 224)</li><li>Unrecognized statement type. (near "END" at position 291)</li><li>Unrecognized statement type. (near "END" at position 299)</li></ol></p><p><strong>SQL query:</strong> <a href="#" class="copyQueryBtn" data-text="--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_a_run` (`cw_action` VARCHAR(255), `cw_query` TEXT) BEGIN
SET @buffer = cw_query;
PREPARE stmt FROM @buffer;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
IF cw_action = "INSERT" THEN
SELECT LAST_INSERT_ID() as ins_id;
END IF;
END;">Copy</a>
<a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fselect.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a> </p>
<p>
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_a_run` (`cw_action` VARCHAR(255), `cw_query` TEXT) BEGIN
SET @buffer = cw_query;
PREPARE stmt FROM @buffer;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
IF cw_action = "INSERT" THEN
SELECT LAST_INSERT_ID() as ins_id;
END IF;
END;
</p>
<p>
<strong>MySQL said: </strong><a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
</p>
<code>#1227 - Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation</code><br></div>";s:11:"go_back_url";s:63:"index.php?route=/database/import&db=cafsrms&no_history=true";}is_multi_query|b:0;sql_history|a:1:{i:0;a:3:{s:2:"db";s:7:"cafsrms";s:5:"table";s:0:"";s:8:"sqlquery";s:332:"DROP TABLE `cw_active_status`, `cw_app_config`, `cw_assign_log`, `cw_blood_group`, `cw_branch`, `cw_candidate_status`, `cw_candidate_tracker`, `cw_candidate_tracker_educational_qualification`, `cw_candidate_tracker_log`, `cw_candidate_tracker_working_experience`, `cw_category`, `cw_channel`, `cw_company`, `cw_company_information`;";}}errors|a:0:{}