Znote Problem

[Tovar]

Any one know how to fix this problem?

string(42) "SELECT ip, value FROM znote_visitors"
(query - SQL error)
Type: select_multi (select multiple rows from database)

This appear when I try to enter in the site.

Znote told me to do this.

After you enable the appropriate php extention:
extension=php_mysqli.dll (windows)

After that it should work. Znote AAC still only works with a mysql server, but uses the mysqli class to establish and communicate with the server.

and I've search on the Uniserver menu and php_mysql and php_mysqli both are enable.... :/

 

[Thosh]

Look into the php.ini and search for that extension. I don't really know where the ini is located, but it should be inside the php folder.

 

[Tovar]

Yes I've found it but it seems to be activated :S @Znote Help please :S

BUMP

 

[dominique120]

Skip to the installing on windows part: http://www.php.net/manual/en/mysqli.installation.php

This is when you installed php as stand-alone and not with somethng like uniform server or xampp. It should give you some pointers. You can probably get the dll from here but idk for certain.

 

[Tovar]

If someone have the same problem, go to www/engine/database/connect.php and search for the line

function mysql_select_multi($query){

and after it put

global $connect;

this is how I fix it.

 

[Znote]

If someone have the same problem, go to www/engine/database/connect.php and search for the line

function mysql_select_multi($query){

and after it put

global $connect;

this is how I fix it.

Like: https://github.com/Znote/ZnoteAAC/blob/master/engine/database/connect.php

Znote AAC already contains that line of code, perhaps you used an old mysqli rev?

 

[Tovar]

Like: https://github.com/Znote/ZnoteAAC/blob/master/engine/database/connect.php

Znote AAC already contains that line of code, perhaps you used an old mysqli rev?

I got some features and I didn't want lost it, so I've copy all your commits manually but I guess I forget that line, so I used "Compare it" (software to compare different text files) and I fix the problem.

 

[Znote]

Ahh yeah.