0

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.

1
  • Please show the technique that you are using to insert. Dump the rendered query to see what it being sent. Is the table prefix as desired? To answer properly, we need these Debugging Details.
    – mickmackusa
    Mar 27 at 2:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.