Issues w/ MYSQL queries. Cannot find field value &/or Error 1054

  • Posts: 23
  • Thank you received: 1
7 years 9 months ago #262958

-- url of the page with the problem -- : www.mcnabbcustomcreations.com
-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.5
-- Browser(s) name and version -- : 56.0.2924.87 (64-bit)
-- Error-message(debug-mod must be tuned on) -- : 1) Please enter value for field XXX
2) Error 1054

Greetings,

I have several custom field columns for multiple drop down menus that are lists of colors for yarn.
I originally wanted to make one generic list & call it from multiple locations but I keep getting a MYSQL Error 1054.
So I created several custom fields for each product that requires the color list.
Now I get a error message that says "Please enter a value for field XXXX" or I get a 1054 error "unknown column in field".
I've read over the Hikashop documentation but I cannot find anything that reflects my particular problem.
Debug is on & Error Reporting set to "E_ALL | E_STRICT".

Many Thanks.

====================================
Michael S. "Mac" Miller
Webmaster
Bengalhome Enterprises
This email address is being protected from spambots. You need JavaScript enabled to view it.

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 9 months ago #262962

Hi,

When you create a custom field, you have to provide a "field namekey".
That namekey is also the column name that you'll find in your database.

You have to be sure that you have the corresponding column in your database.
The first step would be to perform a "check database" (button in the toolbar while you're in the HikaShop configuration).
Then, if the problem persist, you'll have to check your custom field configuration and look at your HikaShop tables.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 1
7 years 9 months ago #263093

Jerome,

Thanks for your quick reply. I have checked everything you suggested but I don't see a problem. I have included screen caps of of the Database check results, the a portion of the phpAdmin listing of the customs fields I am having issues with, and 2 caps of 1 particular record.
I would appreciate you looking these over & tell me what I've missed.

Many Thanks,

====================================
Michael S. "Mac" Miller
Webmaster
Bengalhome Enterprises
This email address is being protected from spambots. You need JavaScript enabled to view it.
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 9 months ago #263125

Hi,

Because your custom field is an "item" custom field, the corresponding column in the database should be in the table "cart_product" and "order_product".
Afterwards, we would need to exact error message of the SQL query error ; and if you can also provide the "callstack" it would be awesome.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 1
7 years 9 months ago #263239

Jerome,

Here are screen caps of the jos_hikashop_order_product & jos_hikashop_cart_product tables plus 2 screen caps of the jos_hikashop_field callstacks. There were no callstacks for the order/cart product tables.

====================================
Michael S. "Mac" Miller
Webmaster
Bengalhome Enterprises
This email address is being protected from spambots. You need JavaScript enabled to view it.
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 9 months ago #263242

Hi,

Afterwards, we would need to exact error message of the SQL query error ; and if you can also provide the "callstack" it would be awesome.

I'm afraid that is not the error message that I was talking about :

I get a 1054 error "unknown column in field".

The error you gave previously is not the real error message and does not contain the "call stack" I was talking about.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 23
  • Thank you received: 1
7 years 9 months ago #263343

Jerome,
Figured out what I was doing wrong & all is working correctly now.
Many thanks for the help.

====================================
Michael S. "Mac" Miller
Webmaster
Bengalhome Enterprises
This email address is being protected from spambots. You need JavaScript enabled to view it.

Please Log in or Create an account to join the conversation.

Time to create page: 0.070 seconds
Powered by Kunena Forum