Hello there,

I have DB Replacer setup to auto open/config on the Yootheme's zoo_item table. It has a column that determines the state of the item to be published "1" or unpublished "0". I'm trying to get the DB Replacer to take that column, select all the 0's and replace it to 1's. The problem is it will do it in reverse with no problem. If going from 1 to 0 the replace button will activate and allow me to click it to execute the replace. But for the 0 to 1 is stays grayed out.

When search/selecting the 0's I have tried different ways to isolate them. When searching on 0 without running it as a regular expression, the search returns everything up to the record limit, both 1's and 0's. (I have it set to 500 records). Replace button remains dormant. If I search on 0 as a regular expression ^0$ it will only return the 0's in the search but will not highlight them and active the replace button. Is there something else I need to do to be able to search and replace a 0 to a 1 without having to go into phpmyadmin or use a mysql client with an update statement?

This is for a project that will be going through weekly imports and I'm trying to make it as easy as possible for my customer to follow steps to mass publish imported data.

I hope I was clear and not confusing. I look forward to your response.

I tried the development version and the results haven't changed. It is still reacting the same way.

Below is a screenshot of how the database table is setup from yootheme's zoo_item. #13 STATE is where there are only two variables. 1 for published and 0 for unpublished. I'm not sure if this might help or not.

Search will return results, but it will not allow for a replace with 0's. If I search on 1's it will allow for it.

Here are recent screenshots of the behavior.

That worked! Great job and wonderful customer service as always!