[BUG] Issue in Japji Sahib Bani Bookmarks

[uttamdeepk22]

🐛 Bug Description

Pauri number 34 of Japji Sahib is written the same as Pauri number 33 in the bookmarks, and when you click either 33 or 34 in the bookmarks, it opens Pauri 33.

🔄 Steps to Reproduce

1. Go to 'Japji sahib' bani
2. Click on bookmarks
3. Scroll down to 'Pauri 33 and 34'
4. See error

✅ Expected Behavior

Each pauri in bookmarks should show the correct order and open the correct bani as per sequence.

❌ Actual Behavior

in the bookmarks, Pauri 34 is written the same as Pauri 33 and opens pauri 33 as well when clicked.

📱 Device Information

• OS Version: Android 15, IOS 18.6.2

📸 Screenshots/Videos

🔍 Environment

• iOS
• Android
• Both

📊 Severity

• Critical (App crashes or completely unusable)
• High (Major functionality broken)
• Medium (Minor functionality affected)
• Low (Cosmetic issue)

[uttamdeepk22]

@amitojsingh ji, same issue in Japji Sahib Bani as well in Pauri 33 and 34. Attached screenshot below:

[sanyachaw1a]

@indersinghkhalis @amitojsingh seems like a db error

Database Location:
ios/www/gutka_v01.db
android/app/src/main/assets/www/gutka_v01.db

Table: Banis_Bookmarks

Issue: Pauri 34 bookmark for Japji Sahib (Bani 2) contains incorrect text data

Navigation seems to be working correctly (they go to different locations)
Only the visual display in the bookmark list is wrong

If we were to query:
SELECT
ID,
Seq,
Gurmukhi as BookmarkLabel,
BaniShabadID,
TukGurmukhi,
TukGurmukhiUni as DisplayText
FROM Banis_Bookmarks
WHERE Bani = 2 AND Gurmukhi IN ('pauVI 33', 'pauVI 34')
ORDER BY Seq;

we get:
35|340|pauVI 33|328|AwKix joru cupY nh joru ]|ਆਖਣਿ ਜੋਰੁ ਚੁਪੈ ਨਹ ਜੋਰੁ ॥
36|350|pauVI 34|336|AwKix joru cupY nh joru ]|ਆਖਣਿ ਜੋਰੁ ਚੁਪੈ ਨਹ ਜੋਰੁ ॥

potential fix:
UPDATE Banis_Bookmarks
SET TukGurmukhi = 'rwqI ruqI iQqI vwr ]',
TukGurmukhiUni = 'ਰਾਤੀ ਰੁਤੀ ਥਿਤੀ ਵਾਰ ॥'
WHERE Bani = 2 AND Gurmukhi = 'pauVI 34';

[indersinghkhalis]

@sanyachaw1a I have added you to the repo that handles sqlite export. Can you pleasae raise PR on that repo.

Thank you so much!