Installation error: SQLSTATE[42S22] with a DigitalOcean database cluster

[accpacific]

🎯Description of the issue

Hi, I tried to install latest Chevereto on latest LEMP stack (NGINX, PHP7.4) and database cluster (MySQL 8) on DigitalOcean. All of the droplet and database are new installation, however, it shows the following error message while I running the installer.php.



Installation error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'valid' in 'where clause'.



I've searched this forum and I am sure that the table prefix of database are all started with "chv_". Would you please confirm my issue and advise how to do for the next steps? Thank you.

 

[Rodolfo]

If you have a mysql column issue chances are that the install never happened properly. In all these cases you should stop doing the installer and do manual installation, as it is explained in the installer documentation here: https://v3-docs.chevereto.com/setup/installer.html (the installer breaks very easily).

 

[accpacific]

Thanks for your reply. The installation is completed on another Droplets (with SQL server installed). but I will still try the manual installation with standalone Droplet with a managed database cluster. By the way, I cannot find the related SQL instructions about creating a database named "chevereto" for manual installation, what are the next steps after following SQL instructions?

CREATE USER 'chevereto' IDENTIFIED BY 'INSERTPASSWORDHERE';
GRANT ALL ON chevereto.* TO 'chevereto';

Thank you.

 

[Rodolfo]

There are detailed instructions, kindly check:

https://v3-docs.chevereto.com/setup/root-install.html#install-mysql-database

For what I can tell the procedure is likely to be the same you described.

 

[Support]

Unfortunately, this ticket has more than seven days without a reply or feedback from the original poster. We will now consider this ticket abandoned and its now closed.

Don't hesitate to create a new ticket if this matter is still causing you issues.

Ticket closed.