Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Database Errors Rate Topic   - - - - -

 
  • pepo1
  • Advanced Member
  • Members
  • Join Date: 23-Jun 17
  • 85 posts

Posted 23 October 2017 - 07:57 PM #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.

 

 

 



 
  • martfox
  • Member
  • Authorized Reseller
  • Join Date: 15-Jan 10
  • 558 posts

Posted 23 October 2017 - 09:00 PM #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.


CS-Cart with 1 Year FREE Web Hosting | CS-Cart optimized SSD Cloud VPS Servers from €10.00/month
.
VPS SSD Cloud from €10.00 *** Dedicated Servers *** CS-Cart Authorized Reseller and Web Hosting Provider


 
  • CS-Cart team
  • CS-Cart support team
  • Moderators
  • Join Date: 04-Apr 11
  • 3808 posts

Posted 24 October 2017 - 06:51 AM #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.


Sincerely yours, CS-Cart Support Team

 

User guide       |  Developer documentation  |  Core API documentation


 
  • pepo1
  • Advanced Member
  • Members
  • Join Date: 23-Jun 17
  • 85 posts

Posted 25 October 2017 - 08:01 PM #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.



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11333 posts

Posted 25 October 2017 - 09:49 PM #5

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


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19574 posts

Posted 26 October 2017 - 07:02 AM #6

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.