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
Forum Search
Google Site Search
Author « Topic »  

steven vaccaro
Ecommerce Template Guru

USA
1107 Posts

Posted - 06/25/2025 :  13:47:30  
Im trying to make a new category and get this error. Vince do you think this has to also do with going to cloudflare?

Other things are working, like adding products.

"Unknown column 'sectionFooter' in 'field list'
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/offsvac4/public_html/oseadmin/inc/incfunctions.php:2098 Stack trace: #0 /home/offsvac4/public_html/oseadmin/inc/inccats.php(424): ect_fetch_assoc(false) #1 /home/offsvac4/public_html/oseadmin/admincats.php(40): include('/home/offsvac4/...') #2 {main} thrown in /home/offsvac4/public_html/oseadmin/inc/incfunctions.php on line 2098"

Edited by - steven vaccaro on 06/25/2025 13:53:29

dbdave
ECT Moderator

USA
10553 Posts

Posted - 06/25/2025 :  15:11:52  
Hi, that's usually an indicator that your files are not on the same version of as the database.
Perhaps you recently updated, but did not run the "updatestore.php" script to update the database?

Thanks,
David

Phil
ECT Moderator

United Kingdom
7780 Posts

Posted - 06/26/2025 :  02:19:19  
quote:
"Unknown column 'sectionFooter' in 'field list'


I don't recall a column in the database by that name. I see you're logged in to your renamed vsadmin directory, can you comment out $disallowlogin=true; from the vasdmin/includes.php file and login there (yourdomain.com/vsadmin/login.php ) to see if the problem still exists?



*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

steven vaccaro
Ecommerce Template Guru

USA
1107 Posts

Posted - 06/26/2025 :  07:29:15  
Dave thanks,

Phil, logging in using vsadmin, works to solve the problem. What next?

Phil
ECT Moderator

United Kingdom
7780 Posts

Posted - 06/26/2025 :  09:00:34  
quote:
Phil, logging in using vsadmin, works to solve the problem. What next?


Hi Steve,
You have a couple of choices.

1.You can lockout the existing vsadmin directory for security reasons using a login key - https://www.ecommercetemplates.com/phphelp/ecommplus/parameters.asp#padss and then just delete the renamed directory and files from the server.

2. Or copy over the vsadmin files to your existing renamed directory and reinstate the $disallowlogin=true; in the vsadmin/includes.php

Personally I'd go for option 1, that would mean future updates would only have to be applied to one directory.



*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Vince
Administrator

43096 Posts

Posted - 06/26/2025 :  09:39:56  
quote:
"Unknown column 'sectionFooter' in 'field list'
Section Footers are a feature of the updater that has just gone out so if anyone has problems like this running the updatestore.php script should solve it as Phil mentioned.

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.02 seconds. Snitz Forums 2000