Help - Search - Members - Calendar
Full Version: Attempting to convert to sql...
Movable Type Community Forum > Installing and Upgrading > Databases
djwudi
Howdy - working on getting transferred over to MySQL, and when I fired up mt-db2mysql.cgi, I got this error:

QUOTE
**** WARNING: Unrecognized escape \h passed through at /Library/WebServer/CGI-Executables/mt/lib/MT/Util.pm line 251.

**** WARNING: Unquoted string "l" may clash with future reserved word at /Library/WebServer/CGI-Executables/mt/plugins/load.pl line 1.

Loading database schema...

Loading data...
MT::Author

An error occurred while loading data:

No ObjectDriver defined at /Library/WebServer/CGI-Executables/mt/lib/MT/Object.pm line 91.


Any ideas?
djwudi
Erk...well, maybe I got some of it. I'd hacked around with the Util.pm to add smileys, and whaddaya know - the script was gagging on one of my additions.

Switched back to the normal version of Util.pm, and I get this...

QUOTE
**** WARNING: Unquoted string "l" may clash with future reserved word at /Library/WebServer/CGI-Executables/mt/plugins/load.pl line 1.

Loading database schema...


An error occurred while loading data:

Table 'mt_author' already exists at /Library/WebServer/CGI-Executables/mt/mt-db2mysql.cgi line 54.


Back to the drawing board...
djwudi
Okay, checked out 'load.pl', and it turns out that it was a plugin that I'd experimented with at one point. Nuked it, tried again.

QUOTE
Loading database schema...


An error occurred while loading data:

Table 'mt_author' already exists at /Library/WebServer/CGI-Executables/mt/mt-db2mysql.cgi line 54.


I feel like I'm making progress...I'm a bit hesitant to go poking around inside mt-db2mysql.cgi, though. Maybe I should actually just wait for a response before proceeding further? wink.gif
djwudi
Okay, I am making progress here. Apparently the conversion had started on one of the first tries, and had already created the needed tables. When the script failed 'cause I goofed things up, the next time I tried to run it, it saw that the tables were already there and errored out. Went into MySQL, deleted all existing tables, and tried again.

QUOTE
Loading database schema...

Loading data...
MT::Author

An error occurred while loading data:

No ObjectDriver defined at /Library/WebServer/CGI-Executables/mt/lib/MT/Object.pm line 91.
djwudi
Okay - line 91 of Object.pm is

CODE
die "No ObjectDriver defined" unless defined $DRIVER;


Pretty obvious there - for some reason, the system doesn't know what ObjectDriver to use/look for/poke with a sharp stick/whatever.

Now, in my mt.cfg, I've commented out the mtdb line, and added the required MySQL lines as such:

CODE
# DataSource /Library/WebServer/mtdb

ObjectDriver DBI::mysql
Database (database name)
DBUser (username)


Obviously, the databse name and username are as they should be, and not as posted here. smile.gif

So...is there somewhere else I should be defining the ObjectDriver? There's obviously _some_ amount of connectivity between MT and MySQL - I just checked again, and the tables inside the database that I'd just dropped are there again. They're all empty, but they do exist.

Now what?
djwudi
Okay - much thanks to girlie for helping someone else with the same problem!

http://www.movabletype.org/cgi-bin....t=12218

Maybe this could use a bit more clarity in the manual? I was under the impression (and apparently the other person was too) that it was an either/or situation - and while I suppose that normally that would be the case, during the conversion you need both.

Now I know. And knowing is half the battle. G.I.Joe!

Anyway, conversion's in process now. Hopefully this'll be the last of my blather here... biggrin.gif
djwudi
Okay, if someone takes a peek at this - I keep seeing this line pop up every so often during the conversion process:

QUOTE
**** WARNING: Use of uninitialized value in string eq at /Library/WebServer/CGI-Executables/mt/lib/MT/Util.pm line 478.


Is this anything I need to worry about? I figure worst case scenario, it's something that'll break the whole thing (doubtful, since the conversion is still going), and best case scenario, it's just picking up on entries where I didn't escape all the characters in some obnoxiously long URL correctly.

The real answer, of course, will probably be somewhere between the two extremes.

Oh, and checking line 478 of Util.pm didn't help - all it is is
CODE
next unless $find_all ||
 ???
djwudi
QUOTE
Done copying data from Berkeley DB to MySQL! All went well.


biggrin.gif

(Though, I'm still curious about the 'uninitialized value' errors I mentioned in the post immediately preceeding this one, if anyone has the time...)
YYK
I ran into the same problem as you, because I had that line commented out.

I too interpreted the manual in that way.

Anyway, I got the all is well sign!
tanichka
I got the same error but mine was line 580. Same code on the line, tho. I had successful completion too, and i don't see anything weird with that entry. I wonder what it meant. I got a whole bunch of them... It looks like it might have something to do with trackbacks or pings.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.