Need help with znote website :)

[naod123456]

I cant make acc on my znote website when i make a acc this comes up "Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\Viktigt\htdocs\engine\function\users.php on line 1333
Register Account
Unknown column 'name' in 'field list'"

And when am trying to log in this comes up "Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\Viktigt\htdocs\engine\function\users.php on line 1333
We tried to log you in, but...

Failed to authorize your account, are the details correct, have you registered?"

Why please help!

- - - Updated - - -

please help

- - - Updated - - -

please help :/

 

[Angry encoder]

Can you post line 1300-1335?

 

[naod123456]

how do i find the line 1300.1335 i know that i find it in users but how do i find line 1300-1335?

 

[Ninja]

line 1333

return (mysql_result(mysql_query("SELECT COUNT('id') FROM `accounts` WHERE `name`='$username';"), 0) == 1) ? true : false;

Have you imported the mysql schema that follows with TFS to your database?

 

[naod123456]

ahh no

- - - Updated - - -

how do i get mysql schema?

 

[Ninja]

ahh no

- - - Updated - - -

how do i get mysql schema?

Which TFS version are you using?

You can download mysql schemas from the Public Subversion, (tags/your_tfs_version/schemas/mysql.sql)

 

[naod123456]

i use 0.3.6 (8.60)

- - - Updated - - -

I got the mysql schema now what shuld i do with it?

 

[Ninja]

Enter phpMyAdmin -> select database -> import -> choose file to import or look at Znote's tutorial if you don't understand completely.

[video=youtube;AsyxPhDTOcI]http://www.youtube.com/watch?feature=player_embedded&v=AsyxPhDTOcI[/video]

 

[naod123456]

I have watched his toturial i have impoted the sql file to phmyadmin that i dont understand is shuld i import mysql, pgsql or sqlite?

 

[Ninja]

Import the mysql file.