This is a bug in two parts and it affects so many files that a patch would be difficult to post.

There are many cases of tables being created without the use of {} so that the database prefix is not attached. Mostly in the .install files, for example:

cash_sale.install
customer.install
erp_cart.install
erp_formfixes.install
franchise.install
goods_receive.install
invoice.install
item.install
job.install
payment.install
purchase_order.install
quote.install
stock.install
store.install
supplier.install

Also, the MySQL files timesheet.mysql and referral.mysql contain the option:
default charset=latin1 which is not supported on MySQL 4.0

It should be:
CHARSET latin1
or omitted entirely

Of course, the tables are not prefixed with erp_ but that is a known issue in the TODO. Just mentioned it here to be in the bug tracker.

Comments

singularo’s picture

singularo
Location Adelaide, AUS
CreditAttribution: singularo commented

All the .install files have been updated to have {} around the tables. The two mysql files have been removed, and .install files created instead in CVS

singularo’s picture

singularo
Location Adelaide, AUS
CreditAttribution: singularo commented
Status: Active » Closed (fixed)

Doh!

cutecyborg’s picture

cutecyborg CreditAttribution: cutecyborg commented

I get the following underlisted errors when i try to create customers or Invoices

PROBLEM WITH NEW CUSTOMER CREATION
user warning: Field 'user_list' doesn't have a default value query: INSERT INTO erp_customer (nid, fid, address, suburb, state, postcode, postal_address, postal_suburb, postal_state, postal_postcode, phone, fax, mobile, email, email_format, homepage, documentation, terms, reminder_days, specific_day) VALUES (7501, 0, '102 opebi road, off allen avenue', 'Ikeja', 'Lagos', '', '102 opebi road, off allen avenue', 'Ikeja', 'Lagos', '', '08168023299', '', '+2348168023299', 'herculesinfinity@yahoo.com', 2, '', '7502', 23, 2, 0) in C:\xampp\htdocs\cms\includes\common.inc on line 3528.

PROBLEM WITH INVOICE CREATION
user warning: Field 'trans_account' doesn't have a default value query: INSERT INTO erp_accounting (nid, trans_date, trans_type, trans_amt) VALUES (7521, 1297953938, 'erp_invoice', 0) in C:\xampp\htdocs\cms\includes\common.inc on line 3528.