Error SQLite.

General discussions
Locked
Jemay
Posts: 15
Joined: Fri Jan 14, 2011 6:43 am

Error SQLite.

Post by Jemay »

Hi, first: thanks for this great audio player...
A few days ago I created a smart list with a option for path and order for genre (ascedant) but every time when I try to access it Guayadeque crashes, the console I get the following error:

Error: guDbLibrary::ExecuteQuery exception 'SELECT song_id, song_name, song_genreid, song_genre, song_artistid, song_artist, song_albumartistid, song_albumartist, song_composerid, song_composer, song_albumid, song_album, song_pathid, song_path, song_filename, song_format, song_disk, song_number, song_year, song_comment, song_coverid, song_offset, song_length, song_bitrate, song_rating, song_playcount, song_addedtime, song_lastplay, song_filesize FROM songs WHERE (song_path LIKE '%revisar%') ORDER BY genre_name, song_artist, song_album, song_disk, song_number'
1: SQLITE_ERROR[1]: no such column: genre_name
terminate called after throwing an instance of 'wxSQLite3Exception'

What could be happening? and How can I delete the list without delete the another lists that I have?
User avatar
anonbeat
Posts: 2048
Joined: Thu Sep 16, 2010 9:47 pm

Error SQLite.

Post by anonbeat »

Thank you. I will fix this asap.
tamalet
Posts: 490
Joined: Fri Sep 24, 2010 4:34 am

Error SQLite.

Post by tamalet »

LIKE '%revisar%
:)
User avatar
anonbeat
Posts: 2048
Joined: Thu Sep 16, 2010 9:47 pm

Error SQLite.

Post by anonbeat »

This should be fixed in svn revision 1439. Please try it and let me know

Thanks for your help

btw: I LIKE '%revisar%' too ;)
Jemay
Posts: 15
Joined: Fri Jan 14, 2011 6:43 am

Error SQLite.

Post by Jemay »

Gracias a ti anonbeat, te cuento que no he podido instalar esta revisión, no la encuentro desde Synaptic con este repositorio [http://ppa.launchpad.net/anonbeat/guayadeque/ubuntu], mi versión de linux es Ubuntu 10.04

Thanks to you anonbeat and I I tell you that I could not install this revision, I can not find it from Synaptic with this repository [http://ppa.launchpad.net/anonbeat/guayadeque/ubuntu], my linux version is Ubuntu 10.04

PD: Si le gusta "revisar" es porque hablas español ¿cierto?
User avatar
anonbeat
Posts: 2048
Joined: Thu Sep 16, 2010 9:47 pm

Error SQLite.

Post by anonbeat »

I just updated the packages to revision 1447. It will be available for download soon.

Thanks for your help

PD: Si, es porque hablamos español :)
Jemay
Posts: 15
Joined: Fri Jan 14, 2011 6:43 am

Error SQLite.

Post by Jemay »

Hola anonbeat, esta mañana actualice a la 1447 y funciona ok, muchas gracias...

Hi anonbeat, this morning I updated to 1447 and this works ok, thanks...
Linye
Posts: 33
Joined: Sat Oct 09, 2010 8:01 am

Error SQLite.

Post by Linye »

Quien mas habla español? :D
tamalet
Posts: 490
Joined: Fri Sep 24, 2010 4:34 am

Error SQLite.

Post by tamalet »

Somos muchos!
Locked