Having an issue with my MySQL

[epk]

maybe this will help?

 

[X-Istence]

Moved to a more appropriate location

 

[Heeter]

hmmm, I tried putting in a whole new php code. I kept the mysql tables, and it is doing the same thing.

So I know it is not the php side, but the mysql side.

I tried repairing tables, but everything looks fine. Can there be something that I am missing?

Heeter

 

[X-Istence]

I don't know what the table structure is, maybe you are going over some limit because of that. Geffy asked you a question related to that already.

 

[Heeter]

how many invoices do you have? what is the size of the id field and is it signed or unsigned?

Hi Geffy,

Sorry but I didn't even see your post..................Thanks to X for telling me.

This particular invoice setup has only 19 invoices, trying to create #20 but can't.

How do I check for this? maybe this might help, I did a sql dump on this table:

CREATE TABLE IF NOT EXISTS `invoices` (
  `id` int(8) NOT NULL auto_increment,
  `clientid` tinyint(4) NOT NULL,
  `date` date default NULL,
  `bill_date` date default NULL,
  `due_date` date default NULL,
  `paid_date` date default NULL,
  `purchaseorder` varchar(50) default NULL,
  `serv1desc` varchar(255) default NULL,
  `serv1qty` varchar(12) default NULL,
  `serv1rate` decimal(6,2) default '0.00',
  `serv1amt` decimal(6,2) default '0.00',
  `serv2desc` varchar(255) default NULL,
  `serv2qty` varchar(10) default NULL,
  `serv2rate` decimal(6,2) default '0.00',
  `serv2amt` decimal(6,2) default '0.00',
  `serv3desc` varchar(255) default NULL,
  `serv3qty` varchar(10) default NULL,
  `serv3rate` decimal(6,2) default '0.00',
  `serv3amt` decimal(6,2) default '0.00',
  `serv4desc` varchar(255) default NULL,
  `serv4qty` varchar(10) default NULL,
  `serv4rate` decimal(6,2) default '0.00',
  `serv4amt` decimal(6,2) default '0.00',
  `serv5desc` varchar(255) default NULL,
  `serv5qty` varchar(10) default NULL,
  `serv5rate` decimal(6,2) default '0.00',
  `serv5amt` decimal(6,2) default '0.00',
  `serv6desc` varchar(255) default NULL,
  `serv6qty` varchar(10) default NULL,
  `serv6rate` decimal(6,2) default '0.00',
  `serv6amt` decimal(6,2) default '0.00',
  `serv7desc` varchar(255) default NULL,
  `serv7qty` varchar(10) default NULL,
  `serv7rate` decimal(6,2) default '0.00',
  `serv7amt` decimal(6,2) default '0.00',
  `serv8desc` varchar(255) default NULL,
  `serv8qty` varchar(10) default NULL,
  `serv8rate` decimal(6,2) default '0.00',
  `serv8amt` decimal(6,2) default '0.00',
  `serv9desc` varchar(255) default NULL,
  `serv9qty` varchar(10) default NULL,
  `serv9rate` decimal(6,2) default '0.00',
  `serv9amt` decimal(6,2) default '0.00',
  `serv10desc` varchar(255) default NULL,
  `serv10qty` varchar(10) default NULL,
  `serv10rate` decimal(6,2) default '0.00',
  `serv10amt` decimal(6,2) default '0.00',
  `serv1tax` enum('yes','no') NOT NULL default 'no',
  `serv2tax` enum('yes','no') NOT NULL default 'no',
  `serv3tax` enum('yes','no') NOT NULL default 'no',
  `serv4tax` enum('yes','no') NOT NULL default 'no',
  `serv5tax` enum('yes','no') NOT NULL default 'no',
  `serv6tax` enum('yes','no') NOT NULL default 'no',
  `serv7tax` enum('yes','no') NOT NULL default 'no',
  `serv8tax` enum('yes','no') NOT NULL default 'no',
  `serv9tax` enum('yes','no') NOT NULL default 'no',
  `serv10tax` enum('yes','no') NOT NULL default 'no',
  `shipping` decimal(5,2) default '0.00',
  `subtotal` decimal(6,2) default '0.00',
  `salestax` decimal(6,2) default '0.00',
  `misc` decimal(6,2) default '0.00',
  `note` varchar(100) default NULL,
  `total` decimal(6,2) default '0.00',
  `status` enum('pending','paid') NOT NULL default 'pending',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

Heeter

 

[X-Istence]

Wow, whoever wrote that app never heard of normalisation.