My present site is thymegraphics.co.uk and I am attempting to update using a responsive theme purchased from yourselves and testimg at test.thymegraphics.co.uk. I am connected to the same database as the present website

On my main website I can show a product for example here - http://thymegraphics.co.uk/products.asp?cat=5
Clicking on the details tab gives me what I would expect - http://thymegraphics.co.uk/proddetail.asp?prod=scal2

On the test website I am connected to the same database and the same product is here - http://test.thymegraphics.co.uk/products.asp?cat=5
but clicking on the details tab - http://test.thymegraphics.co.uk/proddetail.asp?prod=scal2 gives me an error message instead.
The error message was originally
"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Web Server at test.thymegraphics.co.uk "

I contacted my web hosts thinking the problem was with them. They appear to have looked at a different product but gave me the response below -
"Can't say I've seen this error before. This is the error we get in the logs

GET /proddetail.asp prod=1OutdoorVinylYellows|4599|80004005|[MySQL][ODBC_3.51_Driver][mysqld-5.7.21]Data_truncated_for_column_'rvSessionID'_at_row_1 HTTP/1.1

I've had a look around and can't find what this "rvSessionID" is.
It looks like it may be something with the shopping cart so you best bet would be to ask Ecommerce Templates to see if they know what the issue is."

They obviously managed something because the error now reads -

"An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error."

So I am hoping someone here can help because otherwise I cannot go any further with the new website.

I also do not understand why I am limited to pre sales questions only.
I purchased Set Up Site Plus on Feb 26th. Order ID: 63261 and Premium Responsive Design Order ID: 63237 also on Feb 26th and using the same email address.
I have checked that the email used to purchase and the email registered with this forum are the same

Hi

The support status looks fine now.

I haven't seen an error like that before but it looks like it may be session related. I'll have a look around and get back to you here.

Andy

Please feel free to review / rate our software

Thank you, I would be very grateful if you can solve the problem

So the store is running off a mysql database, correct?

Are the includes.asp and db_conn_open files identical in both?

Andy

Please feel free to review / rate our software

Yes, mysql database
The includes .asp appear to be different
I wouldattach them here but can't see how to do that so have copied them below

thymegraphics includes.asp is -
<%
' For a description of these parameters and their useage, please open the following URL in your browser
' https://www.ecommercetemplates.com/help/ecommplus/parameters.asp

sortBy = 2
pathtossl = ""
taxShipping=0
pagebarattop=0
productcolumns=2
useproductbodyformat=1
usesearchbodyformat=1
usedetailbodyformat=1
useemailfriend=true
nobuyorcheckout=false
noprice=false
expireaffiliate=30
mysqlserver=TRUE
usecategoryformat=1
allproductsimage=""
nogiftcertificate=false
showtaxinclusive=false
upspickuptype="03"
overridecurrency=false
orcsymbol="AU$ "
orcemailsymbol="AU$ "
orcdecplaces=2
orcpreamount=true
encryptmethod="aspencrypt"
commercialloc=true
showcategories=true
termsandconditions=false
showquantonproduct=false
showquantondetail=false
addshippinginsurance=0
noshipaddress=false
pricezeromessage=""
showproductid=false
currencyseparator=" "
noproductoptions=false
invoiceheader="<img src='http://www.thymegraphics.co.uk/new header template.jpg' border='0'><br><br>"
invoiceaddress="<br><b>Thyme Graphics</b><br>1 Riverside Park</b><br>East Service Road</b><br>Raynesway<br>Derby</b><br>DE21 7BF</b><br>Tel:01332 605682<br></b>"
invoicefooter="<br><br><font size='1'>Thank you for shopping with Thyme Graphics</font>"
dumpccnumber=false
actionaftercart=1
dateadjust=0
emailorderstatus=3
htmlemails=false
categorycolumns=1
noshowdiscounts=false
catseparator="<br> "
willpickuptext=""
willpickupcost=0
extraorderfield1=""
extraorderfield1required=false
extraorderfield2=""
extraorderfield2required=false
cardinalurl="https://paypal.cardinalcommerce.com/maps/txns/asp"
termsandconditions=TRUE

' ===================================================================
' Please do not edit anything below this line
' ===================================================================

maintablebg=""
innertablebg=""
maintablewidth="98%"
innertablewidth="100%"
maintablespacing="0"
innertablespacing="0"
maintablepadding="1"
innertablepadding="6"
headeralign="left"

Session.LCID = 1033

const maxprodopts=15
const helpbaseurl="https://www.ecommercetemplates.com/help/ecommplus/"

Function Max(a,b)
if a > b then
Max=a
else
Max=b
end if
End function
Function Min(a,b)
if a < b then
Min=a
else
Min=b
end if
End function
%>





and test.thymegraphics includes.asp is -
<%

' For a description of these parameters and their useage, please open the following URL in your browser

' https://www.ecommercetemplates.com/help/ecommplus/parameters.asp

' These are just a few examples of the parameters you can use to control

' your store. There are many, many more explained at the above URL.

mysqlserver=true

adminencoding="utf-8"



pagebarattop=0



usecategoryname=TRUE



nocatid=TRUE

showinstock=TRUE

usefirstlastname=TRUE

notifybackinstock=TRUE

removedefaultoptiontext=TRUE



detailnameh1=TRUE



' Shipping / Tax Options

taxShipping=0

taxHandling=0



willpickuptext="Pick up from store"

willpickupcost=0.00

willpickupnohandling=TRUE



estimateshipping=TRUE

autobillingtoshipping=FALSE



' Payment Options

payproviderradios=1

persistentcart=5

giftwrappingcost=0.8



' Layout Options

usecsslayout=TRUE

detailpagelayout="navigation,productimage,productname,discounts,price,listprice,currency,instock,reviewstarslarge,shortdescription,options,quantity,addtocart,productid,manufacturer,sku,dateadded,description,previousnext,searchwords,socialmedia,reviews"

productpagelayout="productimage,productname,reviewstars, instock, listprice,price,detaillink,quickbuy"

socialmediabuttons="askaquestion,emailfriend, facebook,linkedin,twitter,pinterest,google"

socialbuttonfacebook="<div class=""fb-like"" data-href=""%pageurl%"" data-layout=""button"" data-action=""like"" data-size=""small"" data-show-faces=""false"" data-share=""true""></div>"

quickbuylayout="productimage, productname, discounts,instock,reviewstars,productid, sku, description, options, listprice, price, currency, detaillink,addtocart"



defaultdescriptiontab="<ecttab title=""#xf036;   Info"">"

ecttabsspecials="<ecttab title=""#xf005;   Reviews"" special=""reviews""><ecttab title=""#xf0a9;   Related"" special=""related""><ecttab title=""#xf155;   Pricing"" special=""quantitypricing"">"



recentlyviewed=TRUE

recentviewlayout="productname,productimage"

numrecentlyviewed=8



quantityupdown=2



actionaftercart=3



useimageincart=TRUE

linkcartproducts=TRUE



' Email Options

useaskaquestion=TRUE

htmlemails=TRUE



' Customer Login

enableclientlogin=true

allowclientregistration=true

customeraccounturl="clientlogin.asp"



loyaltypoints=100

loyaltypointvalue=0.0001



' Customer Reviews and Ratings

enablecustomerratings=TRUE

detailreviewstarstext=" "



' Image Tweaks

imgdetaillink="button"

imgcheckoutbutton="button"



' Affiliate Options

expireaffiliate=30



' Discount Options

nogiftcertificate=FALSE



' Gift Registry and Wish Lists

enablewishlists=TRUE

wishlistonproducts=TRUE



' Cross Selling / Upselling

crosssellaction="bestsellers,related"

csbestsellerstitle="Our best sellers"

csrecommendedtitle="Recommended items"

bestsellerlimit=180



' Text entries

xxInStoc="<i class=""w3-margin-right fa fa-chevron-circle-right""></i>   In Stock"

xxPrId="<i class=""w3-margin-right fa fa-chevron-circle-right""></i>   Product ID"

manufacturerfield="<i class=""w3-margin-right fa fa-chevron-circle-right""></i>   Brand"

showproductsku="<i class=""w3-margin-right fa fa-chevron-circle-right""></i>   ISBN"

dateaddedlabel="<i class=""w3-margin-right fa fa-chevron-circle-right""></i>   Updated"

xxAddToC="#xf290;   Add to Cart"

xxAskQue="#xf27a;   Ask A Question"

xxEmFrnd="#xf0e0;   Email A Friend"

searchwordsheading="<i class=""w3-margin-right fa fa-search""></i> Search words"



xxPrDets="Details   #xf05a;"

xxQuiBuy="Quick Buy   #xf290;"

xxCOTxt="Checkout   #xf07a;"

xxBakOrd="Back Order   #xf290;"

xxConfig="Configure   #xf013;"

xxAddToC="#xf290;   Add to Cart"



xxCMCSC="<i class=""w3-margin-right fa fa-shopping-cart""></i>  View Cart"

xxMCCO="<i class=""w3-margin-right fa fa-shopping-cart""></i>  Checkout"

xxCMCClo="<i class=""w3-margin-right fa fa-close""></i>  Close"



xxEstimatorTitle="<i class=""w3-margin-right fa fa-truck""></i>  Delivery Estimate"



xxBasRat=""



%>

That looks fine.

I've had a look around and it seems to be a database problem rather than files, sessions or versions.

What I don't understand is how it can happen if both sites are connected to the same database.

I'll ask here if anyone has a n't suggestions.

Andy

Please feel free to review / rate our software

Thank you.
If it helps I can give you access to both ftp sites if I can send you the login details privately.
Also I did actually email you the login details to both stores earlier this week

Please do send me on the details and I'll see if I can find anything there.

Andy

Please feel free to review / rate our software

Email sent with details, thank you

That should be fixed now. There were a few things going on, the test site and live site were running different admin versions but on the same database. The vsadmin files all showed double spacing in a text editor. Finally the data length for rvsessionID was too short - thanks to the help from Phil at bettapages for that fix.

Andy

Please feel free to review / rate our software

Many many thanks!!
To both you and Phil!