patva1 Posted April 24, 2010 Report Share Posted April 24, 2010 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. Quote Link to comment Share on other sites More sharing options...
Strider Posted April 24, 2010 Report Share Posted April 24, 2010 You have either accidently double clicked the add schedule button, or you have not added any airports yet. Cheers Dan C Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 2, 2010 Author Report Share Posted May 2, 2010 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. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 2, 2010 Administrators Report Share Posted May 2, 2010 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? Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 5, 2010 Author Report Share Posted May 5, 2010 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. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 5, 2010 Administrators Report Share Posted May 5, 2010 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 Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 20, 2010 Administrators Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 20, 2010 Administrators Report Share Posted May 20, 2010 What's the error message? Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted May 20, 2010 Moderators Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 20, 2010 Administrators Report Share Posted May 20, 2010 You're also on a free host which can/will cause problems Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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 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. Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 20, 2010 Administrators Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 20, 2010 Author Report Share Posted May 20, 2010 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 Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 21, 2010 Author Report Share Posted May 21, 2010 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. Quote Link to comment Share on other sites More sharing options...
g3r84 Posted May 21, 2010 Report Share Posted May 21, 2010 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 Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 22, 2010 Author Report Share Posted May 22, 2010 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 # ===== # # # ===== Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 22, 2010 Author Report Share Posted May 22, 2010 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 Thank you very much. If I can't get things resolved here with 000webhost, I may be interested in the host you are using. What host are you currently using? Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 22, 2010 Administrators Report Share Posted May 22, 2010 You gotta talk to your host... the mysql has gone away/shutdown messages -- they have database problems Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 22, 2010 Author Report Share Posted May 22, 2010 You gotta talk to your host... the mysql has gone away/shutdown messages -- they have database problems Ahh...they just sent me an email informing that the mysql server is down. So I will check again in the morning and see if anything has changed. Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 22, 2010 Author Report Share Posted May 22, 2010 Nabeel, the techs at my hosting site tell me to do this: use mysql_reconnect command before each query. What is this? How would I go about doing it? And is it even worth trying? Thank you. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted May 23, 2010 Administrators Report Share Posted May 23, 2010 Nabeel, the techs at my hosting site tell me to do this: use mysql_reconnect command before each query. What is this? How would I go about doing it? And is it even worth trying? Thank you. That's a huge change and a lame workaround! Tell them to fix their servers They're probably forcibly killing the connection after each request - stupid. Do they want 15-16 connect requests for each page load? I'd say find a new host... Quote Link to comment Share on other sites More sharing options...
patva1 Posted May 23, 2010 Author Report Share Posted May 23, 2010 That's a huge change and a lame workaround! Tell them to fix their servers They're probably forcibly killing the connection after each request - stupid. Do they want 15-16 connect requests for each page load? I'd say find a new host... Already done. I switched to a different host and plan on installing phpvms tonight. Thank you for all of your help. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.