Znote Importing schema to a TFS database in phpmyadmin

[betoxz]

Hello ppl from otland, i was trying today to import the schema from znote to my database from phpMyAdming, so i copied the text and past it, in a new sql query but..

I get this error when i press GO down below... does anyone knows how to fix it? THANKS in advace! I will give rep++

 

[strutZ]

hahaha oh you cutey... Looks like you forgot to enter your SQL details in your config file! Go inzto znote root and edit the config file should find this

    // ------------------------ \\
    // MYSQL CONNECTION DETAILS \\
    // ------------------------ \\

    // phpmyadmin username for OT server: (DONT USE "root" if ur hosting to public.).
    $config['sqlUser'] = 'enter user here';

    // phpmyadmin password for OT server:
    $config['sqlPassword'] = 'password here';

    // The database name to connect to. (This is usually same as username).
    $config['sqlDatabase'] = 'database name here';

 

[betoxz]

no it did not work, i edited this part in config.php but it stills gives me the same error :s .. is there a syntax error maybe in the code from znote? it appears to be cooldown? i dont know plz help :'(

 

[Cornex]

no it did not work, i edited this part in config.php but it stills gives me the same error :s .. is there a syntax error maybe in the code from znote? it appears to be cooldown? i dont know plz help :'(

It clearly gives you a failed to connect to mysql error in the top. The connection details are wrong, or you haven't installed/started mysql.
You will only see that page on znoteaac when connection fails, not when it missing tables, then it will just give you errors about it.

 

[strutZ]

well looking at your first screenshot where it says access denied that is defs your problem. you are getting the internal server error becuase znote couldnt add the columns in. all i can say is maybe delete everything and start again and post errors here. i'll try my best to help.

 

[betoxz]

alright i stated again, and i noticed something strange.. when importing schema.sql, it add the tables but does not add any row... is that normal?

edit: i am using this guide

 

[Codex NG]

Why is the sql not installed automatically, why is this still a manual thing.. if used correctly php can do some amazing things

 

[SlayingWorld]

If your using my tutorial i recommend using this version of uniserver.
11_8_2_ZeroXI

 

[Andréew]

I had the same problem and Slayingworlds tip helped me out!

 

[betoxz]

If your using my tutorial i recommend using this version of uniserver.
11_8_2_ZeroXI

This worked just fine! thanks so much! and sorry for the late answer xd