Trying to upgrade to 1.3.9: Getting 1146 Table 'configuration' doesn't exist

[1234go]

I'm trying to upgrade from 1.3.8 and I've followed all the instructions so far but at this point in the Database setup I hit this error and I can't go any further. Can anyone help?


1146 Table 'XXXXXX.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

[DrByte]

I thought you said you were upgrading? But the "Database setup" page you mentioned is used for *new installs*.
So, it would seem that perhaps you're trying to set up a new site for testing, and in the process it sounds like you've set database information in your new /includes/configure.php file, but that database doesn't have any tables yet. It's better to leave those details blank, rather than point them to an empty database. Normally you wouldn't edit the *contents* of the configure.php files at all. You just need to make them writable so the installer can write them when it goes through its steps.
If you are indeed attempting to install a new site, for whatever purpose, I suggest that your fastest solution right now is to pick either of the following options:
a) edit your /includes/configure.php file and delete everything from it except the first line, leaving just the "<?php" at the top. Then run the install again.
b) or, delete your /includes/configure.php file, then rename your /includes/dist-configure.php file as just "configure.php", make it writable, and then run the install again.

[1234go]

I was trying to upgrade but I actually entirely gave up last night. I followed the instructions to the letter (at least I thought) and ended up with nothing but frustration. Is there a more indepth how to? The one on the site is entirely too simple and doesn't include any advice for when it goes wrong other than check the FAQ and post on this board. It'd be much more helpful to have a troubleshooting section.

[Scott_C]

Hi I got that error, it was a noob mistake I made.

Make sure you create a new empty db.

Export your current LIVE db and import it into the new empty one. (I called mine zc139 so there's no confusion)

But make sure to change your config files to point to the NEW database.

Here's a copy and paste from someone else on this site, this method worked really well for me;

Clean install in sub-directory and move
################################################################################
That will work fine, did this myself.
1. Clean install (by copying the files rather than using zc_install).
2. Create a new database and import (phpmyadmin) a backup of the old database.
3. Rename admin.
4. Copy original configure.php files (both) to new installation.
5. Edit configure.php (both) to reflect sub-directory changes and new database name.
6. Type your new installation url to zc_install.
7. Upgrade database.
8. Rename zc_install (once working just delete this).
9. Install mods (doing backups after each one).
10. Once everything is good, upload your site (being sure to edit your configure files again).

Remove and reinstall all shipping, payment and order total modules.

[Decostyle]

Also check to see whether your database has a prefix or not. I had the same problem and it seems I forgot that the database I am using had a zen_ prefix on it. Added that to the configure.php files and upgrade went ok!

[anne turies]

Hello,

I'm french and I have the same problem:

"1146 Table 'soinsbiocart.products_options' doesn't exist
in: [select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='5' and patrib.options_id = popt.products_options_id and popt.language_id = '1' limit 1]"

I have not created the site myself and I don't know how to correct my pages...
The problems arrive only when I try to add products to sell on my site.

The context: my site has been hacked and I try to restablis it using the "chmod" command with ftp connection... but this is the only thing I do to restablish my site.

I don't know informatic and I hav made the site with help... but now I alone to try to solve may problem.

Have you a checklist or notes to give me to resolve my Problem?

Regards