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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Problems transferring to on-line server

Thread began 4/11/2015 8:47 am by Ian | Last modified 4/13/2015 1:02 pm by Ray Borduin | 353 views | 1 replies |

Ian

Problems transferring to on-line server

I have developed a web site which works perfectly (bar any bugs I have yet to find) on my PC - i.e. using the the localserver. I have transferred all files to my on line server and have updated the databases using Import on the on-line server and using the files generated on the local server using the Export facility. Therefore the on-line database and files should be a the same as what I have on my PC.
So why won't it work? Whenever I try to access a page on-line which needs data from any of the tables it comes up with the unhelpful error message "Error in SQL syntax".It is the same syntax that is on the PC setup which works, so why won't it work on the on-line server?Clearly a basic newby error but I would appreciate a pointer as to what it is! Thanks. URL of on-line setup is bega.org.uk if that helps.

I note that this question has been asked before but the answers usually address a specific issue rather than this very basic and general one so unfortunately have not helped me..

Sign in to reply to this post

Ray BorduinWebAssist

You can turn on debug mode in the mysqli include files. Then it will give you a better error that will tell you what might be the issue. It could be bad credentials or missing tables, but turning on the debug mode will give you the actual error instead of a general message.

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