paid subscriptions ACP error

[greigeh]

When i press 'view users' from a Paid Subscription in the ACP i get the following database error

Database error in vBulletin 3.8.8. Patch Level 1:

Invalid SQL:

		SELECT COUNT(*) AS users
		FROM live_subscriptionlog AS subscriptionlog
		LEFT JOIN live_user AS user USING (userid)
		WHERE 1=1 AND subscriptionid=85 AND status = 1
			AND user.userid = subscriptionlog.userid;

MySQL Error   : Column 'status' in where clause is ambiguous
Error Number  : 1052
Request Date  : Saturday, January 24th 2015 @ 12:08:15 AM
Error Date    : Saturday, January 24th 2015 @ 12:08:15 AM
Script        : http://----.com/acp/subscriptions.php?do=find&status=1&subscriptionid=85&s=
Referrer      : http://-------.com/acp/subscriptions.php?do=modify
IP Address    : -----
Username      : Greig
Classname     : vB_Database
MySQL Version : 5.5.40-cll

Any ideas on what is wrong? (removed some information as private)

Any help appreciated.

[kh99]

It looks to me like a mod has added a column to the user table called 'status', and that broke a query in subscriptions.php. Assuming that you don't want to remove that mod or that column from the user table, you could either figure out how to rename it, or else change acp/subscriptions.php to add the table name to that field so that it isn't ambiguous.

[greigeh]

Originally Posted by kh99

It looks to me like a mod has added a column to the user table called 'status', and that broke a query in subscriptions.php. Assuming that you don't want to remove that mod or that column from the user table, you could either figure out how to rename it, or else change acp/subscriptions.php to add the table name to that field so that it isn't ambiguous.

Hey, I renamed the column 'status' and it broke the Subscription Manager all together. I've tried disabling all mods etc but it doesn't seem to resolve anything

[Zachery]

Why did you rename a column? Rename it back.

[greigeh]

Originally Posted by Zachery

Why did you rename a column? Rename it back.

I have changed it back to 'status', I genuinely have no idea how to fix this ha but hey i'm trying.

[Lynne]

You renamed the column "status" in the user table, not the subscriptionlog table, right? Try disabling your modifications and then View Users and see if you still get the same database error. There is definitely not supposed to be a user.status field, so something added it and it is what is causing the problem.

[greigeh]

Originally Posted by Lynne

You renamed the column "status" in the user table, not the subscriptionlog table, right? Try disabling your modifications and then View Users and see if you still get the same database error. There is definitely not supposed to be a user.status field, so something added it and it is what is causing the problem.

How would I go about this first part? I've tried disabling everything and that seems to have failed so i'm a tiny bit baffled...

[ozzy47]

Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:

define('DISABLE_HOOKS', true); 


So it looks like this:

PHP Code:

<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 3.8.x

Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

If that fixes the issue enable plugins again by adding // before the line you added, then navigate to ACP --> Plugins & Products --> Manage Products and disable one mod at a time until you find the one causing the issue.

Once you find the culprit, post in that mods thread what the issue is, and maybe someone in that thread can help.

[greigeh]

Originally Posted by ozzy47

Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:

define('DISABLE_HOOKS', true); 


So it looks like this:

PHP Code:

<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 3.8.x

Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

If that fixes the issue enable plugins again by adding // before the line you added, then navigate to ACP --> Plugins & Products --> Manage Products and disable one mod at a time until you find the one causing the issue.

Once you find the culprit, post in that mods thread what the issue is, and maybe someone in that thread can help.

I done the whole 'define('DISABLE_HOOKS', true); ' but even disabling all mods/scripts/whatever seem to not cure the problem. :down:

[kh99]

Originally Posted by greigeh

I have changed it back to 'status', I genuinely have no idea how to fix this ha but hey i'm trying.

Yeah, sorry I wasn't clear enough. While one option for fixing the issue would be to figure out how to rename the added column so that it doesn't conflict, that would involve understanding why it was added and making corresponding changes to the code that uses it. I probably shouldn't have mentioned it, but instead just told you to figure out which mod it is and either disable it or ask the developer for help.