Invalid Table No Primary Key ERROR

Questions, tips and tricks and techniques for scripting in Servoy

Invalid Table No Primary Key ERROR

Postby wvitpr » Fri Sep 30, 2022 8:53 am

HI All,
I have been struggling with this now for a bit.. Im not sure how to fix it..

At some point the solution I am working on had both a dbi file and a corresponding table called "random_data", both table and dbi file were deleted, but Servoy is still showing "Table "random_data" has no primary key." in the problems tab. I have searched for references to "random_data" but nothing is found.. how do I fix this error?

Version: 2021.3.3.3645_LTS
MySql 8

Thankyou in advance.
Regards,
Phillip Routley

Worldview IT
Sydney, Australia
User avatar
wvitpr
 
Posts: 219
Joined: Tue Apr 24, 2007 1:38 am

Re: Invalid Table No Primary Key ERROR

Postby omar » Tue Oct 04, 2022 3:40 pm

Hi Phillip,

In de Solution Explorer, right-click the Database Servers node and choose the option "Synchronize with DB server information". After that, to be sure, restart Servoy and do a Project Clean. The errors should be gone.
Intrasoft, Founder
Omar van Galen
omar@intrasoft.nl
+31-(0)6-21234586
Servoy Developer
omar
 
Posts: 377
Joined: Sat Feb 12, 2011 4:51 pm
Location: Intrasoft, The Netherlands


Return to Methods

Who is online

Users browsing this forum: No registered users and 12 guests