Hi - I set debug to 2, and got a lot of sql statements, but nothing in the 'error' column. Then I added the pr calls, and did not get any more info. I didn't see anything in the apache logs either.
I can send you the sql statements if you would like. I just installed cake 1.3.6, and got a page full of errors - cake 1.3.6 is incompatible with my version of PHP (5.5.9), so cannot try with that.
Just reinstalled on cake 1.3.21. Same as on 1.3.20. I do notice in the listed sql statements there are no insert statements.
Code: Select all
Nr Query Error Affected Num. rows Took (ms)
1 SHOW FULL COLUMNS FROM `users` 6 6 1
2 SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; 1 1 1
3 SHOW FULL COLUMNS FROM `people` 38 38 1
4 SHOW FULL COLUMNS FROM `skills` 6 6 1
5 SHOW FULL COLUMNS FROM `allstars` 3 3 1
6 SHOW FULL COLUMNS FROM `games` 27 27 1
7 SHOW FULL COLUMNS FROM `divisions` 28 28 1
8 SHOW FULL COLUMNS FROM `leagues` 16 16 1
9 SHOW FULL COLUMNS FROM `affiliates` 3 3 1
10 SHOW FULL COLUMNS FROM `badges` 9 9 1
11 SHOW FULL COLUMNS FROM `badges_people` 13 13 1
12 SHOW FULL COLUMNS FROM `attendances` 10 10 1
13 SHOW FULL COLUMNS FROM `teams` 23 23 1
14 SHOW FULL COLUMNS FROM `fields` 15 15 1
15 SHOW FULL COLUMNS FROM `facilities` 19 19 1
16 SHOW FULL COLUMNS FROM `regions` 3 3 1
17 SHOW FULL COLUMNS FROM `game_slots` 6 6 1
18 SHOW FULL COLUMNS FROM `division_gameslot_availabilities` 3 3 1
19 SHOW FULL COLUMNS FROM `incidents` 5 5 1
20 SHOW FULL COLUMNS FROM `team_events` 13 13 1
21 SHOW FULL COLUMNS FROM `activity_logs` 9 9 1
22 SHOW FULL COLUMNS FROM `notes` 11 11 1
23 SHOW FULL COLUMNS FROM `stats` 6 6 1
24 SHOW FULL COLUMNS FROM `stat_types` 14 14 1
25 SHOW FULL COLUMNS FROM `franchises` 4 4 1
26 SHOW FULL COLUMNS FROM `franchises_people` 3 3 1
27 SHOW FULL COLUMNS FROM `franchises_teams` 3 3 1
28 SHOW FULL COLUMNS FROM `teams_people` 8 8 1
29 SHOW FULL COLUMNS FROM `teams_facilities` 4 4 1
30 SHOW FULL COLUMNS FROM `preregistrations` 3 3 1
31 SHOW FULL COLUMNS FROM `events` 13 13 1
32 SHOW FULL COLUMNS FROM `event_types` 3 3 1
33 SHOW FULL COLUMNS FROM `questionnaires` 4 4 1
34 SHOW FULL COLUMNS FROM `questions` 7 7 1
35 SHOW FULL COLUMNS FROM `answers` 5 5 1
36 SHOW FULL COLUMNS FROM `questionnaires_questions` 5 5 1
37 SHOW FULL COLUMNS FROM `prices` 17 17 1
38 SHOW FULL COLUMNS FROM `registrations` 12 12 1
39 SHOW FULL COLUMNS FROM `payments` 11 11 1
40 SHOW FULL COLUMNS FROM `registration_audits` 17 17 1
41 SHOW FULL COLUMNS FROM `responses` 6 6 1
42 SHOW FULL COLUMNS FROM `events_connections` 4 4 1
43 SHOW FULL COLUMNS FROM `credits` 8 8 1
44 SHOW FULL COLUMNS FROM `settings` 6 6 1
45 SHOW FULL COLUMNS FROM `uploads` 9 9 1
46 SHOW FULL COLUMNS FROM `upload_types` 3 3 1
47 SHOW FULL COLUMNS FROM `subscriptions` 5 5 1
48 SHOW FULL COLUMNS FROM `task_slots` 9 9 1
49 SHOW FULL COLUMNS FROM `tasks` 8 8 1
50 SHOW FULL COLUMNS FROM `categories` 3 3 1
51 SHOW FULL COLUMNS FROM `groups` 5 5 1
52 SHOW FULL COLUMNS FROM `groups_people` 3 3 1
53 SHOW FULL COLUMNS FROM `waivers` 12 12 1
54 SHOW FULL COLUMNS FROM `waivers_people` 6 6 1
55 SHOW FULL COLUMNS FROM `affiliates_people` 4 4 1
56 SHOW FULL COLUMNS FROM `divisions_people` 4 4 1
57 SHOW FULL COLUMNS FROM `people_people` 5 5 1
58 SHOW FULL COLUMNS FROM `holidays` 4 4 1
59 SHOW FULL COLUMNS FROM `mailing_lists` 5 5 1
60 SHOW FULL COLUMNS FROM `newsletters` 13 13 1
61 SHOW FULL COLUMNS FROM `leagues_stat_types` 2 2 1
62 SHOW FULL COLUMNS FROM `pools` 5 5 1
63 SHOW FULL COLUMNS FROM `pools_teams` 8 8 1
64 SHOW FULL COLUMNS FROM `days` 3 3 1
65 SHOW FULL COLUMNS FROM `divisions_days` 2 2 1
66 SHOW FULL COLUMNS FROM `score_details` 8 8 1
67 SHOW FULL COLUMNS FROM `score_detail_stats` 4 4 1
68 SHOW FULL COLUMNS FROM `score_entries` 11 11 1
69 SHOW FULL COLUMNS FROM `spirit_entries` 20 20 1
70 SHOW FULL COLUMNS FROM `provinces` 2 2 1
71 SHOW FULL COLUMNS FROM `countries` 2 2 1
72 SELECT `Configuration`.`id`, `Configuration`.`affiliate_id`, `Configuration`.`person_id`, `Configuration`.`category`, `Configuration`.`name`, `Configuration`.`value` FROM `settings` AS `Configuration` WHERE `category` != '' AND `affiliate_id` IS NULL AND ((`category` != 'personal') OR (`person_id` = 1)) 116 116 0
73 SELECT COUNT(*) AS `count` FROM `people` AS `Person` LEFT JOIN `affiliates_people` AS `AffiliatePerson` ON (`AffiliatePerson`.`person_id` = `Person`.`id`) WHERE `Person`.`status` = 'new' AND `Person`.`complete` = 1 AND `AffiliatePerson`.`affiliate_id` = (1) 1 1 0
74 SELECT COUNT(*) AS `count` FROM `uploads` AS `Upload` LEFT JOIN `people` AS `Person` ON (`Upload`.`person_id` = `Person`.`id`) LEFT JOIN `upload_types` AS `UploadType` ON (`Upload`.`type_id` = `UploadType`.`id`) WHERE `approved` = 0 AND `type_id` IS NULL 1 1 0
75 SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE ((`id` = 1) OR (`active` = 1)) ORDER BY `Group`.`level` ASC, `Group`.`id` ASC 7 7 0
76 SELECT `Province`.`id`, `Province`.`name` FROM `provinces` AS `Province` WHERE 1 = 1 1 1 0
77 SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 1 1 0
78 SELECT `Group`.`id`, `Group`.`name`, `Group`.`active`, `Group`.`level`, `Group`.`description` FROM `groups` AS `Group` WHERE ((`id` = 1) OR (`active` = 1)) ORDER BY `Group`.`level` ASC, `Group`.`id` ASC 7 7 0
79 SELECT `Affiliate`.`id`, `Affiliate`.`name`, `Affiliate`.`active` FROM `affiliates` AS `Affiliate` WHERE `active` = 1 AND NOT (`id` IS NULL) ORDER BY `name` ASC 1 1 0
80 SELECT `Person`.`id`, `Person`.`user_id`, `Person`.`first_name`, `Person`.`last_name`, `Person`.`publish_email`, `Person`.`home_phone`, `Person`.`publish_home_phone`, `Person`.`work_phone`, `Person`.`work_ext`, `Person`.`publish_work_phone`, `Person`.`mobile_phone`, `Person`.`publish_mobile_phone`, `Person`.`alternate_first_name`, `Person`.`alternate_last_name`, `Person`.`alternate_email`, `Person`.`publish_alternate_email`, `Person`.`alternate_work_phone`, `Person`.`alternate_work_ext`, `Person`.`publish_alternate_work_phone`, `Person`.`alternate_mobile_phone`, `Person`.`publish_alternate_mobile_phone`, `Person`.`addr_street`, `Person`.`addr_city`, `Person`.`addr_prov`, `Person`.`addr_country`, `Person`.`addr_postalcode`, `Person`.`gender`, `Person`.`birthdate`, `Person`.`height`, `Person`.`shirt_size`, `Person`.`status`, `Person`.`has_dog`, `Person`.`contact_for_feedback`, `Person`.`show_gravatar`, `Person`.`twitter_token`, `Person`.`twitter_secret`, `Person`.`complete`, `Person`.`updated`, `User`.`id`, `User`.`user_name`, `User`.`password`, `User`.`email`, `User`.`last_login`, `User`.`client_ip` FROM `people` AS `Person` LEFT JOIN `users` AS `User` ON (`Person`.`user_id` = `User`.`id`) WHERE `Person`.`id` = 1 LIMIT 1 1 1 0
81 SELECT `Skill`.`id`, `Skill`.`person_id`, `Skill`.`sport`, `Skill`.`enabled`, `Skill`.`skill_level`, `Skill`.`year_started` FROM `skills` AS `Skill` WHERE `Skill`.`person_id` = (1) 0 0 0
82 SELECT `Affiliate`.`id`, `Affiliate`.`name`, `Affiliate`.`active`, `AffiliatesPerson`.`id`, `AffiliatesPerson`.`affiliate_id`, `AffiliatesPerson`.`person_id`, `AffiliatesPerson`.`position` FROM `affiliates` AS `Affiliate` JOIN `affiliates_people` AS `AffiliatesPerson` ON (`AffiliatesPerson`.`person_id` = 1 AND `AffiliatesPerson`.`affiliate_id` = `Affiliate`.`id`) 1 1 0
83 SELECT `Group`.`id`, `Group`.`name`, `Group`.`active`, `Group`.`level`, `Group`.`description`, `GroupsPerson`.`id`, `GroupsPerson`.`person_id`, `GroupsPerson`.`group_id` FROM `groups` AS `Group` JOIN `groups_people` AS `GroupsPerson` ON (`GroupsPerson`.`person_id` = 1 AND `GroupsPerson`.`group_id` = `Group`.`id`) 1 1 0
84 SELECT `Province`.`id`, `Province`.`name` FROM `provinces` AS `Province` WHERE 1 = 1 1 1 0
85 SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 1 1 0
86 SELECT `Upload`.`id`, `Upload`.`person_id`, `Upload`.`type_id`, `Upload`.`filename`, `Upload`.`approved`, `Upload`.`valid_from`, `Upload`.`valid_until`, `Upload`.`created`, `Upload`.`updated` FROM `uploads` AS `Upload` WHERE `person_id` = 1 AND `type_id` IS NULL LIMIT 1 0 0 0
87 SHOW FULL COLUMNS FROM `notices` 7 7 1
88 SHOW FULL COLUMNS FROM `notices_people` 5 5 1
89 SELECT `Configuration`.`id`, `Configuration`.`affiliate_id`, `Configuration`.`person_id`, `Configuration`.`category`, `Configuration`.`name`, `Configuration`.`value` FROM `settings` AS `Configuration` WHERE `category` != '' AND `affiliate_id` IS NULL AND ((`category` != 'personal') OR (`person_id` = 1)) 116 116 0