| MySQL? problems with V2.7.7rc2 [message #37638] |
Mon, 11 June 2007 15:33  |
 |
Astoria
Messages: 227
Registered: April 2004
Karma: 0
|
Senior Member |
|
|
My new installation was working fine the other day on a shared host. I disabled the forum, resynched the tables and message files with my forum I am trying to port over from another host. Subsequently I am unable to log into the admin account even though I know the password is correct. I had to reset the string by hand in Globals.php to re-enable the forum. I haven't changed any thing else in the forum software other than that, but trying to bring up the forum crashes with:
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /mydatadir/include/core.inc on line 188
I can't log in to my admin account, even though I know I'm entering the correct password.
I get the following message in errors:
) 1064: 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 '' at line 1<br />
Query: UPDATE fud26_ses SET sys_id='', forum_id=0, time_sec=1181555282, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='t=index&' WHERE id=<br />
_GET: array (
't' => 'index',
)<br />
Server Version: ...
I thought there was something wrong with MySQL and have had a ticket open at the hosting company, but they seem to think that everything's fine, even though another standard script that had been working for me the other day was failing last night.
I got a test connection program to fail using a test userid and :tmp/mysql.sock, which was how I'd been connecting. They said that the problem was "the database user" and that they had "fixed" it.
When I plug my "real" userid to the test connection program, it returns:
Failed to connect to MySQL.
Access denied for user '(myuserid)'@'localhost' (using password: YES)
Any idea as to what could be happening? I still think the problem must be something with the server or configuration. PhpMyAdmin doesn't give me a very good look at what's going on.
Also, were there any changes in the _ses table between v2.7.5 and v2.7.7? Would the software care if I flush out its old records?
I've just created a brand new user, gave it full access privileges, changed include/Globals.php to reflect the change, and I still get the same crash, although the user is allowed to connect via my test connection program.
(PS Sorry I could not send you the Globals file from my problem the other day - I had already given up and reinstalled the new version from scratch. It was just the standard file for 2.7.5, which seems to be in the old globals format so maybe that was the problem)
[Updated on: Tue, 12 June 2007 04:31] Report message to a moderator |
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37642 is a reply to message #37638] |
Mon, 11 June 2007 22:19  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Can you try to delete all entries inside the fu26_ses table. Then clear your cookies for the forum and try to login again. You should also try logging in directly via the admin control panel.
FUDforum Core Developer
|
|
|
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37644 is a reply to message #37642] |
Tue, 12 June 2007 02:02 |
|
Astoria
Messages: 227
Registered: April 2004
Karma: 0
|
Senior Member |
|
|
Hello again,
I deleted all the session records, and erased my cookie. Since the fourm is disabled, I tried to get in via admlogin, which returned me to the login form. The end of the url looked like this when I got back: admloginuser.php?&SQ=0
So, I flipped the bit in fud_opt_1 in the Globals file to reenable the forum, and got the "core.inc" line 188 error again when trying to get to the main index. sql error log read as follows:
| Quote: |
) 1064: 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 '' at line 1
Query: UPDATE fud26_ses SET sys_id='', forum_id=0, time_sec=1181613240, action='Browsing the <a href=\"index.php?t=index\">forum list</a>', returnto='t=index&' WHERE id=
_GET: array (
't' => 'index',
)
Server Version:...
|
Should id have a value, and shouldn't there be a terminating semicolon on that sql statement?
|
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37651 is a reply to message #37644] |
Tue, 12 June 2007 18:56 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
id should be the id of the current session. It most definitely should not be blank.
What is your SESSION_TIMEOUT and COOKIE_TIMEOUT settings inside GLOBALS.php set to?
FUDforum Core Developer
|
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37652 is a reply to message #37651] |
Tue, 12 June 2007 19:13 |
|
Astoria
Messages: 227
Registered: April 2004
Karma: 0
|
Senior Member |
|
|
They read as follors:
$COOKIE_TIMEOUT = 1209600; /* seconds */
$SESSION_TIMEOUT = 1800; /* seconds */
URL sessions are disabled; I don't like using them.
In other news, I was able to get admin login to work on the 2.7.5 site. My browser apparently had some weird glitch going on yesterday (firefox on ubuntu). At the 2.7.7 site the login screen still just reappears with the &sq=0 at the end of the url though.
addendum: A cookie was created with my admin login attempt at the 2.7.7 site this morning. It looks normal, contains a session ID, and doesn't expire until June 26th.
I see the difference in the admin urls now - on the successful login at 2.7.5 there is a session ID before the "sq=0" in the URL. So there is some kind of problem getting the session ID out of the cookie? Are there any server security settings you know of that could be affecting this?
[Updated on: Tue, 12 June 2007 19:46] Report message to a moderator |
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37654 is a reply to message #37638] |
Wed, 13 June 2007 05:10 |
|
Astoria
Messages: 227
Registered: April 2004
Karma: 0
|
Senior Member |
|
|
Finally heard back from the hosting company, after more than 6 hours since I reopened the ticket, which they had closed as "resolved".
The email informed me that the server can't block cookie creation (I never suggested it could) and opined that since it's a "database error" that it must be the programmer's fault.
So, this will be not only my first but also my last month of "service" with this hosting company. I've signed up elsewhere.
[Updated on: Wed, 13 June 2007 05:16] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: MySQL? problems with V2.7.7rc2 [message #37677 is a reply to message #37669] |
Thu, 14 June 2007 23:39 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
That could definitely cause the problem. The forum files should definitely be owned by the web server user.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]