Originally posted by shalmaxb
View Post
Announcement
Collapse
No announcement yet.
Cannot rebuild database or add any custom fields
Collapse
X
-
- Likes 2
-
It is not about COLLATION, it is database (field) type. How did you "review" the SQL-file (from dump)? With an editor (text editor like notepad++)? If not, do that and search for the term "BIT".
BIT is a database field type like BOOL, VARCHAR, INT or TINYINT etc.. Nothing with COLLATION. If you found the term Bit, look, in which table that is.
I guess you have one field ore more, that got the type BIT and this will not be recognized.
If you found the field with that type, go to PHPMyAdmin, look for that field (in the table), choose the tab "Structure", where you can change the type.
I would not say, that this is aguaranteed solution, because I do not know your SQL file, but it would be th place and way to search for it.
Leave a comment:
-
Originally posted by shalmaxb View Postin my opinion, it is still the same error as above. As the error log states, there is a wrong database type "bit" in your database.
Try the following:
Export your database. Open the SQL file with an editor and search for "bit". If you find a field with datatype bit, open your database in PHPMyAdmin and change it to INT.
I don`t know, if this will work, but it is worth a try.
And do not change anything in database performance_schema, that is a database, that PHPMyAdmin needs.
Leave a comment:
-
in my opinion, it is still the same error as above. As the error log states, there is a wrong database type "bit" in your database.
Try the following:
Export your database. Open the SQL file with an editor and search for "bit". If you find a field with datatype bit, open your database in PHPMyAdmin and change it to INT.
I don`t know, if this will work, but it is worth a try.
And do not change anything in database performance_schema, that is a database, that PHPMyAdmin needs.
Leave a comment:
-
After spending hours setting up a duplicate system to troubleshoot and then make primary I've run into the exact same issue.
[2021-07-06 13:21:23] ERROR: Fault to rebuild database schema. Details: Unknown database type bit requested, Espo\Core\Utils\Database\DBAL\Platforms\MariaDb102 7Platform may not support it. at /opt/bitnami/espocrm/vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:398 [] []
[2021-07-06 13:21:23] ERROR: (500) Error while rebuilding database. See log file for details.; POST /Admin/rebuild; line: 134, file: /opt/bitnami/espocrm/application/Espo/Core/DataManager.php [] []
And this is now with a brand new install nothing done but to import the export and copy over my custom directories to it.
So I look at all the tables and the only ones that I can find that are not utf8_general_ci are 2 tables in the performance_schema that are utf8_bin. But the issue is that I can't get rights to change those 2 tables COLLATION. Can someone please help me fix this issue????
Leave a comment:
-
That looks like a php.ini error in your local setup, here's some information
https://stackoverflow.com/questions/...rmat-parameterLast edited by telecastg; 07-02-2021, 04:22 PM.
Leave a comment:
-
So I tried all the rebuild steps but when I get to the import of the sql that exported from my actual server i get a phpmyadmin error:
phpMyAdmin - Error
Incorrect format parameter
once again no idea how I keep getting stuck like this but if i can't export my data and import it then i need to be able to fix my current setup which I'm not having any luck with so far either.
Leave a comment:
-
It's actually a lot more simple, in my opinion, than trying to make sense of cryptic error messages, etc, plus, going through this process gives you some advantages:
1) If you don't have a staging site already, this post will teach you how to do that, so in the future you have a "playground" to try all your customizations first and make sure that everything works before you affect your production (live) website.
2) Having a local staging site will also let you test and isolate problems that could be caused by a permissions or other server or hosting issues that have nothing to do with your EspoCRM implementation.
3) It will take away some of the fear / nightmare of having a production implementation crashing with the users screaming at you while you try to figure out what to do ;-)
-
Originally posted by telecastg View PostMy go to solution when nothing seems to help, instead of spending countless hours troubleshooting some exotic problem, is to wipe out the current installation and install a new one preserving the data and settings.
I you think that you have reached that point, here's a way to install a new instance without losing your data, customizations or settings.
I upgraded from 5.82 and followed the procedures to the current build. For two years prior to this upgrade, everything was running smoothly. I did appropriate backups, so I thought and even looked to the server rewinds etc. Now, every 2-4 hours the CRM crashes again and gives just the blue line across the top of the page. I
Leave a comment:
-
My go to solution when nothing seems to help, instead of spending countless hours troubleshooting some exotic problem, is to wipe out the current installation and install a new one preserving the data and settings.
I you think that you have reached that point, here's a way to install a new instance without losing your data, customizations or settings.
I upgraded from 5.82 and followed the procedures to the current build. For two years prior to this upgrade, everything was running smoothly. I did appropriate backups, so I thought and even looked to the server rewinds etc. Now, every 2-4 hours the CRM crashes again and gives just the blue line across the top of the page. I
Leave a comment:
-
Originally posted by shalmaxb View PostThere is one wrong database type bit in your tables. Perhaps this could help: http://www.bdodev.com/2016/03/doctri...-database.html
Leave a comment:
-
There is one wrong database type bit in your tables. Perhaps this could help: http://www.bdodev.com/2016/03/doctri...-database.html
Leave a comment:
-
Originally posted by tarasm View PostYou do not need to update tables in `performance_schema`. It's the system MySQL tables.
Leave a comment:
-
You do not need to update tables in `performance_schema`. It's the system MySQL tables.
Leave a comment:
-
I don't have any extra tables. What I have found is there are a few tables in the performance_schema database that have the collation set to utf8_bin. I can't edit that database though so i can't change them. Does anyone know how to edit them?
Leave a comment:
Leave a comment: