Wishlist not being added

Hi there

I just checked your customer installation, and it seems that for some reason plugin isn’t able to create default wishlist for the customer when he/she adds something to the list

Could you please check in database if db structure is correct, and if any wishlist was created?
Could you please also check your logs to see if there is any Database error reported there?

Hi YITHEMES,

Can you tell me know : “What exactly have my customer to check to my customer database?”

Best regards,

• This reply was modified 4 years, 8 months ago by themeskysupport.

I want you to check in db that both yith_wcwl and yith_wcwl_lists tables exists

Besides, I’d like you to make sure that structure for yith_wcwl_lists table is up to date (check that it contains a column called session_id)

Finally, I’d like to check whether system correctly registers lists in the table: in order to do this add something to the wishlist as a guest user, and check if a new record is added to yith_wcwl_lists table, with session id not null

Hi YITH,
My customer has checked in db that both yith_wcwl and yith_wcwl_lists tables exists, they have done as your said but data not add yith_wcwl_lists. This is database of my customer
Please you help me.
https://78.46.89.221:2031/pma/
decomgra_dedica2
QrSsU6BGJFi5

Database: decomgra_dedica2

Hi there

Please, avoid sharing direct access on this forum, even for test sites
This dump could contain sensible data, and now it is available to anyone

Anyway, I just checked db structure and I can see that your customer is running an outdated version of wishlist’s database structure, as I imagined
I suggest you to force the system to try update process again

In order to do so, visit /wp-admin/options.php as a logged in administrator, and search for an option called yith_wcwl_db_version
Then cancel its content, and save your options

On next reload plugin will try again to update database structure, hopefully adding missing columns

Hi YITH,

My customer have followed your said

In order to do so, visit /wp-admin/options.php as a logged in administrator, and search for an option called yith_wcwl_db_version
Then cancel its content, and save your options

On next reload plugin will try again to update database structure, hopefully adding missing columns

But it doesn’t work. Can you give me more details so I can reply my customer ?

Thank you so much !

Hi there!

Have you checked the database structure after executing the suggested procedure?
If it is still outdated (table yith_wcwl_lists doesn’t contain session_id column, for example), the only option left is a manual update

Please, try to run the following queries, to update database structure, and test again

alter table wp_yith_wcwl_lists add session_id VARCHAR(255) default NULL;
alter table wp_yith_wcwl_lists add expiration timestamp default NULL;
alter table wp_yith_wcwl add position INT(11) default 0;
alter table wp_yith_wcwl add original_price DECIMAL(9,3) default NULL;
alter table wp_yith_wcwl add original_currency CHAR(3) default NULL;
alter table wp_yith_wcwl add on_sale tinyint NOT NULL DEFAULT 0;

Hi YITH,

My customer have done as you said in the message previous but they have given an error with

alter table wp_yith_wcwl_lists add expiration timestamp default NULL;

#1067 – Invalid default value for ‘expiration’

And this problem is still remain with case my customer not login. Before this problem is happened to 2 cases ( you have logged in and have not login ).

Please you check it for you

Thank you

Sorry, try with this

alter table wp_yith_wcwl_lists add expiration timestamp;

Hi YITH,

Thank you for your support ! Very nice

Hi there

You’re welcome ??

If you appreciate our plugin, and suggest it to your customer, maybe you could consider to take a moment of your time and leave us an honest review; it would be much appreciated ??