Forums / Basic Configuration / trouble with paradise--admin/market dame link

trouble with paradise--admin/market dame link

Views: 8,082

Results 21 to 40 of 62
9 Aug 2024, 1:01 AM
#21
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

trouble with paradise--admin/market dame link

heavensportal:

I forgot to mention to you lat9, I do not have any mods installed this is a totally new files with only what comes with 2.0.1 .
I don't even have any old files nor anything in the download folder but will try removing the database, reinstalling the old 1.3.9h one then re-running zc_install. But that needs to wait for the day to start freshening up.

I uploaded the install folder, removed the tables from my 2.0.1 DB, uploaded 1.3.9h database. got the upgrade won't go further than the page listing the updates it needs after the first and won't go further
Attachment 20725

9 Aug 2024, 1:13 AM
#22
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

alright, I tried admin, which is still not linking right. I am perplexed, oh this is after the not going past the first upgrade listed should I just install all the different upgrades between 1.3.9h and 2.0.1 cause I asked to upgrade and it emptied the tables and left things blank with no customers and stuff

9 Aug 2024, 11:34 AM
#23
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: trouble with paradise--admin/market dame link

There's something going on with your database, as I recently upgraded a site from 1.3.9h directly to 2.0.1 without issue.

You could post the zcInstall*.log files that are present in the site's /logs directory from that last attempt. Be sure to post those files' contents within "CODE" tags, using the big **# **present in the menu-bar as you're writing your response.

9 Aug 2024, 5:12 PM
#24
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

gothstone:

For your database, you delete the database you just created, import the old database, reupload the ZC_install folder, rerun the zc_install so it can update your old database, and delete the zc_install directory again.

did as instructed but the darn thing will only do a clean install. I am wondering IF I will need to install all or at least the first and last 1.5+ then run 2.0.1

I've tried this several times and each time it clears out the customer info and everything leaving me with no settings in admin...and still will not add the admin/index.php to the admin ink

9 Aug 2024, 5:24 PM
#25
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: trouble with paradise--admin/market dame link

heavensportal:

did as instructed but the darn thing will only do a clean install. I am wondering IF I will need to install all or at least the first and last 1.5+ then run 2.0.1

I've tried this several times and each time it clears out the customer info and everything leaving me with no settings in admin...and still will not add the admin/index.php to the admin ink
It kind of feels like one (or both) of the configure.php files aren't pointing to the right places, either file-system or web-address.

9 Aug 2024, 8:44 PM
#26
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

lat9:

It kind of feels like one (or both) of the configure.php files aren't pointing to the right places, either file-system or web-address.

ok, then I will remove the configure files from store and admin in the includes folders. Then I will totally remove the database again.

This is what the configure in admin and the one from store includes says:

admin:

<?php /** * @copyright Copyright 2003-2022 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * File Built by Zen Cart Installer on Fri Aug 09 2024 17:03:10 */ /*************** NOTE: This file is VERY similar to, but DIFFERENT from the "store" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ /** * Enter the domain for your Admin URL. If you have SSL, enter the correct https address in the HTTP_SERVER setting, instead of just an http address. */ define('HTTP_SERVER', 'https://fantasiesrealm.com'); /** * Note about HTTPS_SERVER: * There is no longer an HTTPS_SERVER setting for the Admin. Instead, put your SSL URL in the HTTP_SERVER setting above. */ /** * Note about DIR_WS_ADMIN * The DIR_WS_ADMIN value is now auto-detected. * In the rare case where it cannot be detected properly, you can add your own DIR_WS_ADMIN definition below. */ /** * Enter the domain for your storefront URL. * Enter a separate SSL URL in HTTPS_CATALOG_SERVER if your store supports SSL. */ define('HTTP_CATALOG_SERVER', 'https://fantasiesrealm.com'); define('HTTPS_CATALOG_SERVER', 'https://fantasiesrealm.com'); /** * Do you use SSL for your customers login/checkout on the storefront? If so, enter 'true'. Else 'false'. */ define('ENABLE_SSL_CATALOG', 'true'); /** * These DIR_WS_xxxx values refer to the name of any subdirectory in which your store is located. * These values get added to the HTTP_CATALOG_SERVER and HTTPS_CATALOG_SERVER values to form the complete URLs to your storefront. * They should always start and end with a slash ... ie: '/' or '/foldername/' */ define('DIR_WS_CATALOG', '/market/'); define('DIR_WS_HTTPS_CATALOG', '/market/'); /** * This is the complete physical path to your store's files. eg: /var/www/vhost/accountname/public_html/store/ * Should have a closing / on it. */ define('DIR_FS_CATALOG', '/home/xxx/public_html/market/'); /** * 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. */ /** * The following settings define your database connection. * These must be the SAME as you're using in your non-admin copy of configure.php */ define('DB_TYPE', 'mysql'); // always 'mysql' define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty define('DB_CHARSET', 'utf8mb4'); // 'utf8mb4' or older 'utf8' / 'latin1' are most common define('DB_SERVER', 'localhost'); // address of your db server define('DB_SERVER_USERNAME', 'xxx'); define('DB_SERVER_PASSWORD', 'xx'); define('DB_DATABASE', 'fxxx'); /** * This is an advanced setting to determine whether you want to cache SQL queries. * Options are 'none' (which is the default) and 'file' and 'database'. */ define('SQL_CACHE_METHOD', 'none'); /** * Reserved for future use */ define('SESSION_STORAGE', 'reserved for future use'); /** * Advanced use only: * The following are OPTIONAL, and should NOT be set unless you intend to change their normal use. Most sites will leave these untouched. * To use them, uncomment AND add a proper defined value to them. */ // define('DIR_FS_SQL_CACHE' ... // define('DIR_FS_DOWNLOAD' ... // define('DIR_FS_LOGS' ... // End Of File main includes: <?php /** * @copyright Copyright 2003-2022 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 * File Built by Zen Cart Installer on Fri Aug 09 2024 17:03:10 */ /*************** NOTE: This file is VERY similar to, but DIFFERENT from the "admin" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ /** * Enter the domain for your store * If you have SSL, enter the correct https address in BOTH the HTTP_SERVER and HTTPS_SERVER settings, instead of just an http address. */ define('HTTP_SERVER', 'https://fantasiesrealm.com'); define('HTTPS_SERVER', 'https://fantasiesrealm.com'); /** * If you have https enabled on your website, set this to 'true' */ define('ENABLE_SSL', 'true'); /** * These DIR_WS_xxxx values refer to the name of any subdirectory in which your store is located. * These values get added to the HTTP_CATALOG_SERVER and HTTPS_CATALOG_SERVER values to form the complete URLs to your storefront. * They should always start and end with a slash ... ie: '/' or '/foldername/' */ define('DIR_WS_CATALOG', '/market/'); define('DIR_WS_HTTPS_CATALOG', '/market/'); /** * This is the complete physical path to your store's files. eg: /var/www/vhost/accountname/public_html/store/ * Should have a closing / on it. */ define('DIR_FS_CATALOG', '/home/xxx/public_html/market/'); /** * The following settings define your database connection. * These must be the SAME as you're using in your admin copy of configure.php */ define('DB_TYPE', 'mysql'); // always 'mysql' define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty define('DB_CHARSET', 'utf8mb4'); // 'utf8mb4' or older 'utf8' / 'latin1' are most common define('DB_SERVER', 'localhost'); // address of your db server define('DB_SERVER_USERNAME', 'fxxx'); define('DB_SERVER_PASSWORD', 'xxxx'); define('DB_DATABASE', 'fxxx'); /** * This is an advanced setting to determine whether you want to cache SQL queries. * Options are 'none' (which is the default) and 'file' and 'database'. */ define('SQL_CACHE_METHOD', 'none'); /** * Reserved for future use */ define('SESSION_STORAGE', 'reserved for future use'); /** * Advanced use only: * The following are OPTIONAL, and should NOT be set unless you intend to change their normal use. Most sites will leave these untouched. * To use them, uncomment AND add a proper defined value to them. */ // define('DIR_FS_SQL_CACHE' ... // define('DIR_FS_DOWNLOAD' ... // define('DIR_FS_LOGS' ... // End Of File
10 Aug 2024, 2:14 PM
#27
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: trouble with paradise--admin/market dame link

If you totally remove those configure.php files, the only choice zc_install will give you is a new install.

From the portions you posted above, the site being installed is https://fantasiesrealm(dot)com/market. I'll suggest

  1. Put those configure.php files back in their respective directories.
  2. Restore the site's database to its existing content
  3. Verify that both the storefront and admin configure.php files "point to" that database.
  4. Run https://fantasiesrealm(dot)com/market/zc_install

If you still get only the "Fresh install" option, look further down in the messages displayed by zc_install. If both configure.php files exist but have some type of invalid information, the reason for the no-upgrade path will be contained in those messages.

12 Aug 2024, 11:22 PM
#28
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

really dumb question here...I tried to do the upgrade, yes I got the upgrade or clean stall buttons. It told me that I had to have and upgrade to 1.5.0 to continue and it selected all the upgrades needed.

It says it installed but it says the update for 1.5.01 was done but about 15 minutes later it claims to have finished, does the progress bar not move right along and it is still upgrading or is it dead?

WELLL, Ima gonna try again, starting with the database. When I did it all these times I removed the tables, then uploaded the old one from 1.3.9h. Maybe I was supposed to just empty them.

13 Aug 2024, 1:53 AM
#29
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: trouble with paradise--admin/market dame link

Depending on the size of the database, especially the number of product, orders and customer entries, the progress bar can be very deceiving.

There were a couple of times I almost gave up and then the zc_install continued on to completion.

13 Aug 2024, 2:05 AM
#30
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

lat9:

Depending on the size of the database, especially the number of product, orders and customer entries, the progress bar can be very deceiving.

There were a couple of times I almost gave up and then the zc_install continued on to completion.

Whew, then I need to go back and do it again. This time I will be more patient. I figured maybe I had not quite followed the instructions right. It is a fairly large DB since it has been operating for 17 yrs. Thanks for your patience.

13 Aug 2024, 3:55 AM
#31
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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
13 Aug 2024, 7:48 AM
#32
shop_suey avatar

shop_suey

Zen Follower

Join Date:
Feb 2014
Location:
Germany
Posts:
375
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

You could set another value for PHP max_execution_time

roller-aus-blech.de
Selling on eBay? Use the fee calculator: https://webconcept.one/en/ebay-fee-calculator/

13 Aug 2024, 4:02 PM
#33
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

Shop Suey:

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.

15 Aug 2024, 1:44 AM
#34
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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.

15 Aug 2024, 2:02 PM
#35
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: trouble with paradise--admin/market dame link

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.

15 Aug 2024, 4:53 PM
#36
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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.

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.

16 Aug 2024, 1:37 AM
#37
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,845
Plugin Contributions:
17

Re: trouble with paradise--admin/market dame link

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.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

16 Aug 2024, 8:04 PM
#38
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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.

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

27 Aug 2024, 7:16 PM
#39
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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.

28 Aug 2024, 11:43 PM
#40
heavensportal avatar

heavensportal

New Zenner

Join Date:
Jun 2021
Posts:
95
Plugin Contributions:
0

Re: trouble with paradise--admin/market dame link

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