WebSite X5Help Center

 
J. Sentra
J. Sentra
User

Data management / database setting  en

Autor: J. Sentra
Visited 2713, Followers 1, Udostępniony 0  

Hi, 

How to change details of database settings in Data management tab?

I made mistakes and I cannot change it afterward ( it is greyed )

Thanks

Posted on the
19 ODPOWIEDZI - 1 POMOCNY
J. Sentra
J. Sentra
User
Autor

Additional note:

As the setting is wrong, I cannot update the website at all.

WSX5 message as in the photo

Czytaj więcej
Posted on the from J. Sentra
J. Sentra
J. Sentra
User
Autor

The second message if I push the IGNORE button

Czytaj więcej
Posted on the from J. Sentra
Franz-Josef H.
Franz-Josef H.
Moderator

You can download the installation file of the previous version in your profile menu at the top right of this page under Download and install the program parallel to the old version. Then load the unconverted project and change the information. Then open it again in the new version.

Czytaj więcej
Posted on the from Franz-Josef H.
J. Sentra
J. Sentra
User
Autor

Thank you for your advice Franz. I did as you suggested.

It works for projects that was saved in version 2021.2.8. and it is not updated, however, it will not work for project that is updated and saved in version 2021.3.3 , because the parallel WSX5 (2021.2.8) cannot open it to change the database settings 

Czytaj więcej
Posted on the from J. Sentra
Axel  
Axel  
User

Hello,

In your previous project saved with 2021.3.3 probably you have a backup directory. here many files are your backups... Check the more fresh regarding the date and copy this one into the root of your project. (../)

Save your project.iwprj2 as project.iwprj2.old and rename your backup file here with project.iwprj2.

try to open it with 2021.2.8

Enjoy!
Axel

Czytaj więcej
Posted on the from Axel  
J. Sentra
J. Sentra
User
Autor

Thank you Axel. I did what you suggested.

The backup file can be recovered.

But the problem exists : If you made a mistake during inputting server configuration, the configuration is grey out again and you must recover from backup.

I think this is a bug of 2021.3.3 version, it is better to have the option to correct mistake instead of recover from backup

Until this is fixed by dev. team ,  I will use 2021.2.8 version :)

Thanks again and have a good day guys

Czytaj więcej
Posted on the from J. Sentra
Axel  
Axel  
User

normal.... new version .... bugs, bugs, bugs...

no quality tests ... nothing has changed ! it's a pity.yell

Now, I never use a new version... Too lost time.

Better to wait one or 2 other versionning....

Czytaj więcej
Posted on the from Axel  
Incomedia
Stefano G.
Incomedia

Hello Sentra

This is not actually a bug in the new version. It was made like this to avoid errors in copying the data during the Database upgrade of the new version

If you have a project that uses the Database in the previous version when the project is brought to the new version the data will be presented blocked in this way due to the fact that the new version brings changes to the management of the Database. For the first export only, the project will need to connect to the configured Database and perform some operations. After the first export, this data will be editable again.

If this error appears, it means that the software is unable to connect correctly to the database with the data provided. It is necessary to either reopen the project with the previous version and remove the database or make sure with the hosting that the connection data are still the same

Please verify if this is possible for you and keep me posted here

Thank you

Stefano

Czytaj więcej
Posted on the from Stefano G.
J. Sentra
J. Sentra
User
Autor

Hi Stefano,

Yes you are right, it was connection error, because I made experiment changing the database name.

I never connect to the database before, maybe that was not a problem in 2021.2.8 because I can skip the operation before upload the website update to the server.

2021.3.3 does not allow skipping if the database test failed ,thus, upload process is cancelled automatically.

I guess that what happened.

Other thing is that if I checked the database connection with NAVICAT , I was able to  connect succesfully.

With the same credential I cannot get any connection with websitex5. 

Do I missed something ?

Czytaj więcej
Posted on the from J. Sentra
Incomedia
Stefano G.
Incomedia

Hello Sentra

You will be able to skip the connection to the database the same way you did in v2021.2 but only after the first export. Due to the technical reasons, I explained above, the first export must mandatorily be successful if your project had a Database configured before because it needs to copy it into the new tables.

I'm not sure what you mean at the end of your post. You found out that it was a connection error, but wasn't able to get it fixed yet?

As of now, what is the exact situation? You have a project with a Database configured and the data is supposed to be correct but it won't connect?

Keep me posted here

Thank you

Stefano

Czytaj więcej
Posted on the from Stefano G.
Imraan A.
Imraan A.
User

What a mission just to edit the database, and we can't even delete the database as well as it's all greyed out.

Czytaj więcej
Posted on the from Imraan A.
Jay H.
Jay H.
User

I was just reading what has been going on.  I also had this problem but I solved it quickly without the use of X5 Pro xxx.  I went into my phpMyAdmin or my cPanel - SQL database and either renamed or added a new user to fit the information in X5.  This might not be a solution for others, but has worked for me.

Czytaj więcej
Posted on the from Jay H.
Artur L.
Artur L.
User

Hi Stefano

It is not true that after the first successful export, access to the database editing will be unlocked.
I have correctly written on the basis of the first order, and then there is no possibility to change the database.
What's worse, after updating the WebSide program itself changed the name of the tabel and this is no longer a continuation of the previous base, so that the entire mechanism of automatic import into the order system I can bring to the basket ...
It's me, as an administrator, I have to decide what prefixes created by Website tables have (this was in the old version 17), and not the application itself, because it is necessary to create a universal tool if I have many stores.

This is undoubtedly the application bug.

Artur

Czytaj więcej
Posted on the from Artur L.
Axel  
Axel  
User

Hello Arthur,

Artur L.
It's me, as an administrator, I have to decide what prefixes created by Website tables have (this was in the old version 17), and not the application itself,

I am full agree with you about table name prefix... Now It is not possible to use an external generic tool or script to have an external DB access, because tables name are not the same for each project !!!!!

Czytaj więcej
Posted on the from Axel  
Incomedia
Stefano G.
Incomedia

Good afternoon everyone

I can understand that the change with the table prefixes might not suit all situations. However, after many discussions, it was decided to favor ease of use and avoid the possibility of creating issues on the website due to problems with the way prefixes are inserted contrary to allowing for more customizability

This is the main reason why this was changed this way. We predict that many more users will start using the Database functionality due to the fact that less customization is needed and the entire process is easier to get started

About the issue @Artur mentioned.

I can confirm that if the credentials are inserted correctly and your software can connect to the database correctly, the credentials won't be greyed out. If they remain greyed out, it means that the connection was not successful

If you have any doubt about this, please open up a new private topic and I will look at your project for you

Thank you

Stefano

Czytaj więcej
Posted on the from Stefano G.
Sinisa B.
Sinisa B.
User

@ Stefano

So, can you confirm that if we have only one (1) database used in the project - THERE WILL NOT BE ANY database issues upon update to the newest X5 version?

I'm using X5 form to store form-inputs into the database - am I safe to update the software?

You know, I had some BIG disappointments with the past updates regarding messing up with the site's layout and such... I sure don't want any database mess-up!

Czytaj więcej
Posted on the from Sinisa B.
Axel  
Axel  
User

@Sinisa,

Like Rambo takes some risks my friend foot-in-mouth

Czytaj więcej
Posted on the from Axel  
Incomedia
Stefano G.
Incomedia

Hello Sinisa

If you only have 1 Database, the software will need to perform fewer operations. Namely, it will move all content from the automatically created tables to new ones with a new name. This only goes for the ones created automatically by the software. The ones from the form will not be changed. Additionally, all older tables will not be deleted so that if anything goes wrong, your old version of the website uploaded online will work just as fine as before.

In any case, should you wish to go one further degree of safety, perform a full backup of the Database. As mentioned before though, the old tables are preserved so you shouldn't really risk losing any data

I hope I was helpful

Stefano

Czytaj więcej
Posted on the from Stefano G.
Sinisa B.
Sinisa B.
User

@ Stefano

OK - I back-up everything anyway...

@ Axel

Rambo retired.

Czytaj więcej
Posted on the from Sinisa B.