Fatal Error

[14Steve14]

I have been adding modules to my 1.0.8.20 test site and everything seemed to be going well. With testing everything was good. I came back to do a bit more about an hour later and now when updating a product I am getting a fatal error page with nothing on the page and no source code to see. All I have is red text in the top left corner of the page saying [PHOENIX FATAL]

Looking in the error logs all I can see is the following

[11-Apr-2023 19:13:56 Europe/London] PHP Warning: DB: [1054] Unknown column 'products_metaphone' in 'field list' from <UPDATE products_description SET products_metaphone = 'KRNPLS' WHERE products_id = 7 AND language_id = 1> in /home/####/####/####/includes/system/versioned/1.0.8.1/database_core.php on line 44

Line 44 in just the following

Code: Select all

        trigger_error($line, E_USER_WARNING);

To be honest I have no idea when this error started as I was not adding anything that I thought would affect the admin area. It was working fine as I had been adding and removing test products. I am sure that when I have been adding new modules I have been adding any sql that is also required. All other areas of the admin seem to be working fine.

I have searched for products_metaphone in these forums but cannot see anything.

Anyone have a way of finding out what is actually causing this error.

[tessthepup]

@14Steve14 , Have you gone through the addons you already have installed to check for products_metaphone?

[Kofod95]

products_metaphone is from the "Fuzzy Search" (S8E05). It's installed through visiting a file, and not through manually running sql. You can either remove the hook (includes/hooks/admin/catalog/fuzzy.php if memory serves) or browse to the file (assuming it's on the server - I can't remember the name of the file)

//Daniel

[14Steve14]

products_metaphone is from the "Fuzzy Search" (S8E05). It's installed through visiting a file, and not through manually running sql. You can either remove the hook (includes/hooks/admin/catalog/fuzzy.php if memory serves) or browse to the file (assuming it's on the server - I can't remember the name of the file)

//Daniel

Thanks for that. That is one that I had installed and is on my list to remove. Many thanks @Kofod95

[14Steve14]

Checked all the added modules and all the installs seemed ok. Removed the fuzzy search and tried adding it all again and it seems to have worked correctly this time.

Thanks for the help.