Search results could not be loaded at the moment. Retry

[kanense]

Hi all,

I have the follow errors at (one) of my plesk panel:

at Applications:

Search results could not be loaded at the moment. Retry

I have follow this article for try fix - http://kb.odin.com/en/121173

When I run the command:

select count(*) from psa.smb_apspackages where registryUid not in (select uid from apsc.aps_registry_object);

Get:

ERROR 1146 (42S02): Table 'psa.smb_apspackages' doesn't exist

How do can I fix?

Thank you

Solved, please check: http://talk.plesk.com/threads/searc...oaded-at-the-moment-retry.324794/#post-763196

 

[UFHH01]

Is this a fresh installation?

What are the log entries in "%plesk_dir%/admin/logs/php_error.log" after you tried to view the application list? ( "%plesk_dir%" could be either "/usr/local/psa" or as well "/opt/psa" )

 

[kanense]

Hi,

No is not a fresh installation.
And I'am not find "php_error.log"
my directory as:

/usr/local/psa/admin/logs

Thank you

 

[IgorG]

Try to fix it with bootstrapper repair procedure.

 

[kanense]

Try to fix it with bootstrapper repair procedure.

Hi IgorG,

How to can I to that?
the command as:

/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair

Thank you

Update: I have run the above command the problem persist.

 

[IgorG]

Well. There is smb_apsPackages table instead of smb_apspackages. Looks like there is typo in article.

 

[kanense]

Well. There is smb_apsPackages table instead of smb_apspackages. Looks like there is typo in article.

Sorry I not understand. What do you mean?

Thanks

 

[IgorG]

You should use following SQL query instead of mentioned above:

select count(*) from psa.smb_apsPackages where registryUid not in (select uid from apsc.aps_registry_object);

 

[kanense]

Thank you, worked,
Please update KB Article.
from

select count(*) from psa.smb_apspackages where registryUid not in (select uid from apsc.aps_registry_object);

to

select count(*) from psa.smb_apsPackages where registryUid not in (select uid from apsc.aps_registry_object);

And how to make the backup ??:

"%plesk_bin%\MySQL\bin\mysqldump.exe" -uadmin -P8306 -p****** psa > psa_dump.sql

and the delete records from:

delete from psa.smb_apspackages where registryUid not in (select uid from apsc.aps_registry_object);

to

delete from psa.smb_apsPackages where registryUid not in (select uid from apsc.aps_registry_object);

Solved

Thank you