close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

tables not being found

Thread began 1/04/2020 9:16 am by Patrice | Last modified 6/22/2020 2:16 pm by Ray Borduin | 1561 views | 31 replies |

PatriceWebAssist

tables not being found

I have a ton of sites on my dedicated server. Suddenly, none of the bindings are working - not in the classic and not in the new mysqlil set up. I've checked about 5 sites so far. About a year ago, my server changed to MariaDB, and I ran into a few snags but with some adjustments, it was ok. This is a new problem.

The pages are still displaying ok, but I can't create any new bindings.

I am up to date, as far as I can tell with WA updates.

Any ideas? This isn't anything that the server gods will be able to assist me with.

Using GL6, Mac.
I checked server status and all systems appear to be "up."

Sign in to reply to this post

PatriceWebAssist

I opened a ticket with server gods, and all systems are ok.
Anyone have any ideas?

Sign in to reply to this post

PatriceWebAssist

I renamed Configuration file. I clicked on and off in extend manager for WA tools. Reopened DW, same results. Sites can not see any tables.
Getting desperate here. Anyone have any ideas?

Sign in to reply to this post

PatriceWebAssist

Checking new Config files, there is a WA_DBScript.php script with a June 14, 2019 name. Is there a newer script that should be here instead?

Sign in to reply to this post

Ray BorduinWebAssist

I don't think the issue would be with that script. Give me a call and we can screen share to debug this and figure out what is going on.

Sign in to reply to this post
Did this help? Tips are appreciated...

PatriceWebAssist

ok...thanks!

Sign in to reply to this post

PatriceWebAssist

Thanks for the solution, Ray!
Posting the solution for anyone else that may have encountered it.
At the beginning of the year, my server updated all its auto SSL certs. I have a redirect on my cPanel for all sites to push to https.
Evidently, DW6 code may be too old for newer SSL certs.
Ray changed the htaccess code to include the line that bypasses the auto redirect to mmServerScripts files.

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{SERVER_PORT} !^443$
RewriteCond %{REQUEST_URI} !/_mmServerScripts/.*
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
</IfModule>

Hope that helps someone else!

Thanks again Ray!

Sign in to reply to this post

PatriceWebAssist

Spoke too soon. I moved to another site to make this change but it wasn't successful. I'll try more.
Also not mentioned in above solution was to change the Manage Site server info to include https as one idea. It didn't work for me, however.
More when I have more tests.

Sign in to reply to this post

PatriceWebAssist

Interesting development:
One site doesn't have anything in htaccess except the 401redirect and the db tables are fine.
more testing to follow

Sign in to reply to this post

PatriceWebAssist

Further checking: the site that has no problem doesn't have the forced https in cpanel turned on. Server guys are looking at these notes also to see if they can spot anything.

Sign in to reply to this post
loading

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...