Quote Originally Posted by MyCoolHats View Post
I did try this new sql first with the first line and received the duplicate error. Then I did it without the first line and received this error:
Code:
[17-Jun-2014 15:49:54] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE @UserTrackgID <> 0' at line 1 :: INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('UserTrackingConfig', 'BOX_TOOLS_USER_TRACKING_CONFIG', 'FILENAME_CONFIGURATION', CONCAT('gID=', @UserTrackgID), 'configuration', 'Y', 10001) WHERE @UserTrackgID <> 0; in /home1/mycoolha/public_html/catalog/includes/classes/db/mysql/query_factory.php on line 120
Was I not suppose to try this sql?? I am so sorry to bother you with all of this. I love your work and I know you are working very hard on this. Please know that I greatly appreciate all you are doing.
Okay, so I posted that solution without doing a little more review. My concern is in a delete situation that if the @UserTrackgID is zero then the wrong information will be deleted. In an insert situation such as that line, if you only omitted the first line (the install) then the value should be non-zero, but the check is there so that the configuration option doesn't get buried. So, to that end, and without my other resources immediately available, can try where @UserTrackgID != 0 or instead of just 0 try '0' for the two cases of <> '0' and != '0'.

See if that helps/works. In use though, really the insertion of the admin pages appears to not be necessary as they are currently installed per the duplicate errors reported. Can fix the user tracking configuration error in a bit after verifying that the remaining SQL works. :)