Problem on see profile page

Post

Posted
Rating:
#4559 (In Topic #970)
Avatar
Standard member
gothenk is in the usergroup ‘Fan in training’
HI,
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

Online now: No Back to the top

Post

Posted
Rating:
#4562
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
This looks like a corrupt table. Try repairing the ocp_stats table in phpMyAdmin.


Become a fan of Composr on Facebook or add me as a friend. Add me on on Twitter. Follow me on Minds (where I am most active). Support me on Patreon

Was I helpful?
  • 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.
Online now: No Back to the top

Post

Posted
Rating:
#4572
Avatar
Standard member
gothenk is in the usergroup ‘Fan in training’
tks mate fix work fine
Online now: No Back to the top
1 guest and 0 members have just viewed this.

Statistics

Users online:

babu, MVLipwig, Salman, ХорошаЯ, 224 guests

Forum statistics:
  • 886 topics, 4,284 posts, 5,271 members
  • Our newest member is Varundatta
Birthdays:
Back to Top