Joomla Templates Club 406,261 posts

[ftmmarketing Friend ftmmarketingJoin date: November 2011Posts: 10Downloads:0Uploads:3]

#171618

I’ve never once been able to use the quick start on localhost. I always get this error at the top of my screen on step 4. Ideas?

<blockquote>Some errors occurred while populating the database: 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’ at line 41 SQL=CREATE TABLE `m6rv4_weblinks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT ‘0’, `sid` int(11) NOT NULL DEFAULT ‘0’, `title` varchar(250) NOT NULL DEFAULT ”, `alias` varchar(255) NOT NULL DEFAULT ”, `url` varchar(250) NOT NULL DEFAULT ”, `description` text NOT NULL, `date` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `hits` int(11) NOT NULL DEFAULT ‘0’, `state` tinyint(1) NOT NULL DEFAULT ‘0’, `checked_out` int(11) NOT NULL DEFAULT ‘0’, `checked_out_time` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `ordering` int(11) NOT NULL DEFAULT ‘0’, `archived` tinyint(1) NOT NULL DEFAULT ‘0’, `approved` tinyint(1) NOT NULL DEFAULT ‘1’, `access` int(11) NOT NULL DEFAULT ‘1’, `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT ”, `created` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `created_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `created_by_alias` varchar(255) NOT NULL DEFAULT ”, `modified` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `modified_by` int(10) unsigned NOT NULL DEFAULT ‘0’, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint(3) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Set if link is featured.’, `xreference` varchar(50) NOT NULL COMMENT ‘A reference to enable linkages to external data sets.’, `publish_up` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, `publish_down` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) TYPE=MyISAM ;</blockquote>

[TomC Moderator TomCJoin date: October 2014Posts: 14077Downloads:58Uploads:137 Thanks: 948 Thanked: 3155 times in 2495 posts]

#428771

Errors such as this are, many times, due to the database information not being entered correctly – be it the correct “host,” or entire username or database name. Each webhost seems to have it’s own unique naming structure (depending on the cPanel they utilize).

Might I inquire as to whom your webhost is?

Also, if you are able to get into your cPanel, can you please provide the following information . . .

DATABASE HOST:
DATABASE NAME:
DATABASE USERNAME:
DATABASE PASSWORD:
DATABASE PREFIX:

[pavit Moderator pavitJoin date: September 2007Posts: 15749Downloads:199Uploads:2274 Thanks: 417 Thanked: 4028 times in 3778 posts]

#428774

<blockquote>I’ve never once been able to use the quick start on localhost. I always get this error at the top of my screen on step 4. Ideas?</blockquote>

Wich version of web server are you using on your localhost ?

Try to update the xampp or wamp

[TomC Moderator TomCJoin date: October 2014Posts: 14077Downloads:58Uploads:137 Thanks: 948 Thanked: 3155 times in 2495 posts]

#428776

Also, perhaps this visual tutorial may assist . . . .

[ftmmarketing Friend ftmmarketingJoin date: November 2011Posts: 10Downloads:0Uploads:3]

#428782

as said before its localhost not a webhost. i’ve the most recent version of xampp. if i install joomla w/o the quick setup it works every time, however each time i try the quick setup it fails. id just do a fresh joomla install, import the template + addons but that’s a whole ‘nother world of hurt ive come across as it doesn’t look anything like the template here & its issue after issue of slamming my head trying to fix. so im trying to find the best (most easy/fast) way to get this template working so i can start importing data to it.

[TomC Moderator TomCJoin date: October 2014Posts: 14077Downloads:58Uploads:137 Thanks: 948 Thanked: 3155 times in 2495 posts]

#428783

Here is another way you can try to go about it . . .

You may like to try manually adding the Sample Data as described in the Installation Manual for a manual installation.
summarized as follows:

Open the /installation/sql/mysql/ directory and

Open the file sample_data.sql in an appropriate text/html editor (not notepad Windows User’s) and

Do a Find and Replace of the prefix #__ (has followed by 2 underscores) and replace with jos_ (or the prefix you have selected for your database tables) and

save the file ensuring it is saved as UTF-8 encoding.

Then open your MySQL admin manager (PHPMyAdmin or other) and import the file into your database.

You should then have the sample data installed.

[TomC Moderator TomCJoin date: October 2014Posts: 14077Downloads:58Uploads:137 Thanks: 948 Thanked: 3155 times in 2495 posts]

#428785

Here is another video tutorial I found concerning installing J1.7 on XAMPP . . .

[ftmmarketing Friend ftmmarketingJoin date: November 2011Posts: 10Downloads:0Uploads:3]

#428789

<em>@TomC 288025 wrote:</em><blockquote>Here is another way you can try to go about it . . .
</blockquote>

I’ll try this later. I thought the quick install did all the settings stuff for the addons as well, tis why I’ve tried to hard to get it to work but if its just sample data, ect I guess I can pass. My main issue (and I’ll have to start a new topic on this) is that all the addons are outta wack (not showing, can’t move to correct location, ect) I’ve worked with joomla for many years now & not had so many issues on a template before. Perhaps its the T3 system I’m not used too, I donno. I’ve been populating the site with data for a week now but I’m about to nuke the entire database & try again I’m so fed up with issues and as of late even the T3 widget won’t show anymore >:(

[Author]

Posts