Hi,

Is it possible to set-up a development version of an installed shop?

What I mean is, if I have a shop up and running (albeit as a draft), but want to try out versions of its development, using the same database, is that possible?

I've tried just cloning the live site in to a sub-directory, here

https://www.lr-westend.co.uk/zzdev/

but that creates this error -

Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/sisdev89/public_html/lr-westend.co.uk/zzdev/vsadmin/inc/languagefile.php on line 8
Access denied for user 'sisdev89'@'localhost' (using password: NO)

at the top and a host of others too.

Is there a simple fix I'm missing, or is this in fact impossible?

Hi Mike

That should be possible but you'll need to make sure that the admin files and database on the live site and dev site are running the same version - it looks like your dev site admin files may be older.

Andy

Please feel free to review / rate our software

Hi Andy,

this is so confusing.

I've created a sub-folder, /zzdev/

I've copied all the content of the top level in to it, but if I go to it, I get

Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/sisdev89/public_html/lr-westend.co.uk/zzdev/vsadmin/inc/languagefile.php on line 8
Access denied for user 'sisdev89'@'localhost' (using password: NO)

etc

This page is the only nominally live product detail page -

https://www.lr-westend.co.uk/zzdev/proddetail.php?prod=chanterelle

with loads of errors, but the same page on the top level -

https://www.lr-westend.co.uk/proddetail.php?prod=chanterelle

is fine.

I don't understand how that's possible. The sub-folder content is - literally - just a cut-and-paste from the top level.

Are the db_conn_open.php and includes.php files identical in both sites (along with the rest of the admin files)?

Andy

Please feel free to review / rate our software

Hi

yep, wholly identical. When I say I copied all the top level pages down to the zzdev folder, that is literally all I did!

Do you know what version of PHP the server is running?

Andy

Please feel free to review / rate our software

hi again,

yep, its v7.

Hi it does appear to be a problem with the database connection can you check that the connection string look like the example here https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

All I've done is copied the files - complete - from the working version one level above.

Working Version:

https://www.lr-westend.co.uk/

Copied for development to a sub-folder:

https://www.lr-westend.co.uk/zzdev/

The working version applies the PHP 7 fixes that the post you link to refers to. The non-working version uses exactly the same code - it's a copy from the version above.

So, I can't see that the database connection is itself going to be the cause of the problem. How could it be?

Hi can you let us know if you have made the changes recommended in the link is the vsadmin/db_conn_open.php have the correct code, older versions of the connection string can cause depreciated errors

quote:

---

Deprecated: mysql_query():

---

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

yep, those changes done - in both versions.

I've just been experimenting with what options I can try/have tried to date, so here are more details:

Referring to the main site, which is -

https://www.lr-westend.co.uk/

- f I use the db_conn_open.php and includes.php files without mods I get errors.

STEP ONE-

So I follow the steps on this page

https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737

and I still get errors.

If I then modify

db_conn_open.php

so that INSTEAD OF

//////////////////////////////////////////////////
// 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>');

?>

It says

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

It works.

STEP TWO-

So, turning to the development version I'm trying to work with, I have just tried the SECOND modified version to the /zzdev/ copy, i.e. on this page

https://www.lr-westend.co.uk/zzdev/

and I now get this error -

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/sisdev89/public_html/lr-westend.co.uk/zzdev/vsadmin/db_conn_open.php on line 15

If I apply the first modified version as detailed above in STEP ONE, to the /zzdev/ copy, I get this error (which is the as I first reported the problem) -

Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/sisdev89/public_html/lr-westend.co.uk/zzdev/vsadmin/inc/languagefile.php on line 8
Access denied for user 'sisdev89'@'localhost' (using password: NO)

Either way, it looks like having a development version is impossible, which seems a) very limiting and b) hard to believe. Am I missing something?

Hi Mike, we setup dev versions the same way all the time so its not impossible or limiting. The other part of the error indicates localhost can you check with the host to see if using a different method to access the database such as IP address instead of localhost works better.

quote:

---

Access denied for user 'sisdev89'@'localhost'

---

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

trying

$db_host = "77.104.131.218";

Gives me a different error message:

Database Connect Error (1045) Access denied for user 'sisdev89_lrw'@'77.104.131.101' (using password: YES)
You need to set your database connection in vsadmin/db_conn_open.php
For help setting your database connection please see...
https://www.ecommercetemplates.com/phphelp/ecommplus/instructions.asp#dbconn
We also have a support forum here...
https://www.ecommercetemplates.com/support/

To try and eliminate me as a problem (!), if you like, give me a step by step guide of what to do to create a clone of an existing ECT-site in a sub-directory (i.e. on the same URL) and I'll go through the whole process to see if I'm the cause. I never rule out my own stupidity!

Hi Mike, we have outlined the generic steps here https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=101728 which it sounds like that is what you are doing.

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Thanks. It's time for me to stop work for the night, but I'll give it a go tomorrow and see where that takes me.

So, more anon.

Right, to test what's wrong, I have

* taken a complete copy of all the files in the root folder, and put them in a sub-folder.

root folder:

https://www.lr-westend.co.uk/

sub-folder:

https://www.lr-westend.co.uk/aa-test/

The root folder version works as it should.

The sub-folder version throws up the errors I've already found.

In detail, just on the sub-folder version, on the home page the error is:

Deprecated: mysql_query(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/sisdev89/public_html/lr-westend.co.uk/aa-test/vsadmin/inc/languagefile.php on line 8
Access denied for user 'sisdev89'@'localhost' (using password: NO)

and if you go this page

https://www.lr-westend.co.uk/aa-test/proddetail.php?prod=chanterelle

there are hordes of errors.

To recap:

* both versions now have PHP-7 related mods as per ticket https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737
* both versions are using "localhost" as the database name.


I have looked at your topic https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=101728, but none of the problems/errors identified there correlate with the problems I'm seeing.

* As per earlier with this topic, both versions are using this mod

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

within the db_conn_open.php file, which works on the root version.

If I revert to

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

I get different errors/problems (as already detailed) earlier with this topic. I don't know if that tells you/us anything.

* I have tried both the IP address and the server name instead of "localhost" and that just gave different error messages. Again, as already detailed.

Any ideas?

Would it help if you had FTP access?

Please do send me on your FTP details via email and I'll take a look for you.

Andy

Please feel free to review / rate our software

Will do, which email address is best to use?

No problem - found your email. (Andy@ ...)