I'm trying to install Apsona ShopAdmin and am getting a particular error, so I contacted their support and they referred me to this thread. After doing some reading on it, it seems the error in trying to install the this mod is based on some incorrect SQL syntax from this mod, Admin profiles.
I'm trying to do all this on my install of 139H. The install error that I get when trying to install ShopAdmin is as follows:
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 'apsona_index');'' at line 1
in:
[SELECT id FROM admin_files WHERE page = '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index');']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
It seems to stem from this line in apsona_app_tools_dhtml.php:
$za_contents[] = array('text' => "Apsona ShopAdmin", 'link' => '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index.php');');
Does anyone have a fix for this, to make ShopAdmin work with Admin Profiles? I'm using the Admin profiles for 139h.