Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#28 User creation on anote server

open-accepted
nobody
Test (6)
7
2009-11-24
2004-11-03
No

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.

Discussion

  • 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

     
  • Trilarion
    Trilarion
    2009-11-24

    Although this issue was apparently solved for the submitter, I still think the report should stay open to obtain a general solution.

     
  • Trilarion
    Trilarion
    2009-11-24

    • priority: 5 --> 7
    • status: open --> open-accepted