hello!

question: what versino are you using? did you made any upgade?
usually this problem is related to database tables being created wronlgy...

a way to solve it is to DELETE all muscol database tables and uninstall the component and the reinstall. but with this, you will loose all data... :S

is there a way you can see what FIELDS does the DB table "jos_muscol_artists" have?

Germi

Hello Germi,
i have 2.2.0 version of musiccol

I make a User for you in my website www.radiotubelive.com
if you want to try

USER: germi
PASS: 123456

PARAMETERS OF SERVER
PHP funcionando con: Linux hs-407.dedicated.hostalia.com 2.6.18-128.4.1.el5 #1 SMP Tue Aug 4 20:23:34 EDT 2009 i686
Versión de la base de datos: 5.0.45
Cotejamiento(collation): utf8_general_ci
Versión de PHP: 5.1.6
Servidor web: Apache/2.2.3 (Red Hat)
Interfaz PHP del servidor: apache2handler
Versión de Joomla!: Joomla! 1.5.12 Stable [ Wojmamni Ama Woi ] 01-July-2009 02:00 GMT
Agente: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB7.0; chromeframe/12.0.742.91; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; InfoPath.2; AskTbMPC2/5.11.0.15286)

BD FIELDS of jos_muscol_artists

campo tipo cotejamiento

id int(11)
artist_name varchar(255) utf8_general_ci
image varchar(127) utf8_general_ci
review mediumtext utf8_general_ci
letter varchar(1) utf8_general_ci
class_name varchar(255) utf8_general_ci
related varchar(63) utf8_general_ci
keywords varchar(512) utf8_general_ci
added datetime
hits int(11)
country varchar(255) utf8_general_ci
picture varchar(255) utf8_general_ci
user_id int(11)
metakeywords text utf8_general_ci
metadescription text utf8_general_ci


Thank you

well, the problem is, indeed, here.

these fields are missing in this table:

`city` varchar(255) NOT NULL,
`years_active` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`genre_id` int(11) NOT NULL,

I don't know why this fields were not correctly created... but the problem is this, for sure.

can you add this fields yourseld on the mysql table?

Germi

Solved!, the problem was that the database was missing fields jos_muscol_artist City, years_active, url and genre_id.

I opened my database and I've added the missing fields! and works perfect!.

Thank you.

GREAT!

Hello i have the same problem. I verified in my database and it was missing these fields:
`city` varchar(255) NOT NULL,
`years_active` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`genre_id` int(11) NOT NULL,

So i added them but i still have the "error saving artist". Please Help ??...
PS: i'm using joomla 2.5 and muscol_2.4.1_community_pro_2.5

this means that you were using a previous version of Music Collection on the same site.
when did you purchase it? your account says you purchased MC just 2 days ago, so that's not the one...

Yes that's true i purchased it 2 days ago. But before i had a joomla!1.5 muscol that i tried to install on the same site withtout knowing that was a joomla1.5 version. it evidently refused. So i purchased the 2.5 one and now it's well installed but i have the "error saving artist" problem...

but.. where did you get the previous version, in joomla 1.5? maybe the problem comes from there...

i downloaded it from http://www.filecrop.com

Yes i know.
No i haven't upgraded yet...

Yes! i did it and it works ! Thank you very much !!