search

UIKit0 / freemedforms

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

Zipcodes database queried for non-existing table #271

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
At FMF start I get  several times an error message:
"** ERROR(zipcodescompleters.cpp:140)" "" "SQL Error: 
     * Unable to execute statement
     * no such table: IMPORT
     * SELECT DISTINCT COUNT(`COUNTRY`) FROM `IMPORT` WHERE `COUNTRY`=""" 

So the zipcodes db is queried for the IMPORT table. this table should not exist 
after importing, it gets deleted.

Original issue reported on code.google.com by christian.a.reiter@gmail.com on 8 Jan 2013 at 9:07

GoogleCodeExporter commented 9 years ago 
No no this table is not is kept after importing

Original comment by eric.mae...@gmail.com on 8 Jan 2013 at 9:10

GoogleCodeExporter commented 9 years ago 
Yes, that's what I meant. But at the beginning of FMF it is queried!

Look at zipcodescompleters.cpp, line 128ff. Each time "isCountryAvailable() is 
called, it calls a sql query for the IMPORT table. shouldn't this be "ZIPS"?

Original comment by christian.a.reiter@gmail.com on 8 Jan 2013 at 9:49

GoogleCodeExporter commented 9 years ago 
nop the ZIPS table is kept for 0.7x compatibility. 0.8.2+ will use the IMPORT 
table

Original comment by eric.mae...@gmail.com on 8 Jan 2013 at 9:57

GoogleCodeExporter commented 9 years ago 
ok patched. Will push later

Original comment by eric.mae...@gmail.com on 8 Jan 2013 at 9:59

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision 25d9a3c48d79.

Original comment by eric.mae...@gmail.com on 9 Jan 2013 at 8:37

GoogleCodeExporter commented 9 years ago 
Hm. I set this to not fixed again as it is still not fixed. revision 
25d9a3c48d79 seems to close another bug.

There is the zipcodes.db database opened, but the IMPORT table doesn't seem to 
be existing. My zipcodes.db has only a ZPIS table and 3 indexes. No IMPORT 
table.

Original comment by christian.a.reiter@gmail.com on 9 Jan 2013 at 10:52

GoogleCodeExporter commented 9 years ago 
BTW, zip completion is broken here completely.
downloading the datapack from the server ends in an error (~20x on log):
"Utils" "File 
/home/christian/.freemedforms_debug/datapacks/install/packconfig/freemedforms.ce
rtified.zipcodes.france/packconfig.xml loaded" 
"** ERROR(genericdescription.cpp:196)" "GenericDescription" "Wrong XML. No root 
tag: PackDescription" 

So I can't test/use completion ATM. Did you change something in the package, 
Eric?

Original comment by christian.a.reiter@gmail.com on 9 Jan 2013 at 11:04

GoogleCodeExporter commented 9 years ago 
Ok, please use FreeToolBox to recreate your zip database. Is there a zipcode 
database in the git repo ?

Original comment by eric.mae...@gmail.com on 10 Jan 2013 at 7:10

GoogleCodeExporter commented 9 years ago 
Arrgghhh, I'm in a mess with datapack lib. Many things are not correctly 
working. I'm on...

Original comment by eric.mae...@gmail.com on 10 Jan 2013 at 7:11

GoogleCodeExporter commented 9 years ago 
Thanks, with the newdatapack the autocompleting works.
Just funny that even when I downloaded the french one from the server, it did 
NOT update the zipcodes.db file, so 1. autocompleting did not work. Maybe there 
is something with the downloading and update wrong then.
but this bug is closed now, thanks.

Original comment by christian.a.reiter@gmail.com on 10 Jan 2013 at 3:34

GoogleCodeExporter commented 9 years ago 
Eh eh. I didn't still have time to update the server data :D So FTB is up to 
date but the server isn't...

Original comment by berenger...@gmail.com on 10 Jan 2013 at 3:37

GoogleCodeExporter commented 9 years ago 
ah, ok ;-)
I had very few time the last weeks, so I couldn't do much (as you could see 
maybe). It's getting better now.

Original comment by christian.a.reiter@gmail.com on 10 Jan 2013 at 3:39