Joomla Templates Club 406,261 posts

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#207059

Hi there
I have received fews report about issue with Quickstart and sample database.

Actually it’s server side issue with some bad configured. I have installed and managed it as well in my localhost.
Here is my local configuration. You can consider it as reference for configuration.

php.ini

<blockquote>PHP Version 5.5.25
Build Date May 13 2015 19:53:52
Apache Version Apache/2.4.12 (Win64) OpenSSL/1.0.1m PHP/5.5.25

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version mysqlnd 5.0.11-dev – 20120503 – $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $

MysqlI Support enabled
Client API library version mysqlnd 5.0.11-dev – 20120503 – $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0</blockquote>

phpmyadmin
<blockquote>
Server: localhost via TCP/IP
Server type: MySQL
Server version: 5.7.7-rc-log – MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)

Apache/2.4.12 (Win64) OpenSSL/1.0.1m PHP/5.5.25
Database client version: libmysql – mysqlnd 5.0.11-dev – 20120503 – $Id: 15d5c781cfcad91193dceae1d2cdd127674ddb3e $
PHP extension: mysqli Documentation
PHP version: 5.5.25

Edit Editcharacter set clientDocumentation utf8
(Session value) utf8mb4
Edit Editcharacter set connectionDocumentation utf8
(Session value) utf8mb4
Edit Editcharacter set databaseDocumentation utf8
Edit Editcharacter set filesystemDocumentation binary
Edit Editcharacter set resultsDocumentation utf8
(Session value) utf8mb4
Edit Editcharacter set serverDocumentation utf8
Edit Editcharacter set systemDocumentation utf8
Edit Editcharacter sets dirDocumentation C:Program FilesMySQLMySQL Server 5.7sharecharsets
Edit Editcheck proxy users OFF
Edit Editcollation connectionDocumentation utf8_general_ci
(Session value) utf8mb4_unicode_ci
Edit Editcollation databaseDocumentation utf8_general_ci
Edit Editcollation serverDocumentation utf8_general_ci</blockquote>

And here is Charity database information
<blockquote> ja_charity_j34 utf8_general_ci</blockquote>
Finally here is my database with sample database. If you can’t work at your server side. You can use this.

But i would strong suggest you work with your sysadmin to solve it at root cause.

Thank you,
Viet Vu

---

Attachments:

1. ja_charity_j34.zip

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#573173

MySQL Server would be configured utf8_general_ci as default . It’s not only good configuration but also support for UTF-8 issues.
For sample: If you are using none standard character language, without UTF8 you’ll not able to use that.
That’s why UTF8 must be default for everything.
And not only that but also please do upgrade your server with latest stable version.

<blockquote>MySQL Community Server (GPL)
(Current Generally Available Release: 5.6.25)
</blockquote>

PHP should be from 5.4 or higher. Because 5.3 already EOL.

Thank you,
Viet Vu

[Author]

Posts