Page 1 of 1
Saving record error
Posted: Wed Dec 26, 2012 9:00 pm
by chrisb
First of all, I think this app has a lot of possibilities. I've used Access and Open Office and this does provide some unique options. I had a database set up and it was working well. However, I upgraded to a newer version and now I'm getting save errors. When I add a record, the program saves a new record, but it doesn't save any of the data I enter. I can then click on the newly created (but mostly empty record) and add my data that way. Any suggestions?
Re: Saving record error
Posted: Wed Dec 26, 2012 11:04 pm
by admin
chrisb,
Do you have other Forms?
Does it work on them?
Steven
Re: Saving record error
Posted: Thu Dec 27, 2012 2:42 am
by chrisb
I'm having the same problem with all of the forms I've created.
I'm running: nubuilder-v2.8-12.12.11-Build550
Re: Saving record error
Posted: Thu Dec 27, 2012 11:59 pm
by admin
chrisb,
I have no idea, but try upgrading to the next build.
Steven
Re: Saving record error
Posted: Sat Dec 29, 2012 6:16 am
by chrisb
I've upgraded to the mostrecent version and still having the same problems. Not sure why as it worked with a previous install.
Re: Saving record error
Posted: Sat Dec 29, 2012 10:58 pm
by admin
chrisb,
Can you create a new Form from scratch that works?
Steven
Re: Saving record error
Posted: Sun Dec 30, 2012 8:41 pm
by chrisb
I've tried creating new forms. I deleted the entire database and reinstalled. I used the sample file and then manually added the tables. I added the sample file to the SQL injection script to create the records and nothing seems to be working.
I tried attaching the sql script, but it won't let me. Here's the instructions for a sample table:
Code: Select all
CREATE TABLE IF NOT EXISTS `team` (
`team_id` VARCHAR(11) NOT NULL ,
`team_name` VARCHAR(45) NULL ,
`team_captain` VARCHAR(11) NULL ,
PRIMARY KEY (`team_id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
.
Not sure what is with the table
Re: Saving record error
Posted: Sun Dec 30, 2012 10:21 pm
by admin
chrisb,
What do you mean by
I added the sample file to the SQL injection script
Steven
Re: Saving record error
Posted: Mon Dec 31, 2012 3:30 am
by chrisb
What I meant was that was the sql insert I used to create the table that the form was used for. I didn't know if I had some incorrect table setting that would cause the form to act that way.
Re: Saving record error
Posted: Mon Dec 31, 2012 4:10 am
by admin
chrisb,
This is your problem.. Primary Keys need to be at least 14 characters wide - i suggest 15, and that therefor goes for foreign keys as well.
http://wiki.nubuilder.com/tiki-index.ph ... uilderDocs
These IDs are created with a php function (uniqid) and are being chopped off as you save them.
cap.PNG
This will fix - adding a record and having to go back and select it in the browse.
Steven