I've lost format options for nuNumber and zzzzsys_event crash?

[orangezero]

On the "Input" section it lists "Input Type (and class) and I can select nuNumber, but the second option is "Format" and it is blank with nothing in the dropdown.

If I go to Builders ==> Format then it does seem to show I can make new types of date or number formats.

Sometimes these things go away when I restart, but I also just noticed it said, "SQLSTATE[HY000] General error 1194 Table "zzzzsys_event" is marked as crashed and should be repaired" when I tried to backup the database before restarting.

Many thanks!

[kev1n]

Do you see the formats in the table zzzzsys_format?

To repair the table, open phpMyAdmin and run the sql

Code: Select all

REPAIR TABLE zzzzsys-event

[orangezero]

REPAIR TABLE zzzsys_event did fix a few things, but not completely.

I see errors in nucommon.php at line 930 and 933 when I try to print an invoice report now. That is specifically the part about number formats, so I still have something that I must have put in erroneously. I haven't edited anything in nucommon.php file.

When I try to print an invoice report it says "Warning: Trying to access array offset on value of type null in C:Test/htdocst/I/core/nucommon.php on line 930" and also on line 933 over and over.

Many thanks

[kev1n]

Try updating to the latest version from Github.

[orangezero]

This will test my backup and restore skills.. Good plan. I appreciate the help.

[orangezero]

I may have solved the issue by deleting each of the format options I already had. Then I just made the new ones I needed.

I think this may not be the best way, as I then had to go select the format for several different areas, but it seems to fix it and I can't duplicate the error now.

You seem to be about the best Many thanks! You help, and also force me to learn. I figured out the darn date formatting as I was looking around.

[orangezero]

Kev1n,
I almost started a new thread, but I think it is related to this issue. No clue why this keeps happening. I had the same "disappearing options thing" happen similar to how the format options were not in the dropdown selection as mentioned above, it just was one line that was whited out. It also happened with a subform, and the foreign key didn't have or save an input. Another place it gave me an error that a code can't be empty and I couldn't input and save, but I know there was a code in there before.

Eventually the plan was to have a basic linux install to run apache and mysql, etc. One time it did seem to say the mysql database had an error and needed reinstalled. That happened once. This issue with things disappearing has maybe happened five or six times on two different windows installs, newest nubuilder folder, newest xampp install. I was thinking I may relearn how to install on linux and remove one item from the equation.

Literally the only thing I can think of is that I may have tried to make an addition in nubuilder (like a new browse/edit page with 19 fields), and then perhaps I didn't realize it would take a few seconds, and I closed a window I shouldn't have to move on to something else. Almost everything else I'm doing is just me repeating things similar to the tutorials.

I don't feel it has ever happened as I'm just browsing things, or inputing data info fields. It always happens when I'm editing some of the user interface structure or adding/editing fields, etc. I know I'd tell my family members to try turning it on and off again... Nothing is lost. I'm on to a fresh install again tonight and just typing things in again and see how that goes, rather than updating via an sql that could have some strange error.

Again, as always, many thanks!

[gerese]

Hi, in nuConfig.php for parameter "$nuConfigDBEngine" use MyISAM instead of InnoDB.

Code: Select all

$nuConfigDBEngine					= "MyISAM";

To convert InnoDB to MyISAM, run:

Code: Select all

ALTER TABLE database_name.table_name ENGINE=MyISAM;

Maybe will help you.