[SOLVED] Custom script with extdb

[BeloffHost 0]

I am creating custom script for my server. I am receiving this error in extdb:

[12:00:05:618473 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_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 'to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: SELECT id,to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?
[12:00:05:618500 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:00:05:618517 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: getMailsList:76561198199795037

In exile.ini request is:

[getMailsList]
SQL1_1 = SELECT id,to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?
Number Of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1,2-STRING,3-STRING,4-STRING,5-STRING,6-STRING,7-STRING,8-STRING

[Dragonslayer10 24]

On 12/29/2016 at 5:03 AM, BeloffHost said:

I am creating custom script for my server. I am receiving this error in extdb:

[12:00:05:618473 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_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 'to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: SELECT id,to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?
[12:00:05:618500 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
[12:00:05:618517 +03:00] [Thread 3432] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: getMailsList:76561198199795037

In exile.ini request is:

[getMailsList]
SQL1_1 = SELECT id,to,from,title,message,linked_item,linked_type,date FROM mail WHERE to = ?
Number Of Inputs = 1
SQL1_INPUTS = 1
OUTPUT = 1,2-STRING,3-STRING,4-STRING,5-STRING,6-STRING,7-STRING,8-STRING

In order to help you might want to explain what you added with your script or any information about that. Your error message doesn't really help seeing how it doesn't show anything... Just my two cents.

 

[BeloffHost 0]

15 hours ago, Dragonslayer10 said:

In order to help you might want to explain what you added with your script or any information about that. Your error message doesn't really help seeing how it doesn't show anything... Just my two cents.

 

Doesn't matter. Everything works now. Thread can be closed.

[ka0s 457]

We have closed this thread and marked it as solved.