mysql problem

Alan · Post by **Alan** » Sat Apr 21, 2007 3:02 pm

I have just published my first Aware project.
I am using MYSQL for the database.
Everything works correctly in the test mode but when I try to add data to the published version I get the following error.

Internal error. Error persisting business object Screens Table basdb.intranet_screens doesnt exist

Any suggestions ?

Thanks

tford · Post by **tford** » Sat Apr 21, 2007 7:08 pm

I might have had a similar experience the other day. I inherited an Access database with spaces in the table names and field names. I used a conversion program to move it to MySql & connected it to AwareIM. AwareIM did not complain about the spaces & the Integrity Check did not complain about them either. But, when I tried to test it, I got an error message.

Try taking out the spaces from your table name & see if that works??

Tom