Welcome to Geeklog, Anonymous Thursday, November 14 2024 @ 04:07 pm EST

Geeklog Forums

SQL errors


Nox

Anonymous
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
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

All times are EST. The time is now 04:07 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content