I destroyed a Linux Mint standalone server that had been working flawlessly for over 12 years. With updates to Mint, php, html and mysql, I can access the database and populate our "Products Database Form". With the "previous", "next", and "last" active buttons, I can view the info on over 10k items. The problem is that I cannot edit/save or add new/save. Visually, I can fill in new information in the form but when I click "Submit" to save the changes to the database, I always get an error message (differing depending on what new fix I tried to implement.)
Forum members and online instructions have been a great help but nothing seems to solve this problem. Most suggest code changes that make this process look simple and routine but none of them work for me. The problem has to be in the php commands to the mysql database. I think there are eight .php files corresponding to "button/links" on the form that try to save changes to the database. I'm guessing that they all have the same problem. I am an inexperienced 70 year old, trying to fix this for several months now.
How can I find/hire an individual to fix the coding on my unique server? Either remotely or in person at our shop north of Dallas, TX.
Typical errors: "Trying to access array offset on value of type bool"
"Trying to access array offset on value of type null"
Code: Select all
System:
Kernel: 5.4.0-105-generic x86_64 bits: 64 compiler: gcc v: 9.4.0
Desktop: MATE 1.26.0 info: mate-panel wm: marco 1.26.0 dm: LightDM 1.30.0
Distro: Linux Mint 20.3 Una base: Ubuntu 20.04 focal
Machine:
Type: Desktop Mobo: ASUSTeK model: M5A78L-M LX PLUS v: Rev X.0x
serial: <filter> BIOS: American Megatrends v: 0801 date: 02/15/2012
CPU:
Topology: Quad Core model: AMD FX-4100 bits: 64 type: MCP arch: Bulldozer
rev: 2 L1 cache: 192 KiB L2 cache: 2048 KiB L3 cache: 8192 KiB
flags: avx lm nx pae sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3 svm
bogomips: 28930
Speed: 1829 MHz min/max: 1400/3600 MHz boost: enabled Core speeds (MHz):
1: 1809 2: 1418 3: 1638 4: 1669
Graphics:
Device-1: AMD RS780L [Radeon 3000] vendor: ASUSTeK driver: radeon
v: kernel bus ID: 01:05.0 chip ID: 1002:9616
Display: x11 server: X.Org 1.20.13 driver: ati,radeon
unloaded: fbdev,modesetting,vesa compositor: marco v: 1.26.0
resolution: 1024x768~85Hz
OpenGL: renderer: AMD RS780 (DRM 2.50.0 / 5.4.0-105-generic LLVM 12.0.0)
v: 3.3 Mesa 21.2.6 compat-v: 3.0 direct render: Yes
Audio:
Device-1: AMD SBx00 Azalia vendor: ASUSTeK M5A78L LE driver: snd_hda_intel
v: kernel bus ID: 00:14.2 chip ID: 1002:4383
Sound Server: ALSA v: k5.4.0-105-generic
Network:
Device-1: Realtek RTL8111/8168/8411 PCI Express Gigabit Ethernet
vendor: ASUSTeK P8P67 and other motherboards driver: r8169 v: kernel
port: d800 bus ID: 02:00.0 chip ID: 10ec:8168
IF: enp2s0 state: up speed: 100 Mbps duplex: full mac: <filter>
Device-2: VIA VT6105/VT6106S [Rhine-III]
vendor: D-Link System DFE-530TX+ rev F2 driver: via-rhine v: N/A
port: e800 bus ID: 03:05.0 chip ID: 1106:3106
IF: enp3s5 state: down mac: <filter>
Drives:
Local Storage: total: 4.56 TiB used: 960.90 GiB (20.6%)
ID-1: /dev/sda model: SATA SSD size: 447.13 GiB speed: 3.0 Gb/s
serial: <filter> rev: 61.5 temp: 30 C scheme: MBR
ID-2: /dev/sdb vendor: Seagate model: ST2000DM008-2FR102 size: 1.82 TiB
speed: 3.0 Gb/s rotation: 7200 rpm serial: <filter> rev: 0001 temp: 36 C
scheme: MBR
ID-3: /dev/sdc vendor: Seagate model: ST2000DM008-2FR102 size: 1.82 TiB
speed: 3.0 Gb/s rotation: 7200 rpm serial: <filter> rev: 0001 temp: 36 C
scheme: MBR
ID-4: /dev/sdd type: USB vendor: PNY model: USB 3.0 FD size: 28.90 GiB
serial: <filter> rev: PMAP scheme: MBR
ID-5: /dev/sde type: USB vendor: Seagate model: ST3500418AS
size: 465.76 GiB rotation: 7200 rpm serial: <filter> rev: 102D scheme: MBR
Partition:
ID-1: / size: 438.62 GiB used: 139.64 GiB (31.8%) fs: ext4 dev: /dev/sda5
ID-2: /home size: 1.79 TiB used: 123.89 GiB (6.8%) fs: ext4 dev: /dev/sdc1
Sensors:
System Temperatures: cpu: 34.0 C mobo: 36.0 C
Fan Speeds (RPM): cpu: 1956 case-1: 946
Voltages: 12v: 11.95 5v: N/A 3.3v: 3.32 vbat: N/A
Repos:
No active apt repos in: /etc/apt/sources.list
Active apt repos in: /etc/apt/sources.list.d/google-chrome.list
1: deb [arch=amd64] https://dl.google.com/linux/chrome/deb/ stable main
Active apt repos in: /etc/apt/sources.list.d/official-package-repositories.list
1: deb http://packages.linuxmint.com una main upstream import backport
2: deb http://archive.linux.duke.edu/ubuntu focal main restricted universe multiverse
3: deb http://archive.linux.duke.edu/ubuntu focal-updates main restricted universe multiverse
4: deb http://archive.linux.duke.edu/ubuntu focal-backports main restricted universe multiverse
5: deb http://security.ubuntu.com/ubuntu/ focal-security main restricted universe multiverse
6: deb http://archive.canonical.com/ubuntu/ focal partner
Info:
Processes: 245 Uptime: 7h 14m Memory: 3.58 GiB used: 1.29 GiB (36.2%)
Init: systemd v: 245 runlevel: 5 Compilers: gcc: 9.4.0 alt: 9 Shell: bash
v: 5.0.17 running in: mate-terminal inxi: 3.0.38