Ecommerce software home
Shopping Cart Software Forum for Ecommerce Templates
 
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

Find us on Facebook Follow us on Twitter View our YouTube channel
Search our site
Author « Topic »  

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/28/2020 :  11:51:25  
Hello all,

I have updated my store and had six files that i needed to go back an install backup files for the site to be functional. Then, when I went to the admin area, I found this error:
Unknown column 'adminDeviceNotifAlert' in 'field list'
Fatal error: Call to a member function fetch_assoc() on boolean in
/var/www/vhosts/ streepwear com/httpdocs/vsadmin/inc/incfunctions.php on line 1747

which does not change if I install the new incfunctions file. Please advise what I need to do next. Would it help if you folks did the update for me? Thanks.
~ Judy


Edited by - Judytu on 01/28/2020 12:54:03

Vince
Administrator

42455 Posts

Posted - 01/28/2020 :  14:11:48  
H Judy
You need to run the updatestore.php script and that should sort this out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/28/2020 :  14:38:05  
Thanks Vince. I did do that. I guess I’ll try again tomorrow.

~ Judy

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/29/2020 :  08:37:13  
I re-installed the complete updater - this is the error I got when running updatestore.php.

Checking for blockMaxCartAdds in table admin

Adding htmlemails column to admin table.
Adding adminPwReset column to admin table.
Adding insuranceDomPercent column to admin table.
Adding Shipping Insurance columns
Adding insuranceDomMin column to admin table.
Adding insuranceIntPercent column to admin table.
Adding insuranceIntMin column to admin table.
Adding shipInsuranceDom column to admin table.
Adding shipInsuranceInt column to admin table.
Adding uploadDir column to admin table.
Adding adminDeviceNotifAlert column to admin table.
Adding blockMultiPurchase column to admin table.
Adding blockMaxCartAdds column to admin table.
[red]Terminated but with errors[/red]
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'htmlemails' in 'field list'
Unknown column 'htmlemails' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'adminPwReset' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'insuranceDomPercent' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'insuranceDomMin' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'insuranceIntPercent' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'insuranceIntMin' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'shipInsuranceDom' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'shipInsuranceInt' in 'field list'
Unknown column 'shipInsuranceDom' in 'field list'
Unknown column 'shipInsuranceInt' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'uploadDir' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'adminDeviceNotifAlert' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'blockMultiPurchase' in 'field list'
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
Unknown column 'blockMaxCartAdds' in 'field list'



~ Judy

insight
ECT Moderator

USA
4476 Posts

Posted - 01/29/2020 :  10:32:38  
Tech note:
it's an InnoDB table with dynamic rows.
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/29/2020 :  10:34:59  
Thanks Peter. Unfortunately, being an illiterate when it comes to this stuff, I have no idea what any of that means!

~ Judy

insight
ECT Moderator

USA
4476 Posts

Posted - 01/29/2020 :  10:38:24  
I posted it for Vince

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/29/2020 :  10:40:05  
Oh good! I hated to have to admit my naivety in this area "in public!"

~ Judy

Vince
Administrator

42455 Posts

Posted - 01/29/2020 :  11:14:13  
Hi Judy
Can you get me access to your database (control panel login for instance) sent to my email (vince AT ecommercetemplates DOT com)

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Judytu
Ecommerce Template Guru

USA
2483 Posts

Pre-sales questions only
(More Details...)

Posted - 01/29/2020 :  16:29:45  
Vince, I sent the info as requested just after your request. Please let me know if you received it. Do I need to resend?

Thanks.

~ Judy

Vince
Administrator

42455 Posts

Posted - 01/30/2020 :  00:06:03  
Hi Judy
I got the control login details but I don't know where your control panel is. Could you send the URL of that too? You mention in the email "If you need access to the database on the server" and that's just what I need.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater
  « Topic »  
Jump To:
Shopping Cart Software Forum for Ecommerce Templates © 2002-2022 ecommercetemplates.com
This page was generated in 0.03 seconds. Snitz Forums 2000