i am new here on the forum and wanna ask if somebody can give me an idea / solution about this error my database shown since yesterday:
#1814 - Tablespace has been discarded for table ‘accounts’
I googled around and found a lot, but have not really an idea what to do. Even SuiteCrm is still running well and did not show any error, except in the suitecrm.log
Thanks in advance
What is your SuiteCRM version, PHP version, and MySQL version?
Have you tried upgrading your database, if it’s old?
thanks for your fast reply. Here is the data:
Server: Localhost via UNIX socket
Server-Version: 10.1.38-MariaDB-0+deb9u1 - Debian 9.8
Server-Zeichensatz: UTF-8 Unicode (utf8)
Datenbank-Client Version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
PHP-Erweiterung: mysqliDokumentation curlDokumentation mbstringDokumentation
phpmaadmin : Version: 4.6.6deb4
SuiteCRM Version :
Sugar Version 6.5.25 (Build 344)
I hope this helps and you have any idea. Do you think i can update to 7.11.4?
Did you checked disk space?
yes. There is more than enough space. Ram and diskspace. .
Also I upgraded successful to 7.11.4.
Looks like your table space or .idb file discarded somehow.
Might drop table ( after backup ) , then recreate the structure and then copy data into it …
thanks for your fast answer. Are you able to do that for me?
I never want this again _ that’s why I bought the Software from your company.
No worries, I will take care of the same.
Hello Ashish, I am facing the same problem, I suppose that the DB reach the limit,¿ would you be able to help me ? and please send how much will it cost to my email firstname.lastname@example.org