[Err] 1064 - You have an error in your SQL syntax; When trying to add furni

[adz]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `furniture`
VALUES
(
'10384',
'xmas_c18_doll7',
'xmas_c1' at line 1

when running the sql

INSERT INTO `furniture` VALUES ('10384', 'xmas_c18_doll7', 'xmas_c18_doll7 name', 's', '1', '1', '1', '1', '0', '0', '10384', '1', '1', '1', '1', '1', 'default_type', '4', '0', '0', '0', '0', '0', '0', '0');

EMU running > PLUS EMU
Navi cat <3

 

[Joe]

Check to see if the query matches up with amount of columns in the table. If not, add or delete them

 

[adz]

@JMG still nothing

 

[Joe]

Is there 25 columns?

 

[adz]

Yeah there's 25 columns in the SQL im putting but 26 columns that's probably the problem cheers again joe x

 

[adz]

You must be registered for see images attach

@JMG do you know how to fix this?

 

[Menkz]

Have you put the furniture in hof_furni

 

[adz]

Yeah it's in there.

Here's my furni data;
furnitype id="10384" classname="xmas_c18_doll7.swf"><revision>59005</revision><defaultdir>0</defaultdir><xdim>2</xdim><ydim>6</ydim><partcolors /><name>xmas_c18_doll7 name</name><description>xmas_c18_doll7 desc</description><adurl></adurl><offerid>-1</offerid><buyout>0</buyout><rentofferid>-1</rentofferid><rentbuyout>0</rentbuyout><bc>0</bc><excludeddynamic>0</excludeddynamic><customparams></customparams><specialtype>1</specialtype><canstandon>1</canstandon><cansiton>0</cansiton><canlayon>0</canlayon></furnitype>

 

[Menkz]

Change it to

<furnitype id="10384" classname="xmas_c18_doll7">
<revision>64503</revision>
<defaultdir>0</defaultdir>
<xdim>1</xdim>
<ydim>1</ydim>
<partcolors/>
<name>Snowman Matroyoshka Doll</name>
<description>xmas_c18_doll7 desc</description>
<adurl/>
<offerid>-1</offerid>
<buyout>0</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>0</bc>
<excludeddynamic>0</excludeddynamic>
<customparams/>
<specialtype>1</specialtype>
<canstandon>0</canstandon>
<cansiton>0</cansiton>
<canlayon>0</canlayon>
<furniline>xmas2018</furniline>
</furnitype>

 

[Joe]

Is the SWF added? Have you purged the cache in Cloudflare and cleared your cache in your browser?

 

[adz]

Cloudflare purged, cleared cache, updated code, still nothing. SWF is added to this file location; C:\inetpub\wwwroot\swfs\dcr\hof_furni

 

[Menkz]

Do you have a link I can visit? PM me

 

[Joe]

Have you tried buying it and placing it down? The icon might not exist, that’s all.

 

[adz]

You must be registered for see images attach

 

[Joe]

Are you using an SWF with graphics tags?

 

[adz]

yeah from *****

 

[Joe]

Should work then, if it has all been added properly. Usually does this when the cache hasn’t been purged or cleared.

 

[adz]

This is well annoying ahahahaha!

 

[Menkz]

I think I've discovered the issue, just the furnidata & product data weren't updated correctly.