Has anyone else had any problems running Apsona ShopAdmin and Admin Profiles with V1.3.9h? I have no problems with V1.3.8a.
On a stock install with only Admin Profiles and Apsona installed I get the following 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 'apsona_index');'' at line 1
in:
[SELECT id FROM zen_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.
I started my post in the Apsona thread ( http://www.zen-cart.com/forum/showpo...&postcount=155 ) but they have confirmed this is probably an Admin Profiles issue so thought I transfer the thread here. This was the reply from Apsona:
I'm not sure I fully understand the way admin profiles works, but the SQL is definitely incorrect. The admin profiles add-on should be checking for the page named apsona_index.php, but instead it is page named this:
Code:
#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup('apsona_index');
To me this seems like an error in the way the admin profiles add-on was configured. I am aware of some other folks on this forum that have used admin profiles in conjunction with ShopAdmin, so I hope one of them can help.
The file that causes this issue is /includes/boxes/extra_boxes/apsona_app_tools_dhtml.php
PHP Code:
<script type="text/javascript">
var apsonaWindow = null;
function apsona_showPopup (url) {
var win = window.open (url, "apsona");
if (!win) {
alert ("Your browser seems to be blocking popup windows.\nPlease change its settings to enable popups.");
return null;
}
apsonaWindow = win;
try { win.focus(); } catch (e) { /* Sometimes IE throws a security exception here, so I'm forced to ignore it. */ }
return win;
}
</script>
<?php
$za_contents[] = array('text' => "Apsona ShopAdmin", 'link' => '#" title="Apsona ShopAdmin - opens in new window" onclick="apsona_showPopup(\'apsona_index.php\');');
?>
If I delete it all functionality returns except I obviously don't have the Apson Menu under Tools. I can however access Apson by manually browsing to www.mydomain.com/admin/apsona_index.php
Hopefully someone can help me.
Bookmarks