11-28-2012, 09:56 PM
(11-28-2012, 05:44 PM)John_k22 Wrote: Hi Uwe, input the line and got th following messageThe last insert statement must be the problem. Can you take you favorite mysql client and execute it. The statements looks right but somethink must go wrong, so maybe you get an error message when executing it on its own.
Code:(mysql): INSERT INTO tblDocuments (name, comment, date, expires, owner, folder, folderList, inheritAccess, defaultAccess, locked, keywords, sequence) VALUES ('ddd', '', 1354103919, 0, 1, 1,':1:', 1, 2, -1, '', 1)
(mysql): SELECT LAST_INSERT_ID()
(mysql): SELECT * FROM tblDocuments WHERE id = 3
(mysql): SELECT * FROM tblDocumentLocks WHERE document = 3
(mysql): INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (3, 1,'', 1354103919, 1, '3/', 'Neu Textdokument (5).txt', '.txt', 'text/plain')
(mysql): DELETE FROM tblDocuments WHERE id = 3
John
Uwe