TOPIC:

We've moved our current Xerte installation to a new server, and have upgrade to the latest release. All works okay for existing projects, however when new projects are being created the application fails. The opened browser window message is:

edithtml.php?template_id=FAILED-Failed to create new template record for the database INSERT INTO templatedetails (creator_id

A new installation on the server does not exhibit this behaviour. The development flag is set to true, there are no error logs generated by the application, the php log shows no errors.

Hi
quick reply...
You've moved to a new server so have you restored the files and database from the old server and created an identical MySQL user and password with full permissions on the database? Have you also run upgrade.php?
When you create a new project is the project folder created in USER-FILES?
This is likely to be either database permissions or file system permissions and that should show up in the relevant error logs.
Also what are you using for Authentication and is that still working correctly? e.g. you can login and when you do you see your name top right of the workspace.
HTH
Ron

Using LDAP, authentication is fine, on existing projects, media can be uploaded, the project can edited. Have ensured that the permissons are the same on the moved site as they are on the new installation.

There are no error logs, the only error message is in the window of the browser, nothing is ever writtent to application error logs or PHP logs.

The installation failed on initial migration, so a new instance was created. The USER-FILES were tarred/untarred into the directory, the database was then imported and the path statements and Website URL were updated appropriately.

If the database permissions were incorrect would you be able to create a new folder in the workspace?

Projects can be reassigned to other users, presumably that's database also.

If filesystem permissions were incorrect would you be able to upload media files?

Permissions on the USER-FILES directory is:

drwxrwxr-x 151 www-data root 12288 Jan 11 13:07 USER-FILES/

Two questions:
- can you find the debug.log file (it should existand conatin messages if you enabled $development mode. Normally this file is in error_logs/debug.log
- Like Ron asked, did you run upgrade.php (browse to <xerte url>/upgrade.php)

Have run the upgrade script a second time:
Starting from 29 Updates are being applied to xerte

Current database version - 29

Database is up to date, nothing to do
Cleanup up files that are really in the way
File themes/Nottingham/blackround/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/btnTopPurple/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/darkgrey/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/flatblue/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/flatred/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/flatwhite/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/orangepurple/responsivetext.css not found (already deleted :-) )
File themes/Nottingham/sketch/responsivetext.css not found (already deleted :-) )
File modules/xerte/parent_templates/Nottingham/common_html5/mediaelement/DO NOT CHANGE THESE FILES. USE -src- FOLDER.txt not found (already deleted :-) )
Done

There are logs in the error dirctory now, the CRITICAL.log says
<p>13:01:42 - 11/01/2022 CRITICAL<Br>Failed to create new template record for the database<Br>INSERT INTO templatedetails (creator_id, template_type_id, date_created, date_modified, number_of_uses, access_to_whom, template_name, extra_flags)
VALUES (?, ?, ?, ?, ?, ?, ?, ?)</p>*

No mysql error indicating what the actual error is?

Anyway, there seems to be something off with the rights of the database user, because existing templates do work, so I assume the templatedetails table does exist. The database user details can be found in database.php. Please verify that the b user mentined there is able to create records.