Hi. Everytime I try to add a route I get this error message: There was an error adding the schedule, already exists DB error: Unknown column ‘maxload’ in ‘field list’. Can anyone tell me how to resolve this issue? Thank you.
You have either accidently double clicked the add schedule button, or you have not added any airports yet.
Cheers
Dan C
You have either accidently double clicked the add schedule button, or you have not added any airports yet.
Cheers
Dan C
I have triple checked everything. I am not hitting the button twice and all of my airports are added. Is there anything else it could be? Thanks.
I have triple checked everything. I am not hitting the button twice and all of my airports are added. Is there anything else it could be? Thanks.
Sounds like some files weren’t updated, since that column was removed. Can you run install/checkinstall.php?
Sounds like some files weren’t updated, since that column was removed. Can you run install/checkinstall.php?
I just noticed that even though I ran the update, it is still saying I need to run the update. I will try to run the update again.
I just noticed that even though I ran the update, it is still saying I need to run the update. I will try to run the update again.
What version are you on? Did you force the update? Can you paste the output from checkdb.php and checkinstall.php? Thanks
What version are you on? Did you force the update? Can you paste the output from checkdb.php and checkinstall.php? Thanks
I apologize for the really long delay in a reply, I have been extremely busy with AP classes. Anyways, how do I run both of those checks? When I type them into the browser bar neither works, I also apologize for being such a noob with this. Thank you.
I did force the update and according to the dashboard I am using version 2.0.854
I apologize for the really long delay in a reply, I have been extremely busy with AP classes. Anyways, how do I run both of those checks? When I type them into the browser bar neither works, I also apologize for being such a noob with this. Thank you.
I did force the update and according to the dashboard I am using version 2.0.854
No problem. Doesn’t seem like you’re on the latest version. Both of those files ar ein the /install folder
No problem. Doesn’t seem like you’re on the latest version. Both of those files ar ein the /install folder
Neither will run. I get an error message.
What’s the error message?
What’s the error message?
It’s technically not an error message, but when you try to run it, it goes straight to a search page with the address: http://err.000webhost.com
This is what I’m typing in the address bar: http://www.flypatrioteast.netai.net/install/checkdb.php
It’s technically not an error message, but when you try to run it, it goes straight to a search page with the address: http://err.000webhost.com
This is what I’m typing in the address bar: http://www.flypatrioteast.netai.net/install/checkdb.php
I would reupload the files my friend your database is OK but the files are giving the following errors,
Checking PHP version
[OK] PHP version is 5.2.x
Checking connectivity...
[OK] Can contact outside servers
Checking for SimpleXML module...
[OK] SimpleXML module exists!
Checking file hashes for corrupt or mismatched files
[Error] ../install/navdata.sql doesn't exist
[Checksum failed] /core/common/PIREPData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/jqgrid.class.php doesn't exist
[Checksum failed] /core/common/StatsData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/SchedulesData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/NavData.class.php doesn't exist
[Checksum failed] /core/common/FuelData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/DownloadData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/OperationsData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/OFCharts.class.php doesn't exist
[Error] ../core/templates/profile_badge.tpl doesn't exist
[Checksum failed] /core/templates/schedule_results.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_summarysheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/contact_form.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/core_htmlhead.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_header.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/core_navigation.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_balancesheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pirep_new.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pilots_list.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pilot_public_profile.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/schedule_details.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/codon.config.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/Vars.class.php did not match, possibly corrupt or out of date
[Error] ../core/classes/CodonCache.class.php doesn't exist
[Checksum failed] /core/classes/TemplateSet.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/CodonRewrite.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/CodonModule.class.php did not match, possibly corrupt or out of date
[Error] ../core/classes/ezdb/ezdb_base.class.php doesn't exist
[Error] ../core/classes/ezdb/ezdb_mysql.class.php doesn't exist
[Error] ../core/hooks/client/post-load.php doesn't exist
[Error] ../core/hooks/system/postmoduleload.php.1 doesn't exist
[Checksum failed] /core/modules/Schedules/Schedules.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/XML/XML.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Profile/Profile.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Downloads/Downloads.php did not match, possibly corrupt or out of date
[Error] ../core/modules/kACARS_Free/kACARS_Free.php doesn't exist
[Checksum failed] /core/modules/ACARS/fspax.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/ACARS/xacars.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/PIREPS/PIREPS.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Pages/Pages.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/RouteMap/RouteMap.php did not match, possibly corrupt or out of date
[Error] ../admin/maintenance.php doesn't exist
[Checksum failed] /admin/templates/sidebar_dashboard.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_airlineslist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/export_form.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_detailtabs.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/groups_grouplist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/downloads_overview.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_expenseform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_header.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_airlineform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_aircraftlist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/settings_addcustomfield.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_schedules.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/vacentral_index.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_viewallbids.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_scheduleform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/core_navigation.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_balancesheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_awards.tpl did not match, possibly corrupt or out of date
[Error] ../admin/templates/maintenance_changepilotid.tpl doesn't exist
[Checksum failed] /admin/templates/reports_aircraft.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/sidebar_ranks.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_expenselist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/settings_mainform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/downloads_downloadform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/lib/phpvmsadmin.js did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Finance/Finance.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/PilotAdmin/PilotAdmin.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Downloads/Downloads.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/SiteCMS/SiteCMS.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Import/Import.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Maintenance/Maintenance.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/PIREPAdmin/PIREPAdmin.php did not match, possibly corrupt or out of date
PHP Error Message
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/lib/js/jquery.form.js) is not within the allowed path(s): (/home/:/usr/lib/php:/tmp) in /home/a3247520/public_html/install/checkinstall.php on line 140
Free Web Hosting
[Error] /lib/js/jquery.form.js doesn't exist
-- Checked 182 files, found 76 errors
You’re also on a free host which can/will cause problems
I would reupload the files my friend your database is OK but the files are giving the following errors,
Checking PHP version
[OK] PHP version is 5.2.xChecking connectivity…
[OK] Can contact outside serversChecking for SimpleXML module…
[OK] SimpleXML module exists!Checking file hashes for corrupt or mismatched files
[Error] ../install/navdata.sql doesn’t exist
[Checksum failed] /core/common/PIREPData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/jqgrid.class.php doesn’t exist
[Checksum failed] /core/common/StatsData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/SchedulesData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/NavData.class.php doesn’t exist
[Checksum failed] /core/common/FuelData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/DownloadData.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/common/OperationsData.class.php did not match, possibly corrupt or out of date
[Error] ../core/common/OFCharts.class.php doesn’t exist
[Error] ../core/templates/profile_badge.tpl doesn’t exist
[Checksum failed] /core/templates/schedule_results.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_summarysheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/contact_form.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/core_htmlhead.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_header.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/core_navigation.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/finance_balancesheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pirep_new.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pilots_list.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/pilot_public_profile.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/templates/schedule_details.tpl did not match, possibly corrupt or out of date
[Checksum failed] /core/codon.config.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/Vars.class.php did not match, possibly corrupt or out of date
[Error] ../core/classes/CodonCache.class.php doesn’t exist
[Checksum failed] /core/classes/TemplateSet.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/CodonRewrite.class.php did not match, possibly corrupt or out of date
[Checksum failed] /core/classes/CodonModule.class.php did not match, possibly corrupt or out of date
[Error] ../core/classes/ezdb/ezdb_base.class.php doesn’t exist
[Error] ../core/classes/ezdb/ezdb_mysql.class.php doesn’t exist
[Error] ../core/hooks/client/post-load.php doesn’t exist
[Error] ../core/hooks/system/postmoduleload.php.1 doesn’t exist
[Checksum failed] /core/modules/Schedules/Schedules.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/XML/XML.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Profile/Profile.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Downloads/Downloads.php did not match, possibly corrupt or out of date
[Error] ../core/modules/kACARS_Free/kACARS_Free.php doesn’t exist
[Checksum failed] /core/modules/ACARS/fspax.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/ACARS/xacars.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/PIREPS/PIREPS.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/Pages/Pages.php did not match, possibly corrupt or out of date
[Checksum failed] /core/modules/RouteMap/RouteMap.php did not match, possibly corrupt or out of date
[Error] ../admin/maintenance.php doesn’t exist
[Checksum failed] /admin/templates/sidebar_dashboard.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_airlineslist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/export_form.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_detailtabs.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/groups_grouplist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/downloads_overview.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_expenseform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_header.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_airlineform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_aircraftlist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/settings_addcustomfield.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_schedules.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/vacentral_index.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_viewallbids.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/ops_scheduleform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/core_navigation.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_balancesheet.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/pilots_awards.tpl did not match, possibly corrupt or out of date
[Error] ../admin/templates/maintenance_changepilotid.tpl doesn’t exist
[Checksum failed] /admin/templates/reports_aircraft.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/sidebar_ranks.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/finance_expenselist.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/settings_mainform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/templates/downloads_downloadform.tpl did not match, possibly corrupt or out of date
[Checksum failed] /admin/lib/phpvmsadmin.js did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Finance/Finance.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/PilotAdmin/PilotAdmin.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Downloads/Downloads.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/SiteCMS/SiteCMS.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Import/Import.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/Maintenance/Maintenance.php did not match, possibly corrupt or out of date
[Checksum failed] /admin/modules/PIREPAdmin/PIREPAdmin.php did not match, possibly corrupt or out of datePHP Error Message
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/lib/js/jquery.form.js) is not within the allowed path(s): (/home/:/usr/lib/php:/tmp) in /home/a3247520/public_html/install/checkinstall.php on line 140
Free Web Hosting
[Error] /lib/js/jquery.form.js doesn’t exist– Checked 182 files, found 76 errors
You’re also on a free host which can/will cause problems
Thank you to the both of you. Although it’s possible, I don’t think that the host is the issue as I had a phpvms site set up with them before and it worked perfectly fine. I will reupload the files and see what it does.
Thank you to the both of you. Although it’s possible, I don’t think that the host is the issue as I had a phpvms site set up with them before and it worked perfectly fine. I will reupload the files and see what it does.
I re-uploaded the files and now it works…partially. It says the route has been added, but it doesn’t show up in the list. I also noted that the tables have a slightly new look to them if that tells you anything…they look more sleek in a way. Thank you.
I re-uploaded the files and now it works…partially. It says the route has been added, but it doesn’t show up in the list. I also noted that the tables have a slightly new look to them if that tells you anything…they look more sleek in a way. Thank you.
In local.config.php, cna you enable DEBUG_MODE (set it to true)
Then try adding a route, just browse around. Then can you see if there’s anything the core/logs/log.txt file
In local.config.php, cna you enable DEBUG_MODE (set it to true)
Then try adding a route, just browse around. Then can you see if there’s anything the core/logs/log.txt file
It won’t let me chmod the local.config.php so that i can change debug mode to on, i remember having trouble with chmod before, but I don’t remember how I resolved it
It won’t let me chmod the local.config.php so that i can change debug mode to on, i remember having trouble with chmod before, but I don’t remember how I resolved it
Also if its a hint to why adding but not showing the routes, all my graphs now look really, really weird and on the x axis near where zero would be it says infinity. Thank you.
Thank you to the both of you. Although it’s possible, I don’t think that the host is the issue as I had a phpvms site set up with them before and it worked perfectly fine. I will reupload the files and see what it does.
I had that hosting too and with the last version of phpvms i couldnt get it to work correctly dont know why since i never had problems with them before im on another free hosting and so far no problems at all
Alright Nabeel, I got everything working correctly with chmodding and everything. I turned on debug mode. In the log file there was this after I tried adding a route (same problem: says its added but no route shows up):
=====
Time:
=====
Time: 05.22.10 00:04:32
Backtrace: DB::write_debug > DB::get_results > SettingsData::getAllSettings > SiteData::loadSiteSettings > pre_module_load > include
Query: SELECT * FROM phpvms_settings
Error: (1053) - Server shutdown in progress
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:32
Backtrace: DB::write_debug > DB::get_row > Auth::get_session > Auth::StartAuth > pre_module_load > include
Query: SELECT * FROM phpvms_sessions WHERE id = ‘35’ AND pilotid = ‘1’
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:32
Backtrace: DB::write_debug > DB::query > Auth::start_session > Auth::StartAuth > pre_module_load > include
Query: INSERT INTO phpvms_sessions (pilotid, ipaddress, logintime) VALUES (0,‘96.230.200.110’, NOW())
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > SiteData::GetAllPages > Pages->NavBar > MainController::Run > MainController::loadModules > MainController::loadEngineTasks > include
Query: SELECT * FROM phpvms_pages WHERE enabled=1 AND public=1
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > StatsData::UsersOnline > Frontpage->index > call_user_func_array > MainController::RunAllActions
Query: SELECT p.* FROM phpvms_pilots p, phpvms_sessions s WHERE s.pilotid = p.pilotid AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.logintime
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > StatsData::GuestsOnline > Frontpage->index > call_user_func_array > MainController::RunAllActions
Query: SELECT s.* FROM phpvms_sessions s WHERE s.pilotid = 0 AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.logintime
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > News->ShowNewsFront > call_user_func_array > MainController::Run > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Frontpage->index > call_user_func_array > MainController::RunAllActions
Query: SELECT id, subject, body, postedby, UNIX_TIMESTAMP(postdate) AS postdate FROM phpvms_news ORDER BY postdate DESC LIMIT 5
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getRecentReportsByCount > PIREPS->RecentFrontPage > call_user_func_array > MainController::Run > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Frontpage->index > call_user_func_array > MainController::RunAllActions
Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid ORDER BY p.submitdate DESC LIMIT 5
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:04:33
Backtrace: DB::write_debug > DB::get_results > PilotData::getLatestPilots > Pilots->RecentFrontPage > call_user_func_array > MainController::Run > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Frontpage->index > call_user_func_array > MainController::RunAllActions
Query: SELECT * FROM phpvms_pilots ORDER BY pilotid DESC LIMIT 5
Error: (2006) - MySQL server has gone away
=====
=====
=====
Time:
=====
Time: 05.22.10 00:06:23
Backtrace: DB::write_debug > DB::get_results > StatsData::TotalFlightsToday > include > TemplateSet->getTemplate > TemplateSet->showTemplate
Query: SELECT COUNT(*) AS total FROM phpvms_pirepsDATE(submitdate) = CURDATE()
Error: (1064) - 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 ‘(submitdate) = CURDATE()’ at line 1
=====
=====