Forums / Setting Up Categories, Products, Attributes / Warning message when trying to edit the Catagories titles

Warning message when trying to edit the Catagories titles

Views: 813

Results 1 to 7 of 7
21 Apr 2015, 5:55 PM
#1
bearlymakinit avatar

bearlymakinit

Zen Follower

Join Date:
Feb 2009
Posts:
128
Plugin Contributions:
0

Warning message when trying to edit the Catagories titles

I decided to add something to a Categories that was already set up. To the Categories Description. When I click on the E button to edit I get the following message

WARNING: An Error occurred, please refresh the page and try again.

When I refresh nothing happens. I am having to delete the Categories title and start all over again. That is no problem when that one is blank but how do I figure out what is wrong when that Categories is full of product.

I searched and no one else seems to have this problem. I can add product to the store just fine.

21 Apr 2015, 8:40 PM
#2
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Warning message when trying to edit the Catagories titles

A quick search reveals the following article: An Error occurred, please refresh the page and try again. The article includes instructions on the next step(s) required for you to perform (such as locating the debug log) in order to help us help you.

When responding please include the item(s) mentioned in the article along with answers to the questions found in the posting tips (these are located immediately above the place where you type in your reply; if on a mobile device switch to "full site").

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

23 Apr 2015, 3:30 PM
#3
bearlymakinit avatar

bearlymakinit

Zen Follower

Join Date:
Feb 2009
Posts:
128
Plugin Contributions:
0

Re: Warning message when trying to edit the Catagories titles

I have attched the debug log, and what it says needs to be fixed but I don't understand what I am supposed to change.

This is the debug log:

[23-Apr-2015 09:57:24 America/Chicago] PHP Fatal error: 1146:Table 'xxx_xxx.TABLE_HIDE_CATEGORIES' doesn't exist :: select visibility_status
FROM TABLE_HIDE_CATEGORIES
WHERE categories_id = 36
LIMIT 1 ==> (as called by) /home/xxx/public_html/xxx/xxx/categories.php on line 797 <== in /home/xxx/public_html/xxx/includes/classes/db/mysql/query_factory.php on line 155

This is line 797 from catagories.php

$hide_status = $db->Execute($sql);

This is line 155 from query_factory.php

trigger_error($this->error_number . ':' . $this->error_text . ' :: ' . $this->zf_sql . $query_factory_caller, E_USER_ERROR);
if (defined('IS_ADMIN_FLAG') && IS_ADMIN_FLAG==true) echo 'If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.<br />';
echo '</div>';

23 Apr 2015, 4:02 PM
#4
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Warning message when trying to edit the Catagories titles

bearlymakinit:

...
This is the debug log:

[23-Apr-2015 09:57:24 America/Chicago] PHP Fatal error: 1146:Table 'xxx_xxx.TABLE_HIDE_CATEGORIES' doesn't exist :: select visibility_status
FROM TABLE_HIDE_CATEGORIES
WHERE categories_id = 36
LIMIT 1 ==> (as called by) /home/xxx/public_html/xxx/xxx/categories.php on line 797 <== in /home/xxx/public_html/xxx/includes/classes/db/mysql/query_factory.php on line 155
...
A stock Zen Cart installation does not contain "TABLE_HIDE_CATEGORIES". Did you (or someone else) install (or attempt to install) the 3rd party Hide Categories module?

When installing, the Hide Categories module requires one to run a "SQL Script" during the installation to create "TABLE_HIDE_CATEGORIES". If this step is missed / skipped the above will result.

If the Hide Categories module was previously installed and later removed, it requires one to manually undo the changes to all altered core files (such as "/admin/categories.php"). Unless other items have modified "/admin/categories.php", one can replace the file with a stock copy from the Zen Cart distribution zip archive (download links are available here).

If the Hide Categories module was never installed, please answer the questions in the "Posting Tips". In particular the questions: "What plugins/addons have you installed? When?" and "WHEN did the problem "start"? How does that compare with other events of your hosting company, changes you've made to your site files/addons, or your admin settings, etc?". Answers to the other questions asked in the "Posting Tips" are also valuable to help people on the forums help you.

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

23 Apr 2015, 5:00 PM
#5
bearlymakinit avatar

bearlymakinit

Zen Follower

Join Date:
Feb 2009
Posts:
128
Plugin Contributions:
0

Re: Warning message when trying to edit the Catagories titles

I downloaded it to install the Hide categories. It might have happened when I transferred files from the old store to the new one. I don't remember if I had it on the old store or not, that was set up in 2008. I'll install and see if that fixes my problem. Thank you for your help.

23 Apr 2015, 5:14 PM
#6
lhungil avatar

lhungil

Totally Zenned

Join Date:
Feb 2012
Location:
mostly harmless
Posts:
1,818
Plugin Contributions:
4

Re: Warning message when trying to edit the Catagories titles

No problem! Let us know if (re-)installing Hide Categories solves the reported issue.

The glass is not half full. The glass is not half empty. The glass is simply too big!
Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

23 Apr 2015, 5:36 PM
#7
bearlymakinit avatar

bearlymakinit

Zen Follower

Join Date:
Feb 2009
Posts:
128
Plugin Contributions:
0

Re: Warning message when trying to edit the Catagories titles

That fixed it. Thank you again for your help.