Help setting up RespondCMS

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

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.

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