While installing Openoffice 3.4 in Windows XP, something like below error occurred:

An error occurred during installation of assembly ‘cli_ure,publidKeyToken=”xxx…”, version=”1.0.22.0″,culture=”neutral”,processorArchitecture=”MSIL”. Please refer to Help and Support for more in..

Openoffice Error 1935 Solution

Here is a simple solution.

• Goto your Windows System32 directory, which is usually located as c:\windows\system32.
• In this directory you’ll find a file named mscoree.dll.
• Rename this file to something like mscoreebak.dll
• Now install Openoffice 3.4
• After successful installation, rename the file mscoreebak.dll back to mscoree.dll

Hope this solution works for you.

While using Zen Cart in local system, the error exists as

Table seo_cache doesn’t exist

Here is what was beneficial for me, hope it will also work for you.

seo_cache doesn’t exist – zen cart

To resolve this error, all you have to do is to check that the right table is inserted in the database. As per my problem, there was a table named TABLE_SEO_CACHE in my zencart db, which was wrongly added somehow. After changing that table name to seo_cache, the problem got resolved.

seo_cache doesn’t exist solution

So here is a simple query which you can write in the DB for altering and changing the table name from TABLE_SEO_CACHE to seo_cache:

ALTER TABLE TABLE_SEO_CACHE RENAME to seo_cache;

Hope this solution will work for you.

After this solution, if you start getting other errors like

Table ‘TABLE_SEO_CACHE’ doesn’t exist
in:
[DELETE FROM TABLE_SEO_CACHE WHERE cache_expires <= '2012-07-17 22:30:33']
1146 Table ‘TABLE_SEO_CACHE’ doesn’t exist
in:
[DELETE FROM TABLE_SEO_CACHE WHERE cache_expires <= '2012-07-17 22:30:33']

then you must have to define the TABLE_SEO_CACHE variable in your configuration file, with seo_cache.

All you have to do is to open your configuration.php file, existing in the following path of zen:

includes/configure.php

and add the following line of code, at the end of configuration.php file:

define(‘TABLE_SEO_CACHE’, DB_PREFIX . ‘seo_cache’);

or add this line, right after the line, where DB_PREFIX is defined, something like define(‘DB_PREFIX’, ”);

Now your system will hopefully run smoothly with no as such seo cache errors.

If you have any other concern, or any other suggestion, please comment.

To set the descending order in zencart for new products showing latest products on the top, in descending order, here is the code you have to change, to set your latest products to display on top as New Products.

New Products Sort Order Descending

To show latest products in descending order in zencart, please open up the new_products.php file, existing in the following path:

includes/modules/new_products.php

or if you are using a zencart theme, then it should be appearing in your theme path as:

includes/modules/your_theme_folder/new_products.php

After opening the new_products.php file, add the following line of code:

$new_products_query .= ” ORDER BY products_date_added DESC
LIMIT ” . MAX_DISPLAY_NEW_PRODUCTS;

right before the following line:

if ($new_products_query != ”) $new_products = $db->ExecuteRandomMulti($new_products_query, MAX_DISPLAY_NEW_PRODUCTS);

Once you’re done, save the file and check out your new products, displaying in the homepage. Now you will be able to display your latest products in descending sort order in your homepage.

If you have any comments, or you have any other solution, please post your comment and let us know.