1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

Updated from 7.5.3 to 7.5.4 - SiteBuilder

Discussion in 'Plesk for Linux - 8.x and Older' started by tonyb, Aug 29, 2005.

  1. tonyb

    tonyb Guest

    0
     
    I just upgraded my server. Im running FreeBSD 4.9 and I started playing with sitebuilder but im having all kinds of problems and im not sure what the deal is.

    When I go to http://sitebuilder.domain.com it brings up what looks to be a configuration file created which I type in the correct information and it booms out.

    So I figured maybe I need to make the database for the main domain and create a user. I tried that and I still get the same problem.

    Also I noticed I don't see gpg installed.

    This is the log file it outputs.

    [29-August-2005 2:42:54] Log of installation process
    [29-August-2005 2:42:54] Create dirs...........
    [29-August-2005 2:42:54] The dir "temp" is created ...Ok
    [29-August-2005 2:42:54] The dir "work" is created ...Ok
    [29-August-2005 2:42:54] The dir "users" is created ...Ok
    [29-August-2005 2:42:54] Create config file..........
    [29-August-2005 2:42:54] Unlink file "/usr/local/sitebuilder/include/config.php" ..... Ok
    [29-August-2005 2:42:54] Process sql-query: CREATE DATABASE sitebuilder
    [29-August-2005 2:42:54] Result:...... Error: (code=)
    [29-August-2005 2:42:54] Error on query >> CREATE DATABASE sitebuilder
    [29-August-2005 2:42:54] Create DataBase "sitebuilder"..... fail
    [29-August-2005 2:42:54] Create tables...........
    [29-August-2005 2:42:54] Process of installation has come to the end with failure. Database tables have not been created... Please, check it...


    Anyone else have these problems with sitebuilder if so what did they do to fix it?

    Thanks
    Tony
     
  2. bcscomp

    bcscomp Guest

    0
     
  3. Spyder

    Spyder Regular Pleskian

    25
    40%
    Joined:
    Jan 13, 2003
    Messages:
    155
    Likes Received:
    0
    quick and very dirt .....


    Login as root (via ssh)

    login on mysql...

    execute the script located @

    /usr/local/sitebuilder/sql/psa.sql

    done, from this point worked to me (login sitebuilder.somedomain.com/admin/cc.php)

    Tia
     
  4. bcscomp

    bcscomp Guest

    0
     
    more than willing to try this, but i'm such a n00b at "command line" stuff that i have no idea whatsoever how to login to sql from a command prompt.

    I'll google it, and see what i can find.

    Thanks
    Bill
    :)
     
  5. bcscomp

    bcscomp Guest

    0
     
    tried it, still get the same thing, in fact when i try to access the /admin/cc.php i get a blank screen



    Bill
    ty for the info tho
     
  6. bcscomp

    bcscomp Guest

    0
     
    problem solved, had to get support to do it, but i was able to reference this thread in my ticket to them, and while they didn't tell me what was broken, they fixed it rather easily as all of a sudden i got an email from my box telling me that it had installed
     
  7. noimad1

    noimad1 Guest

    0
     
    Actually I found another thread that said to use the admin username/password instead of the root and it installed ok then...
     
  8. omegauser

    omegauser Guest

    0
     
    Hi, I am trying to execute the SQL query in order to install sitebuilder> I get the following errror>
    SQL query:

    DROP TABLE IF EXISTS sb_logged_users CREATE TABLE sb_logged_users(

    id integer AUTO_INCREMENT PRIMARY KEY ,
    user_id integer NOT NULL default 0,
    SID varchar( 100 ) NOT NULL default '',
    expiretime varchar( 50 ) NOT NULL default ''
    ) CREATE INDEX id_sb_logged_users ON sb_logged_users(
    id
    ) DROP TABLE IF EXISTS sb_ftphosts CREATE TABLE sb_ftphosts(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    ftp_host varchar( 128 ) NOT NULL default '',
    ftp_host_ip varchar( 128 ) default '',
    ftp_host_type integer NOT NULL default '1',
    ftp_host_ip_sec varchar( 128 ) NOT NULL default '0',
    range integer NOT NULL default '0',
    number int( 3 ) NOT NULL default '1',
    owner integer NOT NULL default '1'
    ) CREATE INDEX id_sb_ftphosts ON sb_ftphosts(
    id
    ) CREATE INDEX ftp_host ON sb_ftphosts(
    ftp_host
    ) CREATE INDEX owner ON sb_ftphosts(
    owner
    ) DROP TABLE IF EXISTS sb_resellers_items CREATE TABLE sb_resellers_items(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    id_section int( 1 ) ,
    id_item integer NOT NULL ,
    id_reseller int( 10 ) NOT NULL
    ) CREATE INDEX id_sb_resellers_items ON sb_resellers_items(
    id
    ) CREATE INDEX item ON sb_resellers_items(
    id_section,
    id_item
    ) CREATE INDEX reseller ON sb_resellers_items(
    id_reseller
    ) DROP TABLE IF EXISTS sb_profiles CREATE TABLE sb_profiles(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    user_id integer NOT NULL default '0',
    fname text NOT NULL ,
    lname text NOT NULL ,
    address1 varchar( 120 ) default NULL ,
    address2 varchar( 120 ) NOT NULL default '',
    phone varchar( 20 ) default NULL ,
    email varchar( 120 ) NOT NULL default '',
    lang varchar( 6 ) NOT NULL default 'en_US',
    city varchar( 40 ) NOT NULL default '',
    state varchar( 40 ) NOT NULL default '',
    zip varchar( 15 ) NOT NULL default '',
    country int( 3 ) NOT NULL default '0',
    dquote int( 7 ) NOT NULL default '100000',
    ftp_host_id int( 10 ) default NULL ,
    ftp_work_dir varchar( 128 ) default ''
    ) CREATE INDEX id_sb_profiles ON sb_profiles(
    id
    ) DROP TABLE IF EXISTS sb_users CREATE TABLE sb_users(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    login varchar( 255 ) NOT NULL default '',
    pswd varchar( 128 ) NOT NULL default '',
    role int( 2 ) NOT NULL default '0',
    createtime varchar( 20 ) ,
    sb_type integer NOT NULL default '1'
    ) CREATE INDEX id_sb_users ON sb_users(
    id
    ) CREATE INDEX login ON sb_users(
    login
    ) DROP TABLE IF EXISTS sb_events CREATE TABLE sb_events(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    user_id integer NOT NULL default '0',
    module varchar( 20 ) NOT NULL default '',
    time varchar( 20 ) NOT NULL default '',
    TYPE integer NOT NULL default '0',
    eventtext varchar( 255 ) NOT NULL default ''
    ) CREATE INDEX id_sb_events ON sb_events(
    id
    ) DROP TABLE IF EXISTS sb_events_history CREATE TABLE sb_events_history(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    user_id integer NOT NULL default '0',
    module varchar( 20 ) NOT NULL default '',
    time varchar( 20 ) NOT NULL default '',
    TYPE integer NOT NULL default '0',
    eventtext varchar( 255 ) NOT NULL default ''
    ) CREATE INDEX id_sb_events_history ON sb_events_history(
    id
    ) DROP TABLE IF EXISTS sb_msgs CREATE TABLE sb_msgs(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    uid_from integer NOT NULL default '0',
    uid_to integer NOT NULL default '0',
    TYPE tinyint( 2 ) NOT NULL default '0',
    message varchar( 255 ) NOT NULL default '',
    confirm tinyint( 1 ) NOT NULL default '0',
    createtime varchar( 20 ) NOT NULL default ''
    ) CREATE INDEX id_sb_msgs ON sb_msgs(
    id
    ) DROP TABLE IF EXISTS sb_msgs_history CREATE TABLE sb_msgs_history(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    uid_from integer NOT NULL default '0',
    uid_to integer NOT NULL default '0',
    TYPE tinyint( 2 ) NOT NULL default '0',
    message varchar( 255 ) NOT NULL default '',
    confirm tinyint( 1 ) NOT NULL default '0',
    createtime varchar( 20 ) NOT NULL default ''
    ) CREATE INDEX id_sb_msgs_history ON sb_msgs_history(
    id
    ) DROP TABLE IF EXISTS sb_guestproj CREATE TABLE sb_guestproj(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    dirname varchar( 100 ) NOT NULL default '',
    expire varchar( 50 ) NOT NULL default '',
    site_identety varchar( 100 ) NOT NULL default '',
    is_user tinyint( 1 ) NOT NULL default '0',
    perms integer NOT NULL default '1',
    reseller integer NOT NULL default '1'
    ) CREATE INDEX id_sb_guestproj ON sb_guestproj(
    id
    ) CREATE INDEX byReseller ON sb_guestproj(
    reseller
    ) DROP TABLE IF EXISTS sb_settings CREATE TABLE sb_settings(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    prop_name varchar( 50 ) NOT NULL ,
    prop_value text NOT NULL ,
    parent integer NOT NULL default 1
    ) CREATE INDEX id_sb_settings ON sb_settings(
    id
    ) CREATE UNIQUE INDEX prop_name ON sb_settings(
    prop_name,
    parent
    ) CREATE INDEX parent ON sb_settings(
    parent
    ) DROP TABLE IF EXISTS sb_db_version CREATE TABLE sb_db_version(
    value varchar( 10 ) NOT NULL default '1'
    ) DROP TABLE IF EXISTS sb_userdirs CREATE TABLE sb_userdirs(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    user_id integer NOT NULL ,
    dirname VARCHAR( 255 ) NOT NULL
    ) CREATE INDEX id_sb_userdirs ON sb_userdirs(
    id
    ) DROP TABLE IF EXISTS sb_templates CREATE TABLE sb_templates(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    name varchar( 255 ) default NULL ,
    category varchar( 255 ) default NULL ,
    state int( 1 ) default NULL ,
    attributes blob,
    category_id int( 3 ) NOT NULL default '-1'
    ( 15 ) NOT NULL default ''
    ) CREATE INDEX id_sb_modules ON sb_modules(
    id
    ) CREATE UNIQUE INDEX module_id ON
    ) DROP TABLE IF EXISTS sb_plan_prop CREATE TABLE sb_plan_prop(
    id integer AUTO_INCREMENT PRIMARY KEY ,
    id_tab1 integer NOT NULL default '0',
    id_tab2 integer NOT NULL default '0',
    id_rec1 integer NOT NULL default '0',
    id_rec2 integer NOT NULL default '0',
    userpart int( 1 ) NOT NULL default '0'
    ) CREATE INDEX id_sb_plan_prop ON sb_plan_prop(
    id
    ) DROP TABLE IF EXISTS sb_resellers CREATE TABLE sb_resellers(
    id int AUTO_INCREMENT PRIMARY KEY ,
    domain varchar( 255 ) NOT NULL ,
    email varchar( 128 ) NOT NULL ,
    name varchar( 60 ) NOT NULL ,
    limit_sites int DEFAULT '-1' NOT NULL ,
    limit_hosts int DEFAULT '-1' NOT NULL
    ) CREATE INDEX id_sb_resellers ON sb_resellers(
    id
    ) CREATE UNIQUE INDEX byDomain ON sb_resellers(
    domain
    ) DROP TABLE IF EXISTS sb_stat_referers CREATE TABLE sb_stat_referers(
    id bigint( 20 ) AUTO_INCREMENT PRIMARY KEY ,
    id_site bigint( 20 ) NOT NULL default '0',
    referer varchar( 100 ) NOT NULL default ''
    ) CREATE INDEX id_sb_stat_referers ON sb_stat_referers(
    id
    ) DROP TABLE IF EXISTS sb_stat_site_pages_1 CREATE TABLE sb_stat_site_pages_1(
    id bigint( 20 ) AUTO_INCREMENT PRIMARY KEY ,
    id_site bigint( 20 ) NOT NULL default '0',
    visitor_id bigint( 20 ) NOT NULL default '0',
    page_name varchar( 100 ) NOT NULL default '',
    time bigint( 20 ) NOT NULL default '0'
    ) CREATE INDEX id_sb_stat_site_pages_1 ON sb_stat_site_pages_1(



    and goes on.........................
    )
    MySQL said:

    #1064 - You have an error in your SQL syntax near 'CREATE TABLE sb_logged_users (id integer auto_increment PRIMARY KEY, user_id int' at line 2
     
  9. omegauser

    omegauser Guest

    0
     
    Maybe the SQL is wrong.

    Which one did you use?
     
Loading...