MySQL error

Post

Posted
Rating:
#3535 (In Topic #668)
Joe
Avatar
Standard member
Joe is in the usergroup ‘Honoured member’

when registering or logging in with Facebook

 Unfortunately a query has failed [UPDATE boss_f_member_custom_fields SET field_='US' WHERE (mf_member_id=8) LIMIT 1] [Unknown column 'field_' in 'field list'] (version: 10.0.10, PHP version: 5.6.30, URL: /index.php?page=capture)

The staff have been provided a ‘stack trace’ which may help them diagnose the problem.

I got this same error on my last install and thought it was a problem isolated to that one, but I reinstalled and now I'm getting the same error.

I have quite a few CPFs, but they are all restricted to a subscription based group and are not accessible by regular joining members.
Online now: No Back to the top

Post

Posted
Rating:
#3539
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Are you able to send in a stack trace? You can enable error emails to go to you in your notification settings, they should include the stack traces members don't have access to see.


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

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:
#3540
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Also where's the comma in this?
"when registering or logging in with Facebook"

Do you mean:
"when registering, or logging in with Facebook"
or:
"when registering or logging in, with Facebook"

i.e. Are you only talk about Facebook?


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

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:
#3541
Joe
Avatar
Standard member
Joe is in the usergroup ‘Honoured member’
It seems to be intermittent because I can't reproduce the error at this time.

It happened when I tried logging in with a new Facebook account for the first time. I deleted the account and tried to "re-register", but it's not giving me the same results.

Unfortunately I didn't save the stack trace. But I'll reply to this topic when it happens again and provide it to you.
Online now: No Back to the top

Post

Posted
Rating:
#3542
Avatar
Site director
Chris Graham is in the usergroup ‘Administrators’
Actually I believe I've traced the issue. This should fix it:
Attachment

sources/locations_cpfs.php



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

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
1 guest and 0 members have just viewed this.

Statistics

Forum statistics:
  • 2,052 topics, 7,195 posts, 10,830 members
  • Our newest member is Customcollective
Back to Top