All pastes #482424 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-11 07:41 UTC
rendered paste body
Mysql Query 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 'NOW()', 'INTERVAL 30 DAY')', 'NOW()')' at line 4
SQL Query: INSERT INTO reoccuring_work_orders ( `uid`, `wid`, `wtype`, `wdescription`, `status`, `notes`, `last_billed_date`, `next_billing_date`, `wo_date`) VALUES ('39', '', '6', 'rebill', '', '', 'NOW()', 'ADDDATE('NOW()', 'INTERVAL 30 DAY')', 'NOW()')
Line: 212
Function: execute_query
File: /var/www/html/helpdesk/global/db_class.inc.php

INSERT INTO reoccuring_work_orders ( `uid`, `wid`, `wtype`, `wdescription`, `status`, `notes`, `last_billed_date`, `next_billing_date`, `wo_date`) VALUES ('39', '', '6', 'rebill', '', '', 'NOW()', 'ADDDATE('NOW()', 'INTERVAL 30 DAY')', 'NOW()')