Joomla Templates Club 406,261 posts

[docmedia Friend docmediaJoin date: October 2010Posts: 36Downloads:4Uploads:5 Thanks: 9 Thanked: 1 times in 1 posts]

#797420

I just download Uber_3.4 and installed the Quickstart package, everything was going fine until I tried to load the Sample Data for " Uber Home" in the JoomlArt installer.

I now get a Fatal Error message:

Fatal error: Uncaught exception 'RuntimeException' with message 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT id, home, template, s.params FROM b63a8_template_styles as s LEFT JOIN b63a8_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1' in /home1/docmedia/public_html/jrmarine/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home1/docmedia/public_html/jrmarine/libraries/joomla/database/driver.php(1318): JDatabaseDriverMysqli->execute() #1 /home1/docmedia/public_html/jrmarine/libraries/cms/application/site.php(484): JDatabaseDriver->loadObjectList('id') #2 /home1/docmedia/public_html/jrmarine/libraries/legacy/error/error.php(785): JApplicationSite->getTemplate() #3 /home1/docmedia/public_html/jrmarine/plugins/system/redirect/redirect.php(64): JError::customErrorPage(Object(RuntimeException)) #4 [internal function]: PlgSystemRedirect::handleError(Object(RuntimeEx in /home1/docmedia/public_html/jrmarine/libraries/joomla/database/driver/mysqli.php on line 610

Im not sure what is happening with this? Is there someone who can point me in the right direction.

Thanks,

-Dave

[docmedia Friend docmediaJoin date: October 2010Posts: 36Downloads:4Uploads:5 Thanks: 9 Thanked: 1 times in 1 posts]

#797754

I tried installing the "Uber Home" sample data twice, and got the same "Fatal Error" as I mentioned above – both times.

I then tried the "Uber University" sample data and everything was installed successfully.

Not sure the reason for the problem in the "Uber Home" template.

Thanks,
-Dave

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#800766

Hi
sorry for the inconvenience , Kindly ask your host to change the php values, set the memory limits to 256M and max-execution time to 300 .
Install the package again on Fresh DB with DB collation utf-8-general ci .
Let me know if it helps

[docmedia Friend docmediaJoin date: October 2010Posts: 36Downloads:4Uploads:5 Thanks: 9 Thanked: 1 times in 1 posts]

#802552

Hello, I ended up just installing the sample data from "Uber University" template and everything worked well. I just thought that the problem may be specific to the sample data in "Uber Home".

If I run into this problem again, I will try your suggestions.

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#802780

Hi
one of user in past have same issue , and solved after changing the parameter in php configurations.
once u will change it , you can also install home site sample data . I just tested it on my local system , its working fine .

[sipnata Friend sipnataJoin date: November 2015Posts: 20Downloads:3Uploads:15]

#864883

i got the same error when i try to install the bookstore sample data and my php.ini is configured to memory 256m and max-execution time to 600

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#864981

Hi
Sipnataa could u provide your own thread link where i can check ur site details .

[sipnata Friend sipnataJoin date: November 2015Posts: 20Downloads:3Uploads:15]

#867969

https://www.joomlart.com/forums/topic/problem-when-i-install-the-bookstore-sample/

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#868511

Hi sipnata
Kindly follow your own thread i am already following your thread .

[Author]

Posts