search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

SQL import not working on Staging #770

Closed MerielP closed 8 years ago

MerielP commented 8 years ago

I've just tried uploading an SQL file to Staging, in the database 'Second upload test', in the project 'Staging test'.

I got the messages telling me that my database had been sent to the server for processing, and that the import was successful. However, when I went and looked at the database, I found it was completely empty. There are no tables visible in either the schema designer or the table list.

The same file uploaded to App works perfectly well, so it's not the database itself causing the problem.

thestoat commented 8 years ago

I have tried this with a couple of files and all worked well so it must have something to do with the file you are using. Are you able to add that here or email it to me?

MerielP commented 8 years ago

The file I used is attached (in a zip folder, as Github will only accept certain formats):

Club membership database - expanded.zip

thestoat commented 8 years ago

The problem was spaces in the file name. Should be ok now

MerielP commented 8 years ago

Sorry - I'm still having the same problem as before. You can see this in the database called 'SQL upload text redux' in the project 'Staging test'.

thestoat commented 8 years ago

Does this happen on Dev? Because of course the fix I added went to dev and won't currently be in Staging

MerielP commented 8 years ago

Good point - sorry!

I've tried it on Dev, and it seems to be working fine there, so I'll close this issue.