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.


[SOLVED!] Members having difficulty signing in

Login / Search

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

Community saint

Has to do with members convereted from an AEF dump

Greetings,

Ever since opening up part of my website (the sub-domain I built from a converted AEF forum) members have been having trouble logging into the site.

Here is a brief excerpt from one of my many error emails. Please note I do not want to give out everything from it as I value my member's privacy.

Unfortunately a query has failed [SELECT id FROM ocp4_users WHERE (cookpass='' AND id=6) LIMIT 1] [Table 'norovane_legends.ocp4_users' doesn't exist] (version: 4.1.4, PHP version: 5.2.5, URL: /pg/start)An error has occurredUnfortunately a query has failed [SELECT id FROM ocp4_users WHERE (cookpass='' AND id=6) LIMIT 1] [Table 'norovane_legends.ocp4_users' doesn't exist] (version: 4.1.4, PHP version: 5.2.5, URL: /pg/start)



Now of course the member exist in the database, I checked. So I am at a loss here on how to fix this issue. If you need more information I can give it in a private thread or email.

Thanks in advance.


Last edit: by mythus

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47432
Avatar

Hi,

This is a bug in our AEF forum driver.

Please try this sources/forum/aef.php file.
Attachment
» Download: aef.php (44 Kb, 227 downloads so far)


Sorry for the inconvenience. Hope this solves it for you :).


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.
Back to the top
 
Posted
Rating:
#47433
Avatar

Community saint

Alright I'll put that in.. however I must reiterate that everything had already been imported from AEF. So does this mean I would need to re-import from AEF?

Thanks again for your help!

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47434
Avatar

Oh sorry, I should have sent this:

Attachment
» Download: ocf.php (58 Kb, 253 downloads so far)

(sources/forum/ocf.php)


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.
Back to the top
 
Posted
Rating:
#47435
Avatar

Community saint

AH ok, thanks.

I was curious on how an aef.php file would help an already converted site. As soon as I get confirmation that this fixed the problems my members are having logging in I'll report it. I'll also report if the issue is still there.

Thanks again!

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47441
Avatar

Community saint

It seems like this fixed the problem as a member did log in since applying this fix and I got no error messages.

So thanks!

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47447
Avatar

Community saint

Personal note for Mythus: thank-you very kindly for taking the time to change your subject to include SOLVED where appropriate. It will make searching for solutions by others mucho easier!

"no violence, no hate, no pain, no enemies
just peace, unity, tolerance and love" - The Beloved

OCP V7 | Advocating monetary reform - FreeOurMoney

Need OCP friendly hosting? Look no further:
Web Hosting, Reseller Hosting, and Dedicated Servers w/cPanel - Elief! - Official hosting partner for ocPortal.
Back to the top
 
Posted
Rating:
#47461
Avatar

Community saint

Greetings,

I woke up this morning to see another error email. Thus I have to assume that the problem hasn't been fully fixed.

Here is the full quote of the email.

An error occurred at:

Legends of Nor'Ova - Legends of Nor'Ova

The full error details follow:

Unfortunately a query has failed [SELECT id FROM ocp4_users WHERE (cookpass='' AND id=4) LIMIT 1] [Table 'norovane_legends.ocp4_users' doesn't exist] (version: 4.1.4, PHP version: 5.2.5, URL: /pg/start/index.php?filtered=1&keep_has_js=1)
An error has occurred

Unfortunately a query has failed [SELECT id FROM ocp4_users WHERE (cookpass='' AND id=4) LIMIT 1] [Table 'norovane_legends.ocp4_users' doesn't exist] (version: 4.1.4, PHP version: 5.2.5, URL: /pg/start/index.php?filtered=1&keep_has_js=1)
Here is the stack trace:
- Show quoted text -

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.com 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/norovane/public_html/legendsofnorova/sou
rces/global2.php'
Line    '931'
Function    'get_html_trace'
Args    

File    '/home/norovane/public_html/legendsofnorova/sou
rces/database/mysql.php'
Line    '190'
Function    'fatal_exit'
Args    

object

File    '/home/norovane/public_html/legendsofnorova/sou
rces/database.php'
Line    '723'
Function    'db_query'
Class    'Database_Static_mysql'
Type    '->'
Object    Database_Static_mysql::__set_state(array( ))
Args    

'SELECT id FROM ocp4_users WHERE (cookpass=\'\' AND id=4) '

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

1

NULL

false

false

File    '/home/norovane/public_html/legendsofnorova/sou
rces/database.php'
Line    '631'
Function    '_query'
Class    'database_driver'
Type    '->'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'norovane_legends', ), 'connection_write' => array ( 0 => NULL, 1 => 'norovane_legends', ), ))
Args    

'SELECT id FROM ocp4_users WHERE (cookpass=\'\' AND id=4) '

1

NULL

false

File    '/home/norovane/public_html/legendsofnorova/sou
rces/database.php'
Line    '453'
Function    'query_select'
Class    'database_driver'
Type    '->'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'norovane_legends', ), 'connection_write' => array ( 0 => NULL, 1 => 'norovane_legends', ), ))
Args    

'users'

array ( 0 => 'id', )

array ( 'cookpass' => '', 'id' => 4, )

''

1

NULL

false

File    '/home/norovane/public_html/legendsofnorova/sou
rces/forum/ocf.php'
Line    '1,527'
Function    'query_value_null_ok'
Class    'database_driver'
Type    '->'
Object    database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'norovane_legends', ), 'connection_write' => array ( 0 => NULL, 1 => 'norovane_legends', ), ))
Args    

'users'

'id'

array ( 'cookpass' => '', 'id' => 4, )

- Show quoted text -
File    '/home/norovane/public_html/legendsofnorova/sou
rces/users.php'
Line    '574'
Function    'forum_authorise_login'
Class    'forum_driver_ocf'
Type    '->'
Object    forum_driver_ocf::__set_state(array( 'connection' => database_driver::__set_state(array( 'table_prefix' => 'ocp4_', 'connection_read' => array ( 0 => NULL, 1 => 'norovane_legends', ), 'connection_write' => array ( 0 => NULL, 1 => 'norovane_legends', ), )), 'MEMBER_ROWS_CACHED' => array ( 4 => array ( 'id' => 4, 'm_username' => 'Tiana', 'm_pass_hash_salted' => '2de69219c9374f0eddf80877a14f344e', 'm_pass_salt' => 'nnie', 'm_theme' => '-1', 'm_avatar_url' => '', 'm_validated' => 1, 'm_validated_email_confirm_code' => '', 'm_cache_num_posts' => 18, 'm_cache_warnings' => 0, 'm_join_time' => 1226784470, 'm_timezone_offset' => -8, 'm_primary_group' => 17, 'm_last_visit_time' => 1232587988, 'm_last_submit_time' => 1232587988, 'm_signature' => 400, 'm_is_perm_banned' => 0, 'm_preview_posts' => 0, 'm_dob_day' => 30, 'm_dob_month' => 11, 'm_dob_year' => 1999, 'm_reveal_age' => 1, 'm_email_address' => 'tiana_17_82@yahoo.com', 'm_title' => '', 'm_photo_url' => '', 'm_photo_thumb_url' => '', 'm_views_signatures' => 1, 'm_track_contributed_topics' => 1, 'm_language' => 'EN', 'm_ip_address' => '24.113.44.226', 'm_allow_emails' => 1, 'm_notes' => '', 'm_zone_wide' => 1, 'm_highlighted_name' => 0, 'm_pt_allow' => '*', 'm_pt_rules_text' => 401, 'm_max_email_attach_size_mb' => 5, 'm_password_change_code' => '', 'm_password_compat_scheme' => 'aef', 'm_on_probation_until' => 1231962420, ), ), ))
- Show quoted text -
Args    

NULL

4

'2de69219c9374f0eddf80877a14f344e'

'2de69219c9374f0eddf80877a14f344e'

true

To SD:

Yeah, I try to remember to do so… sometimes I forget though. Old age, kids, and all :P

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47462
Avatar

Could it be the error mail was delayed, from earlier?
I'm confident the fix works, as this stack trace will no longer correlate with the code file I uploaded.


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.
Back to the top
 
Posted
Rating:
#47464
Avatar

Community saint

That is a possibility.

I will monitor it for the rest of the day. Mid-week days such as today are higher traffic days for me so I should be able to see people logging in and thusly no error emails.

If that proves true I'll remark this as solved. If I get more and hear complaints I'll inform you. But I do hope it is fixed.

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47484
Avatar

We're still getting these error messages too, so I think you need to check the new ocf.php file uploaded properly. The string 'cookpass' shouldn't be in the file you have.


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.
Back to the top
 
Posted
Rating:
#47502
Avatar

Community saint

Greetings,

Ok so I checked and that line was indeed present. I suppose that when I uploaded the new file it didn't overwrite the old one. Therefore I went in and deleted the old one first, uploaded the new one and checked to make sure that the one that is uploaded doesn't have that cookiepass line.

So here's hoping that this fixed the issue. I will wait until tomorrow to indicate if it did or didn't and if it did will change the title again to solved.

THanks again for your help.

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47565
Avatar

Community saint

I officially declare this problem SOLVED!

Thanks much for your help Chris! My members and I appreciate it!

Legends of Nor'Ova: A site powered by ocPortal; home of the Legends of Nor'Ova tabletop RPG wiki and community.

Like ocPortal? Want to thank Chris and gang somehow? Then help out in the chat room! It really needs your help! Just open it in a tab everytime you open your web browser, and when you hear a "ding", check it out!

"Those who want help should first be willing to give help."
Back to the top
 
Posted
Rating:
#47568
Avatar

Community saint

Yay glad its all worked out for you.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: