SQL Error

ciar4n
Topic Author
Offline
Junior Member

More

11 years 4 months ago #34364 by ciar4n

SQL Error was created by ciar4n

Hello

Our site is down due to an SQL error which appears to come from the Membership Pro extension. The error is as follows....

Code:

SQL=SELECT a.id FROM XXXX_osmembership_subscribers AS a INNER JOIN XXXX_osmembership_subscribers AS b ON a.id = b.plan_id WHERE b.user_id=46772 AND (a.lifetime_membership=1 OR (DATE(from_date) <= CURDATE() AND DATE(to_date) >= CURDATE())) AND b.published=1

Ciarán

Please Log in or Create an account to join the conversation.

Tuan Pham Ngoc
Offline
Administrator

More

11 years 4 months ago #34390 by Tuan Pham Ngoc

Replied by Tuan Pham Ngoc on topic Re: SQL Error

That's strange. Could you pleas submit a support ticket sending us admin and FTP account of your site so that we can check and solve the issue for you ?

Tuan

Please Log in or Create an account to join the conversation.

ciar4n
Topic Author
Offline
Junior Member

More

11 years 4 months ago #34428 by ciar4n

Replied by ciar4n on topic Re: SQL Error

Hi Tuan

I was able to amend the issue by removing the record from the osmembership_subscribers table. I'll let you know if we ever receive the error again.

Thank you

Ciarán

Please Log in or Create an account to join the conversation.

Tuan Pham Ngoc
Offline
Administrator

More

11 years 4 months ago #34561 by Tuan Pham Ngoc

Replied by Tuan Pham Ngoc on topic Re: SQL Error

That's great. Thanks Ciarán for letting me know ! If you need more help, please don't hesitate to ask me for help !

Tuan

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

SQL Error

Support

Documentation

Information

Connect Us