View Single Post
  #33  
Old 17th October 2009, 14:54
FireDK FireDK is offline
Member
 
Join Date: Oct 2008
Romania
Posts: 4
Default
Quote:
Originally Posted by Nightcrawler View Post
Is it windows?
Yeah, it is.



I've managed to narrow down the error to this part of the /include/ts_functions.php (around line 540).

Code:
if (0 < count ($updateuser))
    {
      (sql_query ('UPDATE users SET ' . implode (', ', $updateuser) . ('' . ' WHERE id=' . $id)) OR sqlerr (__FILE__, 378));
    }
This lead me to line 87 of the same file, inside the sql_query function.

Code:
$__return = mysql_query ($_run_query);
Here I get this error:

Code:
Query: UPDATE users SET page = '/admin/managesettings.php?do=main&sessionhash=okgljrdtjg3lucgicvnpe9p1a1&tshash=948fe263ac6c9faf86a9d5885cc25cdb', last_login = '2009-10-17 15:22:36', last_access = NOW() WHERE id=3

Error: Data too long for column 'page' at row 1
So I guess the 'page' column shouldn't be so small in the install script (create_tables.php, line 1191). I've modified it to a 'mediumtext' and all seems OK for now.

Code:
Original: `page` varchar(100) NOT NULL default \'\',

Modified: `page` mediumtext NOT NULL,
Reply With Quote