Supporting each other

Community forums

Welcome, Guest

Forum

Main Forum

Bugs and Issues

Invalid template_id (could not find in DB)

Report any technical problems you discover and discuss solutions.

Page:
1

TOPIC:

Invalid template_id (could not find in DB) 9 years 5 months ago #2454

cgoacher
Topic Author
Offline
Junior Member
Posts: 26
Thank you received: 0

Hi,

It's been brought to my attention that when users login to our Xerte installation they are no longer seeing their list of projects and only see a workspace folder and a recycle bin. If I login to the management.php page I am still able to see the missing content listed in the user templates area. However any projects that I have tried to edit from this area, upon clicking the Edit button, I am then presented with the error 'Invalid template_id(could not find in DB)'. However it looks like the files are still present on the server and seems that existing published content is still working when accessed directly.

To the best of my knowlegde this has only happened relatively recently. I know that the system was being used without any complaints last week and nobody is aware of any changes to the web server or database server. If I'm honest though my workload hasn't allowed me to spend much time on this system at all since I inherited it about 6 months ago so I was wondering if somebody could offer some advice to help me troubleshoot this issue?

Many thanks in advance.

Thanks

Craig Goacher

Please Log in or Create an account to join the conversation.

Invalid template_id (could not find in DB) 9 years 5 months ago #2459

cgoacher
Topic Author
Offline
Junior Member
Posts: 26
Thank you received: 0

Hi,
Upon further investigation we've traced an error back to the db_query_one in the edit.php page. The query it runs is as follows:

select originaltemplatesdetails.template_name, logindetails.username, originaltemplatesdetails.template_framework, templaterights.user_id, templaterights.folder, templaterights.template_id, templatedetails.access_to_whom from originaltemplatesdetails, templaterights, templatedetails, logindetails where templatedetails.template_type_id = originaltemplatesdetails.template_type_id and templatedetails.creator_id = logindetails.login_id and templaterights.template_id = templatedetails.template_id and templaterights.template_id="637" and role="creator"

It seems to be unhappy with the use of double quotes around the id and role values. The same query returns unknown column errors in MySQL workbench but if the double quotes are changed to single quotes we do then have results returned.

Nobody is aware of any changes happening to either Xerte, Database server or Web server so I'm very confused as to why this has only just become a problem. Is anybody aware of anything that could affect this?

Thanks

Craig

Please Log in or Create an account to join the conversation.

Invalid template_id (could not find in DB) 9 years 5 months ago #2460

cgoacher Topic Author Offline Junior Member Posts: 26 Thank you received: 0	Hi, it looks like we've got to the bottom of this now and should this help anybody in the future... It seems that somehow a global MySQL setting 'SQL mode' has been set to ANSI Quotes which prevents the use of double quotes. Once this option was blanked out (allowing double quotes), Xerte has now started working again. Thanks Craig
	Please Log in or Create an account to join the conversation.