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

Database pages not displaying

Thread began 9/03/2020 2:39 am by iain331081 | Last modified 9/07/2020 3:07 pm by Ray Borduin | 24 views | 6 replies |

iain331081

Database pages not displaying

This is actually an old site I did ages ago, and something has happened that has caused the database pages to not appear. I hadn't changed anything, so not sure what it is. I have checked the following:

- that the files were present and correct as they had been
- that the database and database user were present and correct as they had been
- that the PHP version was up-to-date

I also tried the following:

- updating the code to mySQLi
- created a new database user to check there were no issues with the existing user

None of that has resolved it though, so wondered if you could have a quick look? Its just a straightforward page showing a list of towns. I have also advised the site owners to contact the hosting company.

I have attached the page below. If it looks OK, I'll assume its an issue on the hosting side of things. Thank you.

Sign in to reply to this post

Ray BorduinWebAssist

Add this to the top of your page if you get a blank page to see the error:

php:
<?php

ini_set
("display_errors",1);
?>



I did that and it said you hadn't uploaded the file /webassist/mysqli/rsobj.php

So I uploaded that file and the page seems to load now.

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

iain331081

Thanks Ray. I have that working now, and also the register page. There is still an issue on the page that shows the list of places when you click on a town on this page:

http://www.keepsafeglos.org/safe_places/

Sign in to reply to this post

Ray BorduinWebAssist

The delete server behavior and repeat regions on the page weren't updated to mySQLi. I updated them and the page seems to load properly now. Make sure to download the updated page for your records.

It looks like you weren't using the delete functionality, so I removed it entirely.

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

iain331081

Thanks Ray. I've been going through all the pages in the admin section to SQLi, and its all been nice and straightfoward. None of the stuff I had with DW being picky with some of the safari stuff from before.

I do have an issue with a couple of pages though, which are reporting SQL errors. The user details page and the update user page, ie the ones that are getting the user based on the ID in the URL. I'm not sure of the syntax to try changing anything, but hopefully something pretty minor.

I have attached them below.

Sign in to reply to this post

Ray BorduinWebAssist

You had some hand coded sections that caused the delete and update server behaviors to not update to MySQLi. I've fixed it on those two pages so they should work properly now.

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

iain331081

Thanks Ray.

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