FrontAccounting forum — mysql 5.5.8 problem loading data

Re: mysql 5.5.8 problem loading data

2011-05-03T17:23:41Z

thank u for everything joe.

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

Re: mysql 5.5.8 problem loading data

2011-05-02T06:14:17Z

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

/Joe

Re: mysql 5.5.8 problem loading data

2011-05-02T03:01:54Z

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

Re: mysql 5.5.8 problem loading data

2011-04-28T19:28:24Z

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

Re: mysql 5.5.8 problem loading data

2011-04-28T12:29:25Z

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

Re: mysql 5.5.8 problem loading data

2011-04-27T07:04:44Z

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');

Re: mysql 5.5.8 problem loading data

2011-04-27T03:36:50Z

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

Re: mysql 5.5.8 problem loading data

2011-04-26T21:06:23Z

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

Re: mysql 5.5.8 problem loading data

2011-04-26T19:28:30Z

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

Re: mysql 5.5.8 problem loading data

2011-04-25T22:20:45Z

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

Please try a new installation.

/Joe

mysql 5.5.8 problem loading data

2011-04-25T15:28:10Z

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.