search

ameerssb / Find_Quran_Verse

The Quran Verse Finder is a voice-based Quran search application is a user-friendly and innovative tool designed to assist individuals in finding specific verses from the Quran using voice recognition technology. It offers a convenient and efficient way to search for and access relevant Quranic verses by simply speaking into the device or computer.
https://quran.pythonanywhere.com/
MIT License
9 stars 0 forks source link

Error while processing request #1

Open kamrankhoxa opened 10 months ago

kamrankhoxa commented 10 months ago

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

kamrankhoxa commented 10 months ago

image

ameerssb commented 8 months ago

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 commented 8 months ago

I think is an database error! which version of database are you using or can you please guide or provide details @ameerssb k2455552@gmail.com or kamrankhoxa@icloud.com

SkCodeRains commented 4 months ago

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 ,