FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » MySQL? problems with V2.7.7rc2
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
MySQL? problems with V2.7.7rc2 [message #37638] Mon, 11 June 2007 15:33 Go to previous message
Astoria is currently offline  Astoria   United States
Messages: 227
Registered: April 2004
Karma:
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 &lt;a href=\&quot;index.php?t=index\&quot;&gt;forum list&lt;/a&gt;', returnto='t=index&amp;' WHERE id=<br />
_GET: array (
't' =&gt; '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

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: administrator - cannot access control panel
Next Topic: FUDforum 2.6.0 with MySQL 5.0.38 :: Installation Failed
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 02:32:47 GMT 2024

Total time taken to generate the page: 0.05288 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software