close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQLi Login has broken since updating site with a SSL certificate and static IP

Thread began 9/06/2017 6:36 pm by davidtricker376400 | Last modified 9/07/2017 11:28 am by Ray Borduin | 49 views | 4 replies |

davidtricker376400

MySQLi Login has broken since updating site with a SSL certificate and static IP

Hello,

I've been running this site and cms (in a subdomain) for a couple of years. Yesterday the client wanted to update to a https address. I purchased a PositiveSSL Wildcard and Static IP from JustHost and after a couple of hours the front end was working; the cms subdomain was not.as it was were the site images were stored. Reading further I updated the .htaccess file with the following code:

# Justhost.com
#.htaccess WildCard SSL
RewriteEngine On
RewriteCond %{HTTP_HOST} ^subdomain.example.com$
RewriteCond %{REQUEST_URI} !^/subfolder/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /subfolder/$1
RewriteCond %{HTTP_HOST} ^subdomain.example.com$
RewriteRule ^(/)?$ subfolder/index.php [L]

Substituting my subdomain and domain. Hooray. Everything worked.
.
I tried to login to the CMS only to discover that the page would refresh with the subdomain/index.php url and an error Error in SQL syntax.

I have done everything I can think of to fix this problem. Any help would be greatly appreciated

Sign in to reply to this post

Ray BorduinWebAssist

Can I get a url to reproduce the problem and the username and password you used in the private area. I may need FTP access as well in order to fully debug and find the solution.

Sign in to reply to this post

davidtricker376400

Thanks Ray, requested information sent via PM

Sign in to reply to this post

Ray BorduinWebAssist

You didn't update your connection for the domain: cms.yoursite.com

So it was trying to use your testing server connection information and failed to connect to the database. I updated the connection file and it appears to have fixed the problem.

Sign in to reply to this post

davidtricker376400

Ray, thanks for looking at this, From the form submission of the cms index.php page, a successful login should take you to cms.domain.com/pages/ folder, your amendment makes it clear that the page is instead taking you to cms.domain.com/index.php, which is a .htaccess mirror of the domain.com/index.php page. I think something is missing from the .htaccess allowing other pages in the subdomain other that index.php, /pages/index.php for example.

I've now updates the .htaccess record, which stops the redirect, the form on the CMS login page now redirects successfully.

Many thanks again for looking at this.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...