Jump to content

OneWorldVirtual

Members
  • Posts

    14
  • Joined

  • Last visited

Posts posted by OneWorldVirtual

  1. There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unknown Punctuation String @ 21

    STR: =================================================

    SQL: The pilotshop table

    =================================================

    CREATE TABLE `phpvms_pilotshop` (

    `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

    `pid` INT( 15 ) NULL ,

    `name` VARCHAR( 100 ) NULL ,

    `shop_type` INT( 15 ) NULL ,

    `product_type` INT( 15 ) NULL ,

    `image_link` TEXT NULL ,

    `description` TEXT NULL ,

    `price` FLOAT NULL )

    The pilotshop_types table

    =================================================

    CREATE TABLE `phpvms_pilotshop_types` (

    `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

    `type` INT( 1 ) NULL ,

    `name` VARCHAR( 100 ) NULL ,

    `description` TEXT NULL )

    The pilotshop_bought table

    =================================================

    CREATE TABLE `phpvms_pilotshop_bought` (

    `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,

    `pilot_id` INT( 11 ) NULL ,

    `product_id` INT( 11 ) NULL )

    SQL query:

    The pilotshop table ================================================= CREATE TABLE `phpvms_pilotshop` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pid` INT( 15 ) NULL , `name` VARCHAR( 100 ) NULL , `shop_type` INT( 15 ) NULL , `product_type` INT( 15 ) NULL , `image_link` TEXT NULL , `description` TEXT NULL , `price` FLOAT NULL ) The pilotshop_types table ================================================= CREATE TABLE `phpvms_pilotshop_types` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `type` INT( 1 ) NULL , `name` VARCHAR( 100 ) NULL , `description` TEXT NULL ) The pilotshop_bought table ================================================= CREATE TABLE `phpvms_pilotshop_bought` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pilot_id` INT( 11 ) NULL , `product_id` INT( 11 ) NULL )

    MySQL said: Documentation

    #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 'The pilotshop table

    =================================================

    CREATE TA' at line 1

    Any ideas anyone?

  2. If you have removed the prieps, which it seems may be the case here, you will start to see many odd things happen. When the system updates a pilots time and hours it recalculates all the pireps, so if they are not there they will not be in the final figures.

    Yeah thats what I figured. Thanks for the reply.

    DeeQ @ OWV

  3. Since the update to v2.0, there is an occasional time when a pilot uploads a PIREP and when it is approved the hours and flights reset to a lower number. For example, a pilot has 96.1 hours and 27 flights, uploaded 2 new ones taking him to 102.23 hours but instead it reset to 16 flights and 37.8 hours.

    Is this a problem with the SQL database? we had to switch to a new one and port the info from the previous one, but I didn't move the PIREPS (because the flight numbers changed).

    It's not really a big problem, as they can be manually edited obviously, but If anyone has any theories towards a resoloution then I'd be most grateful.

    Cheers,

    DeeQ @ OWV

  4. Well, I had to disable GA through my hosting provider because it was interfering with the whole site, specifically the map and uploads (it was adding bunches of code onto outputs). Is there a way to do it without using GA entirely?

    DeeQ @ OWV

  5. Anyone got any ideas how to resolve this?

    When checking the database connection durind the upgrade, I get this:-

    Fatal error: Cannot redeclare class ezDB_mysql in /home/a8554731/public_html/phpvms/core/classes/ezDB_MySQL.class.php on line 315

    Thanks in advance

    DeeQ

  6. I'm afraid not, since we upgraded to the beta the boxes no longer show up under FSACARS or XACARS. Previously, the flight info appeared below the map, but the aircraft icon was always a grey box instead of a red or green plane.

    If there's any files you need to take a look at, i'll give you acces to our FTP server via whatever FTP client software you have. Just let me know where to mail the info if you need it.

    Cheers,

    Andy @ OWV

    www.oneworldvirtual.com

  7. We've been running the phpVMS system for a while now, and were originally able to get the live map to show grey squares only, along with the flight info listed below. We attempted to fix it with no success, so moved to the latest beta.

    Now, the map shows up, but no flights appear either on the map or in the list below. Is there a step-by-step set-up guide for FSACARS or XACARS because no matter what we try, we get no results.

    Many Thanks,

    Andy Russell

    One World Virtual

×
×
  • Create New...