TSSE v5.6 DECODED (NULLED BY Nightcrawler)

[FireDK]

Great job with the nulling. Many thanks!

I have a problem with my install, though: when I go into the Track Settings to configure my install, I get a "An error has occured! MySQL Error!" page on every option in the left side menu.

Since it's not a specific error, I have no idea what's causing it so I can try and fix it.
If anybody has any ideas, please share.

My install is a test on localhost, with Apache 2.2.14, PHP 5.3.0 and MySQL 5.1.39

[Nightcrawler]

Originally Posted by FireDK

Great job with the nulling. Many thanks!

I have a problem with my install, though: when I go into the Track Settings to configure my install, I get a "An error has occured! MySQL Error!" page on every option in the left side menu.

Since it's not a specific error, I have no idea what's causing it so I can try and fix it.
If anybody has any ideas, please share.

My install is a test on localhost, with Apache 2.2.14, PHP 5.3.0 and MySQL 5.1.39

Is it windows?

Originally Posted by pergo

hi,

i can't install this version i get a error that de database file most be uploaded in binary ??? step5

i'm ussing plesk9.0 windows2003.

i want to test it.

thanks in advanced

transfer it with ftp in binary mode.

[FireDK]

Originally Posted by Nightcrawler

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).

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.

$__return = mysql_query ($_run_query);

Here I get this error:

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.

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

Modified: `page` mediumtext NOT NULL,

[Nightcrawler]

Originally Posted by FireDK

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

Well I heard there was a bug in php 5.3.0 with "php5.3.0/ext/php_mysql.dll"
and what you need to do is download phpbb5.2 and replace the "php_mysql.dll" in it in the Php5.3 directory.

[fireman]

nice work

[konvolut]

At first ty nightcrawler for your perfect work. But still having problems with changing Tracksettings.
Did anyone has a reason why i cant change the trackersettings. Settings are not saved for me after setting. ty

[Nightcrawler]

Are your config files readable/writable by server?

[konvolut]

Ty, it was really a chmod problem in config dir. Sry! But an important question, what are the right permissions in this directory? Because in installation guide it shows like Chmod 0777 but I think its unbelieveable becuase every user can read and execute files in config dir. And htaccess dont work for me with lighty webserver. Best regards

[Nightcrawler]

best to fix all settings then make them just readable by server only.

[konvolut]

okay, ty again. Last question. I have also a big problem with recaptcha. I set in to on and now To use reCAPTCHA you must get an API key from...!

Okay my mistake but I have there an account and keys. But now I cant change to Trackersettings again because this mistake. Did someone know where are the settings in DB to change login without recaptcha manually or where i can put into my keys manually to login again and make it clean?

_______________________________________________
EDIT

I fixed it...!