mysql error 1146 Table doesn't exist
mysql error: [1051: Unknown table 'btgroupdocsviewer'] in EXECUTE("drop table btgroupdocsviewer")
Now when i want to connect to the website I have this database error occuring :
mysql error: [1146: Table 'renorr_conc75.Packages' doesn't exist] in EXECUTE("select pkgID, pkgName, pkgIsInstalled, pkgDescription, pkgVersion, pkgHandle, pkgDateInstalled from Packages where pkgIsInstalled = 1 order by pkgID asc")
Any idea how I can fix this ?
I'm totally noob so if you can explain clearly how I can fix my database it would be very kind.
After that, search within the tables Packages and BlockTypes for leftovers. Also, you can delete the table btgroupdocsviewer.
a) make a backup first,
b) you should be well versed with restoring a database via phpMyAdmin or from the concrete5 dashboard,
c) and absolutely no guarantee from me!
If you have no packages installed on your server, you can create an empty table, fire your MySQL client or any other and issue the following SQL statement :
CREATE TABLE `Packages` ( `pkgID` int(10) unsigned NOT NULL AUTO_INCREMENT, `pkgName` varchar(255) NOT NULL, `pkgHandle` varchar(64) NOT NULL, `pkgDescription` text, `pkgDateInstalled` datetime NOT NULL, `pkgIsInstalled` tinyint(1) NOT NULL DEFAULT '1', `pkgVersion` varchar(32) DEFAULT NULL, `pkgAvailableVersion` varchar(32) DEFAULT NULL, PRIMARY KEY (`pkgID`), UNIQUE KEY `pkgHandle` (`pkgHandle`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
If this is the only tables that were removed, that should work. If you had any other packages install though, your site might continue to break.