#8 Issue with import userdata.sql to my database

[Lin Zhu]

Hi Dragos,

I'm having a issue when I'm following OpenIMS installation guide. When I do below lines:

mysql -u root -p -h localhost < ser_ims/cfg/icscf.sql
mysql -u root -p -h localhost < FHoSS/scripts/hss_db.sql
mysql -u root -p -h localhost < FHoSS/scripts/userdata.sql

There is an error only for the last line, in my terminal, it's showing:

ERROR 1136 (21S01) at line 41: Column count doesn't match value count at row 1

The 41 line in the userdata.sql is:

LOCK TABLES application_server WRITE;
/!40000 ALTER TABLE application_server DISABLE KEYS /;
INSERT INTO application_server VALUES (1,'default_as','sip:127.0.0.1:5065',0,'','presence.open-ims.test',1024,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
/!40000 ALTER TABLE application_server ENABLE KEYS /;
UNLOCK TABLES;

I'm a little despairing about this since I don't know much about database.
My system is Ubuntu 14.04, I run it on VMware workstation.
I also attached the userdata.sql file, too.
Please help me!

Thanks in advance
Lin Zhu

[Rob Day]

This is a duplicate of #5 - revision 1195 should fix this.