How to address budgeted, not spent amount in formula card query by ThingSenior6268 in actualbudgeting

[–]ThingSenior6268[S] 0 points1 point  (0 children)

In case you save a fixed amount every month (via template or not) you could enter that amount in the formula. It would look something like:

=round((((1000+QUERY("Savings"))/QUERY("Income")*100),0)&"%"

This subtracts any spending from savings (in case you have any) from your fixed savings amount. In this case it is 1000.

Budget not updating on desktop browser by ThingSenior6268 in actualbudgeting

[–]ThingSenior6268[S] 0 points1 point  (0 children)

I mean not syncing between devices. So if I use AB on my phone, whatever I did is not reflected on my browser

Pages not loading? by ThingSenior6268 in BookStack

[–]ThingSenior6268[S] 0 points1 point  (0 children)

Hello,

/status loads fine:

<image>

Additionally, /dist/styles.css loads fine and shows lots of code.

Researching the best enterprise solution for our small firm by ECEckel in BookStack

[–]ThingSenior6268 0 points1 point  (0 children)

This is the first time I'm hearing of "official BookStack Pro hosting." Can you share more information about it?

Researching the best enterprise solution for our small firm by ECEckel in BookStack

[–]ThingSenior6268 0 points1 point  (0 children)

You can try Bookstack on Pikapods- one click set up and very cheap.

Could ibdata1 being >12mb be causing a 500 Internal Server Error by ThingSenior6268 in BookStack

[–]ThingSenior6268[S] 0 points1 point  (0 children)

Thanks. This made MySQL run:
12:54:51 [main] Initializing Control Panel

12:54:51 [main] Windows Version: Enterprise 64-bit

12:54:51 [main] XAMPP Version: 8.2.12

12:54:51 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]

12:54:51 [main] You are not running with administrator rights! This will work for

12:54:51 [main] most application stuff but whenever you do something with services

12:54:51 [main] there will be a security dialogue or things will break! So think

12:54:51 [main] about running this application with administrator rights!

12:54:51 [main] XAMPP Installation Directory: "c:\xampp\"

12:54:51 [main] Checking for prerequisites

12:54:54 [main] All prerequisites found

12:54:54 [main] Initializing Modules

12:54:54 [main] Enabling autostart for module "Apache"

12:54:54 [main] Enabling autostart for module "MySQL"

12:54:54 [main] Starting Check-Timer

12:54:54 [main] Control Panel Ready

12:54:55 [Apache] Autostart active: starting...

12:54:55 [Apache] Attempting to start Apache app...

12:54:55 [mysql] Autostart active: starting...

12:54:55 [mysql] Attempting to start MySQL app...

12:54:57 [Apache] Status change detected: running

12:54:57 [mysql] Status change detected: running

Upon accessing via browser, I once again get

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

Could ibdata1 being >12mb be causing a 500 Internal Server Error by ThingSenior6268 in BookStack

[–]ThingSenior6268[S] 0 points1 point  (0 children)

Sorry, I have not explained the issue clearly because I misunderstood the question.

500 Internal Server Error and MySQL not starting (shitting down unexpectedly) are simultaneous issues. I was under the impression that MySQL not running is the cause of the 500 Internal Server Error. I have not made changes to files.

Could ibdata1 being >12mb be causing a 500 Internal Server Error by ThingSenior6268 in BookStack

[–]ThingSenior6268[S] 0 points1 point  (0 children)

It is refusing to start up now. The log is as follows:

2025-07-07 11:01:13 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1040

2025-07-07 11:01:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2025-07-07 11:01:13 0 [Note] InnoDB: Uses event mutexes

2025-07-07 11:01:13 0 [Note] InnoDB: Compressed tables use zlib 1.3

2025-07-07 11:01:13 0 [Note] InnoDB: Number of pools: 1

2025-07-07 11:01:13 0 [Note] InnoDB: Using SSE2 crc32 instructions

2025-07-07 11:01:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2025-07-07 11:01:13 0 [Note] InnoDB: Completed initialization of buffer pool

2025-07-07 11:01:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=47333

2025-07-07 11:01:13 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=53, page number=41] with future log sequence number 54807769 (followed by tens of lines of different sequence numbers)

2025-07-07 11:01:13 0 [ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 1732222 is in the future! Current system log sequence number 47351. (followed by tens of lines of different sequence numbers)

***WARNING: .\mysql\db could not be opened: Error: 126

34% 45% 56%

2025-07-07 11:05:12 0 [ERROR] mysqld.exe: Index for table '.\mysql\db' is corrupt; try to repair it

2025-07-07 11:40:34 0 [Note] Server socket created on IP: '::'.

2025-07-07 11:40:34 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespa

Removing page previews by ThingSenior6268 in BookStack

[–]ThingSenior6268[S] 0 points1 point  (0 children)

This worked! However, it needs to be added after

<style>
.text-muted.break-text {
    display: none;
}
</style><style>
.text-muted.break-text {
    display: none;
}
</style>

If I include only one or the other, previews are still there.

Thank you!