Jump to content

Community

query error


Luis Manson
 Share

Recommended Posts

Hello, im posting here because my license expired long time ago, but since Im about to move to another software and decided to do some cleaning before the migration....

I filtered "validating" members who never came back after 2016, Im about to move them to another group and got an SQL error:

SELECT COUNT(*) FROM `gacore_members` AS `core_members` LEFT JOIN `gacore_pfields_content` AS `core_pfields_content` ON core_members.member_id=core_pfields_content.member_id WHERE last_visit BETWEEN 978307200 AND 1420156799 AND member_posts=0 AND ( v.lost_pass=0 AND v.forgot_security=0 AND v.vid IS NOT NULL )

 

The query complains about "v.lost_pass"  not existing, but it is in the validating table... any one knows how to fix this?

Link to comment
Share on other sites

8 hours ago, Luis Manson said:

Hello, im posting here because my license expired long time ago, but since Im about to move to another software and decided to do some cleaning before the migration....

I filtered "validating" members who never came back after 2016, Im about to move them to another group and got an SQL error:


SELECT COUNT(*) FROM `gacore_members` AS `core_members` LEFT JOIN `gacore_pfields_content` AS `core_pfields_content` ON core_members.member_id=core_pfields_content.member_id WHERE last_visit BETWEEN 978307200 AND 1420156799 AND member_posts=0 AND ( v.lost_pass=0 AND v.forgot_security=0 AND v.vid IS NOT NULL )

 

The query complains about "v.lost_pass"  not existing, but it is in the validating table... any one knows how to fix this?

I would recommend upgrading your community to the latest version, this issue was fixed over a year ago.

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy