close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Finally wanting to convert to Mysqli, but ...

Thread began 8/09/2019 12:15 am by Roxana | Last modified 8/23/2019 5:18 pm by Roxana | 109 views | 23 replies |

Roxana

Finally wanting to convert to Mysqli, but ...

... the local server I am using (MAMP Pro) only has Mysql options, nothing with Mysqli. Will that be a problem? I heavily rely on local testing before putting pages online.

My profile shows I am up to date with Design extender and eCart. So I will be getting Data Bridge v2 and MySQLi Server Behaviour. Will I be all set with that?

Thanks in advance :)

Sign in to reply to this post

Roxana

Update

Bought the extensions. Updated the data connection, but when I test it, I get the error message in the screen shot. Going back to the original pages, I get the same error code.

Sign in to reply to this post

Ray BorduinWebAssist

This is an issue with your Dreamweaver site definition. Usually it is a bad site URL setting. I'd have to see your connection information to be sure, but look at the testing server settings and make sure they are all correct. If you can't spot the issue then I may need you to send me your site definition export so I can re-create the problem from here.

Sign in to reply to this post

Roxana

I can't spot the mistake.

Sign in to reply to this post

Ray BorduinWebAssist

We could do a ticket. I'd start by uninstalling and reinstalling WAMP. You won't be able to connect to a database that won't start in the first place. Just call the number at the bottom of every webassist page to schedule a screen sharing session to look into this further, or post your phone number and I'll call you.

Sign in to reply to this post

Roxana

A little progress with MAMP instead of MAMP PRO

Sign in to reply to this post

Ray BorduinWebAssist

It looks like your localhost server is running php7 and your site is still using standard MySQL. You might want to use php6 until your site is fully converted.

Sign in to reply to this post

Roxana

I change php version and was able to connect to the local server. I will try converting a file to MySQLi over the weekend. Is there a tutorial for existing pages to convert them?

Sign in to reply to this post

Ray BorduinWebAssist

You just have to:

1) Create a MySQLi connection
2) open each Recordset, Insert, Update, and Delete server behavior and choose the new connection and click "ok"

Sign in to reply to this post

Roxana

Hi Ray, with the help of the extension I switched some of the pages over to MySQLi, some however are giving me trouble. Should I post them one by one, or should we do them all in a screen sharing session?

Error messages include:
- Error: the object is not currently contained in a document
- No data supplied for parameters in prepared statement
- Commands out of sync; you can't run this command now

The last two error messages appear under one of the recordset, that is displayed instead of the page.

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