solved Query Error: Table 'xxx.jr_jrsearch_fulltext_jrgallery' doesn't exist

kaminoey
@kaminoey
6 years ago
38 posts
Menu : CREATE GALLERY, Previously used as usual.
Query Error: Table 'oohmusic_nuipanna.jr_jrsearch_fulltext_jrgallery' doesn't exist
11-5-2561 15-25-49.jpg


updated by @kaminoey: 04/12/19 05:14:41PM
paul
@paul
6 years ago
4,331 posts
Have you recently added the 'Image Galleries' option to the Search module 'Index Options'?
I'd suggest running an Integrity Check with the Repair Tables selected, then run the Search module's Rebuild Indexes tool.
Hope that helps


--
Paul Asher - JR Developer and System Import Specialist
michael
@michael
6 years ago
7,746 posts
I cant read the script, but if that is your login panel and you cant get into the ACP to run the integrity check, you can run it via this method without logging in:
https://www.jamroom.net/the-jamroom-network/documentation/troubleshooting/114/somethings-wrong-what-do-i-do#if-you-cannot-get-in-to-the-acp
kaminoey
@kaminoey
6 years ago
38 posts
Thank you.
I solved the problem with menu search "index options", unselect Image Galleries and Photo Albums.
I try ACP to run the integrity check, it unsuccessful.
douglas
@douglas
6 years ago
2,793 posts
You can check the error logs to see why the integrity check didn't work.

System Tools > Acitivity Logs > Debug Log
/core/debug_log

And

System Tools > Activity Logs > Error Log
/core/php_error_log

You might also check your "System Check" to make sure everything is setup correctly,

System Tools > System Check
/core/system_check

Hope this helps!


--

Douglas Hackney
Jamroom Team - Designer/Developer/Support
FAQ-Docs-Help Videos

Tags