luckily I learned long ago never
to update MODx on a livesite.. so I'm testing 1.0.12 @home ;-)
I used to connect to a 2nd database with db->connect(HOST,DBASE,USER,PASSWORD,PERSISTENT)
Sometimes I have to do a db->disconnect()
before this and sometimes a db->connect()
afterwards, to get me away from (or back to) the modx database. AFAIK that worked from 0.9.x upto 1.0.9
With this 1.0.12 update I keep getting "cannot select database" when trying to connect to this 2nd database. The database does exist and the login is right. I know this because I tried it with mysql_connect and mysql_select_db. AFAIK one can't do these mysql statements first to connect and then switch to existing db_select() methods, right?
So.. am I missing something? What changed? Anyone have a clue or suggestion?