1. Beatrix Willius
  2. Valentina Database ADK
  3. Donnerstag, Januar 07 2016, 01:45 PM
  4.  Abonnieren via E-Mail
Hi,

what does the above error mean? I can't find it in the Valentina errors. The SQL from the error is similar to

update Message set MailboxID = (select Mailbox.recid from Mailbox where Mailbox.MailboxPath = 'Mailboxes:::Importiert:::Test Mails:::\\MIME MAILS') where RecID in ('25','26','19','9','28','8','10','29')

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi,

DECLARE_ERROR( ERR_SQL_PARSER_ERROR, 0x71000);

Something wrong in SQL query.
Please add issue to Mantis.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
We have SQL command MAIL ... please check that you do not use keywords
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
I'm not seeing any keyword in the query. And then I'd get a different error I think. The problem is very strange:

- Either no record is changed.
- Or I get the VException.
- The exact same query works in Valentina Studio.

I've removed the apostrophs from the query (what was I thinking there???). But the problem remains the same:

update Message set MailboxID = (select Mailbox.recid from Mailbox where Mailbox.MailboxPath = 'Mailboxes:::Importiert:::Test Mails:::\\MIME MAILS:::tag test') where RecID in (8)

Unfortunately, this query is my drag-and-drop functionality.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Resolved ... see mantis.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories