Database Errors

Multi-Vendor Questions
1

I suddenly started getting database errors such as:

Unknown column 'cscart_category_descriptions.promo_sub_icon' in 'field list'

for all the following fields in the same table (cscart_category_descriptions):

  • promo_sub_icon
  • promo_top
  • promo_bottom
  • promo_right

Backtrace:

-------------

admin.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 460
app/functions/fn.control.php (include): 702
app/controllers/backend/categories.php (fn_get_categories): 404
app/functions/fn.catalog.php (db_get_hash_array): 1500
app/functions/fn.database.php (call_user_func_array): 45
app/Tygh/Database/Connection.php (getHash): 254
app/Tygh/Database/Connection.php (query): 488

I checked the database and the fields were missing. I manually entered the fields, hoping to get the site working again. The above database errors were fixed, but the site still doesn't work and I can't see any more log errors. Nothing displays on the site.

In installed Cart Power's "Agressive Popup" add-on a few hours before, but everything worked fine after I configured and started using that add-on. It just happened suddenly.

I tried disabling all third-party add-ons, but that didn't help.

If anyone has an advice from previous experience, I'd be glad to know.

Otherwise, please message me with a quotation just to have a look and see what the problem is.

It's funny that this problem happened immediately after I sent a message to Simtech to fix a CSS issue. Now they want to charge $200 just to look and see what the problem is.

Anyway, any help would be appreciated.

2

Now they want to charge $200 just to look and see what the problem is.



$200??? Take a look for a freelancer.

It's funny that this problem happened immediately after I sent a message to Simtech to fix a CSS issue.

Also I would to ask them to fix it free of charge as it didn't happen before they touched your files.

3

There is no such fields in default CS-Cart database. If disabling third-party add-ons did not help, the modification may have been made directly in CS-Cart core files. You can check this using file changes detector (Administration > File changes detector)

If you need assistance with this, please contact us via Customer Help Desk

I suddenly started getting database errors such as:

Unknown column 'cscart_category_descriptions.promo_sub_icon' in 'field list'

for all the following fields in the same table (cscart_category_descriptions):

  • promo_sub_icon
  • promo_top
  • promo_bottom
  • promo_right

Backtrace:

-------------

admin.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 460
app/functions/fn.control.php (include): 702
app/controllers/backend/categories.php (fn_get_categories): 404
app/functions/fn.catalog.php (db_get_hash_array): 1500
app/functions/fn.database.php (call_user_func_array): 45
app/Tygh/Database/Connection.php (getHash): 254
app/Tygh/Database/Connection.php (query): 488

I checked the database and the fields were missing. I manually entered the fields, hoping to get the site working again. The above database errors were fixed, but the site still doesn't work and I can't see any more log errors. Nothing displays on the site.

In installed Cart Power's "Agressive Popup" add-on a few hours before, but everything worked fine after I configured and started using that add-on. It just happened suddenly.

I tried disabling all third-party add-ons, but that didn't help.

If anyone has an advice from previous experience, I'd be glad to know.

Otherwise, please message me with a quotation just to have a look and see what the problem is.

It's funny that this problem happened immediately after I sent a message to Simtech to fix a CSS issue. Now they want to charge $200 just to look and see what the problem is.

Anyway, any help would be appreciated.

4

Well, I have purchased add-ons from them and had development work done. In that process, you have to provide your access details. I must say that they seem very professional. I don't think they would be dishonest and deliberately create a problem.

5

You can also always disable/delete ftp access and any admin accounts you've created.

6

Can you revert back fix from Simtech and check if the issue occurs in this case?