Hi, I really need help with this. My ISPConfig has been working fine for quite a while, but since today (or since the last update, I don't know) I can't do anything in the control panel. When I try to edit or create a website, database, or anything else, the database is updated, so if I come back I can see what I just changed, but there is no job created in the job queue and the changes I made are not actually processed. For example, if I try to add a site I can see the site in the Sites tab, but the site is actually not created and I can not reach the website. Please help me in resolving this issue, it's an urgent matter which I need resolved ASAP... Thanks for any help/advice in advance. -Gertjan
Update of what? See thread https://www.howtoforge.com/community/threads/cannot-create-a-new-site.82614/#post-392050 Looks like @Tom87 and @Sterli have similar problem.
The update of ISPConfig to 3.1.14p2. Like you said, I appear to have the same problem described in thread 82614.
Enable debug mode as described in https://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/ Then change something (create website etc) and run the server.sh script manually.
Then either you did not change anything prior to running the command or the minutely cron job ran before you ran it by hand or you have a multiserver and did not run the debug on the server the changed object belongs to or your database is somehow really defective or you did what I mentioned in the other script – upgrading and downgrading. And please check the sys log inside ISPConfig monitor tab, too.
I did it in the correct order: - Disable cron - Create website - Run serverh.sh What do you mean with: ? The system-log in the ISPConfig monitor tab is empty.
You missed enabling debug mode as described in debug instructions. Go to System > server config and setv the log level to debug. Then create a website, run server.sh and post the result. Beside that, run a repair on all tables in the dbispconfig database with phpmyadmin, it might be that a table is broken.
I'm sorry, here's the output from server.sh now: Code: 26.08.2019-08:03 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. 26.08.2019-08:03 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock finished. How do I run a repair in phpmyadmin?
1) That's the output after you created a new website? It basically means that there is nothing to be configured, which is a bit strange. 2) Maybe it's easier to do the table repair on the shell, run this command: Code: sudo mysqlcheck --defaults-file=/etc/mysql/debian.cnf --optimize --auto-repair --silent dbispconfig
Yes, I tried it twice to make sure the output was the same and this was all that I got.. The output of server.sh is the same after running mysqlcheck
Please have a look into the file /usr/local/ispconfig/server/mysql_clientdb.conf Is the MySQL root password in that file correct?
Please check if your database table "sys_datalog" has a column "session_id". And please check if your table "server_php" has an "active" column.
There we have your problem. The update at some time failed to load the sql incremental files and so your db scheme is missing the neccessary fields. Please change the "dbversion" column of your "server" table to 86 and then do an ISPConfig update again.
Do the update like this: https://www.howtoforge.com/community/threads/forcing-ispconfig-upgrade.81756/#post-387447