change defaults by creating a list

jera

Member
hello everyone

I want to change some default values when a list is created, I must assume that this must be done in one line of code.

Currently when I create a list, I "= Double Opt-out" appears, I want to default to "Opt-out = Single", but do not know how.

F57.jpg


I hope you can guide me to make me this change, of course, thanks.

Greetings.
 

twisted1919

Administrator
Staff member
I am not sure what version you are using there, but since 1.3.5 the default for list opt out is single, not double anymore.

To answer your question, best way to change those defaults is from database table structure because that isn't affected at updates(most likely), but that requires to know how to work with phpmyadmin(should not be that hard), so just open mailwizz database in phpmyadmin, select the table you need, click on the Structure tab from the right side, then identify the field for which you need to change the default, click on the change button for that field and then simply change it's default value.


Thanks.
 

Vpul Shah

Well-Known Member
Hi Twisted,

I have the updated version 1.3.5.2 and default is shows Double Opt-in.

Can you check it ?

Thanks,
Vpul.
 

jera

Member
Hi, thanks for your response.

yes, I work with phpmyadmin, please comentame What should I modify or table that table are these values?

greetings.
 

twisted1919

Administrator
Staff member
I have the updated version 1.3.5.2 and default is shows Double Opt-in.
Only new installs will get single opt-in.

yes, I work with phpmyadmin, please comentame What should I modify or table that table are these values?
I just did above. Select the mw_list table from the left navigation, then from the right side select "structure". then check the opt_in column and click on change button. from there, change it's default value, from double to single.
Better watch some tutorial on youtube before

.

Thanks.
 

Vpul Shah

Well-Known Member
I have install as a fresh Installation not update because update could not get started.

SO Install a fresh one and in same it is default Double opt in.
 

twisted1919

Administrator
Staff member
Below is taken from the database schema shipped with mailwizz 1.3.5.3:
Code:
--
-- Table structure for table `list`
--

DROP TABLE IF EXISTS `list`;
CREATE TABLE IF NOT EXISTS `list` (
  `list_id` int(11) NOT NULL AUTO_INCREMENT,
  `list_uid` char(13) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `visibility` char(15) NOT NULL DEFAULT 'public',
  `opt_in` enum('double','single') NOT NULL DEFAULT 'double',
  `opt_out` enum('double','single') NOT NULL DEFAULT 'single',
  `merged` enum('yes','no') NOT NULL DEFAULT 'no',
  `welcome_email` enum('yes','no') NOT NULL DEFAULT 'no',
  `status` char(15) NOT NULL DEFAULT 'active',
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  PRIMARY KEY (`list_id`),
  UNIQUE KEY `unique_id_UNIQUE` (`list_uid`),
  KEY `fk_list_customer1_idx` (`customer_id`),
  KEY `status_visibility` (`status`,`visibility`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

So it's single opt out.
 

jera

Member
I just upgraded my list with the values shown and have exported the table and has the following values:

Code:
CREATE TABLE IF NOT EXISTS `mw_list` (
`list_id` int(11) NOT NULL,
  `list_uid` char(13) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `display_name` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `visibility` char(15) NOT NULL DEFAULT 'public',
  `opt_in` enum('double','single') NOT NULL DEFAULT 'double',
  `opt_out` enum('double','single') NOT NULL DEFAULT 'single',
  `status` char(15) NOT NULL DEFAULT 'active',
  `date_added` datetime NOT NULL,
  `last_updated` datetime NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8;

However when I create a list output option I keep getting "Double"
 

twisted1919

Administrator
Staff member
Not really sure what happens on your case, or if this is a recent change in my end so better you wait for the next release and we can pick it from there. I am saying this because, have a look how my page looks like when i create a new list:
list-default.png
 

twisted1919

Administrator
Staff member
One more thing, after each change that involves database, make sure you delete the folder apps/common/runtime/cache ;)
 

jera

Member
Hello, and decided it was just a matter of clearing the cache around, I'm very grateful.

An extra question, I see that you have a different version to the latest version of mailwizz, is that the new version will see shortly?

Again thanks and greetings.
 
Top