Re: [sqlite] error "malformed database schema" on view in attached table

[Gert Van Assche]

Bingo! That was indeed the problem, Kevin.

I'm sorry I did not find that user group posting.

Thanks.


2014-07-01 11:30 GMT+02:00 Kevin Benson :

> On Tue, Jul 1, 2014 at 5:07 AM, Gert Van Assche  wrote:
>
> > All,
> >
> > I get this error message:
> >
> > malformed database schema (WrongTargetLang) - view [WrongTargetLang]
> cannot
> > reference objects in database main
> >
> > when I try to attach a database containing a view. If I delete the view,
> I
> > get this message for another view. I get that message for all views.
> >
> > I can open that DB without any problem, but when I open it as an attached
> > db in the sqlite3 shell (in windows), this happens.
> >
> > Anyone any idea what is happening?
> >
> > thanks
> >
> > gert
>
>
> Perhaps you're referencing- main -in your view?
> http://comments.gmane.org/gmane.comp.db.sqlite.general/51366
>
> --
>--
>   --
>  --Ô¿Ô--
> K e V i N
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] error "malformed database schema" on view in attached table

[Richard Hipp]

Can you please send us the complete schema (as shown by the ".schema"
command in the command-line shell) for both the original database and the
database you are trying to attach?


On Tue, Jul 1, 2014 at 5:07 AM, Gert Van Assche  wrote:

> All,
>
> I get this error message:
>
> malformed database schema (WrongTargetLang) - view [WrongTargetLang] cannot
> reference objects in database main
>
> when I try to attach a database containing a view. If I delete the view, I
> get this message for another view. I get that message for all views.
>
> I can open that DB without any problem, but when I open it as an attached
> db in the sqlite3 shell (in windows), this happens.
>
> Anyone any idea what is happening?
>
> thanks
>
> gert
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] error "malformed database schema" on view in attached table

[Kevin Benson]

On Tue, Jul 1, 2014 at 5:07 AM, Gert Van Assche  wrote:

> All,
>
> I get this error message:
>
> malformed database schema (WrongTargetLang) - view [WrongTargetLang] cannot
> reference objects in database main
>
> when I try to attach a database containing a view. If I delete the view, I
> get this message for another view. I get that message for all views.
>
> I can open that DB without any problem, but when I open it as an attached
> db in the sqlite3 shell (in windows), this happens.
>
> Anyone any idea what is happening?
>
> thanks
>
> gert


Perhaps you're referencing- main -in your view?
http://comments.gmane.org/gmane.comp.db.sqlite.general/51366

--
   --
  --
 --Ô¿Ô--
K e V i N
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] error "malformed database schema" on view in attached table

[Gert Van Assche]

All,

I get this error message:

malformed database schema (WrongTargetLang) - view [WrongTargetLang] cannot
reference objects in database main

when I try to attach a database containing a view. If I delete the view, I
get this message for another view. I get that message for all views.

I can open that DB without any problem, but when I open it as an attached
db in the sqlite3 shell (in windows), this happens.

Anyone any idea what is happening?

thanks

gert
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users