Bravo List - Problem with source

Bravo List (http://www.bvlist.com/index.php)

- TBDev (http://www.bvlist.com/forumdisplay.php?f=20)

- - Problem with source (http://www.bvlist.com/showthread.php?t=1040)

Problem with source

Hello every1 ! I have a problem ^ I made all tracker when i go to signup page and singup .... it say BORKED
what is this ?!

You will have to give more info mate.The borked error comes when an mod doesn

Quote:

Originally Posted by ionutzsami (Post 4363)

Hello every1 ! I have a problem ^ I made all tracker... when i go to signup page and singup .... it say BORKED ... what is this ?!

I dont know about any one else but I can not see that at all

First i Made my Tracker....Download TBDEV v1.7 ... puted in c:/xmapp/htdocs .... edited files... secrets.php etc....Cliked on http://localhost/phmyadmin and import the sql....when i puted all ... i entered in http://localhost/ ... The was very nice...when i click signup ... i put there username password country etc....when i click signup (press only once) go... and there it say : SignUp Failure ! BORKED

http://img81.imageshack.us/img81/935...signup2ki4.png

Btw i dont have a windows 98 .... its just XP but i like the classic windows bar

post your signup.php and takesignup pages in code tags so we can take a look

im 99.9% certain its the main insert query. either the premodded source inserts an IP on signup but the var holding the IP is not being populated or possibly a field mismatch error somewhere

also a little tip ... any sql queries in a script that is not working should be appended with sqlerr(__FILE__,__LINE__); to give you a detailed output of the problem

i.e

Code:

$res = mysql_query("SELECT values FROM table WHERE value='var'");

becomes

Code:

$res = mysql_query("SELECT values FROM table WHERE value='var'") or sqlerr(__FILE__,__LINE__);

I gave u to download these two files .... not big :) max 10 kb :)

i havent got a clue .. ive put ur takesignup and signup pages onto my server and tried them and they work fine .. it creates teh user account and attempts to send an email so i dunno whats wrong with urs .. all i can suggest is

1. make sure you have correctly filled in the mysql information with the correct formatting of ur username and password

2. Turn off magic quotes

3. add sqlerr to the end of the query to see if it gives you a different error

i.e. in takesignup.php, change this

Code:

$ret = mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .

                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).

                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')");

Code:

$ret = mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .

                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).

                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')") or sqlerr(__FILE__,__LINE__);

and see if it gives a diff error

Now it say :

SQL Error
Field 'title' doesn't have a default value
in C:\xampp\htdocs\takesignup.php, line 113

this is sometimes caused by a setting in my.cnf (the mysql settings file). If you have access to my.ini then remove STRICT_TRANS_TABLES from your SQL mode in my.ini

otherwise the only other thing i can suggest is go to phpmyadmin, go to your users table, click edit next to the title field (usually a pencil image) and then you can either set the column "NULL" to "Null" rather than "Not Null" or you can set a default value for title .. i would suggest changing the null value rather than the title due to how tbdev is coded (i wont go into it as you dont need to know unless you ask lol)

but first if you have access to my.ini definately try the first thing i mentioned as it will stop any of these errors appearing again (unless ofcourse u mess an sql query up then thats ur problem not the servers lol)

Pff....

I let this tb dev and gonna try Yuna Scatari ! Please go to Yuna Scatari topic :)) and go to PROBLEM... i have a problem at 7/10 - SETUP