Sql error whilst performing integrity check
Using Jamroom
All the ajax responses have the following :- [{"t":"empty","m":"no results found for key"}]
Don't know if thats good or bad !!
Forum Activity for @white-agency
Using Jamroom
All the ajax responses have the following :- [{"t":"empty","m":"no results found for key"}]
Don't know if thats good or bad !!
Sql error whilst performing integrity check
Using Jamroom
Upgraded to 5.3 and updated all the modules so started the integrity check and this appeared in the log files :-
Array
(
[error] => Query Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[_post] => Array
(
[_uri] => /core/integrity_check_save/__ajax=1
[jr_html_form_token] => bf585d54fdc45f892749c1be19cd7958
[jr_html_form_profile_id] => 1
[jr_html_modal_token] => 24d2a456d6f37536e8cf197e7c13d037
[validate_modules] => on
[validate_skins] => on
[repair_modules] => on
[repair_tables] => off
[optimize_tables] => off
[module_url] => core
[module] => jrCore
[option] => integrity_check_save
[__ajax] => 1
)
[query] => UPDATE jr_jrgroup_member SET member_active = '0' WHERE `member_user_id` =
)
Check has been stuck on the users module for over an hour now (16,000 users).
MySql version is 5.6.28-76.1
Cheers
updated by @white-agency: 05/27/16 09:28:00PM
MySQL performance
Installation and Configuration
Don't know about the sql server being on the same switch but it's in the same data centre ! All our other sites across the other servers are running fast; a couple of these servers are in a different data centre to the sql server and we have no latency issues with them.
We run a separate sql server for security and maintenance reasons. Easier to look after 1 rather than 5! It's specifically built as an SQL server by the hosting company ( and looked after by them ) who have a lot more experience than we do !
I've shown the site to other developers who are not familiar with it and they can't see a problem with the speed. I think because of the low score from the performance check it just got me wondering if there was a problem when in fact there isn't.
Cheers
Dave
MySQL performance
Installation and Configuration
Our server setup is more than likely slightly different to most JamRoom setups in that we run a dedicated remote MySQL server (2GB RAM & SSD). This serves all our sites (20+) across 5 webservers.
The JamRoom site is on it's own dedicated server as it is the only php site we run (the rest are Ruby on Rails).
When we run the performance check we get quite a bad SQL score in the mid 44's, which gives us an overall score of 190ish (Quite bad).
On our test server which has it's own installation of MySQL, I followed the details on here https://www.jamroom.net/brian/documentation/guides/1265/optional-mysql-optimizations-for-larger-servers and immediately got a performance boost.
These same changes have been applied to the live server but have no effect because of the remote MySQL server.
I don't think the site is slow and we've had no complaints.
Just wondering if anyone else has any experience of a JamRoom setup with a remote MySQL server?
Cheers
Dave
updated by @white-agency: 02/24/16 08:40:36PM
Group Member count incorrect
Using Jamroom
Unfortunately we only hold 7 days worth of database backups and the problem occurred before then!
I have a three month old database the test site runs on which looks OK though, so we could always go back to that for the members if we had to.
I initially thought the problem could be with a module update but I apply the updates to the test site first and thats OK.
Approving New members process
Suggestions
We use the email approval process on our system but the admins who handle the approving would like to smooth the process out.
Whenever we have pending users, the admins will always use the 'Modify' button to check the details they have submitted.
At this point the admins would like 'approve' and 'decline' buttons adding to this page to save them then having to go back to the dashboard to do the 'approve' and 'decline' actions.
Cheers
Dave
updated by @white-agency: 02/02/16 09:33:40AM
Group Member count incorrect
Using Jamroom
We've just noticed the member count for groups are incorrect. For example, one group is showing 2 members (which doesn't include the owner of the group), when it actually has over 40.
Have tried doing an integrity check with no effect and also checked using a raw ningJa skin to make sure it wasn't a template problem.
Have no idea when this started happening. It was a member who brought it to our attention.
Cheers
Dave
updated by @white-agency: 02/03/16 06:28:27AM
Multiple file attachment upload in Forums
Using Jamroom
When editing or adding to a topic you can upload multiple files but when creating a new topic you are restricted to one file.
Am I missing a setting somewhere or is this be design ?
Cheers
Dave
updated by @white-agency: 02/08/16 11:35:40PM
Remember me cookie problems
Using Jamroom
Not running https at the moment so not that but may be doing that in the future when https://letsencrypt.org/ goes live and we can get the cert for free! I'd then force http to redirect to https
As far as I'm concerned the problem is on client side but the client just keeps blaming us !
