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 »  

quantum503
Advanced Member

United Kingdom
230 Posts

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

Posted - 02/03/2022 :  23:51:35  
Hi

I'm trying to update an instance of a store on my laptop that I use for demo purposes, but when I run the updatestore script I get this message:

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'adminCert' in 'field list' in C:\xampp\htdocs\demo_store\updatestore.php:53 Stack trace: #0 C:\xampp\htdocs\demo_store\updatestore.php(53): mysqli->query('SELECT adminCer...') #1 C:\xampp\htdocs\demo_store\updatestore.php(313): ect_query('SELECT adminCer...') #2 {main} thrown in C:\xampp\htdocs\demo_store\updatestore.php on line 53

I've never had this issue before - any idea what I'm doing wrong?

Eric

Vince
Administrator

42874 Posts

Posted - 02/04/2022 :  03:36:44  
Hi Eric
This is strange as that line is just testing if the column exists, and it shouldn't, so it should just set a flag instead of erroring and move on to the next line. What database connection are you using? Can you show me the details from the db_conn_open.php file (but not the login details of course. )

Vince

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

quantum503
Advanced Member

United Kingdom
230 Posts

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

Posted - 02/04/2022 :  04:55:35  
Thanks Vince

The bit below all the log-in stuff is copied here:

$GLOBALS['ectdatabase'] = new mysqli($db_host, $db_username, $db_password, $db_name);
if(mysqli_connect_error()){
ob_clean();
print '<html><head><title>Database connect error</title></head><body><div style="margin:20px;clear:both">Database Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error() . '</div>';
print('<div style="margin:20px;clear:both">You need to set your database connection in vsadmin/db_conn_open.php</div>');
print '<div style="margin:20px;clear:both">For help setting your database connection please see...<br />';
print '<a href="https://www.ecommercetemplates.com/phphelp/ecommplus/instructions.asp#dbconn" target="_blank">https://www.ecommercetemplates.com/phphelp/ecommplus/instructions.asp#dbconn</a></div>';
print '<div style="margin:20px;clear:both">We also have a support forum here...<br />';
print '<a href="https://www.ecommercetemplates.com/support/" target="_blank">https://www.ecommercetemplates.com/support/</a></div>';
die('</body></html>');
}

quantum503
Advanced Member

United Kingdom
230 Posts

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

Posted - 02/09/2022 :  07:52:43  
Hi Vince

Sorry to be a pain but I'm still having problems here. I've copied a 'live' site to my testing laptop just to make sure that all the files and database tables are correct, but now I get this error:

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in C:\xampp\htdocs\*****\vsadmin\inc\incfunctions.php on line 421

The only differerence I can see is that the laptop is running PHP v8 as compared to v7.2. Is that an issue?

Eric

Vince
Administrator

42874 Posts

Posted - 02/09/2022 :  12:56:40  
Hi Eric
There is a change in the incfunctions.php file now so that those "Deprecated" warnings do not show. But would it be worth trying with PHP 7.2 to see if that solves the other problem? I know it wouldn't be a solution to the problem but at least it would show where to look.

Vince

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

quantum503
Advanced Member

United Kingdom
230 Posts

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

Posted - 02/10/2022 :  06:44:01  
Hi Vince

Thanks for your help. I've tried running PHP 7.2 and 8.0 on a remote server and the site works fine and I've been able to update the store without any issues. So I think there must be an issue with my local xampp installation. I've rolled that back to a previous version (using 7.2) and once again all is OK, and the update script runs faultlessly - as usual.

I'm not really tech-savvy enough to troubleshoot the Apache/xampp installation so I'll park it for now.

Excellent support as usual.

Eric
  « 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