Edit reseller: Error 400 Bad Request

Piradoxlanieve · Jun 13th 2015

debian 8 and imscp 1.2.4

I'm trying to edit a reseller , but I get the Error 400,I have activated the debug mode, but can not remember where to look debug log , I see the database there id reseller is correct.
with another reseller I do not have that problem.

**Nuxwin** · Jun 13th 2015

@Piradoxlanieve

You're not the first one which encount that problem. @sfsolutions asked me about the same problem on IRC yesterday but I've not any new... Well, I must investigate. It could be great if you can give me an access to your panel and the imscp database.

Thanks

Piradoxlanieve · Jun 13th 2015

I try perl imscp-autoinstall -r but problem not solved haha

send mp now with keys wait a minute.

**Nuxwin** · Jun 13th 2015

@Piradoxlanieve

Waiting This is an important bug so I've interest here

Piradoxlanieve · Jun 13th 2015

hope I did not duplicate the problem in the forum, I look but not see this ruling,
thanks for your patience and understand my bad English

**Nuxwin** · Jun 13th 2015

Re;

Bug found. I've found an orphaned user entry in the admin table of the i-MSCP database:

admin_id: 19
admin_name: godelta.com

with status set to todelete...

I've deleted it and all is ok now but this is due to a bug.

After investigations, it's appear that the query which is reponsible to process user deletions is wrong in the request manager (/var/www/imscp/engine/imscp-rqst-mngr

Perl

$rs ||= _process( 'User', " SELECT admin_id AS id, admin_name AS name, admin_status AS status FROM admin LEFT JOIN domain ON(domain_id = admin_id) WHERE admin_type = 'user' AND admin_status = 'todelete' AND domain_id IS NULL ORDER BY admin_id ASC ");

while it should be

Perl

$rs ||= _process(
'User',
"
SELECT
admin_id AS id, admin_name AS name, admin_status AS status
FROM
admin
LEFT JOIN
domain ON(domain_admin_id = admin_id)
WHERE
admin_type = 'user'
AND
admin_status = 'todelete'
AND
domain_id IS NULL
ORDER BY
admin_id ASC
"
);

Display More

THIS IS A BIG BUG WHICH CAN BE THE CAUSE OF MANY ORPHANED USERS...

Will be fixed soon and a new version will be released today.

Thank you for your report.

@Cool your problem is due to the same thing.

How to fix: Either by patching your /var/www/imscp/engine/imscp-rqst-mngr file as shown above and by executing perl /var/www/imscp/engine/imscp-rqst-mngr -v manually, either by waiting for the coming fast-bugfix release.

Piradoxlanieve · Jun 13th 2015

I can disable the maintenance mode? you are a genius, I wish I could help fix errors, but I do not know haha,
if you need more tests, has my keys, you can use my server when you need it
@Nuxwin

**Nuxwin** · Jun 13th 2015

Re ;

Sure, you can disable maintenance mode

**Nuxwin** · Jun 14th 2015

Solved in version 1.2.5

Piradoxlanieve · Jun 14th 2015

does not rest on Sundays Thanks @Nuxwin I try update now

Edit reseller: Error 400 Bad Request

Share

Similar Threads

i-MSCP 1.5.3 RELEASED

Daily visitors