Admin Profiles (for v1.3.x only!) Support Thread

[kuroi]

I am having problems installing admin_profiles.

In admin-tools-install sql patch : First I browse to the correct file and upload it. then I attempt to run it.

What I get is :

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 'install_admin_profiles.sql' at line 1
in:
[install_admin_profiles.sql;]
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.

This is the first time I have used asql patch. So, this may be a obvious error on my part.

I am using Zen Cart 1.3.8a and it is admin profiles 1.0.7.

Any advice would be hugely appreciated!

Thanks

Nick

It's a big of a guess, but historically we used a funny back apostrophe thingy around fields because some MySQL installations seemed unhappy if we didn't. More recenly I've been hearing of versions that don't like it.

So I'd recommend making a copy of the installation SQL and doing a global find and replace to remove them all, and then try running that file. And please let us know how you get on.

[kuroi]

@alhakeem2001

stickman's diagnosis is the same as I would have made if I'd got here earlier. Did that resolve the problem for you?

[niccol]

It's a big of a guess, but historically we used a funny back apostrophe thingy around fields because some MySQL installations seemed unhappy if we didn't. More recenly I've been hearing of versions that don't like it.

So I'd recommend making a copy of the installation SQL and doing a global find and replace to remove them all, and then try running that file. And please let us know how you get on.

Thanks for your answer.

Actually, what I did was re-download everything and start again. Much the same technique as whacking the TV or kicking your car. But like those techniques it seemed to work. Also, I got right level of swearing which is always important.

Sorry, not to be much help as I don't know why it did not play the game to begin with. But thanks for admin_profiles it does just what I need it to do and now works beautifully.

Nick

[kuroi]

@niccol

Glad you got it working and that it's of benefit.