solved Sql error whilst performing integrity check

Upgraded to 5.3 and updated all the modules so started the integrity check and this appeared in the log files :-

Array
(
[error] => Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[_post] => Array
(
[_uri] => /core/integrity_check_save/__ajax=1
[jr_html_form_token] => bf585d54fdc45f892749c1be19cd7958
[jr_html_form_profile_id] => 1
[jr_html_modal_token] => 24d2a456d6f37536e8cf197e7c13d037
[validate_modules] => on
[validate_skins] => on
[repair_modules] => on
[repair_tables] => off
[optimize_tables] => off
[module_url] => core
[module] => jrCore
[option] => integrity_check_save
[__ajax] => 1
)

[query] => UPDATE jr_jrgroup_member SET member_active = '0' WHERE `member_user_id` =
)

Check has been stuck on the users module for over an hour now (16,000 users).

MySql version is 5.6.28-76.1

Cheers


updated by @white-agency: 05/27/16 09:28:00PM

All the ajax responses have the following :- [{"t":"empty","m":"no results found for key"}]

Don't know if thats good or bad !!

This bit of code would fail:

It equates to the sentence "update the group member who's member ID is .......".

Yeah that would throw me for an error too, its annoying when people don't finish their sentences so its coherent.

Seams like something group related is trying to be actioned on a member but the members ID is not provided.

Got steps how to replicate it?

Generated this when I ran the integrity check ( Repair Modules )

Replicated this on our test system.

without more to go on it's hard to offer any options.

Check error logs, check activity logs, check server logs.

Integrity check working fine here.

Checked all the logs I can find.

Same error is in the activity and debug logs but nothing in the error log.

Had a look at the apache, php and mysql logs on the server and can't find anything in there

Managed to work my way round this.

I ran the integrity check in the following order :-

1: Repair Tables
2: Optimize Tables
3: Repair Modules

This time no errors when the Repair Modules ran.
Same result on the test and live servers.