Forum Activity for @brian

brian
@brian
11/16/15 04:37:29PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

I should add as well - both of those queries are in the "sorting results" stage - that means they are using a temp table - make sure you have enough temp space on your server - if you run out of temp space then those queries will just hang.

Note that there have been no changes in that function for quite some time - it's the same in JR 5.2.4x and earlier.
brian
@brian
11/16/15 04:33:22PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

soaringeagle:yup trying to access the shop again
| 10771 | greentec_jam | localhost | greentec_jam | Query | 36 | Sorting result | SELECT `_item_id` AS i,`key` AS k,`index` AS x,`value` AS v FROM jr_jrgallery_item_key WHERE `_item_ | 0.000 |
| 10854 | greentec_jam | localhost | greentec_jam | Query | 10 | Sorting result | SELECT `_item_id` AS i,`key` AS k,`index` AS x,`value` AS v FROM jr_jrgallery_item_key WHERE `_item_ | 0.000 |
+-------+-----

These are from the jrCore_db_get_multiple_items() function (called at the end of jrCore_db_search_items()) - these should NEVER take this long to run - something is messed up here if you're seeing these queries taking 36 seconds. These are "straight up" queries - no joins and WHERE condition only uses primary key. Even on a large datastore (20+ million items) these queries will take less than 100 milliseconds to run.
brian
@brian
11/16/15 04:31:21PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

soaringeagle:| 10209 | greentec_jam | localhost | greentec_jam | Query | 1 | statistics | SELECT `_item_id` AS i,`key` AS k,`index` AS x,`value` AS v FROM jr_jrgallery_item_key WHERE `_item_ | 0.000 |

this seems to be whats holding it up still investigating

That's only been running for 1 second - that should not be the issue. I'm surprised it is taking a second though. Note that we don't develop on MariaDB - just an FYI as there certainly could be cases where JR performs much worse on MariaDB than MySQL, and vice versa.
brian
@brian
11/16/15 04:25:32PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

soaringeagle:just a hunch but could it be this
- New: "slow_query_time" parameter for jrCore_list to log slow queries for individual lists

No - that's not going to do anything unless you specifically add "slow_query_time" as a parameter to a jrCore_db_search function call, which NO ONE is doing yet.
brian
@brian
11/16/15 04:20:19PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

If it was working with 5.3.0b3, I can't think of anything in b4 that should break it - it's almost all just bug fixes (I created almost 60 new unit tests just for the datastore functions, for example)
brian
@brian
11/16/15 04:14:35PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

soaringeagle:what would cause the entie front page to be lost
how many dev sites use the older sitebuilder

None of my dev sites use the older sitebuilder - I have NO IDEA if core 5.3.0 will work at all with the old site builder. It's no longer even in our repo.

If you are seeing errors you need to look in your web server error log - try restarting your web server as well so any PHP caches are reset.
brian
@brian
11/16/15 04:04:14PM
10,167 posts

Core update 500 error
Installation and Configuration

sbhadauria:Finally, I resolved my issue.

I am getting issue because of jrGeo module. I am including jrGeo module manually in my code, that is fine with old core updates. But in new updates jrGeo module is already including by jrCore. So jrGeo module including twice that's why error occurred.

Glad to hear you got it working. Thanks!
brian
@brian
11/16/15 04:03:11PM
10,167 posts

Jamroom 5.3 Beta Kickoff
Announcements

I've been updating all my sites to 5.3.0b4 after the release (I have 15 dev domains on my JR Hosting server, plus my large Genosis site) - I've not seen a single issue. So I'm not sure what to say, but you always seem to have some type of server issue any time you do anything on your site. It's hard for me to know what is JR and what is your server when it comes to the issues you see.
brian
@brian
11/16/15 03:33:04PM
10,167 posts

Corrupted update file recieved
Installation and Configuration

kccomedy:Was still not able to update today. So I figured I had nothing to lose so I started clicking things to see what it would do.

I fixed it by going into Developer Tools and Clicking The "Rebase Modules" button.

I was then able to Update. Now it is all up to date and working fine.

Not sure why this fixed it, but it did.

I'm guessing the directories or symlinks were permissioned incorrectly - rebasing deletes and changes things back to like they are during a "fresh" install. If you find you need to do this regularly it means your web server "user" is not able to permissions files, links or directories.
brian
@brian
11/16/15 03:31:37PM
10,167 posts

Still Unable to upgrade
Using Jamroom

Strumelia:I see a second domain on my server as well (aside from my fotmd.com), called "strumelia-861275.jamroomhosting.com"
I'ts got the Elastic skin on it, but I've never done anything with it. Like Ken, should I just delete that? (I mean, if I wanted to have another domain on my server, it wouldn't have a name like that.) Should I delete strumelia-861275.jamroomhosting.com domain from my server?

Yeah - I'd delete it if you're not using it.
  297