Joomla Templates Club 406,261 posts

[bokkerz Friend bokkerzJoin date: June 2011Posts: 9Downloads:0Uploads:0 Thanks: 4]

#165766

Installing on a Wamp localhost. Created the database in phpmyadmin.
Ran Installation and comes up to the Database section. I put in localhost with root username no password and the database name I created and this is what I get:

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 `jos_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 ;

What should I do?

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#398933

Delete the database entirely…and recreate it. Your installation is trying to create fields where fields already exist.
When you install, the database should have ONLY a name. Nothing else.

Have fun!
John.

1 user says Thank You to John Wesley Brett for this useful post

1. JA Developer

[bokkerz Friend bokkerzJoin date: June 2011Posts: 9Downloads:0Uploads:0 Thanks: 4]

#398942

Hi John,

Unfortunately, that didn’t work.

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#398953

Then something is amiss with your WAMP install.
Until you can get up to a web server where we can take a look, I’m not sure I can help further.

I can only further suggest deleting everything and starting over.

Sorry.
John.

[bokkerz Friend bokkerzJoin date: June 2011Posts: 9Downloads:0Uploads:0 Thanks: 4]

#398956

Thanks John,

I was able to get the standard Joomla installation to work with my Wampserver. It seems to not like the Quickstart. I think I will try and install Xamp and see if that makes a difference.

[bokkerz Friend bokkerzJoin date: June 2011Posts: 9Downloads:0Uploads:0 Thanks: 4]

#399144

Hi John,

I installed an older version of wampserver and I was able to complete the installation for JA rave. Unfortunately, I needed to install JA community. I am able to install it completely but when I try to view the site it gives me:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 98304 bytes) in C:wampwwwmjcpluginssystemjat3jat3coremenubase.class.php on line 630

I am able to get into the admin screen fine but not the site.

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#399151

That indicates that Joomla is needing more memory than your PHP is allowing.

Workaround:
Create a new file php.ini, and add the code…


php_value memory_limit = "128M"

and put that file in your Joomla root folder.

That should help.
John.

[bokkerz Friend bokkerzJoin date: June 2011Posts: 9Downloads:0Uploads:0 Thanks: 4]

#399155

John, I really appreciate your help. I just joined the club yesterday.

I changed the Memory limit and now I am getting this:

Warning: call_user_func(imagecreatefromjpeg) [function.call-user-func]: First argument is expected to be a valid callback in C:wampwwwmjcmodulesmod_jaslideshowhelpersjaimage.php on line 264

Fatal error: Call to undefined function imagecreate() in C:wampwwwmjcmodulesmod_jaslideshowhelpersjaimage.php on line 277

when trying to load the site

[John Wesley Brett Moderator John Wesley BrettJoin date: July 2013Posts: 2142Downloads:17Uploads:26 Thanks: 175 Thanked: 645 times in 426 posts]

#399159

Bok.

You are having some issues not with Joomla or our templates, but with your Winamp/Xamp and PHP settings.
I’m afraid this is beyond the scope of our support here. To get you started here is a video many swear by to get up and running.

http://www.veoh.com/watch/v1802750A7Mnpe7z

Best wishes.
John.

1 user says Thank You to John Wesley Brett for this useful post

1. bokkerz

[Author]

Posts