Saving record error

[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?

[admin]

chrisb,

Do you have other Forms?

Does it work on them?

Steven

[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

[admin]

chrisb,

I have no idea, but try upgrading to the next build.

Steven

[chrisb]

I've upgraded to the mostrecent version and still having the same problems. Not sure why as it worked with a previous install.

[admin]

chrisb,

Can you create a new Form from scratch that works?

Steven

[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

[admin]

chrisb,

What do you mean by

I added the sample file to the SQL injection script

Steven

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

[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