Jump to content

Cannot add routes


patva1

Recommended Posts

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.

Link to comment
Share on other sites

  • Administrators

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

  • Moderators

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

#

=====

#

#

#

=====

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • Administrators

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...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...