Thank you, DrByte, for post # 4. Somehow, I missed it until now, apparently since I posted twice shortly after you did. However, you were exactly correct (as usual). I also set WinMerge to show only differences, which made it easier to read.
On my previous attempt, it appeared Fizezilla didn’t copy all the files. (I did the copy and then overlay on the server, instead of on my PC, and I suspect it timed out or something.) My WinMerge problem was I hadn’t set the option to ignore carriage return differences. However, it was also reporting files different that when I clicked to view, it said it was identical. Strange.
I started over. I created a SQL 5.0 database, and restored it from 1.3.8a’s 4.0 database (my working store). I set-up a demo site of 1.3.8a with the new 5.0 database, and it worked fine. I switched it to the regular store and it is running fine today, although I have to upgrade promptly to 1.5.1 because our host is switching to PHP 5.4.
I then copied the 1.3.8a store to another demo folder on my PC, overlayed it with a fresh 1.5.1, copied the config files into the fresh copy (changing the database and store “demo” name), created another 5.0 database, restored that database from a backup of 1.3.8a’s 5.0 database, and uploaded it into a demo on my server. I downloaded that demo and ran Winmerge against my PC demo file, and they were identical.
I ran zc_install, specified “database upgrade,” and received the following errors:
SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.
I don’t know if the messages above are important, but the admin_activity_log from the SQL dump is:
Before upgrade:
CREATE TABLE admin_activity_log (
log_id int(15) NOT NULL auto_increment,
access_date datetime NOT NULL default '0001-01-01 00:00:00',
admin_id int(11) NOT NULL default '0',
page_accessed varchar(80) NOT NULL default '',
page_parameters text,
ip_address varchar(15) NOT NULL default '',
PRIMARY KEY (log_id),
KEY idx_page_accessed_zen (page_accessed),
KEY idx_access_date_zen (access_date),
KEY idx_ip_zen (ip_address)
) ENGINE=MyISAM AUTO_INCREMENT=6827 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6827 ;
After upgrade:
CREATE TABLE admin_activity_log (
log_id bigint(15) NOT NULL auto_increment,
access_date datetime NOT NULL default '0001-01-01 00:00:00',
admin_id int(11) NOT NULL default '0',
page_accessed varchar(80) NOT NULL default '',
page_parameters text,
ip_address varchar(45) NOT NULL default '',
flagged tinyint(4) NOT NULL default '0',
attention varchar(255) NOT NULL default '',
gzpost mediumblob,
PRIMARY KEY (log_id),
KEY idx_page_accessed_zen (page_accessed),
KEY idx_access_date_zen (access_date),
KEY idx_ip_zen (ip_address),
KEY idx_flagged_zen (flagged)
) ENGINE=MyISAM AUTO_INCREMENT=6841 DEFAULT CHARSET=latin1 AUTO_INCREMENT=6841 ;
I completed the upgrade, received the message about renaming the admin and zc_install, and did so. The demo store looks fine. This time, I received the new sign-in page and it forced me to change my password. However, I have no store options (Configuration, Catalog, Modules, Customers, etc.). I went to “account” via the upper right bar, but it showed only one account (there were 4; it recognizes another sign-in name I tried, so I think it’s a security matter). There’s nothing about “superuser.” It says “(You are presently using: v1.5.1)” under “check for updates,” but when I click on “version” it says “Sorry, your security clearance does not allow you to access this resource.”
Running Winmerge, the 1.5.1 store has a cache file that is different than the 1.3.8 store (I changed the db and password fields to “x” for this post):
installerConfigKeys|a:10:{s:8:"language";s:7:"english";s:16:"DIR_FS_SQL_CACHE";s:62:"/homepages/5/d232125156/htdocs/ohsopersonal.com/store151/cache";s:10:"is_upgrade";s:1:"1";s:7:"DB_TYPE";s:5:"mysql";s:10:"DB_CHARSET";s:4:"utf8";s:9:"DB_PREFIX";s:0:"";s:9:"DB_SERVER";s:26:"localhost:/tmp/mysql5.sock";s:18:"DB_SERVER_USERNAME";s:12:"dboxxx";s:18:"DB_SERVER_PASSWORD";s:24:"xxx";s:11:"DB_DATABASE";s:11:"dbxxxx";}logfilename|s:27:"Jan-20-2013_09-14-01-etfmCq";
Also missing from the 1.5.1 store: curltest.php, authorizenet.
The old store was running on PHP 5.217, Zen version 1.3.8a, DB patch 1.3.8, MYSQL 5.0. I can’t view the new settings, as per above. My server is with 1and1. (1and1 users: The restore on their MYSQLADMIN doesn’t work. Manually drop the table if it has data, and then use “SQL” option to import instead of following 1and1's published instructions.)
Existing in database (from backup) after upgrade (this is what I’m missing, so I know it's the database):
INSERT INTO admin_menus (menu_key, language_key, sort_order) VALUES ('configuration', 'BOX_HEADING_CONFIGURATION', 1),
('catalog', 'BOX_HEADING_CATALOG', 2),
('modules', 'BOX_HEADING_MODULES', 3),
('customers', 'BOX_HEADING_CUSTOMERS', 4),
('taxes', 'BOX_HEADING_LOCATION_AND_TAXES', 5),
('localization', 'BOX_HEADING_LOCALIZATION', 6),
('reports', 'BOX_HEADING_REPORTS', 7),
('tools', 'BOX_HEADING_TOOLS', 8),
('gv', 'BOX_HEADING_GV_ADMIN', 9),
('access', 'BOX_HEADING_ADMIN_ACCESS', 10),
('extras', 'BOX_HEADING_EXTRAS', 11);
Suggestions greatly appreciated.
