Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error while processing request #1

Open
kamrankhoxa opened this issue Jan 12, 2024 · 4 comments
Open

Error while processing request #1

kamrankhoxa opened this issue Jan 12, 2024 · 4 comments

Comments

@kamrankhoxa
Copy link

An Error occured while Processing Request (1191, "Can't find FULLTEXT index matching the column list")

@kamrankhoxa
Copy link
Author

image

@ameerssb
Copy link
Owner

ameerssb commented Mar 7, 2024

The issue is that the system didn’t capture what you said maybe you have to speak a bit loader and i will check from my side

@kamrankhoxa
Copy link
Author

I think is an database error! which version of database are you using or can you please guide or provide details @ameerssb [email protected] or [email protected]

@SkCodeRains
Copy link

SkCodeRains commented Jun 24, 2024

HI there , i am facing the same issue , migrations does not import the data into mysql 8.x database its creating only ! database , i imported csv data into both two tables ,

but i am not sure what else is requirements , there others table which are empty !.

and the same error i am getting , and the error is populating from the translate.py line 10
`

                for i in range(len(Speech_Text)):
                        Store = Speech_Text
                        with connection.cursor() as cursor:
                            query = f'SELECT MATCH (text) AGAINST ("{Store}" IN NATURAL LANGUAGE MODE) score,text,sura,aya,quran_app_quran_suras.sura_name,quran_app_quran_suras.id FROM quran_app_quran_text_simple LEFT JOIN quran_app_quran_suras ON sura = quran_app_quran_suras.id WHERE MATCH (text) AGAINST ("{Store}" IN NATURAL LANGUAGE MODE) ORDER BY MATCH (text) AGAINST ("{Store}" IN NATURAL LANGUAGE MODE) DESC'
                            cursor.execute(query)
                            table = cursor.fetchall()
                        verse_find[i] = pd.DataFrame(table,columns=['score','Arabic Text','Chapter Number','Verse Number','Chapter Name','Chapter id'])
                        # print(verse_find[i].head())

`
Here it is getting end !! and error being trough .

image

these are the tables , in which only ! quran simple and full table having the data which i imported ! ,

Can you help me here !!!

Here are left Joining quran_app_quran_suras, but this table is empty what it supposed to have !! , For Repo can you create ! full documentations !! , and script to import the database , i created script to import database ! from csv ,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants