error when putting in custom bases !

[andy1978]

I just wanted to ask is they a limit on how many bases and custom buildings you place on map ? I got this error code ? #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 ''[0,[' at line 1 , has anyone else had this error and how can I fix it , thanks for your time

 

[Hoplit]

Could you post, or send me in pm the code you want to put in?

 

[Deathcall]

I've done some extensive additions and never hit a "cap" for base building, disregarding performance of course.

I'd say you made a mistake somewhere. Hoplit is right, we need to see your code.

 

[andy_1978]

hear is the code that comes up , , ERROR: Unclosed quote @ 227
STR: '
SQL:

INSERT INTO `bliss_1725`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','1725','[0,[3316.78,14205.72]]'), ('1','1725','[0,[3288.07,14224.45]]'), ('1','1725','[0,[3302.1,14214.48]]'), ('1','1725','[

INSERT INTO `bliss_1725`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','1725','[0,[3316.78,14205.72]]'), ('1','1725','[0,[3288.07,14224.45]]'), ('1','1725','[0,[3302.1,14214.48]]'), ('1','1725','[
MySQL said:

#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 ''[' at line 1



hope this helps !!!

 

[Hoplit]

INSERT INTO `bliss_1725`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','1725','[0,[3316.78,14205.72]]'), ('1','1725','[0,[3288.07,14224.45]]'), ('1','1725','[0,[3302.1,14214.48]]'), ('1','1725','[

Is this the full code?

 

[andy_1978]

that's the error it gives us when we try to put a extra custom base in

 

[andy_1978]

this is my teamspeak 178.33.179.46:18719 if you can help us ill pay you , thanks again mate for your time

 

[andy_1978]

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unclosed quote @ 227
STR: '
SQL:
INSERT INTO `bliss_1725`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','1725','[0,[3316.78,14205.72]]'), ('1','1725','[0,[3288.07,14224.45]]'), ('1','1725','[0,[3302.1,14214.48]]'), ('1','1725','[
SQL query:
INSERT INTO `bliss_1725`.`instance_building` (`building_id`, `instance_id`, `worldspace`) VALUES ('1','1725','[0,[3316.78,14205.72]]'), ('1','1725','[0,[3288.07,14224.45]]'), ('1','1725','[0,[3302.1,14214.48]]'), ('1','1725','[
MySQL said:
#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 ''[' at line 1

 

[Deathcall]

I'm guessing you are trying to add these buildings through the database.

I'm not very familiar with this method, I'd have to see your tables and do some trial and error to find out the problem.

I'll recommend an alternative though. Try the mission method or the script method.

 

[Excelsior]

'[0,[3302.1,14214.48]]'), ('1','1725','[

The end of your line is not closed properly.

 

[Rossymond]

To have another option, you can just use the mission file, adding an SQF file such as "Buildings.sqf" then adding the line

[] ExecVM "buildings.sqf";

To the end of init.sqf

I do this for each individual group/town of additions, this means I can comment out anything I am working on, and it tends to keep things a little easier to manage