HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Users unable to join/create account on my site

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#87090 (In Topic #17768)
Avatar

Fan in action

Just after updating to 8.1.1, I had a user email me about not being able to make an account.

I tested it myself and, sure enough, I come up with the following error:

Unfortunately a query has failed [INSERT INTO oc_f_members (m_username, m_pass_hash_salted, m_pass_salt, m_theme, m_avatar_url, m_validated, m_validated_email_confirm_code, m_cache_num_posts, m_cache_warnings, m_max_email_attach_size_mb, m_join_time, m_timezone_offset, m_primary_group, m_last_visit_time, m_last_submit_time, m_signature, m_is_perm_banned, m_preview_posts, m_notes, m_dob_day, m_dob_month, m_dob_year, m_reveal_age, m_email_address, m_title, m_photo_url, m_photo_thumb_url, m_views_signatures, m_auto_monitor_contrib_content, m_highlighted_name, m_pt_allow, m_pt_rules_text, m_language, m_ip_address, m_zone_wide, m_allow_emails, m_allow_emails_from_staff, m_password_change_code, m_password_compat_scheme, m_on_probation_until) VALUES ('Testing', '0f3e51bd9bdf61736df51fd070cf7004', '��9=��}޵\rw`\r', '', 'themes/default/images/ocf_default_avatars/default_set/music.png', 1, '26140', 0, 0, 5, 1339646057, 'America/New_York', 9, 1339646057, 1339646057, 980, 0, 0, '', 15, 11, 1985, 1, 'tzolak@gmail.com', '', '', '', 1, 1, 0, '*', 981, 'EN', '68.76.120.201', 1, 1, 0, '', '', NULL)] [Incorrect string value: '\xD9\xCC9=\x9E\xEA...' for column 'm_pass_salt' at row 1] (version: 8.1.1, PHP version: 5.3.8, URL: /index.php?page=join&type=step3&redirect=http%3A%2F%2Fwww.defyinggravity.co.cc%2Findex.php%3Fpage%3Dstart)
Back to the top
 
Posted
Rating:
#87092
Avatar

Community saint

I just tested this out also and was able to create an account.

The only problem I received was this message, "Either you ("Guest") have lost access between the time of the link you clicked appearing and now, you have found a bug, or you are jumping into URLs." when hitting the "proceed" button on the registration form.

Steve
Back to the top
 
Posted
Rating:
#87093
Avatar

Fan in action

sholzy said

I just tested this out also and was able to create an account.

The only problem I received was this message, "Either you ("Guest") have lost access between the time of the link you clicked appearing and now, you have found a bug, or you are jumping into URLs." when hitting the "proceed" button on the registration form.
Not quite sure what you mean…

I logged out of my [admin] account, and clicked 'join' on the login screen.
I'm wondering if there is something wrong with the openID or facebook addons from this upgrade?

I can try again. All I know is, I filled out the registration form, and clicked 'proceed' and it took me to the home page again with that error message.


Edit: Found the stacktrace error, will put in a new message.




Last edit: by Ethan Sommerfeld
Back to the top
 
Posted
Rating:
#87094
Avatar

Community saint

Ethan Sommerfeld said

sholzy said

I just tested this out also and was able to create an account.

The only problem I received was this message, "Either you ("Guest") have lost access between the time of the link you clicked appearing and now, you have found a bug, or you are jumping into URLs." when hitting the "proceed" button on the registration form.

Not quite sure what you mean…

I logged out of my [admin] account, and clicked 'join' on the login screen.
I'm wondering if there is something wrong with the openID or facebook addons from this upgrade?
I don't use the openID or Facebook addons.

I can try again. All I know is, I filled out the registration form, and clicked 'proceed' and it took me to the home page again with that error message.
I did the same as you except when I clicked "proceed" I was dumped back into the login screen with this message "Either you ("Guest") have lost access between the time of the link you clicked appearing and now, you have found a bug, or you are jumping into URLs", but the account was created.

Steve
Back to the top
 
Posted
Rating:
#87095
Avatar

Community saint

What version did you upgrade from?

Steve
Back to the top
 
Posted
Rating:
#87096
Avatar

Fan in action

sholzy said

What version did you upgrade from?
8.1 to 8.1.1

Stack trace:


Code

File '/home/defyingg/public_html/sources/failure.php'
Line '684'
Function 'get_html_trace'
Args  

File '/home/defyingg/public_html/sources/global2.php'
Line '983'
Function '_fatal_exit'
Args

object


File '/home/defyingg/public_html/sources/database/mysql.php'
Line '245'
Function 'fatal_exit'
Args

object


File '/home/defyingg/public_html/sources/database.php'
Line '1,068'
Function 'db_query'
Class 'Database_Static_mysql'
Object Database_Static_mysql::__set_state(array( ))
Type '->'
Args ...

array ( 0 => NULL, 1 => 'defyingg_ocpo221', )

NULL

NULL

false

true

false

false


File '/home/defyingg/public_html/sources/database.php'
Line '538'
Function '_query'
Class 'database_driver'
Object database_driver::__set_state(array( 'table_prefix' => 'oc_', 'connection_read' => array ( 0 => NULL, 1 => 'defyingg_ocpo221', ), 'connection_write' => array ( 0 => NULL, 1 => 'defyingg_ocpo221', ), 'text_lookup_original_cache' => array ( 7 => 'Welcome', 1 => 'No one can bring us down!', 75 => '', 76 => '', 34 => 'Administrators', 35 => 'Site director', ), 'text_lookup_cache' => array ( 7 => '', 1 => '', 75 => '', 76 => '', 34 => '', 35 => '', 988 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_4fd9703dbd3785.88152547\']="echo \\"\\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_4fd9703dbd3785.88152547', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), 989 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_4fd9703dbd6536.88285814\']="echo \\"\\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_4fd9703dbd6536.88285814', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type '->'
Args ...

NULL

NULL

false

true

NULL

''

false


File '/home/defyingg/public_html/sources/ocf_members_action.php'
Line '227'
Function 'query_insert'
Class 'database_driver'
Object database_driver::__set_state(array( 'table_prefix' => 'oc_', 'connection_read' => array ( 0 => NULL, 1 => 'defyingg_ocpo221', ), 'connection_write' => array ( 0 => NULL, 1 => 'defyingg_ocpo221', ), 'text_lookup_original_cache' => array ( 7 => 'Welcome', 1 => 'No one can bring us down!', 75 => '', 76 => '', 34 => 'Administrators', 35 => 'Site director', ), 'text_lookup_cache' => array ( 7 => '', 1 => '', 75 => '', 76 => '', 34 => '', 35 => '', 988 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_4fd9703dbd3785.88152547\']="echo \\"\\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_4fd9703dbd3785.88152547', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), 989 => ocp_tempcode::__set_state(array( 'code_to_preexecute' => '$TPL_FUNCS[\'string_attach_4fd9703dbd6536.88285814\']="echo \\"\\";"; ', 'seq_parts' => array ( 0 => array ( 0 => 'string_attach_4fd9703dbd6536.88285814', 1 => array ( ), 2 => 1, 3 => '', 4 => '', ), ), 'preprocessable_bits' => array ( ), 'last_attach' => NULL, 'pure_lang' => NULL, 'codename' => ':container', 'cached_output' => NULL, )), ), 'table_exists_cache' => array ( ), 'static_ob' => Database_Static_mysql::__set_state(array( )), ))
Type '->'
Args ...

true


File '/home/defyingg/public_html/sources/global.php(211) : eval()\'d code'
Line '308'
Function 'ocf_make_member'
Args

'Waffles'

'9ethan21'

'trombonist777@gmail.com'

array ( 0 => 9, )

4

6

1989

array ( )

'America/New_York'

NULL

1

1339650109

1339650109

''

NULL

''

0

0

1

''

''

''

1

1

'EN'

1

0

''

'68.76.120.201'

'22884'

true

''

''


File '/home/defyingg/public_html/pages/modules/join.php'
Line '167'
Function 'ocf_join_actual'
Args  

File '/home/defyingg/public_html/pages/modules/join.php'
Line '80'
Function 'step3'
Class 'Module_join'
Object Module_join::__set_state(array( ))
Type '->'
Args  

File '/home/defyingg/public_html/sources/zones.php'
Line '424'
Function 'run'
Class 'Module_join'
Object Module_join::__set_state(array( ))
Type '->'
Args  

File '/home/defyingg/public_html/sources/site.php'
Line '1,037'
Function 'load_module_page'
Args

'pages/modules/join.php'

'join'


File '/home/defyingg/public_html/sources/site.php'
Line '799'
Function 'request_page'
Args

'join'

true


File '/home/defyingg/public_html/index.php'
Line '104'
Function 'do_site'
Args  

Parameters

confirm
1
label_for__username
Username
username
Waffles
require__username
1
label_for__password
Password
password
9ethan21
require__password
1
password_confirm
9ethan21
require__password_confirm
1
label_for__email_address
E-mail address
email_address
trombonist777@gmail.com
require__email_address
1
email_address_confirm
trombonist777@gmail.com
require__email_address_confirm
1
dob_day
4
dob_month
6
dob_year
1989
require__dob
0
label_for__reveal_age
› Reveal age
reveal_age
1
tick_on_form__reveal_age
0
require__reveal_age
0
label_for__timezone
Time zone
timezone
America/New_York
require__timezone
1
label_for__allow_emails
Receive e-mails from other members
allow_emails
1
tick_on_form__allow_emails
0
require__allow_emails
0
label_for__referrer
Referrer
referrer
Elphaba
require__referrer
0
label_for__security_image
Security image
security_image
615238
require__security_image
1
Back to the top
 
Posted
Rating:
#87097
Avatar

Community saint

Ethan Sommerfeld said

sholzy said

What version did you upgrade from?
8.1 to 8.1.1


Same here.

Steve
Back to the top
 
Important!
Posted
Item has a rating of 5 (Liked by sholzy)  
Rating:
#87104
Avatar

Automated fix message

Ethan Sommerfeld said

Just after updating to 8.1.1, I had a user email me about not being able to make an account.

I tested it myself and, sure enough, I come up with the following error:

Unfortunately a query has failed [INSERT INTO oc_f_members (m_username, m_pass_hash_salted, m_pass_salt, m_theme, m_avatar_url, m_validated, m_validated_email_confirm_code, m_cache_num_posts, m_cache_warnings, m_max_email_attach_size_mb, m_join_time, m_timezone_offset, m_primary_group, m_last_visit_time, m_last_submit_time, m_signature, m_is_perm_banned, m_preview_posts, m_notes, m_dob_day, m_dob_month, m_dob_year, m_reveal_age, m_email_address, m_title, m_photo_url, m_photo_thumb_url, m_views_signatures, m_auto_monitor_contrib_content, m_highlighted_name, m_pt_allow, m_pt_rules_text, m_language, m_ip_address, m_zone_wide, m_allow_emails, m_allow_emails_from_staff, m_password_change_code, m_password_compat_scheme, m_on_probation_until) VALUES ('Testing', '0f3e51bd9bdf61736df51fd070cf7004', '��9=��}޵\rw`\r', '', 'themes/default/images/ocf_default_avatars/default_set/music.png', 1, '26140', 0, 0, 5, 1339646057, 'America/New_York', 9, 1339646057, 1339646057, 980, 0, 0, '', 15, 11, 1985, 1, 'tzolak@gmail.com', '', '', '', 1, 1, 0, '*', 981, 'EN', '68.76.120.201', 1, 1, 0, '', '', NULL)] [Incorrect string value: '\xD9\xCC9=\x9E\xEA...' for column 'm_pass_salt' at row 1] (version: 8.1.1, PHP version: 5.3.8, URL: /index.php?page=join&type=step3&redirect=http%3A%2F%2Fwww.defyinggravity.co.cc%2Findex.php%3Fpage%3Dstart)
This issue has been filed on the tracker as issue #612, with a fix.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
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 ocPortal whenever you see the opportunity.
  • 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 ocPortal 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.
Important!
 
Posted
Rating:
#87115
Avatar

Fan in action

Chris Graham said

This issue has been filed on the tracker as issue #612, with a fix.

Thank you so much for posting that. Was worried :\
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: