Quickstart doesn't work

May 2014 Joomla Template
GK User
Mon Sep 12, 2016 11:30 am
Hi,

Five days ago, I purchased your University Template for Joomla.
Trying to install the Quickstart, I failed.
I tried to attach the message, I receive instead of the installation, but this forum doesn't allow any of the formats, I tried - .txt, .docx, .pdf. :evil:
It fails to create the database tables correctly, it seems.

I need a working Quickstart, because I don't have the time to build up the site and template from scratch.
And honestly, I regret to have purchased this template...

Please fix the Quickstart.

Thank you!
Kind regards,
Oliver
User avatar
Fresh Boarder

teitbite
Thu Sep 15, 2016 11:03 am
Hi

Please send me an access to cPanel, so I'll try to install it and see what can be wrong. What was the error message ?
User avatar
Moderator

GK User
Thu Sep 15, 2016 5:37 pm
Hi,

there was no error message.
You can see for yourself.
http://www.beziehungsthemen.de

[edited by moderator]
User avatar
Fresh Boarder

teitbite
Sat Sep 17, 2016 5:01 pm
Hi

There is a big error displayed :) This means Your database does not support "utf8mb4", please ask Your hosting provider to update it or edit file /installation/sql/mysql/joomla.sql and replace all "utf8mb4" to "utf8", save and install again.
User avatar
Moderator

teitbite
Sat Sep 17, 2016 5:03 pm
Sorry, I forgot to add error screenshot.
User avatar
Moderator

GK User
Sat Sep 17, 2016 6:38 pm
I have exactly the same problem. The error returned is "Could not connect to the database. Connector returned number: Could not connect to MySQL".

The DB access information is correct (username, password, DB name, host). The site is hosted on a VPS managed by me. On this VPS, I have about 10 other sites running on this VPS with no problems connecting to mysql (mysql, mysqli and pdo-mysql modules are installed and usable).

Please check the installer for errors.
User avatar
Fresh Boarder

teitbite
Sun Sep 18, 2016 11:25 am
Hi

During a connection quickstart is using not changed files of a regular joomla installer and I see not known issues which can return such error other than wrong connection details or database not allowing an outside connection. Please check if everything is ok in this area.

Try install clean joomla from joomla.org, it will reveal if there is a broken file in our package.
User avatar
Moderator

GK User
Sun Sep 18, 2016 11:26 am
Oh, thank you :D
I didn't realize it as an error, because there was so much informationv :woohoo:
I'll check it out.
Greetings
User avatar
Fresh Boarder

GK User
Sun Sep 18, 2016 12:05 pm
Hm...I tried it, the way you wrote, but get yet again an error message - although another one this time.

Table 'db646221628.#__assets' doesn't exist SQL=INSERT INTO `#__assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES (1,0,1,504,0,'root.1','Root Asset','{\"core.login.site\":{\"6\":1,\"2\":1},\"core.login.admin\":{\"6\":1},\"core.login.offline\":[],\"core.admin\":{\"8\":1},\"core.manage\":{\"7\":1},\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(2,1,1,2,1,'com_admin','com_admin','{}'),(3,1,3,8,1,'com_banners','com_banners','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(4,1,9,10,1,'com_cache','com_cache','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(5,1,11,12,1,'com_checkin','com_checkin','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(6,1,13,14,1,'com_config','com_config','{}'),(7,1,15,22,1,'com_contact','com_contact','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(8,1,23,84,1,'com_content','com_content','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":[],\"core.edit\":{\"4\":1},\"core.edit.state\":{\"5\":1},\"core.edit.own\":[]}'),(9,1,85,86,1,'com_cpanel','com_cpanel','{}'),(10,1,87,88,1,'com_installer','com_installer','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1},\"core.delete\":[],\"core.edit.state\":[]}'),(11,1,89,90,1,'com_languages','com_languages','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(12,1,91,92,1,'com_login','com_login','{}'),(13,1,93,94,1,'com_mailto','com_mailto','{}'),(14,1,95,96,1,'com_massmail','com_massmail','{}'),(15,1,97,98,1,'com_media','com_media','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":{\"3\":1},\"core.delete\":{\"5\":1}}'),(16,1,99,100,1,'com_menus','com_menus','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(17,1,101,102,1,'com_messages','com_messages','{\"core.admin\":{\"7\":1},\"core.manage\":{\"7\":1}}'),(18,1,103,106,1,'com_modules','com_modules','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(19,1,107,116,1,'com_newsfeeds','com_newsfeeds','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1},\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(20,1,117,118,1,'com_plugins','com_plugins','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(21,1,119,120,1,'com_redirect','com_redirect','{\"core.admin\":{\"7\":1},\"core.manage\":[]}'),(22,1,121,122,1,'com_search','com_search','{\"core.admin\":{\"7\":1},\"core.manage\":{\"6\":1}}'),(23,1,123,124,1,'com_templates','com_templates','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(24,1,125,126,1,'com_users','com_users','{\"core.admin\":{\"7\":1},\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(26,1,127,128,1,'com_wrapper','com_wrapper','{}'),(27,8,24,31,2,'com_content.category.2','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(28,3,4,5,2,'com_banners.category.3','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(29,7,16,17,2,'com_contact.category.4','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(30,19,108,109,2,'com_newsfeeds.category.5','Uncategorised','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(32,33,33,34,3,'com_content.article.1','Typography','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(33,8,32,49,2,'com_content.category.7','Template articles','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(34,33,35,36,3,'com_content.article.2','Module positions','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(35,33,37,38,3,'com_content.article.3','Messages','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(39,8,50,51,2,'com_content.category.9','Layouts','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(52,33,39,40,3,'com_content.article.18','Module variations','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(53,7,18,19,2,'com_contact.category.10','Sample category I','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(54,7,20,21,2,'com_contact.category.11','Sample category II','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(57,19,110,111,2,'com_newsfeeds.category.14','GavickPro','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(58,19,112,113,2,'com_newsfeeds.category.15','Joomla! WebLinks','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(59,27,25,26,3,'com_content.article.19','Archive article I','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(60,27,27,28,3,'com_content.article.20','Archive article II','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(61,27,29,30,3,'com_content.article.21','Archive article III','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(115,33,41,42,3,'com_content.article.56','Page break example','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(116,33,43,44,3,'com_content.article.57','Page Break','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(127,8,52,73,2,'com_content.category.32','Demo content','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(128,127,53,58,3,'com_content.category.33','Subcategory I','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(129,127,59,64,3,'com_content.category.34','Subcategory II','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(141,3,6,7,2,'com_banners.category.35','Demo','{\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(142,1,484,485,1,'com_k2','com_k2','{\"core.admin\":[],\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[],\"core.edit.own\":[]}'),(144,1,486,487,1,'com_joomlaupdate','com_joomlaupdate','{\"core.admin\":[],\"core.manage\":[],\"core.delete\":[],\"core.edit.state\":[]}'),(171,33,45,46,3,'com_content.article.90','Template features','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(174,127,65,66,3,'com_content.article.91','Students choose accounting lecturer','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(175,127,67,68,3,'com_content.article.92','Private Pesticide Applicators Training','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(176,127,69,70,3,'com_content.article.93','Students to spend spring break serving others','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(177,127,71,72,3,'com_content.article.94','University theme for education website','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(179,129,60,61,4,'com_content.article.95','Jumpstart Your Success in Your College Studies','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(180,129,62,63,4,'com_content.article.96','The Best Universities','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(181,128,54,55,4,'com_content.article.97','Project 2014 - Workshop','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(182,128,56,57,4,'com_content.article.98','Criminal Justice Camp','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(183,33,47,48,3,'com_content.article.99','Frontpage elements','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(187,188,75,76,3,'com_content.article.101','About University','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(188,8,74,83,2,'com_content.category.37','About','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}'),(189,188,77,78,3,'com_content.article.102','History','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(190,188,79,80,3,'com_content.article.103','Facts','{\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(191,188,81,82,3,'com_content.article.104','Frequently Asked Questions','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(192,1,488,489,1,'com_finder','com_finder','{}'),(193,1,490,491,1,'com_tags','com_tags','{\"core.admin\":[],\"core.manage\":[],\"core.create\":[],\"core.delete\":[],\"core.edit\":[],\"core.edit.state\":[]}'),(194,1,492,493,1,'com_contenthistory','com_contenthistory','{}'),(195,1,494,495,1,'com_ajax','com_ajax','{}'),(196,1,496,497,1,'com_postinstall','com_postinstall','{}'),(197,18,104,105,2,'com_modules.module.739','Connect','{\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1}}'),(198,1,498,499,1,'#__ucm_content.1','#__ucm_content.1','[]'),(199,1,500,501,1,'#__ucm_content.2','#__ucm_content.2','[]'),(200,1,502,503,1,'#__ucm_content.3','#__ucm_content.3','[]'),(201,19,114,115,2,'com_newsfeeds.category.38','Joomla!','{\"core.create\":{\"6\":1,\"3\":1},\"core.delete\":{\"6\":1},\"core.edit\":{\"6\":1,\"4\":1},\"core.edit.state\":{\"6\":1,\"5\":1},\"core.edit.own\":{\"6\":1,\"3\":1}}')
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 '-- MySQL dump 10.13 Distrib 5.5.50, for Linux (x86_64) CREATE' at line 1 SQL=-- MySQL dump 10.13 Distrib 5.5.50, for Linux (x86_64) CREATE TABLE `#__assets` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n', `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`,`rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 8:03 am
So I got the template installed using the following steps:

1) Uploaded the files from quickstart via ftp
2) Created the DB and run the sql files (via phpmyadmin) in installation/sql/mysql/ folder (joomla.sql and sample data.sql
3) Created a new Joomla user on the users table and assigned him to the admin usergroup.
4) Logged in to admin
5) Installed the template through Extensions->Install->From package file

Unfortunately, the required extensions like Image Show GK5 and the Custom HTML Modules were not installed. So I have to rebuild the template from scratch in order to get the same result as the quickstart package.

If I had to guess, I would say that there has been a mixup between the template download files (quickstart and template packages), so I would check the distributed sql files.

Please check this issue, because I have a website due to the end of the month and the client insisted on this template.

Thank you in advance.
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 10:40 am
Dear kostaskopelli,

thanx for your effort and the information.
I cannot follow your example, because I don't have the time to build up anything from scratch.
This is the very purpose of a QUICKstart, to get a website up and running within an hour max, isn't it?

So I really ask for fixing this quickstart in order to make it working.

Thank you! ;)
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 4:50 pm
General question: Can I expect this Quickstart to be fixed or not?
If not, I have to pull back my order in order to get refunded until Thursday.
I need a working template.
University is the most sophisticated and beautiful, but if it doesn't work, I have to consider an alternative, I'm afraid...
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 6:37 pm
I am a member just as you, not a moderator or member of gavick's staff. :)
xiantropist wrote:Dear kostaskopelli,

thanx for your effort and the information.
I cannot follow your example, because I don't have the time to build up anything from scratch.
This is the very purpose of a QUICKstart, to get a website up and running within an hour max, isn't it?

So I really ask for fixing this quickstart in order to make it working.

Thank you! ;)
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 6:44 pm
Yes I know - but great effort anyway :D
User avatar
Fresh Boarder

GK User
Mon Sep 19, 2016 6:56 pm
My friend, if you run only joomla.sql in the steps I provided, the template works perfectly.
It will take less than 30 minutes to setup like I said.

If you don't know how to do this, find someone with basic hosting knowledge and ask them to do it for you, following the steps I described.
User avatar
Fresh Boarder

GK User
Tue Sep 20, 2016 3:46 pm
I'm sorry, but it doesn't work for me.
The table created have the prefix #_.
Tried to rename in the koomla.sql file.
But of course, it doesn't work this way...
How do I teach my installation to use the database, the credentials, the tables...?

I have definitely enough with this thing.
If I would charge you the time, I already invested in making a QUICKSTART working, you had to pay me 10 times of what the template costs.

So once again: will you fix this or not?
Sorry, but I really start to get angry... :angry:
User avatar
Fresh Boarder

teitbite
Wed Sep 21, 2016 10:38 am
Hi

Send me ftp, database and url to the site. I'll install it for You. Just tried on my server and had no problems at all.
User avatar
Moderator

teitbite
Wed Sep 21, 2016 10:38 am
A cPanel access would be even better to speed up file transfer.
User avatar
Moderator

teitbite
Thu Sep 22, 2016 3:13 pm
Hi

Thank You for the access. I've tried to install quickstart, but I'm getting message: "Your host needs to use PHP 5.3.10 or higher to run this version of Joomla!", that's most probably why installation could not be done before. Please ask Your hosting provider to rise PHP version on server.
User avatar
Moderator

teitbite
Tue Sep 27, 2016 12:24 pm
Hi

I think after updating PHP You should have no problems to install quickstart. Just select "English (United kingdome)" and than follow instructions. I've tried, but got this message after filling database details:

An error occurred while trying to create the database dbo646221628.
The user may not have enough privileges to create a database. The required database may need to be created separately before you can install Joomla!


which user needs a higher permissions.
User avatar
Moderator


cron
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.
GavickPro website uses cookies. By continuing to use this website, you are giving consent to cookies being used. More details…×