WebSite X5Help Center

 
seok S.
seok S.
User

How do I connect to the database?  en

Autore: seok S.
Visite 363, Followers 1, Condiviso 0  

Even though I entered the database information using Data Management, the basic tables can not be created.

http://studytest.wayhome.kr/admin/login.php

I guess that's why the above page does not open.
How are database connections and default table settings handled?

The value of $ imSettings ['databases'] in /res/x5settings.php is also correct (when you check the contents of the file with ftp).

Postato il
9 RISPOSTE - 2 UTILI
Aleksej H.
Aleksej H.
Moderator

Hello.

  1. Enable PHP 7.1 on the hosting.
  2. Check that the UTF-8 encoding is set for the site on the hosting.
  3. Check data you entered to connect to the database.
  4. Check the hosting logs for any connection errors.

P.S. You may find these paid video tutorials helpful.

Leggi di più
Postato il da Aleksej H.
Paul M.
Paul M.
Moderator
Utente del mese EN

Hello seok,

You say the basic tables cannot be created: what error message do you get?  Can you post a screenshot or provide more detail?

The problem with your admin login page (and also your contact form) is not indicative of any particular database error.  Even if there was no connection to the database available at all, you should still be able to access your admin panel.

Your issue is almost certainly an incorrectly configured server, particularly with regards to PHP.

Ask Korea Telecom for assistance on how to enable PHP on your site hosting.

WebSite X5 will operate correctly with PHP version 5.6 or higher.

There is an update available for your WebSite X5 software.  You can download it here:

Download WebSite X5

Kind regards,

Paul

Search the WebSite X5 Help Center (multilingual)

Leggi di più
Postato il da Paul M.
seok S.
seok S.
User
Autore

There are no errors when creating the source.
I am using php5.2 for hosting now, and I will try to fix the version information and try again.

After that, I will ask questions after checking again.

Thank you for your response.

Leggi di più
Postato il da seok S.
Paul M.
Paul M.
Moderator
Utente del mese EN
seok S.
I am using php5.2 for hosting now

This is definitely an issue...  you need version 5.6 as an absolute minimum:

What are the minimum requirements for the server

Once a suitably recent version of PHP is installed and configured correctly on the hosting, then you can use WebSite X5's built-in admin panel to check the database settings for any errors.  However, you may well find that there aren't any.

Leggi di più
Postato il da Paul M.
seok S.
seok S.
User
Autore

I'm testing again with php 7.3.

There were no errors in creating the source as before.
But now the database connection error is happening and the site does not open at all.

http://way21x5.cafe24.com/admin/

Looking at the database, it is still empty.
The server information is shown below.
UTF-8 (PHP7.3, mariadb-10.0.x)

As before, the value of $ imSettings ['databases'] in the /res/x5settings.php file is correct.

Why does not the built-in database be created?

Upload method is from websiteX5 pro program, Upload the Website to internet in Export menu.

Leggi di più
Postato il da seok S.
Aleksej H.
Aleksej H.
Moderator

Please note the link provided by Paul M.. Try MySQL, not mariadb.

Leggi di più
Postato il da Aleksej H.
Paul M.
Paul M.
Moderator
Utente del mese EN

And if still not successful when using MySQL, can you confirm that you can connect to your database using exactly the same credentials when using a third-party software such as phpMyAdmin?  In other words can you access the database successfully outside of WebSite X5 using the very same login details?

Leggi di più
Postato il da Paul M.
seok S.
seok S.
User
Autore

Yes I am logging in with the same information as mysql workbench.

Leggi di più
Postato il da seok S.
Paul M.
Paul M.
Moderator
Utente del mese EN

Some more things to check...

Have you given full permissions to the Username which is accessing the database from within WebSite X5?

Is your database on the same server as your WebSite X5 project?

Did you let WebSite X5 create the database table or did you do it manually yourself?

What have you entered in the Host Name field for the database in Step 1 Settings > Advanced > Data Management?

Are you using the built-in FTP client to export files to the server?  If so, what have you entered as the WebSite Address (URL) in Step 5 Export > Upload the WebSite to Internet?

When you try to export your WebSite X5 files to the server as above, the software performs some checks on PHP settings and database access.  What error messages does it report at this stage?

Can you confirm you are using MySQL and not MariaDB?

What information does the Korea Telecom error log on the server show?

Leggi di più
Postato il da Paul M.