java.lang.IllegalArgumentException: Invalid column name

Question

I hope you all are safe.........question! Can you help me out with this? I am lost! Thank you! I highly appreciate it!

LogCat:

java.lang.IllegalArgumentException: Invalid column name
at com.musicapp.android.musicapp.fragment_all_songs.readSongs(fragment_all_songs.java:64)

code:

            String[] projections = {
                    MediaStore.Audio.Media.ARTIST,
                    MediaStore.Audio.Media.DISPLAY_NAME,
                    MediaStore.Audio.Media.SIZE,
                    MediaStore.Audio.Media.MIME_TYPE,
                    MediaStore.Audio.Media.DEFAULT_SORT_ORDER};

    63        ContentResolver contentResolver = getActivity().getContentResolver();
    64        Cursor cursor = contentResolver.query(MediaStore.Audio.Media.EXTERNAL_CONTENT_URI,projections,null,null,null);
            if (cursor != null){
                if (cursor.moveToFirst()){
                    do {
                        Song song = new Song();
                        song.artist_Name = cursor.getString(cursor.getColumnIndex(MediaStore.Audio.Media.ARTIST));
                        song.songTitle = cursor.getString(cursor.getColumnIndex(MediaStore.Audio.Media.DISPLAY_NAME));
                        song.songSize = cursor.getInt(cursor.getColumnIndex(MediaStore.Audio.Media.SIZE));
                        //song.SongCover= cursor.get(Integer.parseInt(MediaStore.Audio.Media.MIME_TYPE));
                        song.genre= cursor.getString(cursor.g

etColumnIndex(MediaStore.Audio.Media.DEFAULT_SORT_ORDER));

                    song_list.add(song);
                }while (cursor.moveToNext());
            }
            cursor.close();
        }

Have a look at [this answer](https://stackoverflow.com/a/6782345/3818303). They might have the same problem you are having about invalid column — instanceof, Jun 17 '20 at 20:15

score 0 · Accepted Answer · answered Jun 17 '20 at 20:16

0

Please try to change MediaStore.Audio.Genres.DEFAULT_SORT_ORDER to MediaStore.Audio.Media.DEFAULT_SORT_ORDER?

answered Jun 17 '20 at 20:16

ror

3,295
1
19
27

Please explain. I did run the code before/after (crash before/work after). – ror Jun 17 '20 at 20:24
I copied the exact same code, but logcat tells me it is the same error – WelcomeToTheDarkSide Jun 17 '20 at 20:27
Your code at a whole will not work simply because you are trying to Integer.parseInt string. I was referring to the lines 63/64. – ror Jun 17 '20 at 20:38
THANK YOU THANK YOU THANK YOU – WelcomeToTheDarkSide Jun 17 '20 at 20:44
I updated the code! so all the above works(If anyone in the future needs help with the same thing)!!! – WelcomeToTheDarkSide Jun 17 '20 at 20:46

java.lang.IllegalArgumentException: Invalid column name

1 Answers1