62504

Failed security check. DataPage cannot be rendered from this account type.

This error occurs when you store users’ passwords in a Text (255) field in a user table.

Due to data security restriction, passwords must be stored in a Password data type field.

50501

The deploy code of the DataPage may be missing the complete app key.

The DataPage is deleted and no longer exists in your account.

Select the DataPage, click Deploy, choose the preferred deployment method, copy the deploy code and replace the deploy code on your host page with the new version.

50522

This DataPage belongs to Caspio Account which has exceeded one of its usage limits. Please ask your administrator to increase the limit for Caspio Account.

This error occurs when one or more resources (for example emails, storage or data transfer) utilized by your DataPages has reached its daily or monthly limits.

If you want to increase the limits, upgrade your account to a higher plan or contact Caspio Support for assistance.

50510

This DataPage is not configured for public access.

Enable external access to the DataPage.

1. On the DataPages listing, select your DataPage.
2. Click Deploy.
3. On the Deploy DataPage screen, choose the deployment method and activate other functionalities.
4. In the Deployment Status section, click the Enabled button.
5. Click Close. If you just close the dialog without clicking on the Enabled button, the DataPage will not be deployed and cannot be accessed externally.

 Cannot redirect to the specified destination page. This DataPage is designed to be embedded on a web page.

You may encounter this error in two cases:

1. After submitting a form or update. The Destination Options in your DataPage is set to Relative path. When this option is chosen, the DataPage must be embedded on your site for the destination page to be found. If the DataPage is used in direct URL mode, there is no way to place the destination page.

On the Destination and Emails screen, provide the complete path to the destination page, for example, http://example_website.com/example_page or do not use this DataPage via a direct URL.

2. After opening an authenticated form. The Time out & Redirection under Advanced Settings of your authentication is set to Relative path. When this option is chosen, the DataPage must be embedded on your site for the redirection page to be found.

On the authentication Advanced Settings provide the complete path to the page or do not use this DataPage via a direct URL or Preview mode.

This DataPage must be accessed via HTTPS only.

The reason you get this error message is because your DataPage deployment inside Caspio Bridge has SSL encryption enabled. However, you are trying to access the DataPage through “http” protocol.

Use HTTPS in the URL or the Embed deploy code in your webpage source.

If you don’t need the SSL encryption, then you can clear the Enable SSL encryption check box in the DataPage deployment screen.

There are 2 possible reasons:

1. When you’re loading or submitting the app offline.

Publish the webpage and access it online or use direct URL of the DataPage.

2. If you’re using direct URL of a Report DataPage when you leave the results page for a few hours and then attempt to go to the Details page. Record’s session expires and cause the error message when you attempt to go to the record Details page.

Use embed deployment method or create custom details link which remains permanent. See how.

Duplicates values are not allowed

You see this message because Caspio Bridge enforces the Unique integrity rule of a field in your table. Submitting any record that violates the Unique rule is not allowed.

If your email field is set to unique, it is not possible to enter a duplicate email address. Note that “blank” is also considered a value. As a result the unique field can only be left blank in one record.

To see or change the “Unique” property of a field, open the table in Design mode.Bottom of Form

Cannot redirect to Facebook

or

Error: redirect_uri_mismatch

This error occurs when your ID service provider is expecting to be reached via HTTPS but your application is calling it in HTTP.

To resolve this issue try one of the following:

1. Deploy your DataPage in HTTPS.
2. Configure your ID service to accept HTTP. For more information go to the article and see step 8.

Object moved to here or This webpage is not available.

You see this error when the form you are submitting or the DataPage you are interacting with is accessed from your file system and is not deployed to a web server.

Upload your DataPage to a web server and access the page via its URL. If you don’t have a web server, instead of getting the embed code from Caspio’s Deployment screen, get a direct URL to your DataPage.

For more instructions, go to the article on DataPage Deployment.

Error in formula

While performing calculations in a DataPage using Calculated Fields or Aggregate functions, there could be a number of arithmetic issues contributing to the message, Error in formula, but there are common situations when your formula is causing the error.

Division by zero:

Example: “A/B” works fine, except when B is zero and you get the error message.

Solution

Use the following code which catches the zeros before they cause an error. Just make sure to change A and B with your own field names.

Case

When [@field:B]= '0'

Then null

Else

([@field:A]/[@field:B])

End

Blank values:

Example: A+B works fine, except when the field value is blank.

Solution

Use the following code to handle blanks.

IsNull([@field:A],0)+IsNull([@field:B],0)

Non-numeric values:

Example: A+B works fine, except when the field value is text such as N/A.

Solution

Use the following code to skip the text values in the calculation.

IsNumeric([@field:A])+IsNumeric([@field:B])

Table or Field name change:

If table or field name is changed in the table design, it won’t be updated in the formula which results in “error in formula” error message.

Solution

Update the table or field name reference manually in the formula.

Mismatch data type:

If fields in the formula do not have the same data type.
If result expressions in Case formula do not have the same data type. Example:

CASE input_expression
WHEN when_expression
THEN result_expression
ELSE result_expression
END

Solution

Make sure the fields and result expressions have the same data type or use CAST function to convert the data type:

CAST (result_expression AS datatype)

Most common data types are char, varchar, binary, date, float, real, int.

See an example in our community forum, https://forums.caspio.com/index.php/topic/3632-calculated-field-to-compare-dates-or-return-text/.