Debug: Database connection successful Housekeeping (Page 130) / Meta New Mars / New Mars Forums

New Mars Forums

Official discussion forum of The Mars Society and MarsNews.com

You are not logged in.

Announcement

Announcement: This forum has successfully made it through the upgraded. Please login.

#3226 2023-12-16 20:50:42

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut .... we appear to have cleared up the problems with the posts table, as reported previously in this topic:

python3 validatetables15.py
csv_path_file_name: /home/tahanson/mysql_archive/fluxbb_posts_202311121532.csv
table name: fluxbb_posts
All 210281 rows validated successfully.
tahanson@tom-GA-78LMT-01:~/mysql_archive$

For the record, here is a report of the repair run:

python3 repairtable30.py
csv_path_file_name: /home/tahanson/mysql_archive/fluxbb_posts_202311121532.csv
table name: fluxbb_posts
All 210281 rows processed. Repaired 2363 rows. Inserted 725 missing rows.

(th)

Offline

Like button can go here

#3227 2023-12-17 11:52:18

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut ...

Validation work list:                    
fluxbb_bans_202311121523.csv                      -774
fluxbb_categories_202311121528.csv                  -7
fluxbb_censoring_202311121529.csv                  -0
fluxbb_config_202311121529.csv                      -81
fluxbb_forum_perms_202311121530.csv          -6
fluxbb_forums_202311121530.csv                      -26
fluxbb_forum_subscriptions_202311121530.csv  -117
fluxbb_groups_202311121531.csv                      -5
fluxbb_online_202311121531.csv                      -> Skip Not useful
fluxbb_posts_202311121532.csv                      - 210281
fluxbb_reports_202311121534.csv              - 10
fluxbb_search_cache_202311121615.csv          -7
fluxbb_search_matches_202311121637.csv         -15,493,240 per Count(*)
fluxbb_search_words_202311121620.csv         -373,691
fluxbb_topics_202311121621.csv                     -8290
fluxbb_topic_subscriptions_202311121621.csv  -668
fluxbb_users_202311121622.csv                        -19631

Validation of the 17 useful tables in fluxbb_newmars is complete.

(th)

Offline

Like button can go here

#3228 2023-12-17 15:57:21

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,436

Re: Housekeeping

NewMarsMember wrote:

Here's a forum message I've not seen before:

Bad CSRF hash. You were referred to this page from an unauthorized source.

The system seems to have honored the login despite the problem with the hash.

(th)

;
This happens when the login cookie and session keys are the same for different forums under the browser cache area.

The software thinks it's being hacked.

Offline

Like button can go here

#3229 2023-12-18 07:29:11

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut ...

This item falls into the "inside baseball" category.

In working with the forum database I've learned how the word search mechanism works.  There is a table of words entered into the posts table by members.  That list is referenced by search_match table that is nearly 400,000 rows long.  The search_match table rows are tiny ... they consist only of integers pointing to the word table and to the posts table, and the ID primary key.

That is how the program is able to so quickly perform searches of the entire collection of posts so rapidly.

You can see both tables using your spreadsheet software, if you are interested.

(th)

Offline

Like button can go here

#3230 2023-12-18 07:33:39

NewMarsMember
Member
Registered: 2019-02-17
Posts: 1,396

Re: Housekeeping

For SpaceNut re #3228

The error just occurred again.

Info
Bad CSRF hash. You were referred to this page from an unauthorized source.

Go back

This time I paid attention to the sequence of events prior to the error ....

I had just logged in as tahanson43206 and then logged out, and the error occurred when I logged in as NewMarsMember.

It is as though the record for tahanson43206 was (somehow) still being used for the new log in.

Since I am probably the only member who uses two ID's, I may be the only member who sees this error message.

(th)


Recruiting High Value members for NewMars.com/forums, in association with the Mars Society

Offline

Like button can go here

#3231 2023-12-19 08:21:01

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

Here is a small Todo item for someone ...

GW Johnson recently published a study that predicts a 150 meter diameter hydrogen filled balloon should fly on Mars, and it turns out NASA has flown exactly such a balloon back in 2018, for research at high altitude.

The altitude reached by the balloon was 150,000 feet on Earth.

I'm hoping someone in the NewMars membership will be able to compare that altitude on Earth to the situation on Mars, where the atmosphere is so much less dense.

If NASA launched that same balloon on Mars, what altitude might it reach?

It should be noted that the balloon on Earth carried a heavy payload.  On Mars that payload would be reduced significantly.

Gravity is .38% of Earth on Mars, so that would factor into the computation.

Arizona State University offers an estimate: Pressure at surface on Mars is about equal to 45 kilometers (28 miles) on Earth

150,000 feet was achieved by the NASA Big 60 balloon --- 5280 feet in a mile >>  28.4 miles.

There we have it!  The Big 60 balloon would just barely fly at Mars with a payload.  It should fly nicely with no payload, as GW predicted.

(th)

Offline

Like button can go here

#3232 2023-12-20 08:04:02

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut .... with any luck, Santa Claus will bring you a new furnace, along with items for the stockings!

Update later: https://www.yahoo.com/news/really-drive … 31280.html

This article considers why people are concerned about the sexual activities of others.

(th)

Offline

Like button can go here

#3233 2023-12-21 11:08:23

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut .... it appears we  do not need to create a topic for discussion of LENR.

I have changed my new topic to be sure to specify that it has nothing to do with LENR.

Cold fusion (LENR) is for real - NASA says so by louis [ 1 2 ]
Life support systems    30    2023-08-14 20:49:48 by Mars_B4_Moon

Is it LENR? NASA and Global Energy developing a new type of generator. by louis
Life support systems    8    2018-04-28 23:45:18 by Void

LENR/cold fusion looks real and Japan is leading the way by louis
Science, Technology, and Astronomy    12    2018-02-01 16:27:58 by Void

LENR confirmed by louis
Science, Technology, and Astronomy    0    2017-12-11 09:57:39 by louis

LENR - looking good by louis
Life support systems    5    2017-09-21 10:44:17 by Oldfart1939
Pages:1

(th)

Offline

Like button can go here

#3234 2023-12-22 18:30:05

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re today's posts ....

It is good to see you engaging with so many posts ... it reminds me of old times in the forum archive! 

Best wishes for the Holiday's!  I hope that Santa Claus brings you a new furnace, complete with duct work and all the trimmings!

A new powerful computer would be another nice deliverable if Santa can spare one!  That's a lot to pack into a sleigh, or for the reindeer to haul.

***
Item: I was surprised to find New Hampshire listed as home of the maker of some exotic chocolate candies that showed up unexpectedly here.

One of Santa's elves left the offering on the porch.  That's the ** first ** that's happened in 30+ years.

(th)

Offline

Like button can go here

#3235 2023-12-23 13:36:37

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut ....

Re https://newmars.com/forums/viewtopic.ph … 85#p217485

That is a helpful update on development of the near-space balloon flights business ...

I thought we had a topic for that, but if not, your post would be a good one to start out with. There are likely to be more such stories with images from actual flights, and potentially we might even persuade someone to report on an actual flight experience.

(th)

Offline

Like button can go here

#3236 2023-12-24 08:50:32

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re Nickel-63 to Copper-63 Nuclear Battery proposal...

Your interests and skills seem to be particularly well tuned for critical evaluation of the work of others.

Please evaluate the possible use of Nickel-63 as a large scale energy storage material. 

You will find the Nickel-63 section at the bottom of the transcript.

https://docs.google.com/document/d/1545 … sp=sharing

(the)

Offline

Like button can go here

#3237 2023-12-24 18:43:13

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re new topic dedicated to Nickel-63 to Copper-63 ...

https://newmars.com/forums/viewtopic.php?id=10643

Thanks for finding and posting the links to Russian work on this concept!

I was happy to see Calliban's follow up!

One observation I would offer is that I am not interested in the heat production aspect of the decay mechanism.

I haven't read any of the links you provided, but I am guessing the Russians might have been focused upon traditional thermal outputs.

From my perspective, that might be worth pursuing, but the direct electric generation is what would make this a practical system.

The use of the term "highly enriched" in the post would put off ordinary people, because it implies radioactive materials like Uranium.

This material produces electrons, while transitioning from Nickel to Copper. 

It does cause a neutron to convert to a proton, but that happens inside the nucleus, so the electron is ejected.

Thanks again for the research you did, and for providing an opportunity for Calliban to contribute a link!

(th)

Offline

Like button can go here

#3238 2023-12-24 22:27:57

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut and All.... NewMars was found back up at 4:27 UTC (23:27 New Hampshirte time)

Update at 11 AM local time ... the Internet seems congested today.... I can well imagine that there is heavy usage due to the holiday in the US.

(th)

Offline

Like button can go here

#3239 2023-12-26 13:24:40

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut ...

This post is to drop off a backup copy of the link to a study of a 1 megawatt RTG using Nickel-63.

https://www.dropbox.com/scl/fi/gpkmu1hp … vxro8&dl=0

In the end, the project requirements exceeded even my tolerance.

The study includes a demonstration of ChatGPT4 accepting helpful feedback from Calliban that led to correction of it's results, to bring them into line with Calliban's prediction.

Update Wednesday 2023/12/27 ... IP address of newmars.com is 69.163.253.124 (same as marssociety.org)

I observed a DNS lookup delay this morning, but the site eventually connected with no packet loss

(th)

Offline

Like button can go here

#3240 2023-12-27 10:11:15

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re Nickel-63  to Copper-63 studies ...

As reported elsewhere, I am transitioning from study of the 1 Megawatt scenario to a home sized 14 Kw scenario.

The target of the 14 Kw study will be for a longer period, such as 50 years.

I'll ask ChatGPT4 to compute the requirements for a system able to deliver 14 Kw after 50 years, and that means the opening power output will be well above that.  The excess can be sold to the grid by the home owner. 

I have an request for you to consider. I understand your time is limited, and this request may not fit into your available free time.

Request: Please document how you would use a power supply that delivers 14 Kw for 50 years.  Because of the difficulty of pulling electrical power directly from the package, I am leaning toward generating thermal energy and using that directly where that is appropriate, and otherwise using it to create electrical energy despite the poor efficiency.  Waste thermal energy can be directed into the thermal energy budget.

Applications for a home owner would include power to clean up contaminated water such as might come from a well, or such as might come from the home itself, as a result of human activity.

Because your study will match the requirements of a a home on Mars, please discard NOTHING.

On Earth, humans have gotten used to just tossing waste out into the Earth, for natural processes to handle.

On Mars, that will NOT be an option, so your study will be helpful for those planning a Mars community.

Please plan to allocate enough energy to reduce unneeded compounds to their elemental form, or to useful compounds such as water where possible.

My first question would be... is 14 Kw enough?

A relative installed a 14 Kw Generac, but the installer was able to supply only about half the energy requirements of the house. The requirements were based upon peak loads which might be imposed if everything is turned on. The compromise covers the essentials, such as furnace, air conditioning and some appliances.

The next generally recognized performance standard is 20 Kw.

(th)

Offline

Like button can go here

#3241 2023-12-27 18:58:37

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re thermal energy supply ....

A thermal energy supply would be able to provide a maximum of (about a third) of the output energy delivered as electric current.

The size supply I'm working on is 14 Kw, because that is a popular size for home backup devices made by Kohler and Generac.

As you've pointed out in recent posts in other topics, a user of such a system would be lucky to get 1/3, or about 4 Kw of usable electricity.

In one of your posts you mentioned 2 Kw as a usage you might have recorded at your home.

However, that might not include heating for air for the home, and water for various uses.

One application that might be possible, if you had 10 Kw of thermal energy constantly available, is a neighborhood hot springs business.

That idea might work better in a Northern latitude that has more winter and less summer.

Another option that practically anyone could use is to deliver the excess thermal energy into the water underground, where it would be available for retrieval via heat pump if necessary.

An example for application of such a capability might be melting ice on the driveway or sidewalks, which would otherwise be unaffordable for most folks.

Update later:
I asked Google about the efficiency of KRUSTY, which uses stirling engine technology to drive a generator ...

The thermal power of the test ranged from 1.5 to 5.0 kW(thermal), with a fuel temperature up to 880°C. Each 80-W(electric)–rated Stirling converter produced ~90 W(electric) at a component efficiency of ~35% and an overall system efficiency of ~25%.
Results of the KRUSTY Nuclear System Test - Taylor & Francis Online
www.tandfonline.com › ... › List of Issues › Volume 206, Issue sup1
About Featured Snippets

That figure of 25% is interesting, because it shows performance of a system not too different from the one we're talking about in the Nickel-63 topics.

If the target output is 14 Kw, then 25% of that is a bit over 3 Kw for electric supply, and that would appear to meet most of the household electrical supply needs.

The balance of 11+ Kw of thermal energy would be available for heating or for processing water to remove impurities or other similar applications.

Whatever thermal energy can't be used by the customer has to be fed to the air or to the water underground.

(th)

Offline

Like button can go here

#3242 2023-12-28 10:51:18

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re planning for Ni-63 industry ...

Please start thinking about how we might organize topics in the forum to support development of a global and eventually Solar system-wide industry based upon the reliable heating and energy storage capability of Ni-63.

It seems to me that our Economy topic might be the best fit for creating topics that would help to organize thinking about the several aspects of the new industry.

Topics might include:
A great deal more work is required to turn this discovery into an industry:
1) Manufacture of Ni-63
2) Assembly at a factory
3) Shipment while keeping cool (ie, redirecting thermal energy)
4) Installation while keeping cool
5) Operation while keeping cool
6) Removal from operation while keeping cool
7) Return to factory while keeping cool
8) Disassembly and reprocessing at factory (70% of the original charge will remain after 50 years)
9) Security, Government relations, Public relations, other topics

(th)

Offline

Like button can go here

#3243 2023-12-28 13:35:31

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut ... this is a question for our Senior Admin ...

Is there a way to ask for a different font when posting?

Please look at this post: https://newmars.com/forums/viewtopic.ph … 77#p217777

You will see that ChatGPT4 is stymied by the use of proportional fond by FluxBB.

(th)

Offline

Like button can go here

#3244 2023-12-28 14:20:32

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

This is an experiment in formatting:

This is some code.

What I'm wondering is if the font remains proportional, or if it adjusted to fixed for code.

(th)

Offline

Like button can go here

#3245 2023-12-28 14:21:32

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

Time (seconds) | Time (minutes) | Temperature (°C)
-------------------------------------------------
            0  |            0.00 |              0.0
          209  |            3.48 |             9.99
          418  |            6.97 |            19.97
          627  |           10.45 |            29.96
          836  |           13.93 |            39.94
         1045  |           17.42 |            49.93
         1254  |           20.90 |            59.91
         1463  |           24.38 |            69.90
         1672  |           27.87 |            79.89
         1881  |           31.35 |            89.87
         2090  |           34.83 |            99.86

The BBCode that produced that nice layout is: Left bracket code right bracket and the corresponding slash to close the sequence.

(th)

Offline

Like button can go here

#3246 2023-12-28 14:50:34

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,436

Re: Housekeeping

The font could be changed if a mod was installed for it but that is one of the reasons that we adopted the standard no frills version.
I think it was a [size] command line in another version but its not present currently.

Offline

Like button can go here

#3247 2023-12-28 15:22:27

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut re #3246

Thank you for thinking about the presentation problem!  I stumbled across the "code/code" option.  It formats plain text correctly.

An example was posted recently in another topic, or perhaps this one. I don't remember << sigh>>.

I have tested several of the available bbcodes and they seem to work in this forum.

I'm about to open a new topic for manufacturing of Ni-63, per our previous discussion.

(th)

Offline

Like button can go here

#3248 2023-12-28 18:03:58

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,436

Re: Housekeeping

my Apache error did not like the day, month of the moon post under the ula topic.

Offline

Like button can go here

#3249 2023-12-28 18:47:41

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 19,585

Re: Housekeeping

For SpaceNut .... as we enter 2024, I'm hoping kbd512 will have time to finish his modifications to the FluxBB code that runs our forum. When he is finished, the software should run on current level MySQL, PHP and Apache.  When we have the package running on our home systems, we ** should ** be able find out where these Apache Internal Server errors are coming from.

As a possible clue, I learned in setting up the duplicate system here, that FluxBB puts every word we enter into a post into a very large indexed table. That is how it is able to perform searches by word, when we ask it where a particular word might be.  Instead of searching the actual posts, it searches the table of words. That table has the ID of the post where the word appears. i'm guessing that some words in a new post may trigger a conflict with the words table. 

If you have not yet started setting up your duplicate system, 2024 is a brand new year to accomplish that.

I expect you'll need hardware, such as a removable hard drive and mount, so your existing home system is not cluttered up with the development software.

(th)

Offline

Like button can go here

#3250 2023-12-28 18:59:36

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,436

Re: Housekeeping

I know that data bases with MySQL, oracle and other treat dates in given formats and excel can change them for others that it may not be liking all that well.

Offline

Like button can go here

Board footer

Powered by FluxBB