Help! with database problem

[enquirer66]

Tried installing a module 9product expire) which has messed up my database. I now have a message which reads:

1054 Unknown column 'products_bundle' in 'field list'
in:
[select products_quantity ,products_bundle from fws_products where products_id = '73']

How can I resolve this? Restoring the DB doesn't seem to do it.

Any urgent help much appreciated.

[misty]

So you took a copy of database BEFORE installing mod?
If so, delete existing and replace with copy taken..

[Diavire]

Were there any database modifications that the add-on required you to make, but you didn't?

That error means it's looking for a table in a database, but that table isn't there.

Looks like, if you tried to uninstall the add-on, that some or all files of the add-on are still in place on your site and looking for that table. Otherwise, if you've installed the mod but not uninstalled it, you didn't make the necessary adjustments to your database when installing the add-on.

[ALiepinieks]

...That error means it's looking for a table in a database, but that table isn't there...

don't you mean looking for a field in the table...

either way, the field cannot be found. best bet would be to rollback if you can by removing the mod, and reinstalling, following instructions to the letter.

sounds to me like you have missed an sql statement that should've been executed through the sql patches facility or similar.

cheers
andy

[RodG]

Tried installing a module 9product expire) which has messed up my database. I now have a message which reads:

1054 Unknown column 'products_bundle' in 'field list'
in:
[select products_quantity ,products_bundle from fws_products where products_id = '73']

How can I resolve this? Restoring the DB doesn't seem to do it.

Any urgent help much appreciated.

Contrary to other replies (so far), and your assumption, this isn't actually a database problem, and restoring the database will not only not fix the problem, but could also CAUSE the problem.

Instead of restoring the database you should be running any SQL scripts that came with the package that you installed.

In simple terms, this is what is happening:

The module you installed requires the addition or modification of one or more of the .php files. These additions/modifications is what is causing the error message that you are getting. It is doing this because the table/field that they need to access don't exist in the database, usually because the installation SQL hasn't been run (to create the table/fields) ... or, when the database gets restored *without* these tables/fields.

If these fields do exist, the .php scripts that were installed/modified wouldn't be 'complaining'. Furthermore since no other piece of code will be accessing these new fields then *they* won't complain either (in other words, new fields added to a database generally won't cause a problem unless the code accessing the database has been very poorly written).

So, you have two solutions.

1. Finish the installation of the module by running any install.sql scripts that came with it. or

2. Remove or re-edit the .php files that were installed/edited when you installed the module.

There is no need to remove any new tables or fields created by a module, even if you uninstall the module itself.

My personal recommendation is that since you've already donethe 'hard' bit of putting the .php files into their correct locations, then why not finish the installation off before giving up on it? (please note, I am not familiar with particular module). My comments are based on the basic principle of how all modules (and databases) work.

Cheers
Rod

[enquirer66]

Thanks. It has been easier to try and uninstall the files and I agree it can cause more problems than it is worth restoring a DB. However, what is calling for a field that doesn't exist in the checkout? This is the problem I am left with: 1054 Unknown column 'products_bundle' in 'field list'
in:
[select products_quantity ,products_bundle from fws_products where products_id = '40']

Is this a field which is being called that no longer exists or is this a field which was created in the DB which which is no longer being filled? I can't find the field in the DB using phpMyADmin, so it must be the other. But I have tried uninstalling all of the php files but something is still being called - how is this possible?

I've looked for the string 'products_bundle' using the Developers Toolkit but there is nothing that matches..

[enquirer66]

By the way this is the error message when a client hits the 'Add to Cart' button.

[enquirer66]

So I installed a newer version of the module - and it's now OK. Very strange however. Thanks for your help

[RodG]

[select products_quantity ,products_bundle from fws_products where products_id = '40']

Is this a field which is being called that no longer exists

It either no longer exists (data restored from an older backup), or it never existed in the first place (sql installation script wasn't run, or the table prefix wasn't set correctly).

or is this a field which was created in the DB which which is no longer being filled?

As per my previous message, having additional fields (fields that are never referenced) in a database isn't going to cause any problems.

I can't find the field in the DB using phpMyADmin,

You won't. THAT IS WHY YOU ARE GETTING THE ERROR MESSAGE!!

But I have tried uninstalling all of the php files

My suggestion to finish the installation will probably be easier, but do it your way if wish.

but something is still being called - how is this possible?

Again, as per my previous response, you either haven't uninstalled all of the .php files that were installed by the module, OR you haven't reverted the modifications it performed on existing files. It can't be anything else.

I've looked for the string 'products_bundle' using the Developers Toolkit but there is nothing that matches..

Did it ever occur to you that the developers toolkit may not be searching all files, or that you only told it to search for functions or constants, or some other filter type.

but something is still being called - how is this possible?

It isn't possible, Therefore one (or more) of the .php files installed by the module hasn't been removed, or one (or more) of the .php files that it modified is yet to be restored to its pre-modified state.

I shall again repeat my suggestion, you will probably find it easier to complete the installation than it would be to uninstall it (assuming you have already placed the .php files into their correct locations). All you need to is run the sql script that updates the database,

If you feel you must uninstall then you need to find the .php file(s) that reference this field. If you don't find it/them then you simply aren't looking in the right place(s).


Cheers
Rod