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.

1 comment
  • 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

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.

1 answer

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.

Submit an Answer