Geeklog Forums

Hey everyone.

I have migrated sites from one server to another in the past, without error, but this time I am having a heck of a time.

The problem:
Something along the xfer is adding new lines into just about every file.
So that code gets broken into bits. I have gone through and fixed whatever I get an error message for, but now I am at a standstill.

I only have FTP to work with, no SSH or uncompression or un-archiving utilities, IE tar. Because of this I have had to install an FTP client that supports directory xfer onto my mac, then down / upload the entire directory tree.

So after many hours of removing newlines, I get this:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'emote_ip = 'xx.xx.xx.xx')' at line 2. SQL in question: SELECT uid FROM gl_sessions WHERE (sess_id = '2005763854') AND (start_time > 1091456704) AND (r emote_ip = 'xx.xx.xx.xx')

I can see the issue, remote has a space in there
r emote_ip='etc'

The problem is I cant find which file is sending this info,
I have grepped the entire directory tree, then file by file, but still nothing.

If anyone can tell me where this is located, or why newlines are being added when I xfer the directory.

Thanks

The line you're looking for is in system/lib-sessions.php, in function SESS_getUserIdFromSession().

YOu can make your life a lot easier, though, if you simply upload all the files in binary mode.

bye, Dirk