I have created a secondary user table to store other information in the Joomla database. However, when I try to insert information into that table, I get this error.
1146 Table 'database.#__vvuser' doesn't exist
The table exists and has the correct prefix. The database version and Joomla versions are compatible since all non-custom tables work. I have tried clicking the fix database button in the control panel, but that did not resolve the issue.
I created the table using an SQL statement similar to this.
CREATE TABLE examp_vvuser( email varchar(100) NOT NULL, user_id INT NOT NULL, username varchar(150) NOT NULL, recieve_notice BOOLEAN DEFAULT FALSE, user_group INT DEFAULT 0, login_date DATE DEFAULT (CURRENT_DATE) );
I am using a Debian 10 server with PHP 7.4 and MySQL 8.0.22 installed. My Joomla! version is 3.9.25.