I'm not sure what it means, but here it is : *** in database main *** On page 2580 at right child: 2nd reference to page 2677 On tree page 9 cell 15: 2nd reference to page 2678 On tree page 9 cell 15: Child page depth differs On tree page 9 cell 16: Child page depth differs Page 2681 is never used Page 2682 is never used Page 2683 is never used Page 2684 is never used Page 2685 is never used Page 2686 is never used Page 2687 is never used Page 2688 is never used Page 2689 is never used Page 2690 is never used Page 2691 is never used Page 2692 is never used Page 2693 is never used Page 2694 is never used Page 2695 is never used Page 2696 is never used Page 2697 is never used Page 2698 is never used Page 2699 is never used Page 2700 is never used Page 2701 is never used Page 2702 is never used Page 2703 is never used Page 2704 is never used Page 2705 is never used Page 2706 is never used Page 2707 is never used Page 2708 is never used Page 2709 is never used Page 2710 is never used Page 2711 is never used Page 2712 is never used Page 2713 is never used Page 2714 is never used Page 2715 is never used Page 2716 is never used Page 2717 is never used Page 2718 is never used Page 2719 is never used Page 2720 is never used Page 2721 is never used Page 2722 is never used Page 2723 is never used Page 2724 is never used Page 2725 is never used Page 2726 is never used Page 2727 is never used Page 2728 is never used Page 2729 is never used Page 2730 is never used Page 2731 is never used Page 2732 is never used Page 2733 is never used Page 2734 is never used Page 2735 is never used Page 2736 is never used Page 2737 is never used Page 2738 is never used Page 2739 is never used Page 2740 is never used Page 2741 is never used Page 2742 is never used Page 2743 is never used Page 2744 is never used Page 2745 is never used Page 2746 is never used Page 2747 is never used Page 2748 is never used Page 2749 is never used Page 2750 is never used Page 2751 is never used Page 2752 is never used Page 2753 is never used Page 2754 is never used Page 2755 is never used Page 2756 is never used Page 2757 is never used Page 2758 is never used Page 2759 is never used Page 2760 is never used Page 2761 is never used Page 2762 is never used Page 2763 is never used Page 2764 is never used Page 2765 is never used Page 2766 is never used Page 2767 is never used Page 2768 is never used Page 2769 is never used Page 2770 is never used Page 2771 is never used Page 2772 is never used Page 2773 is never used Page 2774 is never used Page 2775 is never used Page 2776 is never used
On Nov 20, 2007 6:30 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > > Mitchell Vincent wrote: > > select max(item_id) from invoice_items; > > > > Produces "803" - but that is pretty clearly wrong when I look at the > > dataset a count() returns 15503 records in that table. > > > > min(item_id) is 1 (as expected). > > > > I can insert records if I specify a unique item_id. > > > > > > On Nov 20, 2007 5:50 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > > > >> Mitchell Vincent wrote: > >> > >>> Here we go. I am accessing the database through an ODBC connection > >>> using the most recent version from Christian's site.. > >>> > >>> The table schema : > >>> > >>> CREATE TABLE invoice_items ( > >>> item_id INTEGER PRIMARY KEY, > >>> invoice_id int4, > >>> product_id int4, > >>> product_name text , > >>> sku text , > >>> description text , > >>> quantity text, > >>> price int4, > >>> cost int4, > >>> taxable bool, > >>> format_price text, > >>> format_total_price text, > >>> taxable2 boolean) > >>> > >>> The query : > >>> > >>> INSERT INTO invoice_items > >>> (item_id,invoice_id,product_id,product_name,sku,description,quantity,price,cost,taxable,taxable2,format_price,format_total_price) > >>> VALUES (NULL,899,1001975,'HD0001 - ASH - YL','','HOUSE > >>> DIVIDED',1,800,450,'f','f','$8.00','$8.00') > >>> > >>> The error : > >>> > >>> PRIMARY KEY must be unique (19) > >>> > >>> I can't post the database itself because it contains some sensitive > >>> information (as you might have guessed, it's a database of billing > >>> information). > >>> > >>> The INSERT query for the invoice_items table has "NULL" hard coded in > >>> for item_id, so I know it's not accidentally being set to an existing > >>> value. > >>> > >>> > >>> > >>> > >> Can you select the max and min item_id values form the database and > >> report them back here. > >> > >> Can you then change your code to insert a new dummy record with an > >> item_id that is set to one greater than the maximum value, rather than > >> your hard coded NULL value. I just want to see if you can insert a > >> properly formed record into your database at all. You should then delete > >> that record so it doesn't cause a problem in your database later. > >> > >> Dennis Cote > >> > >> > >> > >> ----------------------------------------------------------------------------- > >> To unsubscribe, send email to [EMAIL PROTECTED] > >> ----------------------------------------------------------------------------- > >> > >> > >> > > > > > > > > > Mitchell, > > You should probably run an integrity check on your database to see if it > has been corrupted somehow. > > Can you issue a PRAGMA INTEGRITY_CHECK command? > > > Dennis Cote > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
