• Registered: 04/25/2011
  • Posts: 12

Topic: mysql 5.5.8 problem loading data

innodb is default engine in Wamp server 2.2 with mysql 5.5.8
Went to my.ini sql and commented out all # pertaining to innodb,
except for#innodb_log_arch_dir = C:\mysql\data/,
set the right relative path for home directory, turn on open ssl,
change deprecated function from type to engine,
import en_us_demo sql from myphpadmin into new created data frontacct.
Installation was a success,
but I am still not able to retrive my data.
Enter main menu, but i m getting this error messages

when i m in url http://localhost/frontaccounting/sales/sales_order_entry.php?NewQuotation=Yes
DATABASE ERROR :
At file C:\wamp\www\frontaccounting\includes\db\references_db.inc:73:
The last transaction ref for 32 could not be retreived
error code : 1146
error message : Table 'frontacct.0_sys_types' doesn't exist
sql that failed was : SELECT next_reference FROM 0_sys_types WHERE type_id = '32'


Back

04/25/2011 | 03:12 pm   

,and when i enter this url http://localhost/frontaccounting/sales/sales_order_entry.php?NewOrder=Yes

DATABASE ERROR :
At file C:\wamp\www\frontaccounting\includes\db\references_db.inc:73:
The last transaction ref for 30 could not be retreived
error code : 1146
error message : Table 'frontacct.0_sys_types' doesn't exist
sql that failed was : SELECT next_reference FROM 0_sys_types WHERE type_id = '30'


Back

04/25/2011 | 03:13 pm   
FrontAccounting 2.3.3 - Theme: default -
FrontAccounting

and for all the url pertaining to retrieving data.
I try to do google search for weeks but i cannot figure out what i m doing wrong, so i came here to post as last resort.

PLEASE HELP BEEN WORKING ON WEEKS TO SET UP. THANK U IN ADVANCE.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: mysql 5.5.8 problem loading data

There seems to be a missing table in your sql script. 0_sys_types.

Please try a new installation.

/Joe

  • Registered: 04/25/2011
  • Posts: 12

Re: mysql 5.5.8 problem loading data

thank u joe for a reply, but i have reinstall but i m having the same issue.

can it be that i m not putting session save path properly?

i have put session save path as C:/wamp/www/frontaccouting/tmp. is that right or wrong.

another question i would like to ask is in share window  server in

C:/wamp/www/frontaccounting/include/session
line 200  //ini_set('session.save_path', dirname(__FILE__).'/tmp/');

how do u modify this. what is dirname(_FILE_)
and do i leave

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: mysql 5.5.8 problem loading data

I am not sure if this is the problem.
Can you try to look in the database with phpMyAdmin and see if the table 0_sys_types exists and it is populated.

dirname(__FILE__) means the folder name where the file exists, but this line is commented, which means that it is not used.

/Joe

  • Registered: 04/25/2011
  • Posts: 12

Re: mysql 5.5.8 problem loading data

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: mysql 5.5.8 problem loading data

There was, for some reason, a missing 0_sys_types table in your script.

Please copy these lines and paste into phpMyAdmin to your database, SQL form, and run the query.

--
-- Table structure for table `0_sys_types`
--

DROP TABLE IF EXISTS `0_sys_types`;
CREATE TABLE IF NOT EXISTS `0_sys_types` (
  `type_id` smallint(6) NOT NULL default '0',
  `type_no` int(11) NOT NULL default '1',
  `next_reference` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`type_id`)
) TYPE=InnoDB;

--
-- Dumping data for table `0_sys_types`
--

INSERT INTO `0_sys_types` VALUES(0, 19, '3');
INSERT INTO `0_sys_types` VALUES(1, 8, '2');
INSERT INTO `0_sys_types` VALUES(2, 5, '2');
INSERT INTO `0_sys_types` VALUES(4, 3, '1');
INSERT INTO `0_sys_types` VALUES(10, 19, '4');
INSERT INTO `0_sys_types` VALUES(11, 3, '2');
INSERT INTO `0_sys_types` VALUES(12, 6, '1');
INSERT INTO `0_sys_types` VALUES(13, 5, '2');
INSERT INTO `0_sys_types` VALUES(16, 2, '1');
INSERT INTO `0_sys_types` VALUES(17, 2, '1');
INSERT INTO `0_sys_types` VALUES(18, 1, '3');
INSERT INTO `0_sys_types` VALUES(20, 8, '3');
INSERT INTO `0_sys_types` VALUES(21, 1, '1');
INSERT INTO `0_sys_types` VALUES(22, 4, '2');
INSERT INTO `0_sys_types` VALUES(25, 1, '2');
INSERT INTO `0_sys_types` VALUES(26, 1, '8');
INSERT INTO `0_sys_types` VALUES(28, 1, '1');
INSERT INTO `0_sys_types` VALUES(29, 1, '2');
INSERT INTO `0_sys_types` VALUES(30, 5, '6');
INSERT INTO `0_sys_types` VALUES(32, 0, '1');
INSERT INTO `0_sys_types` VALUES(35, 1, '1');
INSERT INTO `0_sys_types` VALUES(40, 1, '3');
  • Registered: 04/25/2011
  • Posts: 12

Re: mysql 5.5.8 problem loading data

thank u again for a reply joe
I created sql sript and dump it to mysql, i m having the same problem.
Could it be that php version 5.35 is not compatible with frontaccounting.
also i replace type with engine

if u see the data i send u for frontacc why some are innodb and some are myisam.

is it okay to have some myisam in frontacc if frontacc data needs to be innodb

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: mysql 5.5.8 problem loading data

If you are using newer versions of MySql you have to replace the type with engine.
It should be ok to use some of the tables as myisam and other as innodb.

I hope you are getting this to work.

/Joe

  • Registered: 04/25/2011
  • Posts: 12

Re: mysql 5.5.8 problem loading data

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: mysql 5.5.8 problem loading data

The dirname(__FILE__) means the folder name of the file that included session.inc.

/Joe

  • Registered: 04/25/2011
  • Posts: 12

Re: mysql 5.5.8 problem loading data

thank u for everything joe.

do u know which part of forum to ask question about oscommerce integration?