MarioKnight

@asyag While this would be a band-aid at best, setting this to a varchar(250) still yields the same row size too large error.

Hello @asyag ,

I host the site for @djranmas , and when I run the query, I get the following error:

#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

After some digging, it turns out that adding this is failing because doing so would exceed the maximum row size of 65,535 bytes. This table already has another bigint(20) along with a handful of varchar(250)’s. I’m seeing that this is a hard data limit for MySQL, despite the storage engine in place. I’m not sure what to suggest, as I do see you have an author bigint(20) field in another table and of course that should match others, but doing so on this table at this point is a technical restraint. Please look into and advise.

While trying to further troubleshoot and gather more information, somehow everything is now working as intended. I’m not sure what happened to kick things back off sadly, but I will close this as it is resolved and will update here if I figure out what happened.

Hello,

With the 3.5.3 update this issue still persists. It is actually worse than I had realized, as when adding more items to the store, they do not appear in the listings both in the dashboard and the front-end store. The counts in both front and back ends are adjusted properly, however the items do not show. Like the order mentioned above, I can see them when I go to their URLs directly, but that doesn’t help with customers finding them for making sales. Please advise.

Hello,

Thank you for that quick turnaround. I’ve tested this on my dev instance, and it works with no issues I can see. I’ll still need to decide if I want to do this sort of switch or not given the scale and future dev work mentioned above, but at least this new system to your plugin works and is an option now, so I’ll mark this as resolved. Thank you!

I am using Lite currently, am definitely considering getting a license in the future pending potential expansions.

Thank you for that information and plugin recommendation, while I’m still curious as to where that data resides, I redid my site creation process from the start, used the plugin instead of raw find-replaces, and now the galleries are working fully as intended. Since this worked so well in dev, I’m confident that there will be no issues when I perform everything on the live site. Thank you very much for your help and quick response!

To add, the default HTML minification also changes all links to outbound pages. When linking to other sites either as references or places that visitors might also like to check out, these are altered to use //. This effectively breaks outbound links whose sites are not using https. I’ve had to disable the new HTML minification for now, as the URL options do not currently have a option to not force any changes (as of this typing, they are force all http, force all https, force //).

That did the trick, thank you! =D

Thanks for the quick response! =) (I apparently missed seeing it right away, sorry about that ^^; ) While I’m still waiting to gather all the photos of the event before making the galleries public, I put one of them online at https://sailormoonevents.org/envira-gallery-test/ for you to look at. Any advice would be greatly appreciated as I really don’t want to edit titles of 100s of photos if I can help it. x_x Thank you!

This is an oddity for me as well, since it came to me as something I’ve never used and was given little details. The colleague who reported believed it to be caused by BPS since supposedly it had started after the switch-over, and I was hoping I would be lucky in you having any idea of what was being said. Thank you for the additional troubleshooting information, I can happily say BPS was not affecting this now. Sorry for the trouble, and thanks again for the troubleshooting info!

I’m sorry, I mistyped post as port somehow. Unfortunately I’m not seeing a log entry for whatever is being blocked or denied so right now I’m at a bit of a loss.

That worked perfectly. Thank you for the quick response!

Hello,

I’m sorry for the delay. I was just able to try this on one of our sites and it looks like it is working as intended now. Thank you for the response, I will go ahead and mark this as resolved.

It looks like I can manually put these rules above the BPS block via the htaccess editor within the plugin as well. However if anything is changed (activating RBM for example), these additions are removed, even if they were made in the secure.htaccess which seemed to be a template. How can I make manual changes and not have to worry about losing them later on?

It looks like the rule I had was limited to the base options. While I am curious as to why this worked before when it shouldn’t have, but right now I’m just happy that we’re back up and running. I will close this.