Can't create accounts on Znote

[Blasphemy]

Hi everyone,
When i try to create accounts on my website, this error happens... what should it be?

I'm using the last Znote version.

 

[Evil Puncker]

if you think it is a bug, report it here

 

[Znote]

Why does your accounts table have a column named page_lastday? Looks like another AAC installation has thrashed your database.
You can probably remove that column.

What distro are you using, and what AAC have you tried to install previously?

 

[Blasphemy]

Why does your accounts table have a column named page_lastday? Looks like another AAC installation has thrashed your database.
You can probably remove that column.

What distro are you using, and what AAC have you tried to install previously?

Hi Znote!
Acctually I'm using an OTX distro based on TFS0.3 (I think).

Respect the database,I actually created another one with a clean sql file... anyways I really don't know if that is right tho...
Also, I follow a very old video tutorial to instal Znote, that you uploaded, and when I created an user for my DB it begin to crash... maybe there's the problem

 

[Znote]

Hi Znote!
Acctually I'm using an OTX distro based on TFS0.3 (I think).

Respect the database,I actually created another one with a clean sql file... anyways I really don't know if that is right tho...
Also, I follow a very old video tutorial to instal Znote, that you uploaded, and when I created an user for my DB it begin to crash... maybe there's the problem

Go into phpmyadmin and enter the accounts table, and delete the column page_lastday

 

[Blasphemy]

ps: I tryed to use a Gesior application before... but just as I mentioned before, I deleted that DB and created another one.

Post automatically merged: Feb 20, 2020

Go into phpmyadmin and enter the accounts table, and delete the column page_lastday

Ok, I'm doing this right now!
I'll post results ASAP...
ps: I have another issue, a friend of mine tryed to connect to the website and show me this error (he couldn't even get into the index):

Post automatically merged: Feb 20, 2020

Go into phpmyadmin and enter the accounts table, and delete the column page_lastday

Didn't work

I think im dropping this DB and doing a new other haha

 

[Znote]

edit config.php and set $config['log_ip'] = false;

Or try to execute this SQL:

ALTER TABLE `znote_visitors` CHANGE `ip` `ip` BIGINT(20) NOT NULL DEFAULT '0';
ALTER TABLE `znote_visitors_details` CHANGE `ip` `ip` BIGINT(20) NOT NULL DEFAULT '0';

I havent tested ip logging properly in the IPv6 world.

 

[Blasphemy]

edit config.php and set $config['log_ip'] = false;

Or try to execute this SQL:

ALTER TABLE `znote_visitors` CHANGE `ip` `ip` BIGINT(20) NOT NULL DEFAULT '0';
ALTER TABLE `znote_visitors_details` CHANGE `ip` `ip` BIGINT(20) NOT NULL DEFAULT '0';

I havent tested ip logging properly in the IPv6 world.

Did all and I have another new error... I think something went wrong with this PC or something that is out of my knowledge...
I'll try to do all from begining in another computer.

Very grateful of u Znote <3