Joomla Templates Club 406,261 posts

[dayman Friend daymanJoin date: May 2011Posts: 21Downloads:1Uploads:6 Thanks: 7 Thanked: 1 times in 1 posts]

#163853

Dear friends,

im trying to install ja_minisite on my local drive. In the installation i get this error HELP please!!!!

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 AUTO_INCREMENT=9’ 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` int(10) unsigned NOT NULL DEFAULT ‘0’, `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL DEFAULT ‘0’, `ordering` int(11) 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, `params` text NOT NULL, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), KEY `idx_banner_catid` (`catid`) ) TYPE=MyISAM AUTO_INCREMENT=9

[pritam Friend pritamJoin date: April 2011Posts: 609Downloads:0Uploads:29 Thanks: 11 Thanked: 125 times in 113 posts]

#390782

Hello,

The quickstart is not a module but a complete joomla install.

There are many guides on how to use the quickstart.

Extract the quickstart zip.
Upload the extracted files to wherever you want your Joomla to be installed.
Browse to wherever you just uploaded the files to.
Follow through the standard Joomla install.

And if you are new to Joomla and JoomlArt, all of video in this channel are MUST see

1. http://www.youtube.com/watch?v=fIoUNi7L5wg

2. http://www.youtube.com/user/JoomlArt#g/c/1C6547ADE0DD2AC2

[dayman Friend daymanJoin date: May 2011Posts: 21Downloads:1Uploads:6 Thanks: 7 Thanked: 1 times in 1 posts]

#390783

dear pritam,

thank you so much for the reaction.

I am quite familiar with Joomla already. I was using the instal already, but after i inserted localhost, db name password i got this message. Both local using MAMP and on my server.

What’s wrong?

Thanks for reacting!

[pritam Friend pritamJoin date: April 2011Posts: 609Downloads:0Uploads:29 Thanks: 11 Thanked: 125 times in 113 posts]

#390792

Hi,

I have raised ticket for this issue, someone will get back to you soon.

[dayman Friend daymanJoin date: May 2011Posts: 21Downloads:1Uploads:6 Thanks: 7 Thanked: 1 times in 1 posts]

#390793

thanks a lot!

[visioni_eu Friend visioni_euJoin date: August 2010Posts: 18Downloads:0Uploads:0]

#391416

Hi, I had the same problem!!
How did you resolve this issue?
Thank you,
Francesco

[dayman Friend daymanJoin date: May 2011Posts: 21Downloads:1Uploads:6 Thanks: 7 Thanked: 1 times in 1 posts]

#391417

Dear Francesco,

really weird, but from the one to the other moment it worked…

Don’t know what the problem was..

Sorry

[visioni_eu Friend visioni_euJoin date: August 2010Posts: 18Downloads:0Uploads:0]

#391437

I think I’ve solved it, but I’d like to have a feedback from the staff.
Inside Installation folder there’s the SQL folder. I edited the joomla.sql file. I’ve substituted TYPE= with ENGINE, I think it depends on the SQL installation, because on older version of PHP TYPE worked perfectly,
With ENGINE I had everything work!
Please let me know,
Francesco

[dayman Friend daymanJoin date: May 2011Posts: 21Downloads:1Uploads:6 Thanks: 7 Thanked: 1 times in 1 posts]

#391472

The cause of this bug is “t3-assets” folder was not created (normal, It will be automatically created by t3 framework, but this function is not work in your case).

You have to manually create it and chmod it to writable, and it work properly now.

FYI: you can config ftp account (on global configuration page >> system tab) to solve this bug.

[visioni_eu Friend visioni_euJoin date: August 2010Posts: 18Downloads:0Uploads:0]

#391479

With my edit t3-assets is created, and I’ve tried to export a previous JA template direct from PHP MyAdmin to see how it writes code, for this reason I’ve applied edit I’ve described.
Thank you for your reply dayman,
Francesco

[joomted Friend joomtedJoin date: May 2011Posts: 12Downloads:0Uploads:0 Thanked: 1 times in 1 posts]

#392316

Well, I’m having the same problem with quickstart installs for JA Methys, JA Teline IV and JA Minisite as well.
I’m using the latest version of MAMP for my localhost.
I have tried the trick with the ENGINE=MyISAM and it gets me to the last step of the install, but when I enter
my admin info and click ‘next’ , I get a message about an ‘invalid token’ and my luck ends there.

Please, joomlart folks, give it a try and fix it if it’s not much of a deal. Great info and tips here on the forums, but I’m one of those who is not a developer, just an end user who wants to make a website using a well-designed template as a starting point and my knowledge of code is very limited, so things that seem to be an easy fix for some are big problems for others like me!

Thanks!

[joomted Friend joomtedJoin date: May 2011Posts: 12Downloads:0Uploads:0 Thanked: 1 times in 1 posts]

#392367

ok, I just uploaded the JA Minisite quickstart file onto my Bluehost account.
did everything as instructed, got to the installer, filled out all the info, did not get the sql-related errors, but after entering all
the admin user and admin pass info and hitting ‘next’, I only get the following message: “The most recent request was denied because it contained an invalid security token. Please refresh the page and try again.” and all my efforts end there.

That’s as far as I have gotten on my local host as well, after making the recommended changes to the sql files (ENGINE=MyISAM).

Update:

Just tried install of JA Minisite quickstart on Bluehost again – now it works!
No changes made from first attempt!
Oh well, at least this one works ….

[thangnn1510 Friend thangnn1510Join date: October 2014Posts: 1608Downloads:0Uploads:80 Thanks: 73 Thanked: 278 times in 256 posts]

#392552

We have checked and installed them well on our server. Could you give us the login to the site that you meet problem (FTP/Mysql account). We’ll try for you.

[Author]

Posts