If this is your first visit, check our documentation. To post, register or login.
Forums / Bug Reports / Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

Locked

Started by boozubay on 5 Oct 2006, 7:37 PM · Views: 2,319

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
5 Oct 2006, 7:37 PM
#1
boozubay avatar

boozubay

New Zenner

Join Date:
Oct 2006
Posts:
6
Plugin Contributions:
0

Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

I think our server has upgraded our PHP and we cannot edit/delete/add any products or categories any more. The front end of the cart works just fine. This is only an admin issue.

we get the error-
Fatal error: Call to a member function on a non-object in /home/boneezc/public_html/dog-treats/admin/categories.php on line 1132

This is line 1131>

<?php $products->MoveNext(); } $cPath_back = ''; if (sizeof($cPath_array) > 0) { for ($i=0, $n=sizeof($cPath_array)-1; $i<$n; $i++) { if (empty($cPath_back)) { $cPath_back .= $cPath_array[$i]; } else { $cPath_back .= '_' . $cPath_array[$i]; } } } $cPath_back = (zen_not_null($cPath_back)) ? 'cPath=' . $cPath_back . '&' : ''; ?>

We tried to do an upgrade and it would keep telling us tables are missing when we followed the directions so we had to stop since it would not let us preceed

This is release 1.0.4

I know this is an old version but it was working great until now and we are sure one of you experts that have evolved through the version may know what is causing this...

Thanks

5 Oct 2006, 8:01 PM
#2
jetx avatar

jetx

Zen Follower

Join Date:
Apr 2006
Posts:
425
Plugin Contributions:
0

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

Can you use phpAdmin? Backup your database, save it elsewhere and upgrade.

5 Oct 2006, 8:07 PM
#3
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

A missing table issue sounds like you did not complete the upgrade using the Zen Cart installer (/zc_install folder). If you are upgrading, you need to at least run the installer and choose "Upgrade Database" to bring the DB up to the latest version (the code knows what version you have and what changes need to be made)

Before I go any further, I strongly recommend that you consider trying to upgrade again as soon as possible. Differences between versions of Zen Cart are one thing; you're at the point where PHP itself may be outpacing you.

Now then, the error you are seeing is because $products->MoveNext(); is not defined, which means there's a problem somewhere along the path of this DB search. This issue is compounded by the fact that you are running a very old version.

Since I don't have a copy of 1.0.4, and I don't know what the whole file looks like, can you tell us is you have a line that begins like the following:

  $products = ...

Also include your MySQL version. We want to see where/how the variable is defined, and that might tell us more about the issue. Possible sources include...

  • ADODB abstraction layer (still present in your version)
  • Differences in PHP versions (your store vs your server)
  • Differences in MySQL versions (your store vs your server)
  • Modified files (categories.php plus anything that it connects to)

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

5 Oct 2006, 8:37 PM
#4
boozubay avatar

boozubay

New Zenner

Join Date:
Oct 2006
Posts:
6
Plugin Contributions:
0

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

We followed the upograde instructions to the letter. We tried to use our configure.php files for inclues and admin and it would go no further except to say that tables are missing and nothing else. I wonder if this version is just soooo old it will not upgrade?

The database is already backed up through cpanel as well as the entire file structure. Our MYSQL is version 4.1.10 and our php version is 4.4.4

$products = array();

$products = $db->Execute("select p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id,
p.products_model
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = p2c.products_id
and pd.products_name like '%" . zen_db_input($search) . "%'
order by pd.products_name");
} else {
$products = $db->Execute("select p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p.products_model
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_id = p2c.products_id
and p2c.categories_id = '" . (int)$current_category_id . "'
order by pd.products_name");
}

$products = $db->Execute($products_query_raw);

These are on various lines in the file categories.php

5 Oct 2006, 8:45 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

The upgrade routines should upgrade from as far back as v1.0.4 without difficulty.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

5 Oct 2006, 8:55 PM
#6
boozubay avatar

boozubay

New Zenner

Join Date:
Oct 2006
Posts:
6
Plugin Contributions:
0

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

1146 Table 'boneezc_zencart.dogconfiguration' doesn't exist
in:
[update dogconfiguration set configuration_value='/home/boneezc/public_html/dog-treats2/cache' where configuration_key='SESSION_WRITE_DIRECTORY']

We have tried the updat 3 times and it stops here

5 Oct 2006, 9:19 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

"dog" ... is that the value in your DB_PREFIX setting in your configure.php file?

Your "old" configure.php file wouldn't have that setting available, and thus it would be best to have it set to blank for the upgrade.

define('DB_PREFIX', '');

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

5 Oct 2006, 9:32 PM
#8
boozubay avatar

boozubay

New Zenner

Join Date:
Oct 2006
Posts:
6
Plugin Contributions:
0

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

Yup,
Already caoght that and am trying to get this to update bu it keeps saying incorrect tables?

1103 Incorrect table name 'configuration set configuration_value='/home/boneezc/public_html/tmp' where configuration_key='SESSI'
in:
[update `configuration set configuration_value='/home/boneezc/public_html/tmp' where configuration_key='SESSION_WRITE_DIRECTORY']

This is gettin unnerving!!! :)

6 Oct 2006, 1:00 AM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

I'm surprised that there is a back-quote in there, because the zc_install process strips those out if it finds them.

What is the URL of the page you're on when this occurs?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

6 Oct 2006, 2:28 PM
#10
boozubay avatar

boozubay

New Zenner

Join Date:
Oct 2006
Posts:
6
Plugin Contributions:
0

Re: Categories will not work any longer - Trying to upgrade from v1.0.4 to 1.3.5

I found a version 1.2.6d and was able to do the upgrade. The upgrade still showed errors saying it can't find the MYSQL documents? I kept putting in my user name and password over and over and it finished up. I ate about 8 hours yesterday with this since this is a very old client (as you can tell by the zencart version)

Just FYI I did a full clean install of the older version on my server and had the exact same error with categories. So it is not compatible any more with PHP 4.4.4.

Now that we don't have to rekey everything we are off to change the graphics and style sheet back to their look and finished.

I guess the lesson here is keep up with the updates! Fortunately all our other clients carts are newer.

Thanks for the help everyone!