Jump to content

[Resolved] All products UNAVAILABLE


kalyncomputers
 Share

Recommended Posts

Been having a few problems after upgrading from 6.04 to 6.06.

Trying to sort them out and I have obviously done something silly and now every product is showing as UNAVAILABLE - I have tried everything I can think of but to no avail. I know it's a database problem but as I am not an SQL expert (in fact not much of anything with SQL!) can anyone help please?

Affected shop is here

Thanks

 

Tim

Link to comment
Share on other sites

It is probably the case that CC606 (vs CC604) the "Available for Purchase" setting in the Add/Edit Product screen is new. There is a database table column for this setting.

However, the setting must be enabled (the table column holding a value of "1") in order to be able to see the item.

If the database was not properly updated, this new column will not exist. CubeCart may treat this missing data item as a logical "0" (or false). Thus, the item is not available.

In admin, Dashboard, right after you log in, CubeCart will display a warning banner if the database schema version is not up to the same version as the code.

You can verify by examining the database directly (use phpMyAdmin, a tool in your hosting account's control panel), the CubeCart_inventory table, looking for a column that suggests 'available'.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...