Login | Sign up | Toll-Free: 1-800-752-0455
 
 

Forum

 

6 posts by 2 authors in: Forums > CMS Builder
Last Post: April 30, 2009

Hello,

I am having a problem with CMSB retrieving data for the footer of the page only. Everything else above the main contents area is appearing. The error message is printed at the end of this message.

The URL is http://www.lakesideworlddarts.co.uk/subscribe_test.php where the full source code can be viewed (PHP show-source).

This problem occurred AFTER I inserted two includes in the main content area. These includes queried another database to populate two drop down boxes. After that I cannot figure out how to reconnect with the CMSB database to retrieve the content for my footer.

Can you tell me how to achieve this please?

Thanks
Terry

---- ERROR MESSAGE ------

Warning: mysql_query(): Access denied for user: 'lakedarts@localhost' (Using password: NO) in /home/lakedarts/www/www/cms_admin/lib/viewer_functions.php on line 146 Warning: mysql_query(): A link to the server could not be established in /home/lakedarts/www/www/cms_admin/lib/viewer_functions.php on line 146 getRecords(lakeside_darts) MySQL Error: Access denied for user: 'lakedarts@localhost' (Using password: NO)

Re: [terryally] Connection problem on footer of page only

Hi Terry

I am wondering if the extra includes is bumping you into a connection limit or some sort. Like, you can only connect to the database with the same account a certain amount of times in quick succession.

I don't know for sure though so I'd like to run a couple tests. Could you email me FTP details to your server through ross@interactivetools.com? If you could link back to this forum post as well, that would be great!

Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [terryally] Connection problem on footer of page only

Hi Terry

I just replied to your email but wanted to post here for anyone else following along.

Basically, the problem here is going to be that the MySQL username or password you are using in one of the two includes files before your footer code is incorrect.

This is where the error message comes from and because it's throwing an error, the footer code doesn't even get a chance to run.

If you remove all the CMS Builder footer code you have there, you'll see that the error messages are still there.

You'll need to double check the login details for your includes and then that should get things going.

Keep me up to date with how you are making out. Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

Re: [ross] Connection problem on footer of page only

Hi Ross,

I got your note and I just responded in a fairly comprehensive way.

Basically, I removed the footer and the message vanished. I believe that the CMSB connection closed after I open a second connection. Perhaps there is a way to reopen it for the footer?

Terry

Re: [terryally] Connection problem on footer of page only

Hi Terry.

I agree with you on this one. There is defintiely something thought you'll want to put into the structure of the data before you get started.

The main thing to keep in mind though is that we are here to help even at that stage. So it's better to think it out first, ask us as many questions as you need and then start setting up the database.

Keep me up to date with how you are making out. We are always here to help :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/