Cannot get going

[rgtr]

Windows 11 Pro on HP machine
Yesterday had a problem with trying to fix a broken Joomla site - seems to be community builder.
was ok yesterday ...
this morning the dreaded 500.

found a new version of xampp ... uninstalled old one, and installed latest

apache starts ok
mysql starts and then stops. I have changed the c:\xampp\htdocs folder to c:\XJ_Sites

error says to post log. here it is.

2023-01-04 11:07:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-04 11:07:55 0 [Note] InnoDB: Uses event mutexes
2023-01-04 11:07:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-04 11:07:55 0 [Note] InnoDB: Number of pools: 1
2023-01-04 11:07:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-04 11:07:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-04 11:07:55 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-04 11:07:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-04 11:07:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-04 11:07:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-04 11:07:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-04 11:07:55 0 [Note] InnoDB: Waiting for purge to start
2023-01-04 11:07:55 0 [Note] InnoDB: 10.4.27 started; log sequence number 300721; transaction id 193
2023-01-04 11:07:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-04 11:07:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-04 11:07:55 0 [Note] InnoDB: Buffer pool(s) load completed at 230104 11:07:55
2023-01-04 11:07:55 0 [Note] Server socket created on IP: '::'.

going nuts, aged 75.
richard

[Altrea]

Hi,

related to HTTP status code 500 you will find additional information in your /xampp/apache/logs/error.log

related to the mysql / MariaDB problem:
Try to start MariaDB as console application and tell us what it responses. To do so, please:

• Open a new XAMPP Shell by clicking the Shell Button in your control panel
• type in the following command
  

  Code: Select all

  mysqld --defaults-file=mysql\bin\my.ini --standalone --console

• copy us the response of the console

[rgtr]

Hi
It appears to be that I have to have the data in the htdocs directory.
Also in the new version - the shell button launches and then closes immediately
And lastly, the toolbar icon that allows one to do things faults when one closes xampp - cannot write ini file.

But I have fixed the 500 error. I had to completely eradicate Community Builder from Joomla - apart from the cd tables. Reinstalled after upgrading to J4 and all is ok.

Richard

[rgtr]

Hi

After a few days of perfect operation having installed an earlier version of xampp [xampp-windows-x64-8.1.12-0-VS16-installer.exe] I am back to mysql closing down unexpectedly.

might it have something to do with firefox ?

the pc is an HP SSD with windows 11 pro.

Device name HP-Dec22
Processor 12th Gen Intel(R) Core(TM) i9-12900 2.40 GHz
Installed RAM 32.0 GB (31.7 GB usable)
Device ID DF581B9C-0D59-44B0-9549-396C6527570C
Product ID 00355-60784-96364-AAOEM
System type 64-bit operating system, x64-based processor
Pen and touch No pen or touch input is available for this display

the cmd window opens and closes ...
cannot run the requested code - just comes back with a not found

opening manually, I have changed directory to xampp\mysql\bin
found aria_chk.exe and ran - instructions then as follows.

Variables (--variable-name=value)

and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
character-sets-dir (No default value)
data-file-length 0
ignore-control-file FALSE
keys-used 18446744073709551615
datadir .
logdir .
max-record-length 9223372036854775807
require-control-file FALSE
set-auto-increment 0
set-collation (No default value)
sort-records 0
tmpdir (No default value)
transaction-log FALSE
update-state TRUE
warning-for-wrong-transaction-id TRUE
page-buffer-size 268427264
read-buffer-size 261120
write-buffer-size 261120
sort-buffer-size 268434432
sort-key-blocks 16
decode-bits 9
ft-min-word-len 4
ft-max-word-len 84
aria-ft-stopword-file (No default value)
stats-method nulls_unequal

something very weird going on....

richard

[rgtr]

Hi

Reinstalled xampp again ..

reset the permissions for xampp-control.ini to "all" from "read only"
reset the directory in httpd.conf
# DocumentRoot "C:/xampp/htdocs"
# <Directory "C:/xampp/htdocs">
DocumentRoot "C:/XJ_Sites"
<Directory "C:XJ_Sites">

Apache/2.4.54 (Win64) OpenSSL/1.1.1p PHP/8.1.12 Server at 127.0.0.1 Port 80

13:35:59 [Apache] XAMPP Apache is already running on port 80
13:35:59 [Apache] XAMPP Apache is already running on port 443
13:35:59 [mysql] XAMPP MySQL is already running on port 3306

some help would be appreciated ....

have been using apache for a very long time - like since php 4

richard

[rgtr]

Hi

Absolutely amazing

But not surprising - I blame all my woes in Windows 11 Pro. It is as flaky as Windows 3.1 if anyone cam remember that. XP and 7 were stable and I still have one of each running - flawlessly.

Turn the gadget on. Logon. FIRST THING is to start xampp.

09:19:32 [main] Initializing Control Panel
09:19:32 [main] Windows Version: Enterprise 64-bit
09:19:32 [main] XAMPP Version: 8.1.12
09:19:32 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
09:19:32 [main] You are not running with administrator rights! This will work for
09:19:32 [main] most application stuff but whenever you do something with services
09:19:32 [main] there will be a security dialogue or things will break! So think
09:19:32 [main] about running this application with administrator rights!
09:19:32 [main] XAMPP Installation Directory: "c:\xampp\"
09:19:32 [main] Checking for prerequisites
09:19:32 [main] All prerequisites found
09:19:32 [main] Initializing Modules
09:19:32 [main] The Mercury module is disabled
09:19:32 [main] The Tomcat module is disabled
09:19:32 [main] Starting Check-Timer
09:19:32 [main] Control Panel Ready
09:19:34 [Apache] Attempting to start Apache app...
09:19:34 [Apache] Status change detected: running
09:19:37 [mysql] Attempting to start MySQL app...
09:19:37 [mysql] Status change detected: running
09:19:38 [mysql] Status change detected: stopped
09:19:38 [mysql] Error: MySQL shutdown unexpectedly.
09:19:38 [mysql] This may be due to a blocked port, missing dependencies,
09:19:38 [mysql] improper privileges, a crash, or a shutdown by another method.
09:19:38 [mysql] Press the Logs button to view error logs and check
09:19:38 [mysql] the Windows Event Viewer for more clues
09:19:38 [mysql] If you need more help, copy and post this
09:19:38 [mysql] entire log window on the forums
09:19:44 [mysql] Attempting to start MySQL app...
09:19:44 [mysql] Status change detected: running

Utterly amazed. It's all "the highly unreliable" windows - perhaps Gates should give MicroShaft a grant to fix their product.

Richard

[rgtr]

Hi

09:19:32 [main] You are not running with administrator rights! This will work for
09:19:32 [main] most application stuff but whenever you do something with services
09:19:32 [main] there will be a security dialogue or things will break! So think
09:19:32 [main] about running this application with administrator rights!

That was the first time I have seen that message ...

Fixed.

Installation problem then.

Richard