Problem on see profile page
Posted
#4559
(In Topic #970)

Standard member

using an old version of ocportal have a problem of login today i reset password from phpmyadmin but when I log and try to go on my profile page to set other password i got an error. same happen if other user try to make it. in attach file of error. I cant answaer here please telle where I can put this question can't upgrade to compsr atm to much mod page on site.
Tks
error said
Unfortunately a query has failed [SELECT browser,operating_system FROM ocp_stats WHERE (the_user=4) ORDER BY date_and_time DESC LIMIT 1] [Can't find record in 'ocp_stats'] (version: 9.0.19, PHP version: 5.6.25, URL: /portale/index.php?page=members&type=view&id=username)
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 'C:\wamp64\apps\portale\sources\failure.php'
Line '838'
Function 'get_html_trace'
Args
File 'C:\wamp64\apps\portale\sources\global2.php'
Line '1,053'
Function '_fatal_exit'
Args
object
File 'C:\wamp64\apps\portale\sources\database\mysqli.php'
Line '253'
Function 'fatal_exit'
Args
object
File 'C:\wamp64\apps\portale\sources\database.php'
Line '1,134'
Function 'db_query'
Class 'Database_Static_mysqli'
Object Database_Static_mysqli::__set_state(array( ))
Type '->'
Args …
1
NULL
false
false
false
false
File 'C:\wamp64\apps\portale\sources\database.php'
Line '927'
Function '_query'
Class 'database_driver'
Object database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'sito', ), 'connection_write' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'sito', ), 'text_lookup_original_cache' => array ( 7 => 'Welcome', 1 => '', 523 => '', 524 => '', 34 => 'Administrators', 35 => 'Site director', 8 => 'Admin Zone', 11 => 'Content Management', 1003 => 'collaboration', 13 => 'Forums', 3724 => 'MAD', 9 => 'Site', 2 => 'Admin Zone', 5 => 'Content Management', 1004 => '???', 12 => 'Forum', 3725 => '', 4 => '', 14 => 'About me', 18 => 'Facebook profile', 20 => 'Google+ profile', 22 => 'Twitter account', 30 => 'Staff notes', 83 => 'ocp_mobile_phone_number', 279 => 'ocp_points_gained_seedy', 290 => 'ocp_points_gained_chat', 316 => 'ocp_currency', 318 => 'ocp_payment_cardholder_name', 320 => 'ocp_payment_type', 322 => 'ocp_payment_card_number', 324 => 'ocp_payment_card_start_date', 326 => 'ocp_payment_card_expiry_date', 328 => 'ocp_payment_card_issue_number', 330 => 'ocp_payment_card_cv2', 344 => 'ocp_firstname', 346 => 'ocp_lastname', 348 => 'ocp_building_name_or_number', 350 => 'ocp_city', 352 => 'ocp_state', 354 => 'ocp_post_code', 356 => 'ocp_country', 380 => 'ocp_points_used', 382 => 'ocp_gift_points_used', 384 => 'ocp_points_gained_given', 386 => 'ocp_points_gained_rating', 388 => 'ocp_points_gained_voting', 390 => 'ocp_sites', 392 => 'ocp_role', 394 => 'ocp_fullname', 15 => 'Some personally written information.', 19 => 'A link to your Facebook profile.', 21 => 'A link to your Google+ profile.', 23 => 'Your Twitter name (for example, \'charlie12345\').', 31 => 'Notes on this member, only viewable by staff.', 84 => 'This should be the mobile phone number in international format, devoid of any national or international outgoing access codes. For instance, a typical UK (44) number might be nationally known as \'01234 123456\', but internationally and without outgoing access codes would be \'441234123456\'.', 280 => '', 291 => '', 317 => '', 319 => '', 321 => '', 323 => '', 325 => '', 327 => '', 329 => '', 331 => '', 345 => '', 347 => '', 349 => '', 351 => '', 353 => '', 355 => '', 357 => '', 381 => '', 383 => '', 385 => '', 387 => '', 389 => '', 391 => '', 393 => '', 395 => '', 525 => '', 526 => '', ), 'text_lookup_cache' => array ( 7 => '', 1 => '', 523 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_5577e317e82689.45842531\']="echo \"\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_5577e317e82689.45842531', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), 524 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 35 => '', 8 => '', 11 => '', 1003 => '', 13 => '', 3724 => '', 9 => '', 2 => '', 5 => '', 1004 => '', 12 => '', 3725 => '', 4 => '', 14 => '', 18 => '', 20 => '', 22 => '', 30 => '', 83 => '', 279 => '', 290 => '', 316 => '', 318 => '', 320 => '', 322 => '', 324 => '', 326 => '', 328 => '', 330 => '', 344 => '', 346 => '', 348 => '', 350 => '', 352 => '', 354 => '', 356 => '', 380 => '', 382 => '', 384 => '', 386 => '', 388 => '', 390 => '', 392 => '', 394 => '', 15 => '', 19 => '', 21 => '', 23 => '', 31 => '', 84 => '', 280 => '', 291 => '', 317 => '', 319 => '', 321 => '', 323 => '', 325 => '', 327 => '', 329 => '', 331 => '', 345 => '', 347 => '', 349 => '', 351 => '', 353 => '', 355 => '', 357 => '', 381 => '', 383 => '', 385 => '', 387 => '', 389 => '', 391 => '', 393 => '', 395 => '', 525 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, 'is_really_empty' => true, )), 526 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, 'is_really_empty' => true, )), ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysqli::__set_state(array( )), 'dedupe_mode' => false, ))
Type '->'
Args
'SELECT browser,operating_system FROM ocp_stats WHERE (the_user=4) ORDER BY date_and_time DESC'
1
NULL
false
false
array ( )
''
File 'C:\wamp64\apps\portale\sources\hooks\systems\profiles_tabs\about.php'
Line '318'
Function 'query_select'
Class 'database_driver'
Object database_driver::__set_state(array( 'table_prefix' => 'ocp_', 'connection_read' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'sito', ), 'connection_write' => array ( 0 => mysqli::__set_state(array( 'affected_rows' => NULL, 'client_info' => NULL, 'client_version' => NULL, 'connect_errno' => NULL, 'connect_error' => NULL, 'errno' => NULL, 'error' => NULL, 'error_list' => NULL, 'field_count' => NULL, 'host_info' => NULL, 'info' => NULL, 'insert_id' => NULL, 'server_info' => NULL, 'server_version' => NULL, 'stat' => NULL, 'sqlstate' => NULL, 'protocol_version' => NULL, 'thread_id' => NULL, 'warning_count' => NULL, )), 1 => 'sito', ), 'text_lookup_original_cache' => array ( 7 => 'Welcome', 1 => '', 523 => '', 524 => '', 34 => 'Administrators', 35 => 'Site director', 8 => 'Admin Zone', 11 => 'Content Management', 1003 => 'collaboration', 13 => 'Forums', 3724 => 'MAD', 9 => 'Site', 2 => 'Admin Zone', 5 => 'Content Management', 1004 => '???', 12 => 'Forum', 3725 => '', 4 => '', 14 => 'About me', 18 => 'Facebook profile', 20 => 'Google+ profile', 22 => 'Twitter account', 30 => 'Staff notes', 83 => 'ocp_mobile_phone_number', 279 => 'ocp_points_gained_seedy', 290 => 'ocp_points_gained_chat', 316 => 'ocp_currency', 318 => 'ocp_payment_cardholder_name', 320 => 'ocp_payment_type', 322 => 'ocp_payment_card_number', 324 => 'ocp_payment_card_start_date', 326 => 'ocp_payment_card_expiry_date', 328 => 'ocp_payment_card_issue_number', 330 => 'ocp_payment_card_cv2', 344 => 'ocp_firstname', 346 => 'ocp_lastname', 348 => 'ocp_building_name_or_number', 350 => 'ocp_city', 352 => 'ocp_state', 354 => 'ocp_post_code', 356 => 'ocp_country', 380 => 'ocp_points_used', 382 => 'ocp_gift_points_used', 384 => 'ocp_points_gained_given', 386 => 'ocp_points_gained_rating', 388 => 'ocp_points_gained_voting', 390 => 'ocp_sites', 392 => 'ocp_role', 394 => 'ocp_fullname', 15 => 'Some personally written information.', 19 => 'A link to your Facebook profile.', 21 => 'A link to your Google+ profile.', 23 => 'Your Twitter name (for example, \'charlie12345\').', 31 => 'Notes on this member, only viewable by staff.', 84 => 'This should be the mobile phone number in international format, devoid of any national or international outgoing access codes. For instance, a typical UK (44) number might be nationally known as \'01234 123456\', but internationally and without outgoing access codes would be \'441234123456\'.', 280 => '', 291 => '', 317 => '', 319 => '', 321 => '', 323 => '', 325 => '', 327 => '', 329 => '', 331 => '', 345 => '', 347 => '', 349 => '', 351 => '', 353 => '', 355 => '', 357 => '', 381 => '', 383 => '', 385 => '', 387 => '', 389 => '', 391 => '', 393 => '', 395 => '', 525 => '', 526 => '', ), 'text_lookup_cache' => array ( 7 => '', 1 => '', 523 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_5577e317e82689.45842531\']="echo \"\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_5577e317e82689.45842531', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), 524 => 'return unserialize("a:6:{i:0;a:0:{}i:1;a:0:{}i:2;s:10:\":container\";i:3;N;i:4;N;i:5;s:0:\"\";}"); ', 34 => '', 35 => '', 8 => '', 11 => '', 1003 => '', 13 => '', 3724 => '', 9 => '', 2 => '', 5 => '', 1004 => '', 12 => '', 3725 => '', 4 => '', 14 => '', 18 => '', 20 => '', 22 => '', 30 => '', 83 => '', 279 => '', 290 => '', 316 => '', 318 => '', 320 => '', 322 => '', 324 => '', 326 => '', 328 => '', 330 => '', 344 => '', 346 => '', 348 => '', 350 => '', 352 => '', 354 => '', 356 => '', 380 => '', 382 => '', 384 => '', 386 => '', 388 => '', 390 => '', 392 => '', 394 => '', 15 => '', 19 => '', 21 => '', 23 => '', 31 => '', 84 => '', 280 => '', 291 => '', 317 => '', 319 => '', 321 => '', 323 => '', 325 => '', 327 => '', 329 => '', 331 => '', 345 => '', 347 => '', 349 => '', 351 => '', 353 => '', 355 => '', 357 => '', 381 => '', 383 => '', 385 => '', 387 => '', 389 => '', 391 => '', 393 => '', 395 => '', 525 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, 'is_really_empty' => true, )), 526 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '', 'seq_parts' => array ( ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, 'is_really_empty' => true, )), ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysqli::__set_state(array( )), 'dedupe_mode' => false, ))
Type '->'
Args
'stats'
array ( 0 => 'browser', 1 => 'operating_system', )
array ( 'the_user' => 4, )
'ORDER BY date_and_time DESC'
1
File 'C:\wamp64\apps\portale\sources\ocf_profiles.php'
Line '49'
Function 'render_tab'
Class 'Hook_Profiles_Tabs_about'
Object Hook_Profiles_Tabs_about::__set_state(array( ))
Type '->'
Args
4
4
true
File 'C:\wamp64\apps\portale\site\pages\modules\members.php'
Line '312'
Function 'render_profile_tabset'
Args
4
4
'username'
File 'C:\wamp64\apps\portale\site\pages\modules\members.php'
Line '105'
Function 'profile'
Class 'Module_members'
Object Module_members::__set_state(array( ))
Type '->'
Args
File 'C:\wamp64\apps\portale\sources\zones.php'
Line '446'
Function 'run'
Class 'Module_members'
Object Module_members::__set_state(array( ))
Type '->'
Args
File 'C:\wamp64\apps\portale\sources\site.php'
Line '882'
Function 'load_module_page'
Args
'site/pages/modules/members.php'
'members'
File 'C:\wamp64\apps\portale\sources\site.php'
Line '662'
Function 'request_page'
Args
'members'
true
File 'C:\wamp64\apps\portale\index.php'
Line '97'
Function 'do_site'
Last edit: by gothenk
Posted

Site director

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.
Posted

Standard member

1 guest and 0 members have just viewed this.