errror when installing
Permalink Browser Info Environment
Trying to install but get the following error message:
Doctrine \ DBAL \ Exception \ TableNotFoundException
An exception occurred while executing 'select COUNT(*) as c from PagePassword where cID=? UNION select COUNT(*) as c from PagePassword where `recursive`=1' with params [81]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs12200785.PagePassword' doesn't exist
Doctrine \ DBAL \ Exception \ TableNotFoundException
An exception occurred while executing 'select COUNT(*) as c from PagePassword where cID=? UNION select COUNT(*) as c from PagePassword where `recursive`=1' with params [81]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs12200785.PagePassword' doesn't exist
| Type: | Ticket |
|---|---|
| Status: | In Progress |
After trying to install, website crashed and had to restore database from backup
Hi, sorry for your error, it seems that the package didn't create the tables on install. Did you receive any error during install?
you can try to create the tables manually (in phpmyadmin or equivalent) with:
Thanks
Regards
Nicola
you can try to create the tables manually (in phpmyadmin or equivalent) with:
CREATE TABLE `PagePassword` ( `cID` INT UNSIGNED NOT NULL, `passwordID` INT UNSIGNED NOT NULL, `recursive` INT, PRIMARY KEY (`cID`, `passwordID`), INDEX `idx_cID` (`cID`), INDEX `idx_passwordID` (`passwordID`) ); CREATE TABLE `PagePasswordPasswords` ( `passwordID` INT UNSIGNED NOT NULL AUTO_INCREMENT, `value` TEXT, PRIMARY KEY (`passwordID`) );
Thanks
Regards
Nicola
Good day, I deleted all error messages in PHP, installed my backup database and re-installed PASSWORD, that seems to have worked. Very nice package, and very easy to work with, thx