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
During installation: "PHP Error [8192]: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead" in initialize.php	All versions up to 2.2.1	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 value you put in for "Application Name" and "Administrator Email" must not contain any apostrophes, or 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. 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.