blog documentation FAQ followers forum marketplace services youtube

solved Query Error: Table 'bluemrec_jam516.jr_jrlogwatch_rule' doesn't exist

The Jamroom Network » Forum » Installation and Configuration » Page » Query Error: Table 'bluemrec_jam516.jr_jrlogwatch_rule' doesn't exist
bmrecords
@bmrecords
9 years ago
14 posts
I am getting the following in the error log?
Query Error: Table 'bluemrec_jam516.jr_jrlogwatch_rule' doesn't exist
updated by @bmrecords: 04/30/16 01:56:22PM
paul
@paul
9 years ago
4,335 posts
Has the module just been installed? If so, try running the Integrity Check.


--
Paul Asher - JR Developer and System Import Specialist
bmrecords
@bmrecords
9 years ago
14 posts
I am now running integrity check, however it looks like the error has been happening since the update on December 13th, 2015. Now getting Error communicating with the server.
I will move the whole installation on to my new server. I have a backup prior to December 13th, 2015. I will see if this fixes the problem.
bmrecords
@bmrecords
9 years ago
14 posts
I can now confirm the error I was getting is now fixed. I have moved my installation to my new server, and ran integrity check which created the missing table.
I can only assume the previous problem was from an update (around Dec 13th, 2015) which had timed out on the old server and I was unable to run Integrity check as it kept timing out.
The new dedicated server I have designed from scratch, so goes to demonstrate the importance of running Jamroom on a dedicated system, where you can control resources, instead of shared hosting.
paul
@paul
9 years ago
4,335 posts
Glad you are sorted.

Quote: The new dedicated server I have designed from scratch, so goes to demonstrate the importance of running Jamroom on a dedicated system, where you can control resources, instead of shared hosting.
Jamroom is designed to, and does run on most servers and hosting plans. See the system requirements here - https://www.jamroom.net/the-jamroom-network/documentation/getting-started/774/requirements
However, there will always be hosts that have a setting on their servers that might create an issue for JR and often, when brought to their attention, they will correct it.

Alternatively, checkout Jamroom's own hosting plans. Our servers are specifically setup to run JR fast and error free - https://www.jamroom.net/hosting


--
Paul Asher - JR Developer and System Import Specialist
bmrecords
@bmrecords
9 years ago
14 posts
Thank you Paul, I have my own web hosting dedicated servers, and now run most of my Client's websites on these. However the previous installation of Jamroom was hosted on an old Reseller account (which was resource limited) instead of one of my dedicated servers.
Being the admin of my own servers allows me to allocate resources on a per Client/Website basis, therefore more control, and easier to troubleshoot and monitor.

Tags