Problem with writing database and folder permissions 
Author: Taco D.Website X5 Prof. v14.
I made a website with a shop and placed it on the server. I created manually the folder which contains the database and set the permissions to 777 (see 3 Server DeBaatTrading.png). In Step 1 I filled in the Write Access Folder (see 4 Data Management.png) On the server it all looks fine. When I login on the admin page and run the website test I get the following results:
PHP versie: 7.0.26: Pass
Session support: Pass
Server public folder pad (/domains/debaattrading.nl/db): Fail, Ask your Web Space Provider for the path of the read/write folder. This folder must have its permissions set as 777
MySQL settings (DBDeBaatTrading): Fail
So if I hit the “Buy now” button I get the “Generic error” message.
I did upload the website into the public_html folder (/domains/debaattrading.nl/public_html)
This is what I also tried:
- Changed the permission from public_html in root in 777 (see 1 Server Root.png)
- Changed the permission in from \domains\debaattrading.nl in 777 (see 2 Server Domains.png)
It is clear that it is a permission problem but I can’t figure out which folder(s) the permission settings are wrong.
Is says in the error: /domains/debaattrading.nl/db
so you need to set permissions for folder db.
If you get an error on your database, check all settings, ftp adress is very importand, some providers use just localhost, password and login.
Then all should work, else make a new database and try again. Use databases for 1 item onnly, if you need to have two objects with databases, you also need to create 2 databases.
Goodluck.
Author
Hi Andre,
I made a test website and added a shop. When I choose in Step 1 the Sending order "Send data by e-mail" it its functioning as expected. I can complete the order. If I changed the Sending order in "Send data to a Database" it will fail. Apparently it is still not possible to write to the database in folder "DB" while it does have the necessary rights (777).
What does the admin panel say?
For the shop it is not needed to give 777 rights, this does not work with a folder online but with a database.
If all settings from the database are correct that should work. So check adres /name password and so on of the databse. use only 1 databse for every object that requires a database
Hello Taco,
You don't need to create a folder for the database but use the Database Connection data you received from your hosting where you find the address, username and password to connect to the database which cannot be accessed via FTP on the hosting space. Your hosting provider can provide you the correct informations needed so you can then enter these in the program to connect to the database.
Many thanks!
Author
@Andre E and Claudio D
Thanks for the explanation. I really misunderstood the working of the program.
Since my client uses an obscure and cheap hoster it is not possible to contact the helpdesk because there isn't any. I will search for a reliable hosting company with support so I hope the website of my client will run as expected.
Thanks both of you for your time and help. I really appreciatie it!