Shape 5

Joomla Templates => Game Vision - October 2007 - Club => : korsath July 30, 2008, 03:24:14 PM



: Please, help for a noob *-*
: korsath July 30, 2008, 03:24:14 PM
http://www.it4clan.com


what's wrong in this template? *-*

I'm a newbye on joomla and I need help =/


: Re: Please, help for a noob *-*
: mikek July 30, 2008, 06:16:09 PM
I am not seeing anything wrong, what do you mean?

You can try installing our sql dump if you want the site to look like our demo.


: Re: Please, help for a noob *-*
: korsath July 30, 2008, 11:35:06 PM
I am not seeing anything wrong, what do you mean?

You can try installing our sql dump if you want the site to look like our demo.
MMM...how can I try install your sql dump?


: Re: Please, help for a noob *-*
: mikek July 31, 2008, 07:16:17 AM
Hi, your cpanel should have phpadmin. In the admin section drop all of your current tables to ensure that the old data will be gone. And then simply import the sql data dump from the downloads section. This will recreate the tables with all the data from the demo.


: Re: Please, help for a noob *-*
: korsath July 31, 2008, 10:34:12 AM
jtablesession::Store Failed
DB function failed with error number 1146
Table 'rfckit_istUrjoom.istu_session' doesn't exist SQL=INSERT INTO `istu_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '9ba9d422a3c05fb502993040dc3fab59','1217521998','','0','1','0' )


I drop all data and import your sql =(


edit:

if I import without drop all data there is this error:

query SQL:

--
-- Dumping data for table `jos_banner`
--
INSERT INTO  `jos_banner` (  `bid` ,  `cid` ,  `type` ,  `name` ,  `alias` ,  `imptotal` ,  `impmade` ,  `clicks` ,  `imageurl` ,  `clickurl` ,  `date` ,  `showBanner` ,  `checked_out` ,  `checked_out_time` ,  `editor` ,  `custombannercode` ,  `catid` ,  `description` ,  `sticky` ,  `ordering` ,  `publish_up` ,  `publish_down` ,  `tags` ,  `params` )
VALUES ( 1, 1,  'banner',  'OSM 1',  'osm-1', 0, 103, 0,  'osmbanner1.png',  'http://www.opensourcematters.org',  '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00',  '',  '', 0,  '', 0, 0,  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  '',  '' ) , ( 2, 1,  'banner',  'OSM 2',  'osm-2', 0, 119, 0,  'osmbanner2.png', 'http://www.opensourcematters.org',  '2004-07-07 15:31:29', 1, 0,  '0000-00-00 00:00:00',  '',  '', 0,  '', 0, 0,  '0000-00-00 00:00:00',  '0000-00-00 00:00:00',  '',  '' ) ;


Messaggio di MySQL:

#1062 - Duplicate entry '1' for key 1


: Re: Please, help for a noob *-*
: mikek July 31, 2008, 12:11:33 PM
Make sure it's dropping the tables and not just clearing them. Your PHPMyAdmin should list no tables in the database once they are dropped. Then import the database and it will create the new tables. Make sure you are grabbing the correct version of Joomla's sql dump.


: Re: Please, help for a noob *-*
: korsath July 31, 2008, 01:46:03 PM
All data were delete but if I upload your sql there is this error on my homepage:


jtablesession::Store Failed
DB function failed with error number 1146
Table 'rfckit_iTxZFjoom.itxz_session' doesn't exist SQL=INSERT INTO `itxz_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '22dff2e6f703d04517882d7471f166b6','1217533127','','0','1','0' )



sorry but I need help =(


: Re: Please, help for a noob *-*
: mikek July 31, 2008, 02:02:05 PM
I would reinstall Joomla. It's looking for table suffix itxz_ the default Joomla suffix is jos_ and that is how the sql dump is setup. When you install Joomla it gives you the option to make your own but you should use jos_


: Re: Please, help for a noob *-*
: korsath August 01, 2008, 07:22:36 AM
now it's perfect!

thank you very much =)


: Re: Please, help for a noob *-*
: korsath August 01, 2008, 03:16:49 PM
I'm come back xD

The title of game control panel I change in template option but how can I change its text and images?


: Re: Please, help for a noob *-*
: korsath August 02, 2008, 08:34:14 AM
The title of game control panel I change in template option but how can I change its text and images?
How can I remove the text on s5 box?

"Toolbar Position
Publish any module to the toolbar position to use the S5 Box."


: Re: Please, help for a noob *-*
: mikek August 02, 2008, 09:26:14 AM
You can simply not publish anything to the toolbar position and it will not show.


: Re: Please, help for a noob *-*
: korsath August 02, 2008, 10:43:11 AM
but I want a project module there and when I add it in toolbar position I see:

"Toolbar Position
Publish any module to the toolbar position to use the S5 Box."

and next my module.
How can I remove your demo text?

I've this problem also in advert1 and advert2's space with your image and text demo.

I've your wonderful template on www.it4clan.com



edit: "Native 1.5 and 1.0x Template Installs available!"
I would remove this as well *-*


: Re: Please, help for a noob *-*
: korsath August 05, 2008, 09:15:26 AM
can you answer please?


: Re: Please, help for a noob *-*
: mikek August 05, 2008, 09:22:27 AM
Hi, sorry I must have overlooked your post before. If that text is still showing that means that the module from the demo is still published to the toolbar position. Simply unpublish the module with the demo content from the toolbar position.


: Re: Please, help for a noob *-*
: yosnakorn 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

 :'( :'( :'( :'( :'(


: Re: Please, help for a noob *-*
: mikek 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.


: Re: Please, help for a noob *-*
: yosnakorn 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




 :-\ :-\ :-\ :-\ :-\ :-\


: Re: Please, help for a noob *-*
: mikek 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)