An error has occurred
Standard member
Occurred while mass adding to gallery
Hi Chris,I mass added some photos to a gallery. The images were imported, but I received the following error. I've mass added to galleries before, but not since the last RC upgrade, so I don't know if something's krept in or if this was just an isolated error.
Code
An error has occurred
Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512 LIMIT 1] [Table 'kilnandc_compcms.cms_activities' doesn't exist] (version: 10 RC32, PHP version: 5.6.29, URL: /cms/index.php?page=cms-galleries&type=__import&cat=schmitt_party&uploading=1&keep_gallery_root=root)
Here is the stack trace:
Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologize for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.
File
'/home/kilnandc/public_html/sources/failure.php'
Line
972
Function
'get_html_trace'
Args
File
'/home/kilnandc/public_html/sources/global2.php'
Line
914
Function
'_fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512 LIMIT 1] [<strong>Table 'kilnandc_compcms.cms_activities' doesn't exist</strong>]
File
'/home/kilnandc/public_html/sources/database/mysqli.php'
Line
261
Function
'fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512 LIMIT 1] [<strong>Table 'kilnandc_compcms.cms_activities' doesn't exist</strong>]
File
'/home/kilnandc/public_html/sources/database.php'
Line
1,344
Function
'db_query'
Class
'Database_Static_mysqli'
Object
O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:3;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512'
array
1
NULL
false
false
false
false
File
'/home/kilnandc/public_html/sources/database.php'
Line
1,113
Function
'_query'
Class
'DatabaseConnector'
Object
O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:16:"kilnandc_compcms";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:13:"sitemap_cache";b:1;}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512'
1
NULL
false
false
NULL
''
File
'/home/kilnandc/public_html/sources_custom/activities_submission.php'
Line
62
Function
'query'
Class
'DatabaseConnector'
Object
O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:16:"kilnandc_compcms";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:13:"sitemap_cache";b:1;}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487204912 AND a_time<=1487205512'
1
File
'/home/kilnandc/public_html/sources_custom/hooks/systems/activities/activities.php'
Line
44
Function
'activities_addon_syndicate_described_activity'
Args
'galleries:ACTIVITY_ADD_IMAGE'
'Schmitt012A.jpg'
''
''
'_SEARCH:galleries:image:518'
''
''
'galleries'
1
NULL
false
NULL
Function
'syndicate_described_activity'
Class
'Hook_activities_activities'
Object
O:26:"Hook_activities_activities":0:{}
Type
'->'
Args
'galleries:ACTIVITY_ADD_IMAGE'
'Schmitt012A.jpg'
''
''
'_SEARCH:galleries:image:518'
''
''
'galleries'
1
NULL
false
NULL
Parameters
csrf_token
531e13666152d
MAX_FILE_SIZE
524288000
test
1
label_for_file_1
Upload
label_for__set_title
Title
set_title
require__set_title
0
http_referer http://kilnandcrafts.com/cms/index.php?page=cms-galleries&type=_import&keep_gallery_root=root&name=schmitt_party
Site director
Or delete the sources_custom/activities_submission.php file.
Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon
- If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
- If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
- If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
- If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Standard member
Code
An error has occurred
Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536 LIMIT 1] [Table 'kilnandc_compcms.cms_activities' doesn't exist] (version: 10 RC32, PHP version: 5.6.29, URL: /cms/index.php?page=cms-calendar&type=_add&uploading=1)
Here is the stack trace:
Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologize for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.
File
'/home/kilnandc/public_html/sources/failure.php'
Line
972
Function
'get_html_trace'
Args
File
'/home/kilnandc/public_html/sources/global2.php'
Line
914
Function
'_fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536 LIMIT 1] [<strong>Table 'kilnandc_compcms.cms_activities' doesn't exist</strong>]
File
'/home/kilnandc/public_html/sources/database/mysqli.php'
Line
261
Function
'fatal_exit'
Args
Tempcode -> Unfortunately a query has failed [SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536 LIMIT 1] [<strong>Table 'kilnandc_compcms.cms_activities' doesn't exist</strong>]
File
'/home/kilnandc/public_html/sources/database.php'
Line
1,344
Function
'db_query'
Class
'Database_Static_mysqli'
Object
O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:3;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536'
array
1
NULL
false
false
false
false
File
'/home/kilnandc/public_html/sources/database.php'
Line
1,113
Function
'_query'
Class
'DatabaseConnector'
Object
O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:16:"kilnandc_compcms";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:13:"sitemap_cache";b:1;}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536'
1
NULL
false
false
NULL
''
File
'/home/kilnandc/public_html/sources_custom/activities_submission.php'
Line
62
Function
'query'
Class
'DatabaseConnector'
Object
O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:4:"cms_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:16:"kilnandc_compcms";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:1:{s:13:"sitemap_cache";b:1;}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:1:{s:54:"a:2:{i:0;s:16:"kilnandc_compcms";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:16:"kilnandc_compcms";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type
'->'
Args
'SELECT a_language_string_code,a_label_1,a_label_2,a_label_3,a_is_public FROM cms_activities WHERE a_member_id=5 AND a_time>1487442936 AND a_time<=1487443536'
1
File
'/home/kilnandc/public_html/sources_custom/hooks/systems/activities/activities.php'
Line
44
Function
'activities_addon_syndicate_described_activity'
Args
'calendar:ACTIVITY_CALENDAR_EVENT'
'March 18th: Ceramic Painting (\$35.00) Paint two ceramic soup bowls (In honor of St. Patty's Day we will sample Irish Stew - Recipe included)'
'Sat March 18th 2017 - Sat March 18th 2017 (1 day) and recurs regularly'
''
'_SEARCH:calendar:view:1'
''
''
'calendar'
1
NULL
true
NULL
Function
'syndicate_described_activity'
Class
'Hook_activities_activities'
Object
O:26:"Hook_activities_activities":0:{}
Type
'->'
Args
'calendar:ACTIVITY_CALENDAR_EVENT'
'March 18th: Ceramic Painting (\$35.00) Paint two ceramic soup bowls (In honor of St. Patty's Day we will sample Irish Stew - Recipe included)'
'Sat March 18th 2017 - Sat March 18th 2017 (1 day) and recurs regularly'
''
'_SEARCH:calendar:view:1'
''
''
'calendar'
1
NULL
true
NULL
Parameters
csrf_token
500ae19dc8b4e
label_for__title
Title
title
March 18th: Ceramic Painting ($35.00) Paint two ceramic soup bowls (In honor of St. Patty's Day we will sample Irish Stew - Recipe included)
require__title
1
label_for__all_day_event
All day event
all_day_event
1
tick_on_form__all_day_event
0
require__all_day_event
0
label_for__start
Date and time
start
2017-03-18
start_time
09:00
require__start
1
label_for__end
End date and time
end
end_time
require__end
0
label_for__type
Type
type
9
require__type
1
label_for__priority
Priority
priority
2
require__priority
1
label_for__validated
Validated
validated
1
tick_on_form__validated
0
require__validated
0
label_for__post
Event text
comcode__post
1
MAX_FILE_SIZE
524288000
f_face
/
f_size
f_colour
post
[title="1"]March 18th:[/title] Saturday March 18th 6to8PM, Ceramic Painting ($35.00) Paint two ceramic soup bowls (In honor of St. Patty's Day we will sample Irish Stew - Recipe included) [title="2"]Contact us[/title] [block="spring_2017_classes" to="kilnandcrafts@gmail.com" subject="Spring Class"]main_contact_catalogues[/block]
posting_ref_id
1278194906
label_for__member_calendar
Personal calendar
member_calendar
require__member_calendar
0
label_for__timezone
Timezone
timezone
America/New_York
require__timezone
1
label_for__do_timezone_conv
Do timezone conversions
tick_on_form__do_timezone_conv
0
require__do_timezone_conv
0
recurrence
none
label_for__recurrence_pattern
Recurrence pattern
require__recurrence_pattern
0
label_for__recurrences
Recurrences
require__recurrences
0
label_for__seg_recurrences
Segregate recurrence feedback
tick_on_form__seg_recurrences
0
require__seg_recurrences
0
require__monthly_spec_type
1
label_for__sign_up_reminder
Sign up for reminder
sign_up_reminder
1
tick_on_form__sign_up_reminder
0
require__sign_up_reminder
0
label_for__sign_up_reminder_groups_list
Sign up usergroups for reminders
sign_up_reminder_groups
+
require__sign_up_reminder_groups_list
0
label_for__hours_before
Reminder notice
hours_before
1
require__hours_before
1
label_for__meta_views
Views
meta_views
require__meta_views
0
label_for__meta_submitter
Owner
meta_submitter
Kiln & Crafts
require__meta_submitter
1
label_for__meta_add_time
Add date/time
meta_add_time
meta_add_time_time
require__meta_add_time
0
label_for__meta_edit_time
Edit date/time
meta_edit_time
meta_edit_time_time
require__meta_edit_time
0
label_for__meta_url_moniker
URL Moniker
meta_url_moniker
require__meta_url_moniker
0
meta_keywords
(array)
label_for__meta_keywords
(array)
require__meta_keywords
0
label_for__meta_description
Concise description
meta_description
Weekly Spring class at Kiln & Crafts.
require__meta_description
0
http_referer
Standard member
1 guest and 0 members have just viewed this.
