# solution import trouble continued **URL:** \ **Category:** Classic Servoy\ **Created:** [December 14, 2004, 3:11pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281 "2004-12-14T15:11:51Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [December 14, 2004, 3:11pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/1 "2004-12-14T15:11:51Z")
Hello, after having this Oracle problem when trying to import a solution I now tried mySQL. Here I am getting this error: > com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: Syntax error or access violation message from server: “Incorrect column specifier for column ‘name’” Strange thing: upon first try, some 30 tables were created. When I try once more I have some 60 tables, next time almost 80, then 82, then 94, 94 again, next time 95, then 97; that’s as far as I get, missing a few tables. Sorry to be so annoying, but I think this should work. Thanks Patrick ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [December 16, 2004, 4:32pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/2 "2004-12-16T16:32:29Z")
This seems to me a bug in your database or driver, Servoy will time upon time create and execute the same SQL! ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [December 16, 2004, 5:46pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/3 "2004-12-16T17:46:12Z")
It’s a newly downloaded mySQL with latest driver. ![:?]( "Confused") What I did: download and install mySQL, created a repository and imported a solution that was developed on MS SQL Server. It simply doesn’t work with my solution. ---
**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\ **Post date:** [December 17, 2004, 10:06am UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/4 "2004-12-17T10:06:43Z")
I can think of 3 possibilities: 1-bug in database or driver 2-“access violation” database user/pass has not enouf priviliges todo all the actions 3-bug in Servoy (very unlikely in this senario) To rule out: 3-try importing on sybase for example 2-check priviliges 1-try older stable version of that db ---
**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\ **Post date:** [December 19, 2004, 5:41pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/5 "2004-12-19T17:41:28Z")
can you also see which table it fails exactly? If you start the developer with -DSTACKTRACE=TRUE then what is the last create table statement that fails? ---
**Author:** ![OGTDan](https://avatars.discourse-cdn.com/v4/letter/o/c77e96/32.png) [@OGTDan](https://forum.servoy.com/u/OGTDan)\ **Post date:** [December 22, 2004, 12:47am UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/6 "2004-12-22T00:47:33Z")
Can you do a quick dump of the table structure of the database? It sounds to me like you’re trying to import a values mismatching what the database is expecting. For example, trying to import a `firstname` column into an `id` column. Id est, the `id` column is most likely auto\_increment, which requires the column to be of type INT. The `firstname` column would most likely be of type VARCHAR. Do a structural export and look it over. You may notice something right off the bat. If not, post it in here and we can all look it over. If nothing else it would help rule that out. ---
**Author:** ![grahamg](https://avatars.discourse-cdn.com/v4/letter/g/a4c791/32.png) [@grahamg](https://forum.servoy.com/u/grahamg)\ **Post date:** [December 22, 2004, 12:49pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/7 "2004-12-22T12:49:17Z")
Haven’t got any answers for Patrick but maybe my problem will assist his trouble-shooting. Getting same error message “… incorrect column specifier for column tr\_id…” when trying to import a solution developed on my laptop onto a Server (as new solution). The column in question is the PK and Sequence Type had been set to ‘db identity’. Laptop development was using Servoy/Sybase but import was to MySQL on Win 2K Server. Server ISP suggesting maybe incompatibility between Sybase & MySQL but other guidance/suggestions welcomed. Thanks GrahamG LAPTOP Servoy Developer Version R2 2.1.2-build 315 Java version 1.5.0-b64 (Windows XP) SERVER Servoy Developer MySQL 4.0.16 Version R2 2.1.2-build 315 Java version 1.4.2\_05-B04 (Windows 2000) Apache Tomcat/4.0.1 ---
**Author:** ![Harry\_Catharell](https://avatars.discourse-cdn.com/v4/letter/h/e19adc/32.png) [@Harry\_Catharell](https://forum.servoy.com/u/Harry_Catharell)\ **Post date:** [December 22, 2004, 5:11pm UTC](https://forum.servoy.com/t/solution-import-trouble-continued/3281/8 "2004-12-22T17:11:55Z")
Hi Graham, Wondered why you had not called today !! I have a MySQL 4.x setup in the office running on OS X If you would like me to try a test import here then feel free to call and we can talk it through. Must speak tyomorrow anyway ! Cheers Harry