msql or script problam.

[redarrow]

Fist thing thanks for dan, sorting my account out cheers mate.

 

 

Hi there all , long time no see.

 

 

here is a code that the server keeps spitting out any ideas please?

 

error code

 

 

 

	Error
SQL query:
--

-- Table structure for table `qa_admin`

-- 

CREATE TABLE `qa_admin` (
`id` tinyint( 4 ) NOT NULL AUTO_INCREMENT ,

`user` varchar( 64 ) NOT NULL default '',

`pass` varchar( 64 ) NOT NULL default '',

PRIMARY KEY ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;




MySQL said: 
#1050 - Table 'qa_admin' already exists 

 

do you no any think about this error i have try the uploadf agin

done that 100 times.

 

 

yes i deleted the last insert sorry but it a 1050 error and the sql file huge there every where.

 

 
 
--

-- Table structure for table `qa_admin`

--



CREATE TABLE `qa_admin` (

  `id` tinyint(4) NOT NULL auto_increment,

  `user` varchar(64) NOT NULL default '',

  `pass` varchar(64) NOT NULL default '',

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;



--

-- Dumping data for table `qa_admin`

--



INSERT INTO `qa_admin` (`id`, `user`, `pass`) VALUES (1, 'admin', '1a1dc91c907325c69271ddf0c944bc72');

 the tables get made but the database spit the info out.

Edited March 3, 2013 by redarrow

[Christian F.]

As the error message says: The table already exists, so it cannot create it. You need to either drop the table first, or make the creation conditional with "CREATE TABLE IF NOT EXISTS".