close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

... webassist/mysqli/queryobj.php on line 450

Thread began 9/07/2018 8:36 am by randyrie405335 | Last modified 9/10/2018 10:51 am by Ray Borduin | 1688 views | 10 replies |

randyrie405335

... webassist/mysqli/queryobj.php on line 450

I've exhausted all attempts to remedy this error:

Fatal error: Uncaught Error: Call to a member function Prepare() on null in /Library/WebServer/Documents/FaithCentre-PG/webassist/mysqli/queryobj.php:450 Stack trace: #0 /Library/WebServer/Documents/faithcentre-pg/donate_money.php(28): WA_MySQLi_Query->execute() #1 {main} thrown in /Library/WebServer/Documents/FaithCentre-PG/webassist/mysqli/queryobj.php on line 450
[which reads ... $query = $this->Connection->Prepare($this->Statement);]

It only happens for just one of my forms on one of my sites. ALL the other forms on the other sites that are similarly configured work fine. I need this to work by Monday so I'm under a tight deadline.

Sign in to reply to this post

Ray BorduinWebAssist

Please send FTP information and a URL for debugging and I can help you debug this issue.

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

randyrie405335

The FTP credentials are listed in my private message... Let me know if you cannot access

Sign in to reply to this post

Ray BorduinWebAssist

You are trying to insert a value into the column "Cell", but it doesn't exist in your database.

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

randyrie405335

Yeah... I was working on that when you tested. I've removed the "cell" field from the forms and the database. Please review the "Donate Money" tab and see if you get any errors... the form does not insert nor send its email. The "Donate Time" form sends its email while the very similar "Donate Items" does not. I'm probably too close to this to see what the issues are since I've been pounding on this for three days now.

Sign in to reply to this post

randyrie405335

I just noticed the only difference between the "Time" and "Items" forms was that the "Items" form included encryption "multipart/form-data" ... when I removed it, the form sent its email. The email extension cannot handle encrypted forms?

Still cannot get the "Donate Money" form to insert its data nor send its email.

Sign in to reply to this post

Ray BorduinWebAssist

Setting the enctype won't have an effect. Something else might have changed.

The Donate money page still isn't working because you are trying to insert into the "Cell" column and that column doesn't exist in the database.

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

randyrie405335

You must be on the wrong site/page... the current posted Money page does not have a cell field. Are you using faithcentre.info ... /FaithCentre-PG (case sensitive) as the remote directory? I've not removed the old site yet (lower case "pg") until I can get the forms to all work.

Sign in to reply to this post

Ray BorduinWebAssist

Your connection is wrong in the FaithCentre-PG folder. It looks like you have it set to your localhost connection.

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

randyrie405335

Update

My install of DB v2.2 must have gone corrupt - maybe because I was really pounding out the pages to make my Monday deadline and screwed something up. I removed it from DWCS6 and installed the earlier Beta (which didn't function properly at all), removed the configuration file, re-installed DB v2.2 and rebooted my Mac. After re-configuring DWCS6, I re-ran the Money form and it worked perfectly - no queryobj error.

The form still does not work on my host site and I believe the cause is that the host site is running PHP 5.3. I am moving the FaithCentre site from the host's old server to a newer one running PHP 5.6 and reconfigure the connect script to be the same as my localhost. I'm hoping this will resolve why the Money form will not work on the host even though it does work fine on localhost. I assume the email should work as well since it does for the other two forms.

Thanks for your help with all this, BTW. Your expertise is always greatly appreciated.

And the saga continues...

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