Connection problem on footer of page only
6 posts by 2 authors in: Forums > CMS Builder
Last Post: April 30, 2009 (RSS)
By terryally - March 28, 2009
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
By ross - March 30, 2009
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
By ross - April 1, 2009
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
By terryally - April 1, 2009
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
By terryally - April 29, 2009
Essentially I was using the multi-record section editor and that does not like other non-CMSB database connections on the same page so it throws a tantrum.
However the single record section editor doesn't mind another connection.
The bottom line is that CMSB does have its limitations in this respect and once you know that you can decide what type of section editor to use or whether CMSB is appropriate the job at hand.
The only solution in my case was to start from scratch and re-code the entire site - which I am not going to do!
If I am wrong, I am sure Ross will correct me.
Terry
Re: [terryally] Connection problem on footer of page only
By ross - April 30, 2009
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/