Error with Big Images Modification

[Bryan]

I installed it to a "T" I think and am not getting this error:

 

1054 - Unknown column 'c.status' in 'field list'



select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name



[TEP STOP]

 

I get this error on the 'admin/categories.php' page. Ideas?

[Ajeh]

In the categories table the status was removed. You can either edit the select to not have c.status or add a field status to your database.

 

I'd fix the php files where you find that error.

[Bryan]

Ok, that is done and it allows me to go one step further. Now when trying to add an item I fill in the fields and hit "Preview" and get the following:

 

Fatal error: Call to undefined function: tep_currency_format() in /path/to/the/admin/categories.php on line 540

 

That line has this code:

 

<td class="pageHeading" align="right"><?php echo tep_currency_format($pInfo->products_price); ?></td>

[Ajeh]

Back in May, there was a change to both the configuration table and to /admin/categories.php

 

On the configuration table it affects the set_function field for configuration_key MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING

 

Check here for the changes to categories.php:

 

http://cvs.sourceforge.net/cgi-bin/viewcvs...=1.131&r2=1.132

 

I do not know if any other files are effected by this change. You might do a search on tep_currency_format and see if anything else refers to it.

[Bryan]

Yes, you got it! Thanks for the help.

[Ajeh]

Searching ... tracking ... tracing old code ...

 

This URL is really handy for finding new and old code and snippets you cannot locate in the existing version you have:

http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/tep/

 

Just do a few searches to narrow it down. Then figure out was another program involved or get a time period to research through.

 

Peice it all together and you have a ... headache ... er ... solution :shock:

[Bryan]

I'm getting a new error when trying to add a category:

 

1054 - Unknown column 'status' in 'field list'



insert into categories (sort_order, parent_id, date_added, status) values ('', '0', now(), '0')

 

This is for the admin/categories.php file but I do not see this call anywhere in that file to remove the "status" call from the query?

[Ajeh]

Search for the word status in the file and see if you can't locate it that way. It's basically the same problem as before, it is calling a field that has been removed.

[gnyus]

:evil: 1054 - Unknown column 'c.categories_status' in 'where clause'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from categories c, categories_description cd where c.categories_status = '1' and c.parent_id = '46' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name

 

[TEP STOP]

 

 

Getting this error and looked in the /includes/language/english/default.php, catalog/default.php, and categories files and cannot find the error it only happens when I add subcategories to a category and it is only on the main category page where the subs are... any suggestions? solutions?

[Ajeh]

Check your database tables ... categories_status was removed awhile ago.

 

Most likely the add-on was written for an older snapshot.

 

Edit the select line so that it does not include:

 

c.categories_status = '1' and