cancel
Showing results for 
Search instead for 
Did you mean: 

Error on install. PDO exception: SQLSTATE[HY000]: General error: 1036

Error on install. PDO exception: SQLSTATE[HY000]: General error: 1036

Hi,

 

I'm having some issues installing Magento 2.0.1 on our development server. The installation worked fine when I tried it locally, but we've got a newer version of PHP and mySQL on our development server.

 

The console log comes up with this message:

 

[ERROR] PDOException: SQLSTATE[HY000]: General error: 1036 Table 'store_website' is read only in  (big list of files)

 

 

None of the tables are read only, the user for the database has full privileges. 

 

After this we can't go back and try changing any of the settings, if we do we get the message:

 

Fatal error: Uncaught DomainException: Default website is not defined in ... (list of files) ...  (filepath)\vendor\magento\module-store\Model\WebsiteRepository.php on line 129

 

 

The last file is the only one that appears to come with  a line number. I'm guessing this just means that is started trying to install Magento, failed and can't get back to the setup stuff. The main problem is the errors when I try to install.

 

Any ideas?

 

Thanks.