The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/showthread.php 26 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/showthread.php 26 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/showthread.php 26 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/showthread.php 137 forum_permissions
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1380 fetch_forum_permissions
/inc/functions.php 2909 forum_permissions
/showthread.php 621 build_forum_jump
Warning [2] Undefined property: MyLanguage::$ratings_update_error - Line: 5 - File: showthread.php(732) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/showthread.php(732) : eval()'d code 5 errorHandler->error
/showthread.php 732 eval
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions_user.php 844 is_member
/inc/functions_post.php 406 purgespammer_show
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: inc/functions_post.php(474) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php(474) : eval()'d code 6 errorHandler->error
/inc/functions_post.php 474 eval
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "canonlyreplyownthreads" - Line: 660 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 660 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showimages" - Line: 741 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 741 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 746 - File: inc/functions_post.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions_post.php 746 errorHandler->error
/showthread.php 1070 build_postbit
Warning [2] Undefined array key "invisible" - Line: 1506 - File: showthread.php PHP 8.1.31 (Linux)
File Line Function
/showthread.php 1506 errorHandler->error
Warning [2] Undefined variable $threadnotesbox - Line: 30 - File: showthread.php(1533) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 30 errorHandler->error
/showthread.php 1533 eval
Warning [2] Undefined variable $addremovesubscription - Line: 79 - File: showthread.php(1533) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/showthread.php(1533) : eval()'d code 79 errorHandler->error
/showthread.php 1533 eval



FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.
Form Tools › Form Tools › API v
Orphan clean up: Report on orphans found

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Orphan clean up: Report on orphans found
mrGarvin Offline
Member
***
Posts: 62
Threads: 9
Joined: Apr 2009
Reputation: 2
#1
Mar 2nd, 2012, 12:53 AM
Hi!
You wished to see my result if the Orphan clean up found anything. My test found 101:
Code:
TABLE: ft_email_templates
- num orphans: 96
- error description:
1. Invalid email_from_form_email_id: 0 for email_id = 1
2. Invalid email_reply_to_account_id: 0 for email_id = 1
3. Invalid email_reply_to_form_email_id: 0 for email_id = 1
4. Invalid email_from_form_email_id: 0 for email_id = 2
5. Invalid email_reply_to_account_id: 0 for email_id = 2
6. Invalid email_reply_to_form_email_id: 0 for email_id = 2
7. Invalid email_from_form_email_id: 0 for email_id = 3
8. Invalid email_reply_to_account_id: 0 for email_id = 3
9. Invalid email_reply_to_form_email_id: 0 for email_id = 3
10. Invalid email_from_account_id: 0 for email_id = 5
11. Invalid email_reply_to_account_id: 0 for email_id = 5
12. Invalid email_reply_to_form_email_id: 0 for email_id = 5
13. Invalid email_from_form_email_id: 0 for email_id = 6
14. Invalid email_reply_to_account_id: 0 for email_id = 6
15. Invalid email_reply_to_form_email_id: 0 for email_id = 6
16. Invalid email_from_form_email_id: 0 for email_id = 7
17. Invalid email_reply_to_account_id: 0 for email_id = 7
18. Invalid email_reply_to_form_email_id: 0 for email_id = 7
19. Invalid email_from_account_id: 0 for email_id = 8
20. Invalid email_from_form_email_id: 0 for email_id = 8
21. Invalid email_reply_to_account_id: 0 for email_id = 8
22. Invalid email_reply_to_form_email_id: 0 for email_id = 8
23. Invalid email_from_account_id: 0 for email_id = 9
24. Invalid email_reply_to_account_id: 0 for email_id = 9
25. Invalid email_from_form_email_id: 0 for email_id = 10
26. Invalid email_reply_to_account_id: 0 for email_id = 10
27. Invalid email_reply_to_form_email_id: 0 for email_id = 10
28. Invalid email_from_form_email_id: 0 for email_id = 11
29. Invalid email_reply_to_account_id: 0 for email_id = 11
30. Invalid email_reply_to_form_email_id: 0 for email_id = 11
31. Invalid email_from_form_email_id: 0 for email_id = 12
32. Invalid email_reply_to_account_id: 0 for email_id = 12
33. Invalid email_reply_to_form_email_id: 0 for email_id = 12
34. Invalid email_from_account_id: 0 for email_id = 13
35. Invalid email_from_form_email_id: 0 for email_id = 13
36. Invalid email_reply_to_account_id: 0 for email_id = 13
37. Invalid email_reply_to_form_email_id: 0 for email_id = 13
38. Invalid email_from_form_email_id: 0 for email_id = 14
39. Invalid email_reply_to_account_id: 0 for email_id = 14
40. Invalid email_reply_to_form_email_id: 0 for email_id = 14
41. Invalid email_from_form_email_id: 0 for email_id = 15
42. Invalid email_reply_to_account_id: 0 for email_id = 15
43. Invalid email_reply_to_form_email_id: 0 for email_id = 15
44. Invalid email_from_form_email_id: 0 for email_id = 16
45. Invalid email_reply_to_account_id: 0 for email_id = 16
46. Invalid email_reply_to_form_email_id: 0 for email_id = 16
47. Invalid email_from_form_email_id: 0 for email_id = 17
48. Invalid email_reply_to_account_id: 0 for email_id = 17
49. Invalid email_reply_to_form_email_id: 0 for email_id = 17
50. Invalid email_from_form_email_id: 0 for email_id = 18
51. Invalid email_reply_to_account_id: 0 for email_id = 18
52. Invalid email_reply_to_form_email_id: 0 for email_id = 18
53. Invalid email_from_form_email_id: 0 for email_id = 19
54. Invalid email_reply_to_account_id: 0 for email_id = 19
55. Invalid email_reply_to_form_email_id: 0 for email_id = 19
56. Invalid email_from_account_id: 0 for email_id = 20
57. Invalid email_from_form_email_id: 0 for email_id = 20
58. Invalid email_reply_to_account_id: 0 for email_id = 20
59. Invalid email_reply_to_form_email_id: 0 for email_id = 20
60. Invalid email_from_form_email_id: 0 for email_id = 21
61. Invalid email_reply_to_account_id: 0 for email_id = 21
62. Invalid email_reply_to_form_email_id: 0 for email_id = 21
63. Invalid email_from_form_email_id: 0 for email_id = 22
64. Invalid email_reply_to_account_id: 0 for email_id = 22
65. Invalid email_reply_to_form_email_id: 0 for email_id = 22
66. Invalid email_from_account_id: 0 for email_id = 23
67. Invalid email_from_form_email_id: 0 for email_id = 23
68. Invalid email_reply_to_account_id: 0 for email_id = 23
69. Invalid email_reply_to_form_email_id: 0 for email_id = 23
70. Invalid email_from_account_id: 0 for email_id = 25
71. Invalid email_from_form_email_id: 0 for email_id = 25
72. Invalid email_reply_to_account_id: 0 for email_id = 25
73. Invalid email_reply_to_form_email_id: 0 for email_id = 25
74. Invalid email_from_account_id: 0 for email_id = 26
75. Invalid email_from_form_email_id: 0 for email_id = 26
76. Invalid email_reply_to_account_id: 0 for email_id = 26
77. Invalid email_reply_to_form_email_id: 0 for email_id = 26
78. Invalid email_from_form_email_id: 0 for email_id = 27
79. Invalid email_reply_to_account_id: 0 for email_id = 27
80. Invalid email_reply_to_form_email_id: 0 for email_id = 27
81. Invalid email_from_account_id: 0 for email_id = 28
82. Invalid email_from_form_email_id: 0 for email_id = 28
83. Invalid email_reply_to_account_id: 0 for email_id = 28
84. Invalid email_reply_to_form_email_id: 0 for email_id = 28
85. Invalid email_from_account_id: 0 for email_id = 29
86. Invalid email_from_form_email_id: 0 for email_id = 29
87. Invalid email_reply_to_account_id: 0 for email_id = 29
88. Invalid email_reply_to_form_email_id: 0 for email_id = 29
89. Invalid email_from_account_id: 0 for email_id = 30
90. Invalid email_from_form_email_id: 0 for email_id = 30
91. Invalid email_reply_to_account_id: 0 for email_id = 30
92. Invalid email_reply_to_form_email_id: 0 for email_id = 30
93. Invalid email_from_account_id: 0 for email_id = 32
94. Invalid email_from_form_email_id: 0 for email_id = 32
95. Invalid email_reply_to_account_id: 0 for email_id = 32
96. Invalid email_reply_to_form_email_id: 0 for email_id = 32
_______________________


TABLE: ft_field_settings
- num orphans: 4
- error description:
1. invalid field_id: 227
2. invalid field_id: 227
3. invalid field_id: 228
4. invalid field_id: 228
_______________________


TABLE: ft_field_validation
- num orphans: 1
- error description:
1. Invalid reference to field_id: 330 for rule_id: 1
_______________________
Reply
Find
Ben Offline
Administrator
*******
Posts: 2,456
Threads: 39
Joined: Dec 2008
Reputation: 6
#2
Mar 3rd, 2012, 1:46 AM
Nice, thanks!

Do you recall what version of FT you originally installed? Just curious if it was a very old one: that would explain all the dud records.

- Ben
Reply
Find
mrGarvin Offline
Member
***
Posts: 62
Threads: 9
Joined: Apr 2009
Reputation: 2
#3
Mar 5th, 2012, 2:28 AM
Oh... Don't remember, but I've been around for some years now so :-)

(Mar 3rd, 2012, 1:46 AM)Ben Wrote: Nice, thanks!

Do you recall what version of FT you originally installed? Just curious if it was a very old one: that would explain all the dud records.

- Ben

Reply
Find


Forum Jump:


Users browsing this thread: 1 Guest(s)