Cannot activate Data Connector. Table with name users already exists

William_Assell · July 10, 2023, 2:39pm

I am working on an app for an existing application, and I am not able to connect to the application database due to there being an existing users table in the external database. I get the following error “Cannot activate Data Connector. Table with name users already exists” Maybe being able to add a prefix to the tables would help.

vladimir-upirov · July 10, 2023, 3:18pm

Hi @William_Assell

I’ve created a ticket to investigate the issue, thanks for the report.
We will notify you about the result here.

Regards,
Vlad

Inna_Shkolnaya · July 14, 2023, 9:19am

Hello @William_Assell

Could you tell us your current version of Backendless?

Regards,
Inna

William_Assell · July 14, 2023, 3:05pm

Marina.Kan · July 14, 2023, 3:36pm

Hi @William_Assell

Please upgrade the current version of Backendless to 7.0.2.7 and check if the problem is reproduced there. We will be waiting for your response.

Regards,
Marina

William_Assell · July 14, 2023, 4:44pm

When I try to upgrade I get the following error.

Marina.Kan · July 14, 2023, 4:46pm

@William_Assell, Ohh, yeah. I am sorry for that, we are aware of this issue, and it will be fixed in the nearest time. Just try to select the version to update one more time.

Regards,
Marina

William_Assell · July 14, 2023, 4:48pm

Different error

Marina.Kan · July 14, 2023, 4:51pm

@William_Assell, What version do you have now? You can find it in the all services tab

William_Assell · July 14, 2023, 4:54pm

Looks like everything upgraded anyway except one item config values

William_Assell · July 14, 2023, 4:55pm

The original issue is resolved thank you for your help

Marina.Kan · July 14, 2023, 4:57pm

@William_Assell This is expected, the config values have not been updated.
Great, thanks for letting us know about this.

Regards,
Marina

William_Assell · July 14, 2023, 5:00pm

Now that I have connected the database I am getting an error trying to view the data see below

Marina.Kan · July 14, 2023, 5:48pm

@William_Assell, Is that all that you have there? No additional info about the error? Could you please provide us an example of datetime values that you have.

Please check what you have under the config → server → dateFormats? It can be found in consul http://localhost:32600/

Regards,
Marina

William_Assell · July 14, 2023, 5:53pm

William_Assell · July 14, 2023, 5:54pm

Maybe the time-only ones are the issue? I don’t think I see that in the config

sergey.kuk · July 17, 2023, 6:03am

hello @William_Assell

could you please make a dump of the table that has an issue and sent it to us?