User creation on anote server
Brought to you by:
mafiaflysoft
I have created the anote database with the 3 tables.
After modifying the server's address, the user does not
get created on the new server.
My apache logs do not show error messages and the
PHP script get executed. However, the tables stay
empty.
I have also installed anote on my portable and tried to
use the same name and password as on my desktop, but
I am not able to retrieve my notes from the central
database server.
Logged In: YES
user_id=356013
youll have to do 3 things:
first, configure init.php and connect.php with username,
password, db name and db server to fit your needs. the
configured user needs to have at least write and read rights
within the database, maybe more i dont know. ive granted full
access.
second, uncomment the 6th line in getnotes.php ( the include
("init.php") thing).
last, append 6 new fields to the database, called
`slidedleft` text NOT NULL,
`slidedright` text NOT NULL,
`slidepositionleft` text NOT NULL
`slidepositiontop` text NOT NULL,
`slidepositionright` text NOT NULL,
`slidepositionbottom` text NOT NULL
all not null and all of type text.
or alter your "create database.txt" with the following code to
include the six fields, and re-import (probably after deleting
the anote database)..
CREATE TABLE `note` (
`userid` int(11) NOT NULL default '0',
`noteid` text NOT NULL,
`noteversion` int(11) NOT NULL default '0',
`text` text NOT NULL,
`alarmtime` text NOT NULL,
`usealarm` enum('true','false') default 'false',
`title` text NOT NULL,
`visible` enum('true','false') NOT NULL default 'true',
`notecolor` int(11) NOT NULL default '0',
`positionleft` int(11) NOT NULL default '0',
`positiontop` int(11) NOT NULL default '0',
`width` int(11) NOT NULL default '0',
`height` int(11) NOT NULL default '0',
`dockedleft` text NOT NULL,
`dockedtop` text NOT NULL,
`dockedright` text NOT NULL,
`dockedbottom` text NOT NULL
`slidedleft` text NOT NULL,
`slidedright` text NOT NULL,
`slidepositionleft` text NOT NULL
`slidepositiontop` text NOT NULL,
`slidepositionright` text NOT NULL,
`slidepositionbottom` text NOT NULL
) TYPE=MyISAM;
Logged In: NO
Shatting, you forgot the comma's on some of the lines below.
People please add a comma where it is missing at end of line
on SQL attached to this post.
Cheers for reply though Shatting, it does work :D
Although this issue was apparently solved for the submitter, I still think the report should stay open to obtain a general solution.