How do I connect to the database? 
Автор: seok S.
Просмотрено 4231,
Подписчики 2,
Размещенный 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).
Размещено
Hello.
P.S. You may find these paid video tutorials helpful.
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)
Автор
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.
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.
Автор
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.
Please note the link provided by Paul M.. Try MySQL, not mariadb.
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?
Автор
Yes I am logging in with the same information as mysql workbench.
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?