Hello,
Where can I find user data in the database?
And what if you pull all the user data and add it to another database, the same but old?
Will ads and user data be affected?
Thanks

Have you checked t_user table?

Have you checked t_user table?

This is the Shockwave oc_t_user
But when importing after deleting the old table
An error message appears
#1005 - Can't create table `mas_mas `.`oc_t_user` (errno: 150 "Foreign key constraint is incorrectly formed")
Now the number of users is zero

Quote from: MB Themes on July 14, 2022, 01:45:40 PM

Have you checked t_user table?

This is the Shockwave oc_t_user
But when importing after deleting the old table
An error message appears
#1005 - Can't create table `mas_mas `.`oc_t_user` (errno: 150 "Foreign key constraint is incorrectly formed")
Now the number of users is zero

I found this solution and it worked for me
I hope it is correct and there is no problem
What is the opinion of the site manager?

In the users file just change from
CREATE TABLE `oc_t_user` (
  `pk_i_id` int(10) UNSIGNED NOT NULL,
  `dt_reg_date` datetime NOT NULL,
  `dt_mod_date` datetime DEFAULT NULL,
  `s_name` varchar(100) NOT NULL,
  `s_username` varchar(100) NOT NULL,
  `s_password` char(60) NOT NULL,to me
CREATE TABLE `oc_t_user` (
  `pk_i_id` int(10) UNSIGNED NOT NULL PRIMARY KEY
  `dt_reg_date` datetime NOT NULL,
  `dt_mod_date` datetime DEFAULT NULL,
  `s_name` varchar(100) NOT NULL,
  `s_username` varchar(100) NOT NULL,
  `s_password` char(60) NOT NULL, `pk_i_id` int(10) UNSIGNED NOT NULL PRIMARY KEY