Forum Activity for @brian

brian
@brian
09/20/17 12:42:36PM
10,162 posts

questions about new beta ecommerrce
Installation and Configuration

soaringeagle:and are more shipping options available/ like zone options flat rate options anything like that.

No - not this time in the module. It IS something we've planned for though - there are specific hooks into the cart to allow for shipping based on the buyers location, but for now it is still just a single shipping and handling value. Note that we do not have any plans to build that type of functionality ourselves - any variable shipping options would be integrated using a 3rd party API, as there are entire companies that have built around this single feature.
brian
@brian
09/20/17 07:48:42AM
10,162 posts

Error: Query Error: The table 'jr_jrcore_cache' is full
Installation and Configuration

I'm not really seeing anything in your my.cnf that would account for bad performance. Here's the relevant parts from the my.cnf file for our servers with 24 gigs RAM:

#
# * Fine Tuning - 24 GIG RAM
#
key_buffer              = 1024M
max_allowed_packet      = 64M
table_open_cache        = 1536
table_definition_cache  = 1536
open_files_limit        = 10240
tmp_table_size          = 512M
max_heap_table_size     = 256M
sort_buffer_size        = 4M
read_buffer_size        = 4M
read_rnd_buffer_size    = 768K
max_connections         = 200
innodb_buffer_pool_size = 8G
innodb_flush_method     = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len         = 3
ft_stopword_file        = ""

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP
#
# * Query Cache Configuration
#
query_cache_limit	    = 1M
query_cache_size        = 512M

I do see that you're using dashes instead of underscores in a lot of your settings - not sure if that is supported, so you may want to update those.

It's important as well to make a BACKUP of your mysql data (mysqldump) - you can easily mess up your data by changing some of the innodb settings without knowing what you are changing.
brian
@brian
09/19/17 09:40:36AM
10,162 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction
Installation and Configuration

I logged in a while back on your server, but to be 100% honest you just have too much going on - lots of sites, lots of custom setups, lots of places where things can just not work right. You also were using a control panel at the time, which adds a second layer of possible issues.

If you get around to deciding you want a stable place to host your Jamroom, let us know - we have some extra flexibility now for custom servers we did not used to have if you're interested.
brian
@brian
09/19/17 09:38:38AM
10,162 posts

Use of display:table vs. display:block for Editor
Jamroom Developers

There are no plans for any toolbars - to be honest anything outside a textarea is going to be an issue for some users on mobile devices. On many older iphone/android devices the buttons are just way too small to be effective.
brian
@brian
09/19/17 09:37:26AM
10,162 posts

Error: Query Error: The table 'jr_jrcore_cache' is full
Installation and Configuration

Yes:

- install Redis
- configure the /etc/redis/redis.conf file and set the "maxmemory" setting to something like 1G
- restart Redis
- create a new "server" in the Jamroom Redis module with server as 127.0.0.1
- go into the ACP -> System Core -> Global Config and set the "Active Cache System" to Redis

Note that we can't be the sysadmin support for you here in the forum - if you have any issues with installing or setting up your server you want to contact your hosting provider.
brian
@brian
09/19/17 09:09:45AM
10,162 posts

Jamroom 6.1 has been released!
Announcements

Glad you got everything working - thanks!
brian
@brian
09/19/17 09:08:18AM
10,162 posts

Error: Query Error: The table 'jr_jrcore_cache' is full
Installation and Configuration

https://redis.io/

You can install it from your distro's package manager as well.
updated by @brian: 09/19/17 09:09:14AM
brian
@brian
09/19/17 09:04:06AM
10,162 posts

Use of display:table vs. display:block for Editor
Jamroom Developers

TiG:I am reading that we should not allow our users to use tinymce under any conditions (all devices) because it allows them to stylize their comments with HTML and CSS. Am I misinterpreting?

No - that is correct. The problem with embedding CSS is that you just can't style it. So let's say down the road you want to change the font face used on the site - with embedded CSS you can't change it - you're stuck with whatever the user has selected.

If it is a function of the site and is needed, then of course use it - that's why it is there, so it's 100% up to you.
brian
@brian
09/19/17 08:31:38AM
10,162 posts

Error: Query Error: Lock wait timeout exceeded; try restarting transaction
Installation and Configuration

I have just tested with an MKV file and see no issues. I downloaded one from here for testing:

http://jell.yfish.us/

I apologize, as I know this is not helpful, but you have pretty much had constant issues on your server going on years now. Always some issue with videos not converting, etc. Unfortunately I have no feedback other than "it works here for me", and for our Jamroom hosted users it is working, so something is setup wrong or incorrect on your server.
  104