Search options

Joe thank u very much for being patient and helping me.

it was my own stupidity that got me going in circles for almost three weeks. when i change "TYPE" to "ENGINE" I forgot to put "=" sign. so i change any words with type like sys_0_type. LOL.

Also another question i would like to ask ,if u don't mind, is about session save path

first if i install it locally, is temp located on folder .../frontaccounting/tmp

second if i install it on shared server, i have no clue in the installation instruction:

"2: If you are installing FrontAccounting onto a shared server, you may have to set the session save path within FrontAccounting. At the top of  /includes/session.inc you will find this line :

3: Uncomment this line and set the path to a directory that exists on your server. Make sure that you have read/write privileges on this directory."

what is ":" at the top i don't see it when i open session.inc folder with a notepad2

and set the path directory

I would assume is in line 200 on session.inc

"//ini_set('session.save_path', dirname(__FILE__).'/../tmp/');"
what is "dirname(__FILE__).'/../tmp/'"

thank u again in advance

Thanks for a reply, i check

frontacc data in myphpadmin and there is no table 0_sys_types

sql-script  "en_us-demo" no such thing as sys_types

this is how myphpadmin looks like for data frontacc i have 78 data so its very long so i cut and paste only around sys info

0_sales_pos     Browse     Structure     Search     Insert     Empty     Drop     1     MyISAM     latin1_swedish_ci     3.0 KiB     -
    0_security_roles     Browse     Structure     Search     Insert     Empty     Drop     10     MyISAM     latin1_swedish_ci     7.4 KiB     -
    0_shippers     Browse     Structure     Search     Insert     Empty     Drop     1     MyISAM     latin1_swedish_ci     3.0 KiB     -
    0_sql_trail     Browse     Structure     Search     Insert     Empty     Drop     0     MyISAM     latin1_swedish_ci     1.0 KiB     -
    0_stock_category     Browse     Structure     Search     Insert     Empty     Drop     4     MyISAM     latin1_swedish_ci     3.2 KiB     -
    0_stock_master     Browse     Structure     Search     Insert     Empty     Drop     5     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_stock_moves     Browse     Structure     Search     Insert     Empty     Drop     36     InnoDB     latin1_swedish_ci     48.0 KiB     -
    0_suppliers     Browse     Structure     Search     Insert     Empty     Drop     3     MyISAM     latin1_swedish_ci     3.5 KiB     -
    0_supp_allocations     Browse     Structure     Search     Insert     Empty     Drop     1     InnoDB     latin1_swedish_ci     48.0 KiB     -
    0_supp_invoice_items     Browse     Structure     Search     Insert     Empty     Drop     5     InnoDB     latin1_swedish_ci     32.0 KiB     -
    0_supp_trans     Browse     Structure     Search     Insert     Empty     Drop     3     InnoDB     latin1_swedish_ci     80.0 KiB     -
    0_sys_engines     Browse     Structure     Search     Insert     Empty     Drop     22     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_sys_prefs     Browse     Structure     Search     Insert     Empty     Drop     51     MyISAM     latin1_swedish_ci     8.5 KiB     -
    0_tags     Browse     Structure     Search     Insert     Empty     Drop     0     MyISAM     latin1_swedish_ci     1.0 KiB     -
    0_tag_associations     Browse     Structure     Search     Insert     Empty     Drop     0     MyISAM     latin1_swedish_ci     1.0 KiB     -
    0_tax_engines     Browse     Structure     Search     Insert     Empty     Drop     1     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_tax_groups     Browse     Structure     Search     Insert     Empty     Drop     2     InnoDB     latin1_swedish_ci     32.0 KiB     -
    0_tax_group_items     Browse     Structure     Search     Insert     Empty     Drop     1     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_trans_tax_details     Browse     Structure     Search     Insert     Empty     Drop     11     InnoDB     latin1_swedish_ci     48.0 KiB     -
    0_useronline     Browse     Structure     Search     Insert     Empty     Drop     0     MyISAM     latin1_swedish_ci     1.0 KiB     -
    0_users     Browse     Structure     Search     Insert     Empty     Drop     2     MyISAM     latin1_swedish_ci     3.3 KiB     -
    0_voided     Browse     Structure     Search     Insert     Empty     Drop     0     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_workcentres     Browse     Structure     Search     Insert     Empty     Drop     1     MyISAM     latin1_swedish_ci     3.1 KiB     -
    0_workorders     Browse     Structure     Search     Insert     Empty     Drop     7     InnoDB     latin1_swedish_ci     32.0 KiB     -
    0_wo_issues     Browse     Structure     Search     Insert     Empty     Drop     0     InnoDB     latin1_swedish_ci     32.0 KiB     -
    0_wo_issue_items     Browse     Structure     Search     Insert     Empty     Drop     0     InnoDB     latin1_swedish_ci     16.0 KiB     -
    0_wo_manufacture     Browse     Structure     Search     Insert     Empty     Drop     1     InnoDB     latin1_swedish_ci     32.0 KiB     -
    0_wo_requirements     Browse     Structure     Search     Insert     Empty     Drop     21     InnoDB     latin1_swedish_ci     32.0 KiB     -
    78 table(s)     Sum     530     InnoDB     latin1_swedish_ci     1.6 MiB     0 B
With selected: Check All / Uncheck All