Jump to content

bsl0001

Members
  • Posts

    10
  • Joined

  • Last visited

Posts posted by bsl0001

  1. I dont speak english, sorry about it... i have this problem whit my data base myslq in phpvms_schedules table:

    There was an error adding the schedule, already exists DB error: 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 ''1)' at line 25

    here the code:

    --
    -- Estructura de tabla para la tabla `phpvms_schedules`
    --
    CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `code` char(3) COLLATE latin1_general_ci NOT NULL DEFAULT '',
     `flightnum` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
     `depicao` varchar(4) COLLATE latin1_general_ci NOT NULL DEFAULT '',
     `arricao` varchar(4) COLLATE latin1_general_ci NOT NULL DEFAULT '',
     `route` text COLLATE latin1_general_ci NOT NULL,
     `route_details` text COLLATE latin1_general_ci NOT NULL,
     `aircraft` text COLLATE latin1_general_ci NOT NULL,
     `flightlevel` varchar(6) COLLATE latin1_general_ci NOT NULL,
     `distance` float NOT NULL DEFAULT '0',
     `deptime` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
     `arrtime` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '',
     `flighttime` float NOT NULL DEFAULT '0',
     `daysofweek` varchar(7) COLLATE latin1_general_ci NOT NULL DEFAULT '0123456',
     `price` float NOT NULL,
     `flighttype` varchar(3) COLLATE latin1_general_ci NOT NULL DEFAULT 'a',
     `timesflown` int(11) NOT NULL DEFAULT '0',
     `notes` text COLLATE latin1_general_ci NOT NULL,
     `enabled` int(11) NOT NULL DEFAULT '1',
     `bidid` int(11) NOT NULL DEFAULT '0',
     PRIMARY KEY (`id`),
     KEY `depicao` (`depicao`),
     KEY `flightnum` (`flightnum`),
     KEY `depicao_arricao` (`depicao`,`arricao`),
     KEY `code` (`code`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
    

    Thanks for all. im new in this world of PHP and etc...

  2. Hi, how is everyone?. want to say that I have just opened a virtual airline in this world of PHPvms. I do not know much about their operation (PHP, codes, etc). For this, I need help from administrators, to form and improve the airline (flight plans, fleet, etc). nonprofit, just for fun and a hobby. People who wish help me, my airline is bslairways.tk .. or send me a private message through this forum.

    Thank you for your help.

    sorry for my bad English, I'm Spanish.

×
×
  • Create New...