trouble with paradise--admin/market dame link

[heavensportal]

well, after 1 hour it went no further than and the DB doesn't show 1.5.1 as being done either. If I have to I will just do the installs all from the beginning (updates that is)



this is also the latest log:

---------------
Aug 13 2024 3:03 -- systemChecker::findCurrentDbVersion
1.5.0

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE admin_activity_log CHANGE COLUMN ip_address ip_address varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE whos_online CHANGE COLUMN ip_address ip_address varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE admin MODIFY COLUMN pwd_last_change_date datetime NOT NULL default '0001-01-01 00:00:00', MODIFY COLUMN last_modified datetime NOT NULL default '0001-01-01 00:00:00', MODIFY COLUMN last_login_date datetime NOT NULL default '0001-01-01 00:00:00', MODIFY COLUMN last_failed_attempt datetime NOT NULL default '0001-01-01 00:00:00';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE admin CHANGE COLUMN last_login_ip last_login_ip varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE admin CHANGE COLUMN last_failed_ip last_failed_ip varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE coupon_redeem_track CHANGE COLUMN redeem_ip redeem_ip varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

---------------
Aug 13 2024 3:03 -- upgradeException
ALTER TABLE coupon_gv_queue CHANGE COLUMN ipaddr ipaddr varchar(45) NOT NULL default '';  Cannot CHANGE column COLUMN because it does not exist.  /home/xxx/public_html/store/zc_install/sql/updates/mysql_upgrade_zencart_151.sql

[Shop Suey]

You could set another value for PHP max_execution_time

[heavensportal]

You could set another value for PHP max_execution_time

I know I saw that somewhere, had to step away due to storms and those thunder booms hurt my head...LOL Will give that Ia try.

[heavensportal]

alright, I have been at this all day, it is now 8:30 pm, I finally installed 1.5.8c and it finally took. Then I uploaded the 2.0.1 files and the DB updated....the links for admin are still not right and direct me to the store page.

I also see in the DB that the version is 2.0 not 2.0.1

All else seems to be fine except doing it this way I have no previous information...it would not work at all doing it like I was told to do. The config file for admin doesn't seem to update with the correct info, I added this to the file hoping that it would see it:

/**
 * NOTE about DIR_FS_ADMIN
 * The value for DIR_FS_ADMIN is now auto-detected.
 * In the very rare case where there is a need to override the autodetection, simply add your own definition for it below.
 */
  define('DIR_FS_ADMIN', '/home/fxxx/public_html/market/admin/');

I even tried adding it like this

/**
 * NOTE about DIR_FS_ADMIN
 * The value for DIR_FS_ADMIN is now auto-detected.
 * In the very rare case where there is a need to override the autodetection, simply add your own definition for it below.
 */
  define('DIR_FS_ADMIN', '/home/fxxx/public_html/market/admin/index.php');

I will wait until tomorrow to try removing all files and installing 2.0.1>drop the info from the DB tables and reinstalling the 1.3.9h files and see if that makes a difference


I will try to come in here first to see if anyone has anymore ideas.

[lat9]

Current versions of Zen Cart no longer use the DIR_FS_ADMIN value, so that's not going to have a 'play' in the issue. I've got no additional ideas about the issues you're experiencing, but am still cogitating.

[heavensportal]

Current versions of Zen Cart no longer use the DIR_FS_ADMIN value, so that's not going to have a 'play' in the issue. I've got no additional ideas about the issues you're experiencing, but am still cogitating.

I have the bone and still chewing on it...I will leave the store alone for a while and install the ones I used for our free stuff and the sponsors area which are not with uploads, just what the contest winners can choose from for their prizes. No info stored, no need to log in, just a showcase with items showing the products offered.


So that should behave. I need to step away from the actual store install since it has been raining and with the amount of thunder/lightning we had it kept popping my electric off/on so comp got undone several times. so for sure nothing is right today. I need to try it again.


I also see wwhat you mean about the upgrades, when the store finally installed with 1.5.8c then I tried 2.0.1 it just flew thru the updates faster than superman.

[dbltoe]

You will not see a database level change unless the second place in the version changes. If you strarted with 2.0 and upgraded to 2.0.1, then 2.0.2 (does not exist), you would still show 2.0 as the database version. When you uprgrade to the upcoming 2.1, the database will need to be updated and will show 2.1.0 afterwards.

WAG If both your configure files are correct, you may have a funky redirect in your .htaccess files. Look in them to see if the term 301 is in either of them.

[heavensportal]

You will not see a database level change unless the second place in the version changes. If you strarted with 2.0 and upgraded to 2.0.1, then 2.0.2 (does not exist), you would still show 2.0 as the database version. When you uprgrade to the upcoming 2.1, the database will need to be updated and will show 2.1.0 afterwards.

WAG If both your configure files are correct, you may have a funky redirect in your .htaccess files. Look in them to see if the term 301 is in either of them.

When I started this mess of mine, I had one .htaccess file in the main directory, and in the market folder but I don't seem to have the second one anymore

[heavensportal]

Well still alive barely. since the store was ancient and heavily modded it put up a fight but I still sorta won. I ended up installing the 1.5 files with my existing DB, then exchanging all files needed to remove so 1.5.7c could be installed and then rinse/repeat once more to get the 2.0.1 upgrade done. I now have a working store even if the DB is empty.

No matter what I did it would hang on the 2.0.1 upgrade and not finish. Now I will insert the info from the old db to the corresponding table and hope it works as it should.

Thanks everyone for your help.

[heavensportal]

I noticed that when in admin, there is now an image of the product in the description...how do you set the image size, rather where is the place to set the size, right now it is the same size as the product page image.


Never mind I accidently found it... the shopping cart image *shakes head back and forth*