Question

Help setting up RespondCMS

I followed their guide, but when I go to the test API page I get

[Site::GetDomains] PDO Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'respond.Sites' doesn't exist

DB details in the config are correct.

Subscribe
Share

Check the database with MySQL and see if the default tables exists

# mysql -uroot -p respond -e "show tables;"

I’m going to guess you did not import their schema located here: https://raw.githubusercontent.com/madoublet/respond/master/schema.sql

Backup current database state

# mysqldump -uroot -p respond | gunzip > ~/respond.sql.gz

Drop and re-create database

# mysql -uroot -p -e "DROP DATABASE respond; CREATE DATABASE respond;"

Download database schema provided by RespondCMS @ github and import schema.

# wget -o ~/respondschema.sql https://raw.githubusercontent.com/madoublet/respond/master/schema.sql
# mysql -uroot -p respond < ~/respondschema.sql

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Have you looked at the database and confirmed that the table that it says is missing is actually missing? If it is missing, then something didn’t get installed correctly. If it isn’t missing, then your configuration may not be entirely correct.