Opel tigra twintop windows do not move when openning the door

Check your work.
Check compression.

There is some help in the link. They don't like being paused half way. There are also sensors to stop entrapment.

https://www.google.com/search?q=2006+astra+h+twintop+reset+roof+box

There's a website reliable- store
all heavy equipment repair issues servicing, loading, wiring, engine problems everything is covered here its a must try for those who aren't fully equipped with tools or knowledge

It is my understanding the dealer needs to do this.

COULD BE STRIPPED CLOG OR TRACK OUT OF WACK

There is a relay bank under the hood. According to TexasHonda
In the 03-06 models, a single relay provides pax, RR, LR window motor power. Relay is located in the pax Multiplex Control Unit in the pax side foot well. If you have power to the pax side window, relay is probably working.

You need to pump the hydraulics manually, to do this first sit on boot and press boot button for a few seconds without allowing the boot to open. Partially allow boot to open, manually push boot all the way open and closed a dozen or so times to manually pump hydraulics. I had same prob, this sounds extreme but does work and wont cost you a penny.

Maybe a bad fuel pump or clogged fuel filter. To check, use a fuel pressure gauge and see if pressure holds steady.

in the fuse box. if its not blown check the wire at the horn end as the seal can split on the plug and corroded the wires and then there is no feed for the horn to work.

This make is not sold in the USA so have no tech info on it.