Firstly, DON'T attempt to delete any database tables or records. THERE IS RARELY EVER A REASON that this needs to be done (even after a failed modules installation/removal). Additional/unused DB tables or records are not likely to cause any problems.
Secondly, replacing the store files will only help if the store files have been modified or changed in any way. If the module requires *additional* files to be installed (as most do) these won't be affected by replacing the original store files, unless you delete *all* the files and start afresh.
At this stage I wouldn't even contemplate such an action.
OK, so now I've told you what NOT to do, it is time to actually DIAGNOSE the problem and THEN take action to fix it. This is actually going to be quite easy
Firstly, the 'problem' as indicated is: "1064 You have an error in your SQL syntax"
The SYNTAX error(s) being related to undefined CONSTANTS, namely,
MAX_DISPLAY_UPCOMING_PRODUCTS,
MAX_DISPLAY_RESULTS_CATEGORIES
CONSTANTS can/will originate from one of two places, the SQL Database (which is why deleting tables/records is a bad idea), or, the language/php files.
The fact that you/we are seeing the CONSTANT NAMES rather than the CONSTANT values is telling us that the actual data is missing from the database or the files. This would suggest that either the data wasn't correctly uploaded in the first place, or has since been removed (as a result of reverting back to older files).
Solution. Ensure that these constants get defined, OR remove any code that uses these constants.
If you review the files that came with the module that you tried to install you should be able to identify whether these defines are DB based or File based (perform a word seach/find) . If file based just copy the relevent file over to your store (and assume it wasn't copied the first time for some reason). If DB based then run the SQL setup script that came with the module again (ensure you set/use the correct table prefix).
To remove the module you'll need to delete any FILES that it added to your store (and revert any that were modified). As previously mentioned, you will NOT need to remove any database records that may have been added.
In my experience it us usually easier to 'finish' a failed module installation that it is to try to remove them.
Cheers
Rod
ps. A *possible* "dirty fix" would be to add the following to your english.php file:
MAX_DISPLAY_UPCOMING_PRODUCTS = 10
MAX_DISPLAY_RESULTS_CATEGORIES = 10
Bookmarks