Help setting up RespondCMS

January 14, 2016 749 views
LAMP Stack CMS Apache MySQL PHP Ubuntu

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:

    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
    # mysql -uroot -p respond < ~/respondschema.sql
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.

Have another answer? Share your knowledge.