blog documentation FAQ followers forum marketplace services youtube

solved Search Error

The Jamroom Network » Forum » Using Jamroom » Page » Search Error
Ken Rich
Ken Rich
@ken-rich
11 years ago
926 posts
RI: Query Error: Table 'indiegos_jr5.jr_jrningpage_item_key' doesn't exist
===============================================================================

I am seeing this error on a "blank" page when I search certain things. For instance, if I search for pra I will get the error, if I search for pray I won't.


--

Ken Rich
indiegospel.net
updated by @ken-rich: 01/06/15 03:11:56AM
SteveX
SteveX
@ultrajam
11 years ago
2,584 posts
The power of prayer might not be all it's cracked up to be? No offence intended.


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
Ken Rich
Ken Rich
@ken-rich
11 years ago
926 posts
That's funny especially since I wrote an article on that very topic lol

http://indiegospel.net/indiegospel/forum/christian-teachings/11/the-power-of-prayer

Seriously though, I've seen it come up on at least one other thing and an integrity check doesn't fix it...


--

Ken Rich
indiegospel.net
SteveX
SteveX
@ultrajam
11 years ago
2,584 posts
Agreed, an integrity check can't fix everything, but is generally worth the effort at least once a day.

Thanks for sharing your article Ken, glad you are making progress with that. Formulation of a search term is similar. I am definitely one to mix metaphors, so probably best to leave it at that.


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
Ken Rich
Ken Rich
@ken-rich
11 years ago
926 posts
I'm wondering about jrningpage in the error because Paul was experimenting with something called Npages on my site, and then they were transferred to Pages when the Ning modules were finalized.

So for a while, I had two set's of pages, and two page creation modules. Hmmmmm....


--

Ken Rich
indiegospel.net
paul
@paul
11 years ago
4,335 posts
Sorry - I should have posted here last night (but you were in good company with Steve ;-) )
I did have a look around your site last night and ran the IC, cleared caches etc. The jrNingPage module is long gone from your site so am a bit puzzled as to why this is happening.
I'll have another dig around this morning.


--
Paul Asher - JR Developer and System Import Specialist
brian
@brian
11 years ago
10,148 posts
Make sure you've not added a custom search field for that module in the ACP -> Listing -> Search -> Global Config -> Additional Search Fields - I have a feeling you defined a search field for that module in there.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
updated by @brian: 12/04/14 06:11:43AM
paul
@paul
11 years ago
4,335 posts
No - Nothing there.


--
Paul Asher - JR Developer and System Import Specialist
brian
@brian
11 years ago
10,148 posts
paul:
No - Nothing there.

Then jrNingPage must still be installed in some way. I don't see any other locations that the module is pulled in at.

If you update to the latest Search the module is checked for being active now - so that should fix this, although I'd like to get to the bottom of why it is happening.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
paul
@paul
11 years ago
4,335 posts
Quote: If you update to the latest Search the module is checked for being active now - so that should fix this, although I'd like to get to the bottom of why it is happening.
Not had a chance yet today, but will soon.


--
Paul Asher - JR Developer and System Import Specialist
paul
@paul
11 years ago
4,335 posts
Found it - There was a jrNingPage item in the jrTags DS with the text 'praise radio schedule' so the 'pra' bit was being found there, and the error was from it trying to get more info on the now non-existent NingPage item.
Have cleaned it up.


--
Paul Asher - JR Developer and System Import Specialist
SteveX
SteveX
@ultrajam
11 years ago
2,584 posts
The efficacy of Paul! ;)


--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
brian
@brian
11 years ago
10,148 posts
paul:
Found it - There was a jrNingPage item in the jrTags DS with the text 'praise radio schedule' so the 'pra' bit was being found there, and the error was from it trying to get more info on the now non-existent NingPage item.
Have cleaned it up.

Was it the tags module or the search module that was trying to load the jrNingPage DS? We need to get a jrCore_module_is_active() check around that.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net