close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Blank pages

Thread began 8/04/2010 3:21 am by FPeter | Last modified 8/05/2010 2:31 pm by Eric Mittman | 1850 views | 6 replies |

FPeter

Blank pages

I have used the SecurityAssist wizard to create pages for log in, registration and log out but I'm getting blank pages.

I inserted the code to display errors and got this:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.sites/123/site19/web/Connections/Desmond.php on line 9

Fatal error: Access denied for user 'root'@'localhost' (using password: YES) in /home/.sites/123/site19/web/Connections/Desmond.php on line 9

When I try to view it using F12 I get this:


Warning: require_once(Connections/Desmond.php) [function.require-once]: failed to open stream: No such file or directory in C:\xampp\htdocs\dbusers_Registration.php on line 1

Fatal error: require_once() [function.require]: Failed opening required 'Connections/Desmond.php' (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\dbusers_Registration.php on line 1

I'm really under pressure with this as this project needs to be completed today and another project using Data Assist completed by Friday and I can seem to get anything to work correctly, even using the instructions and examples.

Help needed please.
Peter

Sign in to reply to this post

FPeter

Is anyone there?

Sign in to reply to this post

Eric Mittman

The first error you are getting is telling you that the details in your connection file on your server are not correct. The values that you have specified in here do not have access to the db. You will need to update the details in the connection file on your live server with the correct username and password in order to access the db. You may also need to adjust the host value that points to the db. You should have the values you need for this in the settings on your hosting account, if you can't get to them you may need to contact your host to help you retrieve them.

The second error you are getting when you test locally is telling you that the connection folder is not in your web root. What folder are you storing the files in locally on your web server? You will need to adjust the testing server URL value to match the location of the files on your local server.

Sign in to reply to this post

FPeter

Hi Eric

I sorted the second error by saving the file to the htdocs folder in the xampp on my hard drive.

Is it just the localhost part in connetions file or will it also be username and password that need changed?

Thanks for the help
Peter

Sign in to reply to this post

Eric Mittman

You will need to make sure that the connection file that you use on the live server matches the connections details needed to access your live db. It is very common to have the host set to localhost but you should check your hosting settings to make sure you are using the correct value for this setting.

Sign in to reply to this post

FPeter

Cheers Eric

I am working on two projects at the same time and just managed to get Data Assist to connect to a database when uploaded, after checking the details and changing the database nane etc so I will probably be able to configure the Security thing the same way.

Many thanks for the help and pointing me in the right direction.

Peter

Sign in to reply to this post

Eric Mittman

It is very common to need different versions of the connection file. One thing that I will usually do is to keep the different versions in the connection file and just make sure not to upload the connection folder everytime.

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