Column count doesn't match value count at row 1

[Linas Nenartavičius]

Hi, could you guys help me? Whem im trying to run new query in sql im getting:

Column count doesn't match value count at row 1 Error

Can you guys fix my codes ?


INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '0', '399996', '1', '1', '1', '1', '1', 'default', '1', '0', '0');

INSERT INTO `catalog_items` VALUES ('399996', '94', '399996', 'ads_background', '3', '0', '0', '1');

 

[Joe]

What emulator revision are you using? PlusEMU? R1? R2?

 

[Linas Nenartavičius]

Phoenix Phoenix v3.11.0 (Build 14986)

 

[Joe]

Phoenix Phoenix v3.11.0 (Build 14986)

That's why. You're using the R63B style to import into an R63A database lol. Can you show me what columns you've got in those 2 tables so I can change the queries for you?

 

[Linas Nenartavičius]

Umm, can you tell me how to show u these columns? Cz im newb on this, sorry abt that mate x

 

[Joe]

Open your catalog_items and furniture tables and show me the individual fields and how many there is. Here's an example of the R63B version, just open it in design view.

 

[Linas Nenartavičius]

my furni:

my cat items:

 

[Joe]

Try these.

INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '1', '399996', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0';

INSERT INTO `catalog_items` VALUES ('399996', '94', '399996', 'ads_background', '3', '0', '0', '1', '0', '0');

 

[Linas Nenartavičius]

INSERT INTO `catalog_items` VALUES ('399996', '94', '399996', 'ads_background', '3', '0', '0', '1', '0', '0'); - Added with no prob,


INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '1', '399996', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0';
on that getting error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

 

[Liam]

INSERT INTO `catalog_items` VALUES ('399996', '94', '399996', 'ads_background', '3', '0', '0', '1', '0', '0'); - Added with no prob,


INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '1', '399996', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0';
on that getting error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

INSERT INTO `furniture` VALUES ('399996', 'ads_background', 'ads_background', 's', '1', '1', '1.6', '1', '0', '1', '399996', '1', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0', '0');

Try this.

 

[Joe]

Not sure how I missed the ) sorry

 

[Linas Nenartavičius]

ty gonna check it,