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

Re: "Step 4: Delete entered email" in 'Web Development tutorial series: Add a subscribe/unsubscribe' feature

Thread began 4/12/2020 8:58 am by yogastudents362523 | Last modified 5/25/2020 1:18 pm by Ray Borduin | 414 views | 89 replies |

yogastudents362523

Re: "Step 4: Delete entered email" in 'Web Development tutorial series: Add a subscribe/unsubscribe' feature

Since upgrading to PHP 7 and MySQLi means I can no longer use PowerMessenger, ran through above tutorial to create subscribe/unsubscribe features.

Subscribe page created OK using tutorial.

For Step 4 which is the Delete entered email step, DataAssist reports that it cannot proceed, giving error message that "SQL type not recognized". After clicking through many of these errors, the dialogue box sits stubbornly reports that it can find no tables.

I am again presuming that it is a MySQLi against MySQL issue?

Thank you,
KB

Sign in to reply to this post

Ray BorduinWebAssist

PowerMessenger has not been updated for use with php7 yet. You will have to run php6 or earlier. MySQLi will still work on the same site as MySQL you just have to run an earlier version. You wouldn't have to update anything on the pages.

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

yogastudents362523

Hi,

I upgraded to use a particular piece of forum softward.
PowerMessenger is more useful to me, so I may well abandon it and downgrade.
Decision pending.
Thanks for the info on exactly what the issue might be.

Thank you for your kindness,
KB

Sign in to reply to this post

Ray BorduinWebAssist

I'll see if I have time to update Power Mailer over the next couple of weeks. There aren't that many database references so it shouldn't take too long to do.

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

yogastudents362523

That would be appreciated indeed!
However, it is far from a priority as I am managing, and I am sure there are more important projects concerning your other products.
Nevertheless, thank you,
KB

Sign in to reply to this post

yogastudents362523

I only just today received a passingly coherent response to my message to Support of my mail company that handles the emails that PowerMessenger generates. The last part of what they say is:

"To investigate … could you please use the website and script to send an email to me at xxxxxxxxx ? Please let me know once the email is sent and I'll check on this. If this email can be triggered by me from your website, please point me to the website and I'll use it to send some test emails to me.

Unfortunately, the upgrade of my site to PHP 7.x and MySQLi has rendered PowerMessenger unusable, and I can no longer enter the admin backend to generate the said test emails so they can work on the issue I raised with them.

Please could you indicate to me how these can be generated, and so the company can investigate?

Thank you,
KB

(Reminder: my login name and password are hardwired in to a PHP script somewhere or other, and the email forward is then unable to do what it usually does, and put a more "friendly", not to say accurate, address as source of those emails. They instead stubbornly go out with my login name)

Sign in to reply to this post

Ray BorduinWebAssist

I put up a php 7 compatible version in the folder:

powermessenger_php7

You can use that to send any test emails you need. Just go to a mailing and click Send Preview and enter the email address you want to send it to.

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

yogastudents362523

Thank you!
Will go and play around with it now.
KB

Sign in to reply to this post

yogastudents362523

Hi,

Sorry for the delay in getting back to you.

I eventually could not avoid upgrading my server to Centos 7.x with native PHP 7 loaded upon it; with Plesk Obsidian.

The whole thing was a complete and absolute nightmare, and I am only just getting things to normal.

I wish to report, now, that it looks as if the updates you made to PowerMessenger are working fine. I have only tried a couple of things for the last 5 minutes now that I have access again, and the few things I have tried to do with it are working OK

Thank you very much and I again apologise for the delay in getting back to you.

With every good wish,
KB

Sign in to reply to this post

yogastudents362523

Hello,

SECURITY CODE issue

The Registration Page at:
https://www.xxxx/powermessenger_php7/users_registration.php

asks for a security code … but no such code is in fact loaded.

I see only a few boxes with slanting diagonals and vertical lines. No code exists to be copied.

Thank you,
KB

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