Sign in to follow this  
Followers 0
BeloffHost

[SOLVED] Custom script with extdb

4 posts in this topic

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

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites
Advertisement
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.

Share this post


Link to post
Share on other sites

We have closed this thread and marked it as solved.

Share this post


Link to post
Share on other sites
Advertisement
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.