MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  "invalid date format" when leaving date field empty !?          MySQLTalk.org Forum Index -> Eventum General Discussion View previous topic :: View next topic   Author Message Guest Posted: Mon Dec 15, 2008 7:24 pm    Post subject: "invalid date format" when leaving date field empty !? Hi all Can you please point me in the right direction on how to solved this annoying error ! Happens every time I leave my custom field "Due Date" empty ! The field is not mandatory ! An error was found on line '370' of script 'E:\Inetpub\wwwroot\eventum\include\class.custom_field.php'. The error message passed to us was: 'DB Error: unknown error' A more detailed error message follows: 'INSERT INTO eventum.eventum_issue_custom_field ( icf_iss_id, icf_fld_id, icf_value_date ) VALUES ( 5406, 2, '--' ) [nativecode=1292 ** Incorrect date value: '--' for column 'icf_value_date' at row 1]' A backtrace is available: E:\Inetpub\wwwroot\eventum\include\class.issue.php:2283 Custom_Field::associateIssue((integer )5406, (integer )2, (array )Array) E:\Inetpub\wwwroot\eventum\new.php:71 Issue::insert() Regards Flemming Back to top Nathaniel Shutters Guest Posted: Mon Dec 15, 2008 11:40 pm    Post subject: Cron Job lock file Hi all, My Eventum setup has been working fine for a few days now and then over the weekend it stopped sending out emails. When I run the cron job I get this error (ERROR: There is already a process (pid=6659) of this script running. If this is not accurate, you may fix it by running this script with '--fix-lock') Now I tried to do what the error says to do but it keeps telling me that its invalid syntax. Any ideas? Nathaniel Shutters Network Coordinator (607) 286-7171 Helpdesk x202 Springbrook Back to top Jorey Bump Guest Posted: Tue Dec 16, 2008 12:18 am    Post subject: Re: Cron Job lock file Nathaniel Shutters wrote, at 12/15/2008 12:40 PM: Quote: Hi all, My Eventum setup has been working fine for a few days now and then over the weekend it stopped sending out emails. When I run the cron job I get this error (ERROR: There is already a process (pid=6659) of this script running. Show us your cron entry. Quote: If this is not accurate, you may fix it by running this script with '--fix-lock') Now I tried to do what the error says to do but it keeps telling me that its invalid syntax. Any ideas? Show us the command you are running so we can check the syntax. Back to top Nathaniel Shutters Guest Posted: Tue Dec 16, 2008 12:20 am    Post subject: RE: Cron Job lock file cd /usr/share/eventum/misc; php -f process_mail_queue.php The invalid synatax comes when I try to put --fix-lock in to that current job. Nathaniel Shutters Network Coordinator (607) 286-7171 Helpdesk x202 Springbrook -----Original Message----- From: Jorey Bump [mailto:list (AT) joreybump (DOT) com] Sent: Monday, December 15, 2008 1:18 PM To: Nathaniel Shutters Cc: eventum-users (AT) lists (DOT) mysql.com Subject: Re: Cron Job lock file Nathaniel Shutters wrote, at 12/15/2008 12:40 PM: Quote: Hi all, My Eventum setup has been working fine for a few days now and then over the weekend it stopped sending out emails. When I run the cron job I get this error (ERROR: There is already a process (pid=6659) of this script running. Show us your cron entry. Quote: If this is not accurate, you may fix it by running this script with '--fix-lock') Now I tried to do what the error says to do but it keeps telling me that its invalid syntax. Any ideas? Show us the command you are running so we can check the syntax. Back to top Jorey Bump Guest Posted: Tue Dec 16, 2008 1:55 am    Post subject: Re: Cron Job lock file Nathaniel Shutters wrote, at 12/15/2008 01:20 PM: Quote: cd /usr/share/eventum/misc; php -f process_mail_queue.php That's not a complete crontab entry. It should look something like this: */5 * * * * /usr/bin/php -f /path/to/eventum/misc/process_mail_queue.php Until you show us your complete entry, we have no idea how often you are running the job, or if your syntax is correct. Note that you should not run this script more frequently than every 5 minutes or you may experience lock issues. Some environments may even need to slow that down to every 10 or 15 minutes. If that isn't enough time, you may have other problems. Quote: The invalid synatax comes when I try to put --fix-lock in to that current job. Please don't merely describe what you're doing; paste the exact, complete text of the command you are running. It's usually unnecessary to run this from cron, as you can easily type it once on the command line to fix the problem. You may want to fix your crontab entry first, though, or it might just lock again. Also, make sure you are using the correct php if you have multiple versions installed. Use the full path to the command. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> Eventum General Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.