fix text index in transactions