Support forums

Please check @brandnewbox_uk for support status updates.

Search     Advanced Search
Error on Add Ons - > Members  
Posted: 10 August 2012 10:22 PM —  
Newbie
Rank
Total Posts:  1
Joined  2011-03-07

Hello I’m getting this error when trying to access settings

A Database Error Occurred
Error Number: 1317

Query execution was interrupted

SELECT DISTINCT m.member_id, m.username, m.screen_name, m.email, m.join_date, m.ip_address, m.url, m.bio, g.group_title, m.total_entries, m.total_comments, ( SELECT COUNT(*) FROM exp_members m2 WHERE m.ip_address = m2.ip_address AND m2.group_id != 1 AND m2.group_id != 2 ) as num_ips, ( SELECT COUNT(*) FROM exp_simple_commerce_purchases p WHERE m.member_id = p.member_id ) AS num_buys FROM exp_members m INNER JOIN exp_member_groups g ON m.group_id = g.group_id WHERE m.group_id != 1 AND m.group_id != 2

Filename: third_party/ajw_members/mcp.ajw_members.php

Line Number: 156
Profile
 
Posted: 16 August 2012 07:21 PM —   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  1357
Joined  2006-04-12

Hi,

I think on large member tables some of the queries take a long time.

To work around this, you need to add an additional index to the database table. If you can run the SQL:

alter table `db_name`.`exp_members` add index `ip_address`(`ip_address`);

it should work better. I think you can run it from the EE control panel > Tools > Data > SQL Manager > Database Query Form.

Andrew

Profile
 

‹‹ Members

Select A Theme