Why am I getting so many errors?

[JohnKlassen]

Hi,

I have been using NuBuilder for about 3 weeks. During that time, I have concentrated on creating browse and edit forms from tables and modifying the forms by changing the order of objects on the form, changing titles, etc. I am regularly receiving errors whicle making these changes. In some cases all I am doing is capitalizing the first letter of the title for one object and I get an error. Then I get out of the error and make the same change and it works fine.

I understand that when I change the object name instead of the title that I should get an error. On the other hand I have been very careful to not make a mistake and I still get error screens on a reguar basis. I have watched the form videos many times so I am confident that what I am doing should not be causing errors.

I am using Build 529 from the zip file and running everything locally on a Windows 7 laptop.

Am I doing something wrong? Do I need to re-install NuBuilder? Although I am making headways, it is very frustrating to get an error almost every time I make a minor change.

Thanks for your anticipated help.

[massiws]

John,

can you post the error message or a screenshot?

[JohnKlassen]

Max,

I will post several of them this evening when I get home. It is easy for me to reproduce them.

Thanks,

John

[JohnKlassen]

Max,

I have attached 3 error logs from making changes to to the same form called 'Agent'. Here are the key strokes that I used to get the 3 errors. In between the keystrokes, I show the first page of the error log for each error.

Click on wizard
Click on 'Agent' button
Double-click on ‘agent’ in bottom left corner
Click on Browse tab
Change width of 'Address 2' from 100 to 200
Click on Save (no error)
Click on Browse tab
Change ‘Agent’ to ‘Agent 1’ in Title column
Click on Save (no error)
Click on ‘Reorder Form Objects’
Reversed order of 'phone' and 'email' objects (90 and 100)
Save

Error
An error has occurred while running this query. Please contact technical support and quote error reference: 79a8f76.
The following information is only provided for users logged on as globeadmin.
SQL
SHOW COLUMNS FROM zzsys_object LIKE 'sys_%'
Transaction
No Transaction.
Error
0:
URL
http://

Closed error form
Reopened 'agent' form
Action Buttons
Set Print Button to ‘No’
Save (no error)
General tab
Changed title of form from ‘agent’ to ‘Agent’ (I realize this is not the correct place to change the title for the form.)

Error
An error has occurred while running this query. Please contact technical support and quote error reference: 15c1eec.
The following information is only provided for users logged on as globeadmin.
SQL
SHOW COLUMNS FROM zzsys_object LIKE 'sys_%'
Transaction
No Transaction.
Error
0:
URL
http://

Close error form
Reopened 'agent' form
Browse
Change the Alignment of the 'email' object from 'left' to 'center'

Error
An error has occurred while running this query. Please contact technical support and quote error reference: d37eb42.
The following information is only provided for users logged on as globeadmin.
SQL
SHOW COLUMNS FROM zzsys_object LIKE 'sys_%'
Transaction
No Transaction.
Error
0:
URL
http://

I did notice that the first page of each error log is the same for all 3 errors.

Let me know if you need additional information. Is it possible I have a corrupt system table or something is wrong in the productionnu2 folder?

Thanks,

John

[massiws]

John,

paste
SHOW COLUMNS FROM zzsys_object LIKE 'sys_%'
in phpmyadmin: what you get?

... (I realize this is not the correct place to change the title for the form.)

This procedure is correct. You can also modify any form in Setup > Forms.

Are you getting these errors only on that form?
If so, could be an error on the form; if the errors appear on all forms maybe could be some corrupted table...

[JohnKlassen]

Max,

When I run: SHOW COLUMNS FROM zzsys_object LIKE 'sys_%'

I get the following:

Field Type Null Key Default Extra
sys_setup char(1) NO 0
sys_added datetime YES NULL
sys_changed datetime YES NULL
sys_user_id varchar(15) YES NULL

Although my sample error logs were all from the same form, I get similiar errors on all 6 forms that I have created.

In one of my first posts, I gave an example where I only added one form to NuBuilder. It only had 3 fields in it. At that time I was also getting similiar errors.

Let me know if I should do a new download and create a new app. When I do load the database, I just create the database using phpMyAdmin and then import sample.sql after commenting out the first 4 lines.

Thanks,

John

[massiws]

John,

sorry, but I don't know what to say...
At this point I would think some corrupt table or a bad installation.

You could create a new database, import the sample.sql (comment out the first 4 lines) and change the $DBName value in config.php: this takes a couple of minutes...
Then try to recreate a simple form using Form Wizard.

If you still get errors, try to upload again the productionnu2 folder to your server.

Sorry, maybe Steven or someone can help you more.

[admin]

John,

I have no idea either but you seemed to have a similar problem earlier that you fixed..

http://forums.nubuilder.cloud/viewtopic.p ... 93&p=11105

Steven

[JohnKlassen]

Steven,

The reason I wasn't getting any more errors in the other post was because I learned enough not to make any errors. Since then I have received errors whether I make a mistake or not.

I have downloaded build 550 and will start all over with my project. I will let you know how it goes.

Thanks,

John

[admin]

OK.

Good luck!

Steven