[31-Dec-2025 13:01:46 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 13:01:46 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[31-Dec-2025 13:01:46 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 13:01:46 Asia/Tehran] LOGO DEBUG - File exists: Yes
[31-Dec-2025 23:01:03 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 23:01:03 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[31-Dec-2025 23:01:03 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 23:01:03 Asia/Tehran] LOGO DEBUG - File exists: Yes
[31-Dec-2025 23:33:56 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 23:33:56 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[31-Dec-2025 23:33:56 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[31-Dec-2025 23:33:56 Asia/Tehran] LOGO DEBUG - File exists: Yes
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - File exists: Yes
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 01:27:15 Asia/Tehran] LOGO DEBUG - File exists: Yes
[01-Jan-2026 23:25:41 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 23:25:41 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[01-Jan-2026 23:25:41 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[01-Jan-2026 23:25:41 Asia/Tehran] LOGO DEBUG - File exists: Yes
[02-Jan-2026 01:08:00 Asia/Tehran] LOGO DEBUG - URL from get_logo(): assets/uploads/logo/logo_1766493624.png
[02-Jan-2026 01:08:00 Asia/Tehran] LOGO DEBUG - BASE_URL: https://web.rahnamaseo.com/NikanCRM/
[02-Jan-2026 01:08:00 Asia/Tehran] LOGO DEBUG - Full path: /home/webrahnamaseo/public_html/NikanCRM/assets/uploads/logo/logo_1766493624.png
[02-Jan-2026 01:08:00 Asia/Tehran] LOGO DEBUG - File exists: Yes
[02-Jan-2026 02:06:34 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'registration_source' in 'where clause'
[02-Jan-2026 02:06:34 Asia/Tehran] Error in getPropertyStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'registration_source' in 'where clause'
[02-Jan-2026 02:06:34 Asia/Tehran] Error in getUserStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.is_archived' in 'on clause'
[02-Jan-2026 02:20:15 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:20:15 Asia/Tehran] Error in getUserStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.display_name' in 'field list'
[02-Jan-2026 02:23:08 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:23:08 Asia/Tehran] Error in getUserStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.display_name' in 'field list'
[02-Jan-2026 02:36:26 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:36:26 Asia/Tehran] Error in getUserStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[02-Jan-2026 02:45:06 Asia/Tehran] Error in getUserStatsComplete: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[02-Jan-2026 02:57:50 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:57:50 Asia/Tehran] Error in getUserStatsComplete: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[02-Jan-2026 02:58:35 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:58:35 Asia/Tehran] Error in getUserStatsComplete: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[02-Jan-2026 02:58:41 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:58:41 Asia/Tehran] Error in getUserStatsComplete: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[02-Jan-2026 02:58:57 Asia/Tehran] Error in getBuyerStats: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_by' in 'where clause'
[02-Jan-2026 02:58:57 Asia/Tehran] Error in getUserStatsComplete: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.role' in 'where clause'
[04-Jan-2026 00:30:46 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 00:30:46 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 00:30:49 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 00:30:49 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:01:23 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:01:23 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:01:30 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:01:30 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:01:45 Asia/Tehran] خطا در ایجاد اعلان عمومی: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_superadmin' in 'where clause'
[04-Jan-2026 01:03:02 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:03:02 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:03:41 Asia/Tehran] خطا در ایجاد اعلان عمومی: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_superadmin' in 'where clause'
[04-Jan-2026 01:08:20 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:08:31 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:09:16 Asia/Tehran] خطا در ایجاد اعلان عمومی: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'admin_id' cannot be null
[04-Jan-2026 01:10:49 Asia/Tehran] خطا در ارسال پیام ساده: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:11:00 Asia/Tehran] خطا در ایجاد اعلان عمومی: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'admin_id' cannot be null
[04-Jan-2026 01:37:14 Asia/Tehran] Error in create_public_message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`public_messages`, CONSTRAINT `public_messages_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:38:03 Asia/Tehran] Found conversations: 0
[04-Jan-2026 01:38:44 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 01:38:44 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 02:09:23 Asia/Tehran] خطا در ایجاد گفتگوی جدید: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 02:09:23 Asia/Tehran] خطا در ارسال پیام: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`webrahnamaseo_rahnamaseo`.`personal_messages`, CONSTRAINT `personal_messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE)
[04-Jan-2026 02:32:18 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:32:18 Asia/Tehran] User ID: 1
[04-Jan-2026 02:32:18 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:32:18 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:32:18 Asia/Tehran] DEBUG get_conversation: User ID = 1, Contact ID = 2
[04-Jan-2026 02:32:18 Asia/Tehran] DEBUG: Found 38 messages
[04-Jan-2026 02:32:18 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:32:18 Asia/Tehran] User ID: 1
[04-Jan-2026 02:32:18 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:32:18 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:32:18 Asia/Tehran] DEBUG get_conversation: User ID = 1, Contact ID = 2
[04-Jan-2026 02:32:18 Asia/Tehran] DEBUG: Found 38 messages
[04-Jan-2026 02:42:48 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:42:48 Asia/Tehran] User ID: 1
[04-Jan-2026 02:42:48 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:42:48 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:42:48 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:42:48 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:42:48 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:42:48 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:42:48 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:43:02 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:43:02 Asia/Tehran] User ID: 1
[04-Jan-2026 02:43:02 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:43:02 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:43:02 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:43:02 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:43:02 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:43:02 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:43:02 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:43:55 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:43:55 Asia/Tehran] User ID: 1
[04-Jan-2026 02:43:55 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:43:55 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:43:55 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:43:55 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:43:55 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:43:55 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:43:55 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:44:22 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:44:22 Asia/Tehran] User ID: 1
[04-Jan-2026 02:44:22 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:44:22 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:44:22 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:44:22 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:44:22 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:44:22 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:44:22 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:44:43 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:44:43 Asia/Tehran] User ID: 1
[04-Jan-2026 02:44:43 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:44:43 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:44:43 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:44:43 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:44:43 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:44:43 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:44:43 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:45:07 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:45:07 Asia/Tehran] User ID: 1
[04-Jan-2026 02:45:07 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:45:07 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:45:07 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:45:07 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:45:07 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:45:07 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:45:07 Asia/Tehran] Last message subject: test 1
[04-Jan-2026 02:45:36 Asia/Tehran] === AJAX get_conversation START ===
[04-Jan-2026 02:45:36 Asia/Tehran] User ID: 1
[04-Jan-2026 02:45:36 Asia/Tehran] Contact ID: 2
[04-Jan-2026 02:45:36 Asia/Tehran] Database connection: OK
[04-Jan-2026 02:45:36 Asia/Tehran] === AJAX get_conversation ===
[04-Jan-2026 02:45:36 Asia/Tehran] User ID: 1, Contact ID: 2
[04-Jan-2026 02:45:36 Asia/Tehran] Found 38 messages
[04-Jan-2026 02:45:36 Asia/Tehran] First message subject: 2
[04-Jan-2026 02:45:36 Asia/Tehran] Last message subject: test 1
