Forum Activity for @brian

brian
@brian
22 Sep 2017 08:10:24AM
9,123 posts

profile domains since core update


Installation and Configuration

SNI is not something you enable. If you're seeing the wrong site returned on port 80 (non-SSL), then something is wrong with you web server, or it is not configured correctly.
brian
@brian
22 Sep 2017 07:56:09AM
9,123 posts

Products beta


Using Jamroom

blindmime:
I see. I hadn’t thought of that. Do you have plans to do the template work as part of the default module item list and details? Maybe an extra Bundles-type module would work, but instead of a package of products it’s a selection of products within a collected bundle.

Yes - we'll be expanding this module. Right now this first beta is just to get it out there. I won't have time to work on it for a few more weeks, but didn't want to sit on it - better to get it out and get feedback.

Quote:
Have there been any thoughts about hooking into a shipping API in the cart?

Yes - but it would be integration with a 3rd party service that would do this - we are not going to develop our own shipping API for the module. Entire companies are built around this ONE feature, so to expect us to do it all as part of this module isn't realistic. Instead, we've developed some hooks in the cart that would allow us to integrate 3rd party shipping functionality. If you have any 3rd party shipping providers you think would be a good fit, let us know.

Thanks!
brian
@brian
22 Sep 2017 07:52:46AM
9,123 posts

profile domains since core update


Installation and Configuration

If you are using Profile Domains, the browser must support "SNI":

https://en.wikipedia.org/wiki/Server_Name_Indication

If you have multiple sites on your server using SSL, then to be backwards compatible each SSL site should be on its own IP address. Older browsers and ANY browser on Windows XP do not support SNI. So it could be the remote speed test site is using a browser to "run" your site that does not support SNI.
brian
@brian
22 Sep 2017 07:50:08AM
9,123 posts

Any examples of adding an item to pending?


Jamroom Developers

This would need something custom to basically flip the "profile_active" key on the profile data from "0" (inactive) to "1" (active). The pending system does not work with profiles.

Let me know if that helps.
brian
@brian
22 Sep 2017 07:48:59AM
9,123 posts

jrCloudS3 error on Jamroom-6.1.1 update


Jamroom Cloud

It looks like this is an error when trying to talk to S3 - is this happening on every file transfer? If so, double check that nothig has changed on S3's end or with your credentials.
brian
@brian
22 Sep 2017 07:48:00AM
9,123 posts

How to restore a JR site with the Database backup file only?


Installation and Configuration

pch:
Fatal error: Call to undefined function iconv() in /home/xxxxxxx/public_html/subfolder/modules/jrCore/lib/util.php on line 2598

Your PHP install is missing the iconv functions - these are needed by Jamroom. iconv functions are enabled by default, so they have been purposefully disabled on your server.

Make sure you are running at LEAST PHP 5.3 (PHP 7+ recommended).
brian
@brian
20 Sep 2017 12:45:35PM
9,123 posts

Sitewide Calendar and Events


Design and Skin Customization

Just don't include a profile_id value - i.e.

{jrEvent_calendar}

Let me know if that helps.
brian
@brian
20 Sep 2017 12:42:36PM
9,123 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
20 Sep 2017 07:48:42AM
9,123 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
19 Sep 2017 09:40:36AM
9,123 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.
1