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
 All Forums
 Technical
 PHP (Unix / Linux / Apache) versions
 Update issues & php version issue
Author « Topic »  

matrix
Starting Member

4 Posts

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

Posted - 03/31/2020 :  12:24:17  
Hi,

Just purchased your php updater to update from v4 [really old] to v7. Had a slight error on update which was:
Terminated but with errors - Unknown column 'adminSecret' in 'admin'
but after uploading the vsadmin files then running the update again it seemed to disappear.

But I can only run the cart on php v5.6.40, I have tried it on the following versions 7.0.33, 7.1.30, 7.2.19, 7.3.6 but all I get is a white page for the admin login page and no products are displayed on the client shop side. Also when I change it to a lower version of php it works but when I place a dummy order I get the following at checkout:-

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/cart.php:223) in /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/vsadmin/inc/incfunctions.php on line 2518

Considering how old my original version is the update went well.

Could you shine any light on the errors above.

Thanks for your help

1818charlie
ECT Moderator

United Kingdom
1194 Posts

Posted - 03/31/2020 :  14:00:04  
Hi matrix

DO KEEP A BACKUP OF FILES BEFORE CHANGING ANYTHING

You will need to edit the db_conn_open.php as the syntax has changed from your old version. That file is in the vsadmin folder. It is NEVER overwritten with updaters.

At the moment leave the php @ 5.6.

Your old file will be the same as this.

<SCRIPT language="php">

// You host should be able to provide you with these settings if you do not know them already

$db_username = ""; // Your database login username
$db_password = ""; // Your database login password
$db_name = ""; // The name of the database you wish to use
$db_host = "localhost"; // The address of the database. Often this is localhost, but may be for example db.yoursite.com

//////////////////////////////////////////////////
// Please do not edit anything below this line. //
//////////////////////////////////////////////////

$dbh=mysql_connect($db_host, $db_username, $db_password) or die ('You need to set your database connection in vsadmin/db_conn_open.php.</td></tr></table></body></html>');
mysql_select_db($db_name) or die ('You need to set your database connection in vsadmin/db_conn_open.php.</td></tr></table></body></html>');

</SCRIPT>


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

The current (later) file is as such and what you need to be using. Copy your connection info into the file contents below and upload that to your server.

<?php

// You host should be able to provide you with these settings if you do not know them already

$db_username = ""; // Your database login username
$db_password = ""; // Your database login password
$db_name = ""; // The name of the database you wish to use
$db_host = "localhost"; // The address of the database. Often this is localhost, but may be for example db.yoursite.com


//////////////////////////////////////////////////
// Please do not edit anything below this line. //
//////////////////////////////////////////////////

$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>');
}
?>


Are you using the old website files with a view to just updating to a later version? If so, there are the ectcart.css & ectcart.js files that will need to be in the <head>of all your store pages.

<link rel="stylesheet" href="css/ectstyle.css" />
<link rel="stylesheet" href="css/ectcart.css" />


Steve
Bolton, Lancashire, UK

Remember - Any edits to the ectcart.css file will be overwritten by updater's. ALL edits to ectcart.css rules should be placed in your style.css file

Edited by - 1818charlie on 03/31/2020 19:38:41

dbdave
ECT Moderator

USA
10410 Posts

Posted - 03/31/2020 :  14:10:43  
Hi, in addition to what Steve wrote, there is this thread - https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737

matrix
Starting Member

4 Posts

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

Posted - 04/23/2020 :  03:49:52  
Thanks for all your help and advice.

Just tried it on my test site and everything seems good

Will update the live site now.

Thanks again

matrix
Starting Member

4 Posts

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

Posted - 04/23/2020 :  04:09:39  
Hi Everyone, again

Just tried to do a test transaction under the test site and everything goes ok until I get to the final checkout part and I get the following error [3 times in a block]:

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/cart.php:3) in /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/vsadmin/inc/incfunctions.php on line 2518

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/cart.php:3) in /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/vsadmin/inc/incfunctions.php on line 2518

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/cart.php:3) in /var/www/vhosts/dowlings-sew.co.uk/daleks.dowlings-sew.co.uk/vsadmin/inc/incfunctions.php on line 2518

If I continue with the checkout button it carries on and takes me to the Paypal page.

Running php v7.2.19 and have carried out the modifications above.

Any help would be appreciated

Ray

matrix
Starting Member

4 Posts

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

Posted - 04/23/2020 :  05:57:09  
Just a quick updated.

Found the following in another forum post

<?php
session_cache_limiter('none');
session_start();
ob_start();
?>

The ob_start() line will start output buffering which should stop that message about the headers already being sent.

I have added this to the cart.php page and the errors have gone

Is this the correct way to go - is it ok to ignore the errors.

Have taken the fix out for now so you can see the error

Ta

Ray

Marshall
Ecommerce Template Guru

USA
1909 Posts

Posted - 04/23/2020 :  07:02:45  
This should be at the top of every ECT page.

<?php
session_cache_limiter('none');
session_start();
ob_start();
?>

Marshall
CENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com
  « 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