Known Issues

This page is a work in progress. As new common/recurring issues are encountered, they will be addressed here.

Troubleshooting

Description	Affected Instances	How to Fix
Installation error: deprecated function "mysql_escape_string"	All versions up to 2.2.1 on some servers	Replace all instances of "mysql_escape_string" with "addslashes" in initialize.php, or simply remove those function calls. Note that if you perform the latter action, you must ensure that the values you put in the "Application Name" and "Administrator Email" fields of the installation form do not contain any apostrophes (otherwise, the resulting installation will be broken).
Update notifications do not work	Installed at 1.6.1 or earlier and updated to a version in the range 1.6.5 - 2.0 Installed on any server where the PHP option allow_url_fopen is disabled	Enable fopen_allow_url in the hosting environment (updates themselves won't work without this option; it's the crux of the remote update process) Set value of the column unique_id in table x2_admin to "none", i.e. UPDATE `x2_admin` SET `unique_id`='none' Then, go to "Updater Settings" ("General Settings" in versions earlier than 2.0), ensure "Enable Software Update Notifications" is checked, and submit the form. Run the update manually
Cannot view or create quotes	Installed at 1.6.1 or earlier and updated to a version in the range 1.6.5 - 1.6.6	Run the following SQL: Versions earlier than 2.0: INSERT INTO x2_fields (modelName, fieldName, attributeLabel, modified, custom, type, required, readOnly, linkType, searchable, relevance) VALUES ("Quote", "products", "Products", 0, 0, "varchar", 0, 0, NULL, 0, ""), ("Quote", "existingProducts", "Existing Products", 0, 0, "varchar", 0, 0, NULL, 0, "") Versions 2.0 and later: INSERT INTO x2_fields (modelName, fieldName, attributeLabel, modified, custom, type, required, readOnly, linkType, searchable, relevance,isVirtual) VALUES ("Quote", "products", "Products", 0, 0, "varchar", 0, 0, NULL, 0, "", 1), ("Quote", "existingProducts", "Existing Products", 0, 0, "varchar", 0, 0, NULL, 0, "", 1)

Running Updates Manually

In some cases, it may be desirable to bypass the update notifications and go straight to the updater to check if there is a new version available, because of update notifications disabled or an improperly set unique_id in the x2_admin table. To run an update or check for an update manually, log in as the admin user and in the browser's address bar, replace "index.php/site/whatsNew" with "index.php/admin/updater", and hit enter to run the action.

In versions 2.2 and later, it is possible to go directly to the updater through a link in the admin console under the "System Settings" section.