Bad syntax!

H

Halada

Verified User
Joined
Feb 1, 2009
Messages
10
I'm trying to install a script and I seem to be the only one on their support forum with this issue...I am running CentOS and mySQL Version 5.0.67-community.

The script needs to create tables in the provided database, it connects fine but fraks up at the creation...

Code: 
Reading packages...
Creating table kb3_alliances...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 'PRIMARY KEY (`all_id`)) TYPE=MyISAM' at line 1
Creating table kb3_banned_mails...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 'default0000-00-00 00:00:00,`bml_ip` varchar(32) NOT NULL default,`bml_mail` text' at line 1
Creating table kb3_comments...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 'default0000-00-00 00:00:00,PRIMARY KEY (`id`)) TYPE=MyISAM' at line 1
Creating table kb3_config...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 '`cfg_key` varchar(32) NOT NULL default,`cfg_value` text NOT NULL,PRIMARY KEY (`' at line 1
Creating table kb3_constellations...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 'default0,`con_name` varchar(128) NOT NULL default,`con_reg_id` int(11) NOT NULL ' at line 1
Creating table kb3_contract_details...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 'default0,`ctd_crp_id` int(11) NOT NULL default0,`ctd_all_id` int(11) NOT NULL de' at line 1
Creating table kb3_contracts...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 '`ctr_site` varchar(64) NOT NULL default,`ctr_campaign` smallint(6) NOT NULL defa' at line 1
Creating table kb3_corps...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 '`crp_all_id` int(11) NOT NULL default0,`crp_trial` tinyint(4) NOT NULL default0,' at line 1
Creating table kb3_dgmattributetypes...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 'default0,`attributeName` varchar(100) NOT NULL default,`attributeCategory` int(1' at line 1
Creating table kb3_dgmeffects...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 'default0,`effectName` text NOT NULL,`effectCategory` int(11) NOT NULL default0,`' at line 1
Creating table kb3_dgmtypeattributes...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 'default0,`attributeID` int(11) NOT NULL default0,`value` double NOT NULL,PRIMARY' at line 1
Creating table kb3_dgmtypeeffects...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 'default0,`effectID` int(11) NOT NULL default0,`isDefault` enum(true,false) NOT N' at line 1
Creating table kb3_eveunits...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 'default0,`unitName` varchar(100) default NULL,`displayName` varchar(20) default ' at line 1
Creating table kb3_inv_all...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 'default0,`ina_all_id` int(3) NOT NULL default0,KEY `ina_all_id` (`ina_all_id`),K' at line 1
Creating table kb3_inv_crp...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 'default0,`inc_crp_id` int(6) NOT NULL default0,KEY `inc_crp_id` (`inc_crp_id`),K' at line 1
Creating table kb3_inv_detail...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 'default0,`ind_plt_id` int(6) NOT NULL default0,`ind_sec_status` varchar(5) defau' at line 1
Creating table kb3_inv_plt...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 'default0,`inp_plt_id` int(6) NOT NULL default0,KEY `inp_plt_id` (`inp_plt_id`)) ' at line 1
Creating table kb3_invtypes...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 'default0,`groupID` int(11) NOT NULL default0,`typeName` varchar(100) NOT NULL de' at line 1
Creating table kb3_ip_bans...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 '`ipb_comment` varchar(128) NOT NULL default,UNIQUE KEY `ipb_ip` (`ipb_ip`)) TYPE' at line 1
Creating table kb3_item_locations...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 'PRIMARY KEY (`itl_id`)) TYPE=MyISAM' at line 1
Creating table kb3_item_types...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 'default0,`itt_cat` int(11) NOT NULL,`itt_name` varchar(120) NOT NULL default,`it' at line 1
Creating table kb3_items_destroyed...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 'default0,`itd_itm_id` int(11) NOT NULL default0,`itd_quantity` int(11) NOT NULL ' at line 1
Creating table kb3_items_dropped...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 'default0,`itd_itm_id` int(11) NOT NULL default0,`itd_quantity` int(11) NOT NULL ' at line 1
Creating table kb3_kills...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 'default0000-00-00 00:00:00,`kll_victim_id` int(6) NOT NULL default0,`kll_all_id`' at line 1
Creating table kb3_log...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 'default0,`log_site` varchar(20) NOT NULL default,`log_ip_address` varchar(20) NO' at line 1
Creating table kb3_navigation...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 'default0,`KBSITE` varchar(16) NOT NULL,PRIMARY KEY (`ID`)) TYPE=MyISAM' at line 1
Creating table kb3_pilots...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 'default0,`plt_externalid` int(11) NOT NULL default0,`plt_killpoints` int(11) NOT' at line 1
Creating table kb3_races...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 'PRIMARY KEY (`rce_id`)) TYPE=MyISAM' at line 1
Creating table kb3_regions...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 'default0,`reg_name` varchar(64) NOT NULL default,`reg_x` float NOT NULL default0' at line 1
Creating table kb3_ship_classes...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 '`scl_value` bigint(4) NOT NULL default0,`scl_points` int(11) NOT NULL default0,P' at line 1
Creating table kb3_ships...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 '`shp_class` int(11) NOT NULL default18,`shp_externalid` int(11) NOT NULL default' at line 1
Creating table kb3_standings...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 'default0,`sta_to` int(11) NOT NULL default0,`sta_from_type` enum(a,c) NOT NULL d' at line 1
Creating table kb3_system_jumps...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 'default0,`sjp_to` int(11) NOT NULL default0,KEY `sjp_from` (`sjp_from`)) TYPE=My' at line 1
Creating table kb3_systems...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 'default0,`sys_con_id` int(11) NOT NULL default0,`sys_name` varchar(128) NOT NULL' at line 1
Creating table kb3_user...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 'default0,`usr_state` tinyint(1) NOT NULL default0,PRIMARY KEY (`usr_id`),UNIQUE' at line 1

Nobody knows what is going on, and my google search indicate this happens for so many reasons I am too unexperienced with this to troubleshoot it myself.

The kb3_alliance xml file is:

<?xml version="1.0" encoding="ISO-8859-1"?>
<kb3>
<name>kb3_alliances</name>
<rows>346</rows>
<structure>CREATE TABLE `kb3_alliances` (
`all_id` int(11) NOT NULL auto_increment,
`all_name` varchar(64) NOT NULL default &apos;&apos;,
PRIMARY KEY (`all_id`)
) TYPE=MyISAM;</structure>
</kb3>
Click to expand...

Yet it worked for half the table... like kb3_bannedmails

<?xml version="1.0" encoding="ISO-8859-1"?>
<kb3>
<name>kb3_banned_mails</name>
<rows>0</rows>
<structure>CREATE TABLE `kb3_banned_mails` (
`bml_timestamp` datetime NOT NULL default &apos;0000-00-00 00:00:00&apos;,
`bml_ip` varchar(32) NOT NULL default &apos;&apos;,
`bml_mail` text NOT NULL
) TYPE=MyISAM;</structure>
</kb3>
Click to expand...

Looks identical to me?

Then it checks to make sure table is ok and verifies the little data it imported for testing...

Checking table kb3_alliances:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/domains/lsjv-eve.com/public_html/edk/install/install_step4.php on line 314
/346 - FAILED
Click to expand...

Checking table kb3_banned_mails:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/domains/lsjv-eve.com/public_html/edk/install/install_step4.php on line 314
/0 - PASSED
Click to expand...

Line 314 in that script reads:
$test = mysql_fetch_array($result);
Click to expand...

Not sure if I provided enough information for the pros to locate the problem, if you do, I would appreciate the help!

Any pointer?
 
Last edited:
Other examples of creations that succeeded or failed:

FAILED
Code: 
<?xml version="1.0" encoding="ISO-8859-1"?>
<kb3>
  <name>kb3_constellations</name>
  <rows>780</rows>
  <structure>CREATE TABLE `kb3_constellations` (
  `con_id` int(11) NOT NULL default &apos;0&apos;,
  `con_name` varchar(128) NOT NULL default &apos;&apos;,
  `con_reg_id` int(11) NOT NULL default &apos;0&apos;,
  PRIMARY KEY  (`con_id`)
) TYPE=MyISAM;</structure>
</kb3>


PASSED
Code: 
<?xml version="1.0" encoding="ISO-8859-1"?>
<kb3>
  <name>kb3_contract_details</name>
  <rows>0</rows>
  <structure>CREATE TABLE `kb3_contract_details` (
  `ctd_ctr_id` int(11) NOT NULL default &apos;0&apos;,
  `ctd_crp_id` int(11) NOT NULL default &apos;0&apos;,
  `ctd_all_id` int(11) NOT NULL default &apos;0&apos;,
  `ctd_reg_id` int(11) NOT NULL default &apos;0&apos;,
  `ctd_sys_id` int(11) NOT NULL default &apos;0&apos;,
  KEY `ctd_ctr_id` (`ctd_ctr_id`)
) TYPE=MyISAM;</structure>
</kb3>

FAILED
Code: 
<?xml version="1.0" encoding="ISO-8859-1"?>
<kb3>
  <name>kb3_corps</name>
  <rows>8274</rows>
  <structure>CREATE TABLE `kb3_corps` (
  `crp_id` int(11) NOT NULL auto_increment,
  `crp_name` varchar(64) NOT NULL default &apos;&apos;,
  `crp_all_id` int(11) NOT NULL default &apos;0&apos;,
  `crp_trial` tinyint(4) NOT NULL default &apos;0&apos;,
  `crp_updated` datetime default NULL,
  PRIMARY KEY  (`crp_id`)
) TYPE=MyISAM;</structure>
</kb3>
 
Halada said:
Is the problem too ridiculous or complicated to help?
Click to expand...

If the person who wrote the install script cannot help then there is not much chance we can, at least not in our free time.
 
You must log in or register to reply here.
Back
Top