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 21 to 30 of 30
18 Oct 2012, 2:56 PM
#21
edampfer avatar

edampfer

New Zenner

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

Has anyone gotten this error upon upgrading to 1.5?

No answer for me?

18 Oct 2012, 3:30 PM
#22
dbltoe avatar

dbltoe

Totally Zenned

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

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

Unfortunately, we are worse at conversing in your language than you are in ours.

DrByte has answered your question (post #18) but I think you did not understand.

When you open phpMyAdmin, there should be a list of databases down the left side. The first is probably information_schema. One of them should be dampfmacher as that is what you said your database is named. If not, that is the first problem as it should match what is in BOTH the configure.php files next to DB_DATABASE.

Click on that database name (dampfmacher) and a list of tables will appear. If there is no prefix, the first few should be address_book, address_format, admin, etc. If you had set a prefix of zen_ when you installed Zen Cart, they would look like zen_address_book, zen_address_format, zen_admin, etc. Check farther down the list to see if the project_version table is really there.

If dampfmacher is your database name and it shows in phpMyAdmin as dampfacher then the DB_DATABASE must be set to 'dampfmacher' is BOTH configure.php files.

If phpMyAdmin shows no prefix on address_book, address_format, admin, etc. then your DB_PREFIX should be '' (NOTE: that is two apostrophes ' NOT a quotation mark ")

So, if you have the correct database name of dampfmacher and no prefix to your tables, a look at BOTH configure.php files should see:

define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '
');
define('DB_DATABASE', 'dampfmacher');

If you have a different database name that is NOT dampfmacher and DO have prefix to your tables, a look at BOTH configure.php files should see:

define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'yourprefix_');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', '');
define('DB_SERVER_PASSWORD', '
');
define('DB_DATABASE', 'your_database_name');

Hopefully this will help. It's the same answer you previously received, just coming at it a little differently.

18 Oct 2012, 5:10 PM
#23
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

dbltoe:

Unfortunately, we are worse at conversing in your language than you are in ours.

In case it's helpful.. I took the liberty of translating your post to German for edampfer:

Leider sind wir schlimmer Gespräch in Ihrer Sprache, als Sie in unsere sind.

Webchills hat Ihre Frage beantwortet (post # 18), aber ich denke du hast nicht verstanden.

Wenn Sie phpMyAdmin öffnen, sollte es eine Liste der Datenbanken auf der linken Seite sein. Die erste ist wahrscheinlich information_schema. Einer von ihnen sollte dampfmacher so, dass ist das, was Sie gesagt haben Ihre Datenbank benannt wird. Wenn nicht, das ist das erste Problem, wie es sollte passen, was in den beiden configure.php Dateien, neben DB_DATABASE.

Klicken Sie auf diesen Namen der Datenbank (dampfmacher) und eine Liste der Tabellen erscheint. Wenn es keinen Präfix, sollten die ersten paar address_book, address_format, admin, etc. werden Wenn Sie ein Präfix zen_ gesetzt hatte, wenn Sie Zen Cart installiert, sie würden wie zen_address_book, zen_address_format, zen_admin, etc. aussehen Überprüfen weiter unten in der Liste um zu sehen, ob die project_version Tisch ist wirklich da.

Wenn dampfmacher ist Ihr Name der Datenbank, und es zeigt in phpMyAdmin als dampfacher dann die DB_DATABASE zu "dampfmacher 'gesetzt werden muss ist sowohl configure.php Dateien.

Wenn phpMyAdmin zeigt keine Präfix address_book, address_format, admin, etc. dann ist dein DB_PREFIX sollte'' sein (Hinweis: die zwei Apostrophe 'NOT ein Anführungszeichen "ist)

Also, wenn Sie die richtige Datenbank Name dampfmacher und kein Präfix, um Ihre Tabellen haben, sollten einen Blick auf beide configure.php Dateien zu sehen:

define ('DB_TYPE', 'mysql');
define ('DB_PREFIX','');
define ('db_server', 'localhost');
define ('DB_SERVER_USERNAME', '');
define ('DB_SERVER_PASSWORD', '
');
define ('DB_DATABASE', 'dampfmacher');

Wenn Sie eine andere Datenbank-Namen, die NICHT dampfmacher und haben zu tun haben Präfix zu deinem Tische, sollte einen Blick auf beide configure.php Dateien zu sehen:

define ('DB_TYPE', 'mysql');
define ('DB_PREFIX', 'yourprefix_');
define ('db_server', 'localhost');
define ('DB_SERVER_USERNAME', '');
define ('DB_SERVER_PASSWORD', '
');
define ('DB_DATABASE', 'your_database_name');

Hoffentlich wird dies helfen. Es ist die gleiche Antwort, die Sie zuvor erhalten haben, kommen gerade auf sie ein wenig anders.

18 Oct 2012, 5:16 PM
#24
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?

thanks!
nice translation, divaVocals :)

But i have understand all before and db setting and conficfiles all ok and no fault

18 Oct 2012, 6:01 PM
#25
dbltoe avatar

dbltoe

Totally Zenned

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

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

So......

What is your current problem? Still the project_version?

18 Oct 2012, 7:00 PM
#26
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?

Problem:

The last debugfile:
PHP Fatal error: 1146:Table 'DBName.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /users/dampfmacher/www/includes/classes/db/mysql/query_factory.php on line 101
After this report (3 Days back) is the cachefolder without any new debugfile...

Version:

Server Host: e-zigarette-preiswert.com (176.9.51.229) Database Host: localhost (127.0.0.1)
Server OS: x86_64 Database: MySQL 5.5.27
Server Date: 10/18/2012 20:44:29 Database Date: 10/18/2012 20:44:29
Server Up Time: Unsupported HTTP Server: Apache/2.4
PHP Version: 5.3.16 (Zend: 2.3.0) PHP Memory Limit: 64M PHP Safe Mode: Off
PHP File Uploads: On Max Size: 128M POST Max Size: 132M
Database Data Size: 282 kB Database Index Size: 359 kB
[IMG]http://e-zigarette-preiswert.com/adzig/images/logo.gif[/IMG] ## Zen Cart 1.5.0 ## Database Patch Level: 1.5.0 v1.5.0 [2012-10-15 15:11:23] (Fresh Installation) v1.5.0 [2012-10-15 15:11:23] (Fresh Installation) Double Install?!:no:

PHP Version 5.3.16

18 Oct 2012, 7:27 PM
#27
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?

ZC Admin is allright, but all Products and categories gone to nowere and the shop is dead "WARNING: An Error occurred, please refresh the page and try again."

18 Oct 2012, 7:46 PM
#28
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:

The last debugfile:
PHP Fatal error: 1146:Table 'DBName.project_version' doesn't exist :: select * from project_version WHERE project_version_key = 'Zen-Cart Database' in /users/dampfmacher/www/includes/classes/db/mysql/query_factory.php on line 101
After this report (3 Days back) is the cachefolder without any new debugfile...
So, the last "project_version doesn't exist" error was 3 days ago? But you're still getting "WARNING: An Error occurred, please refresh the page and try again." messages today?

If you're getting "WARNING: An Error occurred, please refresh the page and try again." messages, then you need to investigate what database error is causing that: http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

28 Dec 2012, 9:23 PM
#29
hawkwynd avatar

hawkwynd

New Zenner

Join Date:
Jun 2007
Location:
Nashville, TN
Posts:
32
Plugin Contributions:
1

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

edampfer:

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 **

Just curious, but your website really has a users directory called 'DBName' ? ??

 
/users/DBName/www/includes/classes/db/mysql/query_factory.php on line 101
       ^^^^^

I would start with looking to make sure your configure.php files are correctly set.

29 Dec 2012, 12:28 AM
#30
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

hawkwynd:

Just curious, but your website really has a users directory called 'DBName' ? ??

/users/DBName/www/includes/classes/db/mysql/query_factory.php on line 101
^^^^^