No Writing in Database

[MypowerHD]

Hello I have big problems with extDB2 customs.

---

Db Costoums

`;;______________________________________________________________
[DYNMARKET_Price_Set]
;;

SQL1_1 = UPDATE dynmarket SET prices = ? WHERE id=1;

SQL1_INPUTS = 1-AltisLifeRPG_Array
Number of Inputs = 1

;;______________________________________________________________
[DYNMARKET_Price_Get]
;;

SQL1_1 = SELECT prices FROM dynmarket WHERE id=1;

OUTPUT = 1-AltisLifeRPG_Array

---

Error Log

`> extDB2: Version: 70

extDB2: https://github.com/Torndeco/extDB2
extDB2: Linux Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15

extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads

[06:51:49 +01:00] [Thread 32651] extDB2: Database Type: MySQL
[06:51:49 +01:00] [Thread 32651] extDB2: Database Session Pool Started
[06:51:49 +01:00] [Thread 32651] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[06:51:49 +01:00] [Thread 318] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: 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 'DYNMARKET_Price_Get' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: DYNMARKET_Price_Get
[06:51:49 +01:00] [Thread 318] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Get
[06:55:15 +01:00] [Thread 321] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: 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 'DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["ornate_grilled",190,0],["mackerel_raw",190,0],["mackerel_grilled",190,0],["tuna_raw",190,0],["tuna_grilled",190,0],["mullet_raw",190,0],["mullet_fried",200,0],["catshark_raw",200,0],["catshark_Fried",200,0],["turtle_soup",200,0],["hen_raw",200,0],["hen_fried",200,0],["rooster_raw",210,0],["sheep_raw",210,0],["sheep_grilled",155,0],["goat_raw",155,0],["goat_grilled",300,0],["redgull",1500,0],["coffee",10,0],["waterBottle",10,0],["pickaxe",350,0],["fuelFull",500,0],["spikeStrip",1200,0],["lockpick",75,0],["goldbar",95000,0],["blastingcharge",35000,0],["boltcutter",7500,0],["defusekit",2500,0],["storagesmall",75000,0],["storagebig",15000,0],["oil_processed",1200,0],["copper_refined",1700,0],["iron_refined",1650,0],["salt_refined",1850,0],["glass",1450,0],["diamond_cut",2530,0],["cement",2350,0],["heroin_processed",5000,0],["marijuana",5250,0],["cocaine_processed",5300,0]]
[06:55:15 +01:00] [Thread 321] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["ornate_grilled",190,0],["mackerel_raw",190,0],["mackerel_grilled",190,0],["tuna_raw",190,0],["tuna_grilled",190,0],["mullet_raw",190,0],["mullet_fried",200,0],["catshark_raw",200,0],["catshark_Fried",200,0],["turtle_soup",200,0],["hen_raw",200,0],["hen_fried",200,0],["rooster_raw",210,0],["sheep_raw",210,0],["sheep_grilled",155,0],["goat_raw",155,0],["goat_grilled",300,0],["redgull",1500,0],["coffee",10,0],["waterBottle",10,0],["pickaxe",350,0],["fuelFull",500,0],["spikeStrip",1200,0],["lockpick",75,0],["goldbar",95000,0],["blastingcharge",35000,0],["boltcutter",7500,0],["defusekit",2500,0],["storagesmall",75000,0],["storagebig",15000,0],["oil_processed",1200,0],["copper_refined",1700,0],["iron_refined",1650,0],["salt_refined",1850,0],["glass",1450,0],["diamond_cut",2530,0],["cement",2350,0],["heroin_processed",5000,0],["marijuana",5250,0],["cocaine_processed",5300,0]]
[06:58:15 +01:00] [Thread 32651] extDB2: Stopping ...
`

[serverarma]

same here how do you fix it?

[leohubert]

If you use a 4.3 or 4.4 version you need to follow this tutorial, because the altis-life.ini is not used form the 4.3 life version.

https://github.com/RyanTT/DynamicMarket/tree/29eec6d52f01b63bbe61e9fa87fe0458c83c758e