Image Manager addon

[dutchy]

Hi,

I just started to play and install IM1.5. Great updates btw but I seem to have run into a little problem.

On a test site with IM1.4 installed, when i run the SQL via ADMIN>TOOLS>SQL Query Executor the following is returned.
************
403 error
Forbidden

You don't have permission to access /test/admin1/sqlpatch.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
************

I get the above regardless of what SQL query run.

I tested this with a clean install of Zen Cart. Before I install Image Manager I can use the built in SQL Query Executor to run any SQL statement OK. But once I have installed Image Manager, the SQL Query Executor stops working and returns the above 403 error.

This is not a massive problem though, as I can still run SQL scripts from phpMyAdmin or by using the Zen Cart 'upload file' facility. It is just the method of copy and pasting the SQL which fails.

Please advise
Thanks


p.s. you should have your donation by Wednesday. I think this is because we are in different countries as this happened last time I donated to someone outside the UK.

[boudewijn]

Hi,

Were you able to run the Image Manager SQL-patch? Or did it happen before that and after installation of the files?

Boudewijn

[dutchy]

Hi, i was unable to run the SQL patch for upgrading 1.4 to 1.5 via copy and pasting. But i was able to run the 1.4 to 1.5 upgrade patch by using the 'upload file' feature.

Thinking it might be caused by a number of problems i started to test. I created a clean install of zen cart with no other add-ons installed. I ran a few SQL patches via copy and pasting and there were no problem. I then installed IM1.4 and ran the SQL for the install.sql via copy and paste and it worked with no problems. I then tried to run the 1.4 to 1.5 upgrade patch and the same 403 error when copy and pasting.

I then created another clean ZC test site, ran a few SQL patches via copy and paste with no problems. Installed IM.15 and ran install SQL via copy and paste with no problems. I then ran another (general) SQL patch via copy and paste and it failed.

From what I can gather, (for me) once IM is istalled, I am unable to run any SQL patches via copy and pasting.

It' over my head as to why? Cheers for looking into this.

[boudewijn]

Can you try to run the uninstall script, or remove the IM-configs with phpadmin? And then see what happens?

[dutchy]

Hi, nope.. tried again with 3 clean zencart sites.

Runing
DELETE FROM admin WHERE admin_name = 'Admin';# MySQL returned an empty result set (i.e. zero rows).
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);# 1 row(s) affected.
as a test.

This works Ok before I install Image Manager. But once i install Image Manager i cannot run any SQL statements. A 403 permission error is justs returned. With exception of the IM uninstall SQL. That works fine. However once I have ran the uninstall SQL I am unable to run any SQL fron ZC admin at all. Even via file upload.

Then the only way i can get SQL patches to work is via phpMyAdmin

???

[boudewijn]

I still have no idea about why a 403 occurs. Maybe it's just simple. Did you check the access rights to the script, mentioned in the message? The message is sent from the webserver, being unable to access the file.

[boudewijn]

I did find an issue in the install script of IM, but I doubt very much if that can cause the trouble you have. It's about using escaped single quotes in configuration item titles.
Nevertheless, I would like you to use the new script and try where it gets you. Can you send me your emailaddress, so I can send you the script? My emailaddress is in the image_manager.txt file, in the header.