December 13, 2018 in Technical Problems
I was wondering if the SQL query command to reset profile views was the same as previous versions of IP.Board, and if so, what is the command query for IPS 4.3.6? And can we still run such a command in the SQL Toolbox?
You're asking people to confirm if a SQL query to do something is the same now as it was previously, but you haven't actually provided the SQL query......so, what is the SQL query you are asking about?
What exactly are you trying to achieve?
update core_members set members_profile_views = 0;
update core_members set members_profile_views = 0 where member_id = X;
where X is the member ID.
In addition to what @Adriano Faria said above, it would be best to backup the members table first. Personally I think that it is a good practice to always backup the database before you modify something in it.
I was also wandering what you meant by "was the same as previous versions of IP.Board"?
This topic is now archived and is closed to further replies.
Started 37 minutes ago
Started 7 hours ago
Started February 9