Error Uploading Dictionary: Error 500

[khurshid.arshad]

Dear Team;

I initially developed an application using CSPro 7.7.3, and I am now attempting to deploy the same application in CSPro version 8.0.1. However, during deployment, I encountered the following error: "Error uploading Dictionary: Error 500."

My current environment details are as follows:

XAMPP Version: 8.0.30
Control Panel Version: 3.3.0
CSWeb Version: 8.0.1

Please advise on how to resolve this issue at your earliest convenience.

Thank you.

a.

[justinlakier]

Hello,

Error 500 is the code for a general internal server error. Could you attach your logs? This includes CSPro's sync.log file, your server's api.log file (from csweb/var/logs directory using CSWeb), and your server's php error log if you have one.

Thank you,
Justin

[khurshid.arshad]

Dear Justinlakier;

Please find attached required files.
thanks.
a.

[khurshid.arshad]

The same error occurs on Wamp64. This issue arises during the application deployment."

i am using

WampServer 3.2.6
phpmyadmin 5.1.2
php 8.1.0
Apache/2.4.51
CSWeb 8.0

thanks.
a.

[khurshid.arshad]

Dear Team,

Any update?

[savy]

Can you give us the steps that led you to this state? As a workaround, you can run in phpMyAdmin this statement to drop the existing trigger.

Code: Select all

DROP TRIGGER IF EXISTS hpsdb.tr_HPS_HH_DICT;
DROP TRIGGER IF EXISTS hpsdb.tr_WOMAN_QUES_DICT;

This code drops the existing triggers and allows the application to create the new dictionary tables in the database.

[khurshid.arshad]

Dear Savy;

I hope you are doing well.

The step are as follows:

• Initially, there is no information available about any dictionary in the triggers.

• First, create a database named hpsdb1.

• Copy the csweb folder, rename it to hpsweb, and run the setup.

• After successful configuration, the triggers still do not contain any information about a dictionary.

• Deploy the application, and you will encounter an error.

• Run the SQL command as mentioned. The dictionary has been removed.

• Deploy the application again, and the same error occurs.

System Information is:

• Wampserver 3.2.6 - 64bit

• PhpMyAdmin 5.1.2

• Apache 2.4.51

• PHP 8.1.0

• CSWeb 8.0.1

Please refere to the video for reference.

https://drive.google.com/file/d/1Y2BLSa ... sp=sharing

The same error occured on the in XAMPP server with the same steps. However, it is now working fine. I have no idea what happend.
Best regards.
a.

[savy]

This is strange. We will fix the trigger creation issue anyway.

[khurshid.arshad]

Thank you.
a.

[savy]

We found the issue to be related to XAMPP configuration when large dictionaries are used. It does not happen with WAMP because it uses different settings. To resolve this issue on XAMPP, launch XAMPP control panel and increase max_allowed_packet value in MySQL config to larger than default 1M to max_allowed_packet=100M.