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?
Views: 4,403
New Zenner
No answer for me?
Totally Zenned
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.
Totally Zenned
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.
New Zenner
thanks!
nice translation, divaVocals :)
But i have understand all before and db setting and conficfiles all ok and no fault
Totally Zenned
So......
What is your current problem? Still the project_version?
New Zenner
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: |
New Zenner
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."
Sensei
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
New Zenner
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.
Totally Zenned
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
^^^^^
Tell staff why this post should be reviewed.