[Skip to main content](#vessel-content)

#   1054 error after deleting custom field

##

- **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")**
- [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author
- [ Offline](/forum/user/6788-dibben)

Less More

- Posts: 377
- Thank you received: 7
-
-

12 years 5 months ago [\#159897](#159897) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  *[1054 error after deleting custom field](/forum/3-bug-report/868945-1054-error-after-deleting-custom-field#159897 "-- url of the page with the problem -- :   rapiddeal.co.uk/dev2/bournemouth  -- HikaShop version -- :2.3.1 -- Joomla version -- : 3.3.0  For some reason after deleting a custom field i am now getting a 1054 error on my menu link to those items. The products themselves display ok on their pages and the homepage is fine but i am getting an odd error on the product / category listing page.  Kind regards  Alex")* was created by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")*

-- url of the page with the problem -- : [ rapiddeal.co.uk/dev2/bournemouth](http://rapiddeal.co.uk/dev2/bournemouth)
-- HikaShop version -- :2.3.1
-- Joomla version -- : 3.3.0

For some reason after deleting a custom field i am now getting a 1054 error on my menu link to those items. The products themselves display ok on their pages and the homepage is fine but i am getting an odd error on the product / category listing page.

Kind regards

Alex

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njg5NDUtMTA1NC1lcnJvci1hZnRlci1kZWxldGluZy1jdXN0b20tZmllbGQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

12 years 5 months ago [\#159907](#159907) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1054 error after deleting custom field](/forum/3-bug-report/868945-1054-error-after-deleting-custom-field#159907 "-- url of the page with the problem -- :   rapiddeal.co.uk/dev2/bournemouth  -- HikaShop version -- :2.3.1 -- Joomla version -- : 3.3.0  For some reason after deleting a custom field i am now getting a 1054 error on my menu link to those items. The products themselves display ok on their pages and the homepage is fine but i am getting an odd error on the product / category listing page.  Kind regards  Alex")*

Hello Alex,
Reading that documentation will probably help you : [ www.hikashop.com/support/support/documen...lity-issues.html#SQL](http://www.hikashop.com/support/support/documentation/61-hikashop-compatibility-issues.html#SQL)

> 500 - JDatabaseMySQL::query: 1054 - Unknown column 'XXXXXX' in 'where clause' SQL=SELECT \* FROM.....
> How to fix (for update issues)?
> You should open the file administrator/components/com\_hikashop/install.hikashop.php and search for that column name. You should see something like that:
>
> $this-&gt;db-&gt;setQuery("ALTER TABLE &#96;#\_\_hikashop\_YYYY&#96; ADD &#96;XXXXXXXX&#96; .....................................................");
> $this-&gt;db-&gt;query();
>
> You need to open your phpmyadmin and run the query which is in the double quotes in your database. Don't forget to replace #\_\_ by the prefix of your tables (it's usually jos\_ for Joomla 1.5 but it is random for Joomla &gt; 1.6 ).
>
> For custom fields, you can just delete them and the error should disappear.
> How to avoid problems later on ?
> You should make sure that your MySQL user has the ALTER privilege. If you don't know how to do that, you should ask your hosting company.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njg5NDUtMTA1NC1lcnJvci1hZnRlci1kZWxldGluZy1jdXN0b20tZmllbGQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Dibben](/forum/user/6788-dibben "View Dibben's Profile")**
- [![Dibben's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6788-dibben "View Dibben's Profile") Topic Author
- [ Offline](/forum/user/6788-dibben)

Less More

- Posts: 377
- Thank you received: 7
-
-

12 years 5 months ago [\#160026](#160026) by [Dibben](/forum/user/6788-dibben "View Dibben's Profile")  Replied by *[Dibben](/forum/user/6788-dibben "View Dibben's Profile")* on topic *[1054 error after deleting custom field](/forum/3-bug-report/868945-1054-error-after-deleting-custom-field#160026 "-- url of the page with the problem -- :   rapiddeal.co.uk/dev2/bournemouth  -- HikaShop version -- :2.3.1 -- Joomla version -- : 3.3.0  For some reason after deleting a custom field i am now getting a 1054 error on my menu link to those items. The products themselves display ok on their pages and the homepage is fine but i am getting an odd error on the product / category listing page.  Kind regards  Alex")*

Hi Mohammed,

Thanks for your reply, I checked the tables and under your documentation it states with custom fields just delete the custom field. I have checked the hikashop_field table and the custom field doesnt seem to be in there would it be somewhere else?

Also your documentation says this comes from the user not having the alter priveledge and the server is dedicated so not lacking in resources.

The only ALTER queries i found in that file are:

$this-&gt;db-&gt;setQuery("ALTER TABLE &#96;#__hikashop_vote&#96; CHANGE &#96;vote_comment&#96; &#96;vote_comment&#96; TEXT NOT NULL;");
$this-&gt;db-&gt;setQuery("ALTER TABLE &#96;#__hikashop_payment&#96; DROP INDEX payment_type");
$this-&gt;db-&gt;setQuery("ALTER TABLE &#96;#__hikashop_download&#96; DROP PRIMARY KEY , ADD PRIMARY KEY ( &#96;file_id&#96; , &#96;order_id&#96; , &#96;file_pos&#96; );");
$this-&gt;db-&gt;setQuery("ALTER TABLE &#96;#__hikashop_field&#96; CHANGE &#96;field_value&#96; &#96;field_value&#96; LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL");

There doesn't seem to be anything there which relates to the hikashop field either.
I think what i might do is simply restore this from backup and not delete the custom field! I think I will just unpublish it!

Thanks

Alex

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njg5NDUtMTA1NC1lcnJvci1hZnRlci1kZWxldGluZy1jdXN0b20tZmllbGQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

12 years 5 months ago [\#160062](#160062) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1054 error after deleting custom field](/forum/3-bug-report/868945-1054-error-after-deleting-custom-field#160062 "-- url of the page with the problem -- :   rapiddeal.co.uk/dev2/bournemouth  -- HikaShop version -- :2.3.1 -- Joomla version -- : 3.3.0  For some reason after deleting a custom field i am now getting a 1054 error on my menu link to those items. The products themselves display ok on their pages and the homepage is fine but i am getting an odd error on the product / category listing page.  Kind regards  Alex")*

> I think what i might do is simply restore this from backup and not delete the custom field! I think I will just unpublish it!

Sure, unpublishing custom field is always better than directly deleting them.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84Njg5NDUtMTA1NC1lcnJvci1hZnRlci1kZWxldGluZy1jdXN0b20tZmllbGQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.072 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
