generator-debug log

null
Select distinct recordid,if(isnull(TIMESTAMP),"",CONCAT(TIMESTAMP," ",SAVE_ACTION)) ,if(isnull(CONTENT),"",CONCAT(USER," - ",CONTENT)),USER,SAVE_ACTION from MESSAGE_VIEW0 where parent_recordid = D order by TIMESTAMP DESC
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'D' in 'where clause'
]);

null
Select distinct null from null where (status='A' or  status='D' or  status='F' or  status='R'  or status='P')  and (  (false  or ( DOC_NO like '%competition%')  or ( NO_2 like '%competition%')  or ( NAME like '%competition%') ))   order by null limit 25 offset 0
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'null where (status='A' or  status='D' or  status='F' or  status='R'  or status='' at line 1
]);

jQuery19108735514129512012_1430359737833([
['1419391286546',' HP ProDesk 600 G1 TWR<z><z>- Intel Core i7-4790 3.6G 8M HD 4600 CPU<z><z>- 4GB DDR3-1600 DIMM (1x4GB) RAM<z><z>- 1TB 7200 RPM 3.5 Hard Drive<z><z>- 1TB 7200 RPM 3.5 2nd Hard Drive<z><z>- AMD Radeon R9 255 2GB PCIe x16 GFX<z><z>- Slim SuperMulti Optical Disc Drive<z><z>- HP USB Keyboard - Win Taiwan<z><z>- HP USB Mouse<z><z>- Windows 7 Professional 32 bit OS DVD+ DRDVD<z><z>- Windows 7 Professional 64 bit OS DVD+ DRDVD<z><z>- Preload Microsoft Windows 7 Professional 32 bit (Traditional Chinese)'
Select distinct RECORDID,DESCRIPTION from SALES_ORDER_INV_DESC where 1=1  order by DESCRIPTION
java.sql.SQLException: Column Index out of range, 3 > 2. 
]);

you are only selecting a single column, yet you are trying to access the third column in your result.

Change getString(3) to getString(1) and you should be fine.

user action 
DATALOCK;
DATALOCK_HISTORY;

SELECT USER,TIMESTAMP FROM DB_LOG_BAK00  WHERE DATE(TIMESTAMP)=CURDATE() ;

view user login 

select login_time, login_date , login_id from erp.USER ORDER BY LOGIN_DATE;

database

select LOG  from DB_LOG WHERE DATE(TIMESTAMP)=CURDATE() AND LOG LIKE'%EXCEPT%';

select timestamp from DB_LOG WHERE DATE(TIMESTAMP)=CURDATE();
delete from GRN_LINE where  = 1425438570590 ;

SELECT LOG FROM DB_LOG WHERE LOG LIKE '%SQLException%'
AND  DATE(TIMESTAMP)=CURDATE()
;

MySQLSyntaxErrorException:view' doesn't exist
java.sql.SQLException: Lock wait timeout exceeded
java.sql.SQLException: Data truncated
java.sql.SQLException: Incorrect integer value:


javascript

var myWindowxx = window.open('', 'MsgWindow','_blank');
myWindowxx.document.write('abcd');

SELECT LOG FROM DB_LOG WHERE REC_NO=63;


/**************************/

DNOTE_NO='DNTP01503007'
RECORDID=1420525755409

SOHD_DNBODYOS.DESCRIPTION
<- SOHD_DNBODY <- SODNBODY < - DNBODY

SELECT DESCRIPTION FROM DNOTE_LINE WHERE DESCRIPTION LIKE '%GW%';
SELECT DN_DESC FROM DNBODY WHERE DN_DESC LIKE '%GW%';
SELECT DN_DESC FROM SODNBODY WHERE DN_DESC LIKE '%GW%';
SELECT DN_DESC FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW%';


SELECT DN_DESC FROM SOHD_DNBODYOS WHERE DN_DESC LIKE '%GW%';

SELECT DN_NO, DN_DESC,QD_NO FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW%'

SELECT DN_DESC,QD_NO,DNQTY,INVQTY FROM SOHD_DNBODY WHERE DN_DESC LIKE '%GW

SELECT QD_NO FROM SOHD_DNBODY WHERE QD_NO LIKE '%4125%'

SELECT QD_NO FROM SALES_ORDER_HEAD WHERE QD_NO LIKE '%4125%';

SELECT DNOTE_LINE.USER, DNOTE_LINE.TIMESTAMP,DNOTE_LINE.RECORDID,SO_RECORDID,SALES_ORDER_INV_DESC.RECORDID FROM DNOTE_LINE
LEFT JOIN SALES_ORDER_INV_DESC ON SALES_ORDER_INV_DESC.RECORDID=DNOTE_LINE.SO_RECORDID
WHERE DNOTE_LINE.PARENT_RECORDID=1420525755409;

SELECT RECORDID FROM SALES_ORDER_HEAD WHERE SALES_ORDER='SOTP01503001'; // 1420193987163
 SELECT RECORDID FROM SALES_ORDER_INV_DESC WHERE PARENT_RECORDID=1420193987163; //1420774626655
 SELECT * FROM DNOTE_LINE WHERE SO_RECORDID=1420774626655;



SELECT * FROM DNOTE_LINE WHERE SO_RECORDID=1420444533025;
SELECT RECORDID FROM SALES_ORDER_INV_DESC WHERE RECORDID=1420444533025;

UPDATE DNOTE_LINE SET SO_RECORDID=1420774626655 WHERE RECORDID=1420525762175;