Hallo,
Ik wil joomla uitproberen en heb daarvoor XAMPP geinstalleerd.
Nu vraagt hij om een database. Nu wil ik er een voor aanmaken maar weet niet wat daarin moet staan.
Kan iemand me daar bij helpen aub.
MySql database vullen tbv Joomla
Moderator: pe7er
Forum rules
Forum Regels
Forum Regels
-
- Joomla! Apprentice
- Posts: 5
- Joined: Mon Feb 14, 2011 8:21 pm
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: MySql database vullen tbv Joomla
Je moet gewoon een lege database aanmaken. De tabellen in de database worden door de installatie verzorgd.
-
- Joomla! Apprentice
- Posts: 5
- Joined: Mon Feb 14, 2011 8:21 pm
Re: MySql database vullen tbv Joomla
Okay en als ik dat doe krijg ik de volgende foutmelding:
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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) 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, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`
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 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) 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, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: MySql database vullen tbv Joomla
Een bestandje vervangen, staat in de volgende post: http://forum.joomla.org/viewtopic.php?p ... 9#p2382319
-
- Joomla! Apprentice
- Posts: 5
- Joined: Mon Feb 14, 2011 8:21 pm
Re: MySql database vullen tbv Joomla
Dank voor je tip. Heb nu de installatie gedaan en ging goed.
Maar als ik nu naar de site ga krijg het onderstaande
Strict Standards: Non-static method JLoader::import() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 29
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 71
Strict Standards: Non-static method JLoader::import() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 32
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 71
Strict Standards: Non-static method JLoader::load() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 161
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 138
Strict Standards: Non-static method JRequest::clean() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 33
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 463
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 464
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 465
Enzvoort enzovoort.
Wat kan hier de oorzaak zijn?
Oh ja ik probeer het een en ander op een localhost te installeren
Maar als ik nu naar de site ga krijg het onderstaande
Strict Standards: Non-static method JLoader::import() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 29
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 71
Strict Standards: Non-static method JLoader::import() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 32
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 71
Strict Standards: Non-static method JLoader::load() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 161
Strict Standards: Non-static method JLoader::register() should not be called statically in D:\xampp\htdocs\joomla\libraries\loader.php on line 138
Strict Standards: Non-static method JRequest::clean() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\import.php on line 33
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 463
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 464
Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in D:\xampp\htdocs\joomla\libraries\joomla\environment\request.php on line 465
Enzvoort enzovoort.
Wat kan hier de oorzaak zijn?
Oh ja ik probeer het een en ander op een localhost te installeren
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: MySql database vullen tbv Joomla
Zucht, geen handige standaard instellingen van Xampp.
In de backend, ga naar Help --> System Info --> PHP Information
Je zult een aanpassing moeten maken in het bestand wat achter de instelling. 'Configuration File (php.ini) Path' aangegeven wordt. Open dit bestand met een text editor en wijzig de installing 'display_errors' van 'on' naar 'off'. Nu Xampp herstarten en nog eens proberen.
In de backend, ga naar Help --> System Info --> PHP Information
Je zult een aanpassing moeten maken in het bestand wat achter de instelling. 'Configuration File (php.ini) Path' aangegeven wordt. Open dit bestand met een text editor en wijzig de installing 'display_errors' van 'on' naar 'off'. Nu Xampp herstarten en nog eens proberen.