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.
]]>