Further investigation reveals that perhaps the post you quoted from swguy is incorrect.
Running the following code (even without the #NEXT_X_ROWS... instruction) works just fine, thus suggesting that there's nothing wrong with the SQL:
Code:
SET SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Images';
UPDATE configuration set configuration_value=@t4 where configuration_key = 'STORE_NAME';
UPDATE configuration set configuration_value=@t4 where configuration_key = 'STORE_OWNER';
(this will set Admin->Configuration->My Store-> store name and store owner to '4'. Naturally you'll want to fix those to their correct values if you run this test.)
So, I must ask: have you actually tested the examples and found a specific problem? Or are you merely pointing out a discrepancy between swguy's suggestion vs the help text provided within Zen Cart?
Bookmarks