Leonardo v2 SQL update error

support forum

Leonardo v2 SQL update error

Postby wingower » Mon Aug 06, 2007 5:08 pm

Eror:

SQL-sorgusu :
CREATE TABLE `leonardo_areas` (
`areaID` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 60 ) NOT NULL ,
`desc` varchar( 255 ) NOT NULL ,
`descInt` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `areaID` )
)ENGINE = MYISAM CREATE TABLE `leonardo_areas_takeoffs` (
`areaID` mediumint( 8 ) unsigned NOT NULL ,
`takeoffID` mediumint( 8 ) unsigned NOT NULL
)ENGINE = MYISAM CREATE TABLE `leonardo_clubs` (
`ID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL default '',
`intName` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`intDescription` text NOT NULL ,
`cat` smallint( 5 ) unsigned NOT NULL default '1',
`location` varchar( 60 ) NOT NULL default '',
`intLocation` varchar( 60 ) NOT NULL default '',
`countryCode` varchar( 30 ) NOT NULL default '',
`link` varchar( 255 ) NOT NULL default '',
`club_admin` bigint( 20 ) unsigned NOT NULL default '0',
`contact_person` varchar( 255 ) NOT NULL default '',
`formula` smallint( 6 ) NOT NULL default '0',
`formula_parameters` text NOT NULL ,
`areaID` mediumint( 8 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `ID` )
)ENGINE = MYISAM CREATE TABLE `leonardo_clubs_flights` (
`clubID` mediumint( 8 ) unsigned NOT NULL ,
`flightID` mediumint( 8 ) unsigned NOT NULL
)ENGINE = MYISAM CREATE TABLE `leonardo_clubs_pilots` (
`clubID` bigint( 20 ) unsigned NOT NULL default '0',
`pilotID` bigint( 20 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `clubID` , `pilotID` )
)ENGINE = MYISAM CREATE TABLE `leonardo_log` (
`transactionID` bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
`actionTime` bigint( 20 ) unsigned NOT NULL ,
`userID` mediumint( 8 ) unsigned NOT NULL ,
`effectiveUserID` mediumint( 8 ) unsigned NOT NULL ,
`ItemType` mediumint( 8 ) unsigned NOT NULL ,
`ItemID` mediumint( 8 ) unsigned NOT NULL ,
`ServerItemID` mediumint( 8 ) unsigned NOT NULL ,
`ActionID` mediumint( 8 ) unsigned NOT NULL ,
`ActionXML` text NOT NULL ,
`Modifier` mediumint( 8 ) unsigned NOT NULL ,
`ModifierID` mediumint( 8 ) unsigned NOT NULL ,
`ServerModifierID` mediumint( 8 ) unsigned NOT NULL ,
`Result` mediumint( 8 ) unsigned NOT NULL ,
`ResultDescription` text NOT NULL ,
PRIMARY KEY ( `transactionID` )
)ENGINE = MYISAM CREATE TABLE `leonardo_servers` (
`ID` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`isLeo` tinyint( 3 ) unsigned NOT NULL ,
`installation_type` smallint( 5 ) unsigned NOT NULL default '2',
`leonardo_version` varchar( 20 ) NOT NULL ,
`url` varchar( 255 ) NOT NULL ,
`url_base` varchar( 255 ) NOT NULL ,
`url_op` varchar( 255 ) NOT NULL ,
`admin_email` varchar( 100 ) NOT NULL ,
`site_pass` varchar( 100 ) NOT NULL ,
`is_active` tinyint( 3 ) unsigned NOT NULL default '0',
`gives_waypoints` tinyint( 3 ) unsigned NOT NULL default '0',
`waypoint_countries` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `ID` )
)ENGINE = MYISAM CREATE TABLE `leonardo_stats` (
`tm` bigint( 20 ) unsigned NOT NULL ,
`year` smallint( 5 ) unsigned NOT NULL ,
`month` tinyint( 3 ) unsigned NOT NULL ,
`day` tinyint( 3 ) unsigned NOT NULL ,
`userID` bigint( 20 ) unsigned NOT NULL ,
`sessionID` bigint( 20 ) unsigned NOT NULL ,
`visitorID` bigint( 20 ) unsigned NOT NULL ,
`op` char( 25 ) NOT NULL default '',
`flightID` bigint( 20 ) unsigned NOT NULL ,
`executionTime` float unsigned NOT NULL ,
`os` char( 20 ) NOT NULL default '',
`browser` char( 15 ) NOT NULL default '',
`browser_version` char( 10 ) NOT NULL default '',
KEY `tm` ( `tm` , `year` , `month` , `day` )
)ENGINE = MYISAM ALTER TABLE `leonardo_flights` MODIFY COLUMN `userID` MEDIUMINT( 8 ) NOT NULL DEFAULT '0'

MySQL çıktısı:
#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 'CREATE TABLE `leonardo_areas_takeoffs` (
`areaID` mediumint(


I use phpMyAdmin 2.5.3 , MySQL 4.0.25 version

Thanks
Best Regards
wingower
 
Posts: 10
Joined: Mon Aug 06, 2007 4:59 pm

Postby wingower » Mon Aug 06, 2007 8:13 pm

Hi

leonardo\doc\install\upgrade_2.0.0_fixes\upgrade_1.4_to_2.0.0.sql in this file I forget to write ; at the and of this ENGINE=MyISAM

when I add this symbol ; it has worked
wingower
 
Posts: 10
Joined: Mon Aug 06, 2007 4:59 pm

Postby manolis » Tue Aug 07, 2007 11:06 am

thx i'll fix that and update the zip file
manolis
Site Admin
 
Posts: 152
Joined: Fri Jun 24, 2005 2:04 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Bridge by mehdiplugins.com