Ver Mensaje Individual
  #1 (permalink)  
Antiguo 06/01/2009, 21:47
CYBERUSO
Usuario no validado
 
Fecha de Ingreso: diciembre-2001
Ubicación: MERIDA
Mensajes: 498
Antigüedad: 22 años, 4 meses
Puntos: 2
Problema con código sql en phpmyadmin.

Hola amigos, espero que por favor puedan ayudarme.

Tengo un archivo con extensión .sql el cual deseo importar al phpmyadmin, sin embargo, me aparece este mensaje de error:


******************************************

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: Unclosed quote @ 44321
STR: '
SQL: -- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: mysql3.000webhost.com
-- Generation Time: May 12, 2005 at 10:05 AM
-- Server version: 3.23.49
-- PHP Version: 4.3.9
--
-- Database: `fb`


************************************************** **********


Ahora bien, el archivo sql contiene esto:


Código:
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: mysql3.000webhost.com
-- Generation Time: May 12, 2005 at 10:05 AM
-- Server version: 3.23.49
-- PHP Version: 4.3.9
-- 
-- Database: `fb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `admin`
-- 

CREATE TABLE `admin` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `avatar` varchar(50) default NULL,
  `col_back` varchar(7) NOT NULL default 'ffffff',
  `col_link` varchar(7) NOT NULL default 'ff9900',
  `col_text` varchar(7) NOT NULL default 'ffffff',
  `col_table_border` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_border_2` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_row` varchar(7) NOT NULL default '000000',
  `col_table_row2` varchar(7) NOT NULL default '000000',
  `col_table_header` varchar(7) NOT NULL default 'EB9518',
  `col_table_header_2` varchar(7) NOT NULL default '000000',
  `col_table_header_text` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_row_text` varchar(7) NOT NULL default 'FFFFFF',
  `currency` char(3) NOT NULL default '£',
  `logo_pos` varchar(10) NOT NULL default 'center',
  `texture` varchar(30) NOT NULL default '',
  `admin_message` text NOT NULL,
  `title_message` text NOT NULL,
  `theme_col` varchar(12) NOT NULL default 'grey',
  `site_url` varchar(100) NOT NULL default 'Enter your site url here !!!!',
  `admin_email` varchar(100) NOT NULL default '',
  `pom_vote` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `admin`
-- 

INSERT INTO `admin` VALUES (1, 'admin', 'homer.gif', '000033', 'FFFF33', 'FFFFFF', 'CCCCCC', '888888', '330000', '660000', '000066', '000033', 'FFFF00', 'FFFFFF', '', 'Center', '0', 'This welcome message can be changed from the admin control panel.\r\n\r\nPut whatever message you like !\r\nit will always be displayed at the top of this page\r\n\r\nIMPORTANT: Create a new users straight away, giving yourself admin rights, then login with your new user and delete the admin user !!!', 'Welcome to PHP FC Homepage', 'Grey', '', '', 2);

-- --------------------------------------------------------

-- 
-- Table structure for table `fixtures`
-- 

CREATE TABLE `fixtures` (
  `fix_id` int(10) NOT NULL auto_increment,
  `opp_team` varchar(50) NOT NULL default '',
  `ground` varchar(50) NOT NULL default '',
  `fix_date` date NOT NULL default '0000-00-00',
  `fix_time` varchar(8) NOT NULL default '',
  `home_away` varchar(10) NOT NULL default '',
  `match_type` varchar(40) NOT NULL default '',
  `notes` text NOT NULL,
  `closed` char(3) NOT NULL default 'no',
  `fix_oldname` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`fix_id`)
) TYPE=MyISAM AUTO_INCREMENT=73 ;

-- 
-- Dumping data for table `fixtures`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `league_table`
-- 

CREATE TABLE `league_table` (
  `table_id` int(10) NOT NULL auto_increment,
  `match_id` int(11) NOT NULL default '0',
  `team_name` varchar(50) NOT NULL default '',
  `opp_team` varchar(50) NOT NULL default '',
  `w_d_l` varchar(5) NOT NULL default '',
  `points` int(10) NOT NULL default '0',
  `home_away` varchar(8) NOT NULL default '',
  `match_type` varchar(40) NOT NULL default '',
  `goals_for` int(11) NOT NULL default '0',
  `goals_against` int(11) NOT NULL default '0',
  `oldname` varchar(50) NOT NULL default '',
  `match_report` text NOT NULL,
  `match_tag` char(3) NOT NULL default '',
  `match_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`table_id`)
) TYPE=MyISAM AUTO_INCREMENT=153 ;

-- 
-- Dumping data for table `league_table`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `match_comment`
-- 

CREATE TABLE `match_comment` (
  `comment_id` int(10) NOT NULL auto_increment,
  `match_id` int(11) NOT NULL default '0',
  `name` varchar(40) NOT NULL default '',
  `comment` text NOT NULL,
  PRIMARY KEY  (`comment_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

-- 
-- Dumping data for table `match_comment`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `match_signup`
-- 

CREATE TABLE `match_signup` (
  `signup_id` int(10) NOT NULL auto_increment,
  `match_id` int(10) NOT NULL default '0',
  `name` varchar(40) NOT NULL default '',
  `playing` varchar(5) NOT NULL default '',
  `comment` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`signup_id`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;

-- 
-- Dumping data for table `match_signup`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `match_squad`
-- 

CREATE TABLE `match_squad` (
  `squad_id` int(10) NOT NULL auto_increment,
  `match_id` int(10) NOT NULL default '0',
  `position` varchar(20) NOT NULL default '',
  `playername` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`squad_id`)
) TYPE=MyISAM AUTO_INCREMENT=219 ;

-- 
-- Dumping data for table `match_squad`
-- 


-- --------------------------------------------------------

-- 
--
CONTINUA....