Posted 27 May 2012, 1:19 AM
Community saint
I got this error when I tried to save an edit to the IOTD page
An error has occurred
Unfortunately a query has failed [SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) LIMIT 1] [Unknown column 'main.validated' in 'field list' ] (version: 8.0.1, PHP version: 5.2.17, URL: /cms/index.php?page=cms_iotds&type=__ed&id=11&redirect=http%3A%2F%2Fprehistoricsillustrated.com%2Fsite%2Findex.php%3Fpage%3Diotds%26type%3Dview%26id%3Dfont-paramhelvetica_15%26wide%3D1&uploading=1)
Here is the stack trace:
Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check ocPortal 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 apologise 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/prehisto/public_html/sources/failure.php'
Line
'684'
Function
'get_html_trace'
Args
File
'/home/prehisto/public_html/sources/global2.php'
Line
'979'
Function
'_fatal_exit'
Args
object
File
'/home/prehisto/public_html/sources/database/mysql.php'
Line
'245'
Function
'fatal_exit'
Args
object
File
'/home/prehisto/public_html/sources/database.php'
Line
'1,068'
Function
'db_query'
Class
'Database_Static_mysql'
Type
'->'
Object
Database_Static_mysql::__set_state(array( ))
Args
'SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) '
array ( 0 => NULL, 1 => 'prehisto_prehisto', )
1
NULL
false
false
false
false
File
'/home/prehisto/public_html/sources/database.php'
Line
'912'
Function
'_query'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) '
1
NULL
false
false
array ( )
'main.'
File
'/home/prehisto/public_html/sources/database.php'
Line
'582'
Function
'query_select'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'iotd'
array ( 0 => 'validated', )
array ( 'id' => 11, )
''
1
NULL
File
'/home/prehisto/public_html/cms/pages/modules/cms_iotds.php'
Line
'353'
Function
'query_value'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'iotd'
'validated'
array ( 'id' => 11, )
File
'/home/prehisto/public_html/sources/aed_module.php'
Line
'1,239'
Function
'edit_actualisation'
Class
'Module_cms_iotds'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
'11'
File
'/home/prehisto/public_html/sources/aed_module.php'
Line
'200'
Function
'__ed'
Class
'standard_aed_module'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
File
'/home/prehisto/public_html/sources/zones.php'
Line
'424'
Function
'run'
Class
'standard_aed_module'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
File
'/home/prehisto/public_html/sources/site.php'
Line
'1,016'
Function
'load_module_page'
Args
'cms/pages/modules/cms_iotds.php'
'cms_iotds'
File
'/home/prehisto/public_html/sources/site.php'
Line
'785'
Function
'request_page'
Args
'cms_iotds'
true
File
'/home/prehisto/public_html/cms/index.php'
Line
'50'
Function
'do_site'
Args
Parameters
MAX_FILE_SIZE
792723456
comcode__title
1
label_for__title
Title
title
Frozen in time Locked in a Showdown
require__title
1
label_for__file
Upload
require__file
0
hidFileID_file
-1
label_for__url
URL
url
uploads/iotds/trex%2Btric_Guarding_the_NHMLAC_s%2Brw_1.png
require__url
1
comcode__caption
1
label_for__caption
Caption
caption
<div style="height: auto; margin: 15px auto; width: 50%"> <div class="standardbox_wrap_panel"> <h3 class="standardbox_title_panel" style="text-align: center"> Frozen in time Locked in a Showdown</h3> <div class="standardbox_t_panel"> <div class="standardbox_main_classic"> <div style="padding: 10px; text-align: left"> This is a better view of the bronze sculpture "Dueling Dinos" showing life sized T. rex and Triceratops in a showdown which might end badly for one of them.<br /> <br /> I'm not sure which I would rather be, the Triceratops has his work cut out for him but it might be really difficult for the Tyrannosaurus to find a unprotected vulnerable spot to bring down his lunch.<br /> <br /> Frozen in time we'll never know for these two.<br /> <br /> <span style=" color: #669999; font-size: 8pt">Photo Copyright © 2010 David L. Friend<br /> Any reproduction without permission is strictly prohibited.<br /> ALL RIGHTS RESERVED.</span></div> </div> </div> </div> </div>
caption_parsed
<div style="height: auto; margin: 15px auto; width: 50%"><div class="standardbox_wrap_panel"> <h3 class="standardbox_title_panel" style="text-align: center">Frozen in time Locked in a Showdown</h3><div class="standardbox_t_panel"> <div class="standardbox_main_classic"> <div style="padding: 10px; text-align: left">This is a better view of the bronze sculpture "Dueling Dinos" showing life sized T. rex and Triceratops in a showdown which might end badly for one of them.<br /> <br /> I'm not sure which I would rather be, the Triceratops has his work cut out for him but it might be really difficult for the Tyrannosaurus to find a unprotected vulnerable spot to bring down his lunch.<br /> <br /> Frozen in time we'll never know for these two.<br /> <br /> <span style=" color: #669999; font-size: 8pt">Photo Copyright © 2010 David L. Friend<br /> Any reproduction without permission is strictly prohibited.<br /> ALL RIGHTS RESERVED.</span></div> </div> </div> </div> </div>
label_for__validated
In immediate use
validated
1
tick_on_form__validated
0
require__validated
0
label_for__allow_rating
Allow rating
tick_on_form__allow_rating
0
require__allow_rating
0
label_for__allow_comments
Allow comments
allow_comments
2
require__allow_comments
1
label_for__allow_trackbacks
Allow trackbacks
tick_on_form__allow_trackbacks
0
require__allow_trackbacks
0
label_for__notes
Notes
notes
pre_f_notes
1
require__notes
0
label_for__delete
Delete
tick_on_form__delete
0
require__delete
0
label_for__reverse_point_transaction
Reverse gift transaction
tick_on_form__reverse_point_transaction
0
require__reverse_point_transaction
0
http_referer
http://prehistoricsillustrated.com/cms/index.php?page=cms_iotds&type=_ed&id=11&redirect=http%3A%2F%2Fprehistoricsillustrated.com%2Fsite%2Findex.php%3Fpage%3Diotds%26type%3Dview%26id%3Dfont-paramhelvetica_15%26wide%3D1
caption__is_wysiwyg
1
thumb_url
uploads/iotds_thumbs/7trex%252Btric_Guarding_the_NHMLAC_s%252Brw_1.png
Important!
Posted 27 May 2012, 3:18 PM
ocStaff (admin)
Automated fix message
friendly said
I got this error when I tried to save an edit to the IOTD page
An error has occurred
Unfortunately a query has failed [SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) LIMIT 1] [Unknown column 'main.validated' in 'field list' ] (version: 8.0.1, PHP version: 5.2.17, URL: /cms/index.php?page=cms_iotds&type=__ed&id=11&redirect=http%3A%2F%2Fprehistoricsillustrated.com%2Fsite%2Findex.php%3Fpage%3Diotds%26type%3Dview%26id%3Dfont-paramhelvetica_15%26wide%3D1&uploading=1)
Here is the stack trace:
Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check ocPortal 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 apologise 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/prehisto/public_html/sources/failure.php'
Line
'684'
Function
'get_html_trace'
Args
File
'/home/prehisto/public_html/sources/global2.php'
Line
'979'
Function
'_fatal_exit'
Args
object
File
'/home/prehisto/public_html/sources/database/mysql.php'
Line
'245'
Function
'fatal_exit'
Args
object
File
'/home/prehisto/public_html/sources/database.php'
Line
'1,068'
Function
'db_query'
Class
'Database_Static_mysql'
Type
'->'
Object
Database_Static_mysql::__set_state(array( ))
Args
'SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) '
array ( 0 => NULL, 1 => 'prehisto_prehisto', )
1
NULL
false
false
false
false
File
'/home/prehisto/public_html/sources/database.php'
Line
'912'
Function
'_query'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'SELECT main.validated FROM ocp4_iotd main WHERE (main.id=11) '
1
NULL
false
false
array ( )
'main.'
File
'/home/prehisto/public_html/sources/database.php'
Line
'582'
Function
'query_select'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'iotd'
array ( 0 => 'validated', )
array ( 'id' => 11, )
''
1
NULL
File
'/home/prehisto/public_html/cms/pages/modules/cms_iotds.php'
Line
'353'
Function
'query_value'
Class
'database_driver'
Type
'->'
Object
database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'connection_write' => array ( 0 => NULL, 1 => 'prehisto_prehisto', ), 'text_lookup_original_cache' => array ( 78 => '', 79 => 'Some of my interests include: art and artists, architecture, astronomy, aviation, aircraft, history, museums, paleontology, dinosaurs, fossils, photography, computers, CAD, religion, politics, Physics, space exploration, TV, movies, music-especially classical and composers and …', 36 => 'Administrators', 37 => 'Site director', 11 => 'Content Management', 5 => 'Content Management', ), 'text_lookup_cache' => array ( 78 => 'return unserialize("a:6:{i:0;a:1:{i:0;a:5:{i:0;s:37:\"string_attach_4fbbdfdcb7b333.83972008\";i:1;a:0:{}i:2;i:1;i:3;s:0:\"\";i:4;s:0:\"\";}}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:66:\"\$TPL_FUNCS[\'string_attach_4fbbdfdcb7b333.83972008\']=\"echo \\\"\\\";\";\n\";}"); ', 79 => '', 36 => '', 37 => '', 11 => '', 5 => '', ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Args
'iotd'
'validated'
array ( 'id' => 11, )
File
'/home/prehisto/public_html/sources/aed_module.php'
Line
'1,239'
Function
'edit_actualisation'
Class
'Module_cms_iotds'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
'11'
File
'/home/prehisto/public_html/sources/aed_module.php'
Line
'200'
Function
'__ed'
Class
'standard_aed_module'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
File
'/home/prehisto/public_html/sources/zones.php'
Line
'424'
Function
'run'
Class
'standard_aed_module'
Type
'->'
Object
Module_cms_iotds::__set_state(array( 'lang_type' => 'IOTD', 'special_edit_frontend' => true, 'archive_entry_point' => '_SEARCH:iotds:type=misc', 'view_entry_point' => '_SEARCH:iotds:type=view:id=_ID', 'user_facing' => true, 'send_validation_request' => false, 'upload' => 'image', 'permissions_require' => 'mid', 'javascript' => 'standardAlternateFields(\'file\',\'url\'); standardAlternateFields(\'file2\',\'thumb_url\');', 'menu_label' => 'IOTDS', 'table' => 'iotd', 'module_type' => 'iotds', 'redirect_type' => NULL, 'code_require' => NULL, 'javascript_require' => NULL, 'skip_validation' => false, 'default_type' => 'misc', 'author' => 'Chris Graham', 'organisation' => 'ocProducts', 'check_validation' => true, 'archive_label' => NULL, 'protect_first' => 0, 'permission_page' => NULL, 'permission_module' => NULL, 'permissions_cat_require' => NULL, 'permissions_cat_name' => NULL, 'permissions_cat_require_b' => NULL, 'permissions_cat_name_b' => NULL, 'add_text' => '', 'edit_text' => '', 'extra_donext_entries' => NULL, 'extra_donext_categories' => NULL, 'extra_donext_whatever' => NULL, 'extra_donext_whatever_title' => NULL, 'do_next_editing_categories' => false, 'possibly_some_kind_of_upload' => false, 'cat_aed_module' => NULL, 'alt_aed_module' => NULL, 'seo_type' => NULL, 'award_type' => NULL, 'posting_form_title' => NULL, 'posting_form_text' => '', 'posting_form_text_parsed' => NULL, 'type_code' => 'd', 'catalogue' => false, 'non_integer_id' => false, 'output_of_action_is_confirmation' => false, 'second_stage_preview' => false, 'add_submit_name' => NULL, 'edit_submit_name' => NULL, 'do_preview' => true, 'add_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb234.00047549\']="echo ecv(\$cl,array(),2,\"ADD_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb234.00047549', 1 => array ( ), 2 => 2, 3 => 'ADD_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'add_one_cat_label' => NULL, 'edit_this_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb4b5.90771417\']="echo ecv(\$cl,array(),2,\"EDIT_THIS_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb4b5.90771417', 1 => array ( ), 2 => 2, 3 => 'EDIT_THIS_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_one_label' => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'do_runtime_4fc1703a0cb3a9.24474623\']="echo ecv(\$cl,array(),2,\"EDIT_OR_CHOOSE_IOTD\",\$parameters);"; ', 'seq_parts' => array ( 0 => array ( 0 => 'do_runtime_4fc1703a0cb3a9.24474623', 1 => array ( ), 2 => 2, 3 => 'EDIT_OR_CHOOSE_IOTD', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => true, 'codename' => ':container', 'cached_output' => NULL, )), 'edit_this_cat_label' => NULL, 'edit_one_cat_label' => NULL, 'entries_title' => NULL, 'categories_title' => NULL, 'do_next_description' => NULL, 'appended_actions_already' => false, 'select_name_description' => NULL, 'care_please' => true, 'new_id' => NULL, 'no_blank_ids' => true, 'posting_field_required' => true, 'table_prefix' => '', 'array_key' => 'id', 'title_is_multi_lang' => true, 'orderer' => NULL, ))
Args
File
'/home/prehisto/public_html/sources/site.php'
Line
'1,016'
Function
'load_module_page'
Args
'cms/pages/modules/cms_iotds.php'
'cms_iotds'
File
'/home/prehisto/public_html/sources/site.php'
Line
'785'
Function
'request_page'
Args
'cms_iotds'
true
File
'/home/prehisto/public_html/cms/index.php'
Line
'50'
Function
'do_site'
Args
Parameters
MAX_FILE_SIZE
792723456
comcode__title
1
label_for__title
Title
title
Frozen in time Locked in a Showdown
require__title
1
label_for__file
Upload
require__file
0
hidFileID_file
-1
label_for__url
URL
url
uploads/iotds/trex%2Btric_Guarding_the_NHMLAC_s%2Brw_1.png
require__url
1
comcode__caption
1
label_for__caption
Caption
caption
<div style="height: auto; margin: 15px auto; width: 50%"> <div class="standardbox_wrap_panel"> <h3 class="standardbox_title_panel" style="text-align: center"> Frozen in time Locked in a Showdown</h3> <div class="standardbox_t_panel"> <div class="standardbox_main_classic"> <div style="padding: 10px; text-align: left"> This is a better view of the bronze sculpture "Dueling Dinos" showing life sized T. rex and Triceratops in a showdown which might end badly for one of them.<br /> <br /> I'm not sure which I would rather be, the Triceratops has his work cut out for him but it might be really difficult for the Tyrannosaurus to find a unprotected vulnerable spot to bring down his lunch.<br /> <br /> Frozen in time we'll never know for these two.<br /> <br /> <span style=" color: #669999; font-size: 8pt">Photo Copyright © 2010 David L. Friend<br /> Any reproduction without permission is strictly prohibited.<br /> ALL RIGHTS RESERVED.</span></div> </div> </div> </div> </div>
caption_parsed
<div style="height: auto; margin: 15px auto; width: 50%"><div class="standardbox_wrap_panel"> <h3 class="standardbox_title_panel" style="text-align: center">Frozen in time Locked in a Showdown</h3><div class="standardbox_t_panel"> <div class="standardbox_main_classic"> <div style="padding: 10px; text-align: left">This is a better view of the bronze sculpture "Dueling Dinos" showing life sized T. rex and Triceratops in a showdown which might end badly for one of them.<br /> <br /> I'm not sure which I would rather be, the Triceratops has his work cut out for him but it might be really difficult for the Tyrannosaurus to find a unprotected vulnerable spot to bring down his lunch.<br /> <br /> Frozen in time we'll never know for these two.<br /> <br /> <span style=" color: #669999; font-size: 8pt">Photo Copyright © 2010 David L. Friend<br /> Any reproduction without permission is strictly prohibited.<br /> ALL RIGHTS RESERVED.</span></div> </div> </div> </div> </div>
label_for__validated
In immediate use
validated
1
tick_on_form__validated
0
require__validated
0
label_for__allow_rating
Allow rating
tick_on_form__allow_rating
0
require__allow_rating
0
label_for__allow_comments
Allow comments
allow_comments
2
require__allow_comments
1
label_for__allow_trackbacks
Allow trackbacks
tick_on_form__allow_trackbacks
0
require__allow_trackbacks
0
label_for__notes
Notes
notes
pre_f_notes
1
require__notes
0
label_for__delete
Delete
tick_on_form__delete
0
require__delete
0
label_for__reverse_point_transaction
Reverse gift transaction
tick_on_form__reverse_point_transaction
0
require__reverse_point_transaction
0
http_referer
http://prehistoricsillustrated.com/cms/index.php?page=cms_iotds&type=_ed&id=11&redirect=http%3A%2F%2Fprehistoricsillustrated.com%2Fsite%2Findex.php%3Fpage%3Diotds%26type%3Dview%26id%3Dfont-paramhelvetica_15%26wide%3D1
caption__is_wysiwyg
1
thumb_url
uploads/iotds_thumbs/7trex%252Btric_Guarding_the_NHMLAC_s%252Brw_1.png
This issue has been filed on the tracker as issue
#516 , with a fix.
If not, please let us know how we can do better (please make suggestions that are economically viable and scalable, not just requests to do more for free).
If so, please let others know about ocPortal whenever you see the opportunity .
This information has not loaded yet. It will be generated in the background, please come back later.
If I answered something that you think should be in the documentation, please take the initiative and add it to the
community documentation . We really need people to help out here and build a well-organised large support resource.
Important!
Posted 27 May 2012, 4:48 PM
Community saint
I'm guessing I have to unpack the tar file and there are instructions inside?
Posted 27 May 2012, 5:18 PM
Community saint
Yes, unpack, and the 'tree' is self explanatory. My preference is to lodge the 'hotfixes' in the *_custom directory until the next upgrade, and if the upgrader says the file is no longer necessary (an unnecessary override), I remove it at that time.
Anybody think differently about this. I am always prepared to sit corrected!
Take my advice. I'm not using it! View my working ocPortal site (version 9.x.x ) at Anglo-Indian Portal
Posted 27 May 2012, 6:05 PM
Community saint
Fletch said
Yes, unpack, and the 'tree' is self explanatory. My preference is to lodge the 'hotfixes' in the *_custom directory until the next upgrade, and if the upgrader says the file is no longer necessary (an unnecessary override), I remove it at that time.
Anybody think differently about this. I am always prepared to sit corrected!
My preferred method is to duplicate the original file in place giving it an extension of .BU_ DESC where DESC is a descriptive element like ANTISPAM. I then copy the updated version to the original directory. This method assures I don't have issues with overrides when upgrading. The consistent use of .BU_DESC in all caps makes it easy to spot these entries in listings (either FTP sessions or in the file integrity check) where they can be quickly removed.
Another advantage to this approach is that it documents why I made the change.
Now that Chris has implemented the hotfix patch system, I am probably going to append the hotfix number after DESC. If the fix comes in a forum post, I'll probably use the post number instead.
Just what seems to work for me with minimal effort at upgrade time.
Bob
Last edit: 27 May 2012, 6:22 PM by BobS
Posted 27 May 2012, 6:06 PM
Community saint
I'm sure I don't have anything to unpack the tar as my computer seems confused about what program to uses. It's not my usual world.
Wondering if there is a good program that everybody uses? ...and free is still easier for me to afford but it costs what it costs I guess.
Posted 27 May 2012, 6:16 PM
Community saint
7ZIP is FREE, and it handles TARs (packing and unpacking). The link gives you a choice of 32-bit and 64-bit.
Take my advice. I'm not using it! View my working ocPortal site (version 9.x.x ) at Anglo-Indian Portal
Posted 27 May 2012, 6:30 PM
Community saint
Thanks Chris, it works!
Fletch said
7ZIP is FREE, and it handles TARs (packing and unpacking). The link gives you a choice of 32-bit and 64-bit.
Thanks Fletch, that was easy.