admin area not functional

[koning]

I placed a support request two weeks ago (ticket 1985) but have yet to
have anyone address this problem so I post here.

The admin area DHTML does not function for me. In IE6 I get a page
full of

;font-size:<;font-size:/;font-size:f;font-size:o;font-size:n;font-size:t;

and no menu bar. Funny part is the admin area mostly works with Firefox.

I had some others in the office try it with the same results or in some
cases the page just hangs untill the script times out.

I originally installed sc 155 and since did the upgrade to 1.6 with the
same results. I have posted screen dumps of both browsers render
at http://contractorslibrary.net/sc155_admin_problem.jpg

Anyone else run into this?

[pbxcom]

I don't know if they are working on a reply to your situation but I thought I would point out a few problems I noticed.

I was able to track down your web host and noticed their servers are way out of date on their intalled applications. They are using MYSQL version 3.23 and version 4.0 is now standard on most servers. Also they have a major security problem with there PHP version they are useing PHP version 4.3.9, and ever server I can find is now useing version 4.3.10.

From the php.net web site

[15-Dec-2004] The PHP Development Team would like to announce the immediate release of PHP 4.3.10 and PHP 5.0.3. These are maintenance releases that in addition to non-critical bug fixes address several very serious security issues. All Users of PHP are strongly encouraged to upgrade to one of these releases as soon as possible..

Also check the SquirrelCart requirements at http://www.squirrelcart.com/requirements.php

Your host doesn't appear to support CURL or openSSL or myCrypt. Now support for these isn't need to operate SquirrelCart but will help with several features.

The out of date mysql and php version may be your problem. Also that menu at the top and other functions are ran by javascript make sure that you have javascript enabled in internet explorer or you will also have problems.

[Jamie]

Hi Guys,

pbxcom is right in that it is definitely good to be up to date version wise. We do work OK with MySQL 3.23 and don't use any MySQL features specific to newer versions.

This problem looks like it is probably due to the menu code. I've never seen this before, so it looks like it may be a problem with the way the files were loaded. The code for the menu hasn't changed since 1.5.0.

Sorry for the delay in your ticket...I'm checking it out now. It looks like we were waiting for something to change on your end on 4/1, and missed your response. As soon as I figure this out, I'll update your ticket. If the fix is not specific to your setup, I'll post it here for others.

[Jamie]

OK...here is the problem. The iemenu.js file in 'squirrelcart/menu' controls the menu for the top of the admin page for Internet Explorer. That file need to be uploaded in binary format, and it looks like it was uploaded in ASCII. I uploaded it in binary and it fixed this.

Most FTP clients have an auto mode, which will determine the best way to upload a file (ASCII or Binary). This problem is either a result of the mode being set to ASCII instead of auto, OR a failure by your FTP client to recognize the file as binary.

If you think you may have uploaded everything in ASCII mode, you should reupload all the squirrelcart files in auto mode. Judging by the fact that nothing else seems to be wrong in your cart, I'm guessing maybe your FTP client was set to auto, and didn't detect this file as being binary.

[koning]

Actually we have been using MySQL 4.x since last year. I always leave
the native php mysql support so yeah you will see the 3.x drivers. The
server has mod_php 4.3.9, any sites actually using php get a fresh cgi
version (with curl, mcrypt, gd2, etc).

Thank you jamie, the admin works now. Please note that I uploaded
the distribution zip file (in binary mode) and unzipped it on the server.
I do have a habit of doing an unzip -a which must have caused the
problem.

Now to try the db upgrade from 1.0.8, oh joy.

[Jamie]

That would explain it!

The key to DB updates...first, obviously is to backup your DB. Then, as you apply the DB updates, if you happen to get an error, copy it and let us know what it is. Then, revert to your backup. If you happen to get an error when importing those SQL files, that first error will usually tell us exactly what is going on.

I guess that was more than one "key". :)