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
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
5
3
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
YOu can make your life a lot easier, though, if you simply upload all the files in binary mode.
bye, Dirk
2
6
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