Forum Support

Shape 5
March 28, 2024, 11:48:00 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: 1 [2]
  Print  
Author Topic: Please, help for a noob *-*  (Read 1849 times)
yosnakorn
Jr. Member
**
Offline Offline

Posts: 7



« Reply #15 on: August 09, 2008, 07:18:47 PM »

--
-- Database: `shape5co_kitephotography`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_banner`
--
CREATE TABLE `jos_banner` (

`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 10 ) NOT NULL default 'banner',
`name` varchar( 50 ) NOT NULL default '',
`imptotal` int( 11 ) NOT NULL default '0',
`impmade` int( 11 ) NOT NULL default '0',
`clicks` int( 11 ) NOT NULL default '0',
`imageurl` varchar( 100 ) NOT NULL default '',
`clickurl` varchar( 200 ) NOT NULL default '',
`date` datetime default NULL ,
`showBanner` tinyint( 1 ) NOT NULL default '0',
`checked_out` tinyint( 1 ) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 50 ) default NULL ,
`custombannercode` text,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =3;



MySQL แสดง: 

#1050 - Table 'jos_banner' already exists




!!!!!!!!!!  I import   sql  in joomla  database  is this corrected

 Cry Cry Cry Cry Cry
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #16 on: August 09, 2008, 08:14:29 PM »

The error is saying that the table already existed. Make sure you drop all existing tables first and then import.
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
yosnakorn
Jr. Member
**
Offline Offline

Posts: 7



« Reply #17 on: August 09, 2008, 08:30:27 PM »

same problem


-- Database: `shape5co_kitephotography`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_banner`
--
CREATE TABLE `jos_banner` (

`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 10 ) NOT NULL default 'banner',
`name` varchar( 50 ) NOT NULL default '',
`imptotal` int( 11 ) NOT NULL default '0',
`impmade` int( 11 ) NOT NULL default '0',
`clicks` int( 11 ) NOT NULL default '0',
`imageurl` varchar( 100 ) NOT NULL default '',
`clickurl` varchar( 200 ) NOT NULL default '',
`date` datetime default NULL ,
`showBanner` tinyint( 1 ) NOT NULL default '0',
`checked_out` tinyint( 1 ) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar( 50 ) default NULL ,
`custombannercode` text,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =3;



MySQL แสดง: 

#1050 - Table 'jos_banner' already exists




 Undecided Undecided Undecided Undecided Undecided Undecided
Logged
mikek
Administrator
*****
Offline Offline

Posts: 28743



WWW
« Reply #18 on: August 09, 2008, 09:31:31 PM »

This error:

Table 'jos_banner' already exists

Is saying that the table is already present when it tries to import that database. All tables must be completely removed, not emptied, but totally removed from the database before you import the sql dump. Also your charset should be UTF-8 Unicode (utf8)
Logged

Mike Knott
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Pages: 1 [2]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.