facter

Does anyone else have any idea if there are any plugin that do this? I’m still looking for in, I’d have tight such a common feature these days in the Web thst there would be a wp plugin for it!

Yes, I know about theae functions but this is not what I mean.

It is similar yeh, bur the “read full article” is different. It only shows on mobile, and it is an actual kind of interstitial over the post. The shortcodes are very basic and clunky and not at all like what is seen on most sites.

Take a look at Techcrunch.com on mobile and you’ll see what I mean.

Same problem here.

Hey Toto, again, thankyou very much for this help mate, it is really appreciated.

Okay, so, that is pretty much exactly what I have been doing – nothing more complicated than that. I also tried to go into the table, select all rows and run the query that way.

Here are some images from the db

I checked for any extra spaces or lines at the end, I also put it into notepad to get rid of any potential formatting there might have been also ..

I seriously think theres something wrong with phpmyadmin here … going to trey and contact bluehost again and ask about it.

Hey mate.

No matter what I’m trying it isn’t working… Ig you look eight posts back, you’ll see the exact queries I’ve been using in the code block (5 days ago)

Can you see anything at all in those four lines that may be askew? Those four are directly out if the excel file (which were really placated to 300 records using the concatenate excel code) and I’m cutting and pasting those into the Sql query box on phpmyadmin.

And again, thankyou so much for your help, it really is driving me crazy.

@cais just saying… All this really is a lot of trouble for something that you should really just be able to set as an basic option to have a default gallery style ??

Hmm, okay, the search worked. I hadnt correctly selected the tables. My bad. Okay so the SQL search works fine then. It finds these records just fine now that I actually properly selected the tables.

This still doesnt help me though, as running the SQL query still doesnt work – I only have the one database that I am in, and its definitely the right one as I am able to go into posts and check them.

Could there be something wrong with the syntax of the query? Or am I making some other newbie mistake? It just comes back with

# MySQL returned an empty result set (i.e. zero rows).

I am running this via the Query box which says “Run SQL query/queries on database sswp01:”

I really wish I could attach screen grabs to this post. I contacted my hosting support and they said that they were actually able to get search results and etc just fine.

My wordpress is standard install, no multiple sites in the one database etc

As far as I am aware I am selecting all tables, Im on the SQL page and running it on the entire database .. also selecting all rows as well … to be honest, this is really frustrating, it should just run the query and find them and update them?

I dont know. For wanting to do such a simple action as changing existing galleries style with a simple select, this is getting fairly meh. Ugh.

Well, this certainly is very perplexing.

I have tried the search on verified tables/content etc searching for that term and I still get no results. The [nggallery id=15] is most definitely there in the right place, in post_content (I verified manually).

So strange. I am using phpmyadmin under cpanel … I have a bad feeling there is something wrong with cpanel – why wouldnt it find the record with a simple search?:(

@toto Habschned

I had opportunity to test this out today, and I populated an excel sheet with an iteration of these numbers using the following Excel forumla (which worked amazingly when placed in column A1)

=CONCATENATE(“UPDATE wp_posts SET post_content = REPLACE(post_content, ‘[nggallery id=”,ROW(B1),”]’, ‘[nggallery id=”,ROW(B1),” display_type=photocrati-nextgen_pro_masonry]’) WHERE post_content LIKE ‘[nggallery id=”,ROW(B1),”]’;”)

This gave me a list of all the id numbers to be updated – here is an example

UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=15]', '[nggallery id=15 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=15]';
UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=16]', '[nggallery id=16 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=16]';
UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=17]', '[nggallery id=17 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=17]';
UPDATE wp_posts SET post_content = REPLACE(post_content, '[nggallery id=18]', '[nggallery id=18 display_type=photocrati-nextgen_pro_masonry]') WHERE post_content LIKE '[nggallery id=18]';

Unfortunately, when I put this into phpmyadmin and ran the SQL query, it came back with

“# MySQL returned an empty result set (i.e. zero rows).”

This indicates that somewhere in the SQL it didnt correctly select the rows or that it didnt find the content in them. Can you see why it may have returned this result at all? your help is very much appreciated, I feel like Im almost there in being able to implement this fix ….

Hi Toto,

I see, that is actually very helpful, and I can see that working, thankyou very much mate.

That said, oh man, yeh, there are about 800 galleries haha. I guess I can renumber those for 800 items .. it would certainly be quicker than going in and editing every single post, will still take a little time but hey. At least there is an avenue. I will test it with one gallery first I think.

@cais – maybe you could implement a simple switch in nextgen that just updates the db like this? Im sure you could do it easier tho using some other method, and really, its a no-brainer feature and I am surprised it doesnt exist already.

Thanks Toto that’s a much more helpful piece if advice and Avenue to try. Okay, I don’t have a lot of experience with Sql but I do have phpmyadmin.. So, it’d look something like this?

UPDATE wp_posts SET post_content = REPLACE(post_content, ‘[nggallery id=41]’, ‘[nggallery id=41 display_type=photocrati-nextgen_pro_masonry]’) WHERE post_content LIKE ‘%old shortcode%’;

I’m pretty sure that’s wrong… As What I don’t get is how the I’d numbers are retained etc… Or do I use the Sql code exactly the way you posted it?

Whaaa, seriously? Are you saying that with all the features after all these versions, there is actually no way to global change the way that galleries are displayed in nextgen? That you’re stuck with the default, unless you manually change a line of code?

I can’t even do a find and replace as there no way of doing so without screwing up the gallery Id…

Seriously, my mind is boggling here and I find this pretty bizarre. It seems seems to me that this would be a very foundation level feature.

Is there no code that can be changed to make this work? Are you actually saying that I have to go through 800 galleries and change every single short code in every post just to display a different gallery display? No simple “set global galley display” function?

I mean. Ugh.

Okay, so its a known bug.

Unfortunately, the functions.php fix as indicated in that post did not work for me, so I guess I will be stuck until the issue is addressed and the next version is released.

Quite frustrating.

Same here, it been extremely slow for me.

yes, if I upload a new image, the size is correct – its just all the existing ones (about 10,000 or so) that dont resize =/