Recent Posts

1

Support / Re: SQLSTATE[23000] Error - Foreign Key Constraint in thread Table

« Last post by oabm77 on March 20, 2025, 10:22:31 PM »

Thank you for the clarification! I deleted the foreign key constraint as suggested, and it successfully resolved the issue.

I appreciate your support and quick response. Keep up the great work with Mibew!

Best regards,

2

Support / Re: SQLSTATE[23000] Error - Foreign Key Constraint in thread Table

« Last post by faf on March 20, 2025, 09:24:47 PM »

Would you recommend manually removing this foreign key constraint, or is there another preferred fix?

Yes, at the moment that's the fix. Delete the foreign key constraint.

As far as I can see, the cause of the issue in question is the difference between MySQL and MariaDB in how they handle inline references specification. While MySQL ignores them, MariaDB (starting from 10.5) attempts to apply  the constraint. Please, bear in mind that Mibew Messenger wasn't tested with MariaDB.

3

Support / Re: SQLSTATE[23000] Error - Foreign Key Constraint in thread Table

« Last post by oabm77 on March 20, 2025, 07:26:43 PM »

Hello,

Thank you for your response. Here are my answers to your questions:

It was a clean installation—I did not upgrade from a previous version.
I downloaded Mibew Messenger 3.6.0 directly from the official site.
No third-party plugins or modifications have been installed—it's a default setup.
Regarding the foreign key constraint issue, I checked the database schema, and the thread table does contain a foreign key reference to opgroup(groupid), which seems to be causing the problem.




Would you recommend manually removing this foreign key constraint, or is there another preferred fix?

Thanks for your help!

Best regards,
Omar B.

4

Support / Re: SQLSTATE[23000] Error - Foreign Key Constraint in thread Table

« Last post by faf on March 20, 2025, 06:54:40 PM »

Well, I'll take a look at the issue in question. However, I have several questions.

1. Is it a clean installation or you've upgraded from some previous version?

2. Have you downloaded the distribution of Mibew Messenger from our official site?

3. Do you use some third-party plugins or something else, that might affect Mibew Messenger?

You see, there should not be such foreign key in the database schema.

5

Support / SQLSTATE[23000] Error - Foreign Key Constraint in thread Table

« Last post by oabm77 on March 19, 2025, 07:14:22 PM »

Hello Mibew Team,

I recently installed Mibew Messenger on my server, and everything seemed to work fine. However, when starting a new chat session, I receive the following database error:

Code: [Select]

SQLSTATE[23000]: Integrity constraint violation: 1452
Cannot add or update a child row: a foreign key constraint fails (`chat_visae`.`thread`,
CONSTRAINT `thread_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `opgroup` (`groupid`))

My Setup:
Mibew Version: 3.6.0
PHP Version: 8.2
Database: 10.11.11-MariaDB
Web Server: Apache

Troubleshooting Steps Taken:
Checked the opgroup table using:

Code: [Select]

SELECT * FROM opgroup;
The table is not empty because I have already created groups and agents.

Questions:
Is this a known bug in recent Mibew versions?
Should Mibew automatically assign a valid groupid to chat threads?
What is the correct way to handle this foreign key constraint issue?

Any help would be greatly appreciated! Thanks in advance.

Best regards,
Omar B.

6

Support / Re: Problem with adding new users

« Last post by faf on January 22, 2025, 10:41:13 AM »

First of all, you'd better fix the email issue.

Second of all, take a look at this part of the code. Mibew Messenger tries to salt the password if it's possible. So, if you really need to alter the password directly in the database, you should calculate it manually. Or just set it to md5 hash of the password as it is written in the FAQ.

Otherwise, one could simply give your known user administrative permissions. It's defined by iperm field in the very same mibewoperator table.

7

Support / Problem with adding new users

« Last post by zhomart on January 15, 2025, 10:02:44 AM »

I need to add new users to mibew. In the mibewoperator table there is a user booster, he is an operator. I know his password. There is also a user admin and I forgot his password, and his password is hashed in the DB. I can't recover the password because the message does not arrive in the mail. That's why I can't add users via the admin panel, because I don't know the admin password. I copied the booster hashed password and put it to admin in DB. But I always get the error "Incorrect login or password". How can I deal with this situation?

8

Announcements / Direct downloads and mirrors of repositories

« Last post by faf on November 12, 2024, 11:28:01 PM »

Hi there!

In continuous efforts to keep our project available to everyone we’ve made two important infrastructural steps.

First of all, we've switched to direct dowloads for all files of Mibew Messenger project. Now it's available on our site. Without any restrictions and discriminations. We’ll keep the mirror at SourceForge, but from now on the main way to download Mibew Messenger is our own server.

Second of all, we set up our domestic Gitea instance and mirrored all of our Github repositories. At the moment we’ll keep using Github for the development, but one can use the synced mirrors in case of any troubles accessing Github.

Lately we’ve encountered some unacceptable forms of discrimination of people living in different parts of the World in access to our data. We strongly believe in freedom of information. We believe that anyone has rights to download, modify, use, and distribute our software as long as it is done according to the license. And we neither don’t like, nor don’t accept the situation when any particular government restrict those rights according to its own political views and interests. We stand against the injustice. And we'll win.

9

Русский (ru) / Re: Диалог открывается в новом окне

« Last post by Alexey on June 29, 2023, 04:35:01 AM »

Благодарю за ваш ответ!

Действительно нужно было открыть консоль разработчика и изучить какие ошибки выдаются.

Ошибка была в коде кнопки - путь к скрипту был указан неправильный, поэтому скрипт не подгружался.
Окно чата теперь открывается в фрейме основного сайта.

Единственное, что пока не удается передать фокус ввода чату, но это нужно порыться немного в документации. В остальном история с А-записями ДНС рабочая.

10

Русский (ru) / Re: Диалог открывается в новом окне

« Last post by faf on June 28, 2023, 08:06:49 PM »

Как-то же работают аналогичные сервисы?

Возможно, не используют куки. Не особо интересно, честно говоря.

Mibew - это не сервис, это приложение. Можно ли сделать из него SaaS-решение? Вероятно, да, но нужно дорабатывать.

Я планировал использовать один сервер для трех доменов.

Мне кажется есть такое решение:
для каждого домена прописать в DNS

A-записи вида (1.2.3.4 - ip сервера, на котором mibew размещен)
1.2.3.4 mibew.domen1.ru
1.2.3.4 mibew.domen2.ru
1.2.3.4 mibew.domen3.ru

И кнопки соответственно сгенерировать под каждый домен. 

В теории, да, должно работать. Не проверялось.

UPD:
Протестировал свою версию, прописал А запись
Теперь домен сайта domen.ru и поддомен, на котором открывается чат (mibew.domen.ru) совпадают.
Но чат открывается все равно в новом окне.

В общем случае надо смотреть консоль ошибок браузера.

Схемы (http / https), в которых работают сайт и установка Mibew Messenger одинаковы?