Re: Migrate 2.2 to new 3.0 site - error in the database query!
The problem is caused by bringing the 2.4 database to the new 3.0 site and then upgrading the database to 3.0.
Last time, when my old site was still in 2.2, I've made a new 2.2 site. Exported the database and imported it in the 2.2 site and then used the 2.2 to 2.3 script, the 2.3 to 2.4 script and the 3.0 upgrade script.
That went allright.
Now when trying to upgrade the 2.4 database in the 3.0 site, the upgrading goes ok (no errors there), but when entering the site I get the following error on every page.
" error in the database query"
Message:
Built query was probably:"
It's not possible to paste the error in a CODE. It gets destroyed.
I think i can solve this by installing a new 2.4 site from scratch, then export and import my 2.4 database into this 2.4 site. Then copy all 3.0 files over the 2.4 site, then upgrade the db to 3.0. But, this is quite a long way...
Suzanne