"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.

• 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

• 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)