Administrator
- Join Date:
- Sep 2009
- Location:
- Stuart, FL
- Posts:
- 14,139
- Plugin Contributions:
- 56
sqlpatch.php help-text gives "bad" information
Looking through the help-text (by pressing the Details button) for the admin Tools->Install SQL Patches, the first example under "Advanced Methods" specifies the following code block as a guideline:
#NEXT_X_ROWS_AS_ONE_COMMAND:4
SET @t1=0;
SELECT (@t1:=configuration_value) as t1
FROM configuration
WHERE configuration_key = 'KEY_NAME_HERE';
UPDATE product_type_layout SET configuration_value = @t1 WHERE configuration_key = 'KEY_NAME_TO_CHECK_HERE';
DELETE FROM configuration WHERE configuration_key = 'KEY_NAME_HERE';
The SQL fragment highlighted above in red was previously identified by swguy as problematic (http://www.zen-cart.com/showthread.php?184566-1-5-modders-doing-SQL-changes-please-note!) and the source of the "Attribute Required for Text flag not working" issue. As such, the help text should be modified to give the correct usage.
P.S. It would "help" to have the "Details" button renamed to "Help" ...