Support community for TTG plugins and products.
NOTICE
The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.
This forum is now closed, and exists here as a read-only archive.
You are not logged in.
I'm afraid I may have broken my search function and possibly my ttg-be database. I have a rather large site and am slowly converting from CE3 to CE4. I now have approximately 100 galleries who use Pages and AI along with Gallery and Stage converted to CE4. There are a number of CE3 AI and Gallery sub directories but I don't think they are indexed for search and for the moment not relevant.
I tried a search on the site by typing in "Ephesus" which should have yielded at least one gallery and around a 100 images. The search took several minutes to run and the result was a blank page (as in white, empty, etc.). Search seemed to work OK several weeks ago when I had only converted 1-2 galleries.
Here is the problem, Now I get a DB error with any attempt to use Publisher within LR. Doesn't matter if I try to make a new gallery or if I attempt to add images to an existing gallery.
For a new gallery:
-I looked in my Blue-host directories and the new sub-directory fails to create.
-I tried deleting the gallery in LR and starting over - same problem
-Checked for illegal characters, none found; indeed I cut-pasted from the previously working CE3 gallery.
- have a screen capture of the LR error, unfortunately it won't allow a copy paste to include here, I do have a .jpg if needed.
For update to an existing gallery
-File structure appears correct on Blue-host and the page seems to run OK
-Different ttg-be DB error and new images do not upload.
-I also have a screen capture .jpg for this error
Both errors have the same first 2 lines, and I have tried to hand type them:
"An internal error has occurred: JSON.lua:458: JSON.lua:197: can't parse JSON at char 1 of: SQLSTATE[HY0000}: General error: 5 database is locked........"
-Tried to wait for a time-out reset, not successful.
-Tried to repeat a different search using a term with an expected empty result and one with an expected less than 20 elements result. Both take several minutes to run and produce an empty/blank page result.
-Tried using search from a Pages generated page, a Gallery page and an AI page - all with same result.
I' afraid I am now at a loss as how to proceed. I suspect that Search doesn't work well with very large sites and I can turn off until some future update but for the moment I need to fix my DB.
Jim.
Last edited by jherman (2014-12-22 01:32:41)
User with too little time but coding is therapeutic.
Offline
Hi James, you are right about search. Unfortunately an optimisation to make caption searches efficient has had the complete opposite affect. I have removed the 'optimisation' in my working code. I'll look further into this at the end of the day Melbourne time. In the mean time, can you also email me the file ttg-be/data/publisher/master.sq3?
Offline
Sent file to Ben off-line and his response, " One strategy worth trying would be to copy the database in the same location, then rename the old database and rename the new copy to 'master.sq3'. Can you give that a try?"
Worked. I think I ran into the problem while updating a large Publisher gallery and made the mistake of simultaneously running a search which would produce a large number of results on my site with over a hundred galleries. Oops.
He also indicated he is fixing some issues with the search function due out in a few weeks. He also tweaked my DB and search no longer hangs.
Great work guys.
Jim
User with too little time but coding is therapeutic.
Offline