Zen Cart Logo
Forums / Upgrading to 1.5.x / Has anyone gotten this error upon upgrading to 1.5?

Has anyone gotten this error upon upgrading to 1.5?

Views: 4,403

Results 1 to 20 of 30
29 Apr 2012, 10:45 AM
#1
edizioninautilus avatar

edizioninautilus

New Zenner

Join Date:
May 2009
Location:
Italy
Posts:
19
Plugin Contributions:
0

Has anyone gotten this error upon upgrading to 1.5?

PHP Fatal error: 1146:Table 'cesmush8_zc2.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /home/cesmush8/public_html/nautilus/includes/classes/db/mysql/query_factory.php on line 101

Any idea what this is or how to fix it?

Jeremy

29 Apr 2012, 2:08 PM
#2
edizioninautilus avatar

edizioninautilus

New Zenner

Join Date:
May 2009
Location:
Italy
Posts:
19
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

As a follow up to my original note, this error appears when I try to log in to the new admin page. The site appears to be working ok by itself, but I can't access admin. I've looked through this forum and have read other problems with admin, but I haven't yet seen this particular problem.

However, it does appear that my configure.php file is different from others in this forum. Following is the one that auto-installed during the upgrade process for me. I'm disturbed that there do not appear to be any references at all to admin or a path for admin in this file.

Should I be using a different configure.php?

Thanks,

Jeremy

<?php /** * @package Configuration Settings circa 1.3.8 * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 */ /*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ // Define the webserver and path parameters // HTTP_SERVER is your Main webserver: eg, <http://www.yourdomain.com> // HTTPS_SERVER is your Secure webserver: eg, <https://www.yourdomain.com> define('HTTP_SERVER', 'http://www.edizioninautilus.it'); define('HTTPS_SERVER', 'https://www.edizioninautilus.it'); // Use secure webserver for checkout procedure? define('ENABLE_SSL', 'false'); // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes! // * DIR_WS_* = Webserver directories (virtual/URL) // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder) define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/'); define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/'); define('DIR_WS_PHPBB', '/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/ define('DIR_FS_CATALOG', '/home/cesmush8/public_html/nautilus/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/'); define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', 'zen_'); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'my_username'); define('DB_SERVER_PASSWORD', 'my_password'); define('DB_DATABASE', 'my_DB'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'database'); define('DIR_FS_SQL_CACHE', '/home/cesmush8/public_html/nautilus/cache'); // EOF
29 Apr 2012, 3:10 PM
#3
edizioninautilus avatar

edizioninautilus

New Zenner

Join Date:
May 2009
Location:
Italy
Posts:
19
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

I've now added these lines to no avail:

define('DIR_WS_ADMIN', '/zcadmin/');
define('DIR_WS_HTTPS_ADMIN', '/zcadmin/');

define('DIR_FS_ADMIN', '/home/cesmush8/public_html/nautilus/zcadmin/');

Thought a direct reference to the new admin location that was created by the install script might do the trick, but it did not. Any idea why and attempt to access https://www.edizioninautilus.it/zcadmin/login.php would give me this error on my browser:

WARNING: An Error occurred, please refresh the page and try again.

and this error in my logs:

PHP Fatal error: 1146:Table 'cesmush8_zc2.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /home/cesmush8/public_html/nautilus/includes/classes/db/mysql/query_factory.php on line 101

Can anyone tell me if the table cesmush8_zc2.project_version is a ZenCart table or is this something from an addon perhaps?

Thanks,

Jeremy

15 Oct 2012, 9:04 PM
#4
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

have the same Problem with my electric cigarettes shop

PHP Fatal error: 1146:Table 'DBName.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /users/DBName/www/includes/classes/db/mysql/query_factory.php on line 101

**Please help...Thanks **

15 Oct 2012, 9:06 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

Simple: it means your DB_PREFIX setting in your two configure.php files is incorrect.

15 Oct 2012, 9:27 PM
#6
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

And where are the Fault?
Thank you for answer me!

/*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. /
/
**** The 2 files should be kept separate and not used to overwrite each other. ***********/

// Define the webserver and path parameters
// HTTP_SERVER is your Main webserver: eg-http://www.your_domain.com
// HTTPS_SERVER is your Secure webserver: eg-https://www.your_domain.com
define('HTTP_SERVER', 'http://e-zigarette-preiswert.com');
define('HTTPS_SERVER', 'https://e-zigarette-preiswert.com');

// Use secure webserver for checkout procedure?
define('ENABLE_SSL', 'false');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
// these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');

define('DIR_WS_IMAGES', 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
//the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
define('DIR_FS_CATALOG', '/users/USERNAME/www/');

define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_CHARSET', 'utf8');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '
');
define('DB_DATABASE', '****');

// The next 2 "defines" are for SQL cache support.
// For SQL_CACHE_METHOD, you can select from: none, database, or file
// If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
// or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
// ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
define('SQL_CACHE_METHOD', 'none');
define('DIR_FS_SQL_CACHE', '/users/USERNAME/www/cache');

15 Oct 2012, 10:13 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

What is the DB_PREFIX on the database you imported from?

In phpMyAdmin, do all your tablenames start with a prefix, such as maybe "zen_"? ie: is your "admin" table actually named "zen_admin"? If so, then your DB_PREFIX needs to be set to "zen_".

15 Oct 2012, 10:37 PM
#8
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

No Prefixes there...
alone my ftp admin folder is changed, now ad...

15 Oct 2012, 10:41 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

edampfer:

PHP Fatal error: 1146:Table 'DBName.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /users/DBName/www/includes/classes/db/mysql/query_factory.php on line 101
"DBName.project_version" literally means "in the database named 'DBName', find the table named "project_version".
So, when it says "DBName.project_version doesn't exist", that means that when it's looking in the database named "DBName", it can't find the table named "project_version".

So, either your "project_version" table has a different name, or the "DBName" is incorrect.

16 Oct 2012, 4:50 AM
#10
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

And where is the "project_version" table?

16 Oct 2012, 5:00 AM
#11
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

Database tables are stored in ... the database.

Use phpMyAdmin to view your database.

16 Oct 2012, 11:25 AM
#12
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

yeS I now myphp and can find no "versiontable" there.my database name is same,dampfmacher.thank you dr byte,hope you can help me to find the error.greeting from germany

16 Oct 2012, 3:46 PM
#13
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

here my Table from phpMyAdmin

  • Optionen
    Vollständige Texte project_version_id project_version_key project_version_major project_version_minor project_version_patch1 project_version_patch2 project_version_patch1_source project_version_patch2_source project_version_comment project_version_date_applied
    Bearbeiten Bearbeiten Kopieren Löschen 1 Zen-Cart Main 1 5.0 Fresh Installation 2012-10-15 15:11:23
    Bearbeiten Bearbeiten Kopieren Löschen 2 Zen-Cart Database 1 5.0

what is the fault?

16 Oct 2012, 5:20 PM
#14
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

my database name is "dampfmacher"

16 Oct 2012, 6:07 PM
#15
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

project_version "Database Version Tracking"

Please Help me

16 Oct 2012, 8:57 PM
#16
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

Zen Cart will not say "table does not exist" if it actually exists.
So, since your database is telling Zen Cart that the table doesn't exist, then that must mean your Zen Cart configuration is pointing to a different database.

Zen Cart is only the messenger.

17 Oct 2012, 1:17 AM
#17
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

How can i find it?

17 Oct 2012, 1:44 AM
#18
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Has anyone gotten this error upon upgrading to 1.5?

As I said already, the probable causes are:

  1. wrong DB_DATABASE, DB_PREFIX, DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD in both configure.php files. Yes, there are TWO configure.php files. Check both.

  2. database doesn't contain the table specified.

17 Oct 2012, 5:22 PM
#19
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

Thank you, but i have proof my confics, db and so on....
I cant find a fault...
can i restore an db in phpmyadmin?
Last week i take the 1.5.1 on my ftp, but i return to the old 1.5.0...
How can i restore the Cart before the changes was make?
Sorry for my bad english, i do my best...

17 Oct 2012, 6:36 PM
#20
edampfer avatar

edampfer

New Zenner

Join Date:
Apr 2012
Location:
Wittenberg, Germany (Sa.Anhalt)
Posts:
15
Plugin Contributions:
0

Re: Has anyone gotten this error upon upgrading to 1.5?

also, no new debugfiles in cachefolder
no prefix, correct server and db files, i find nothing