Database connection error (2): Could not connect to MySQL.
By Rob on Thursday, 11 September 2014
Posted in General Issues
Replies 5
Likes 0
Views 1.8K
Votes 0
Hello,

I still keep on receiving this informational message:

Database connection error (2): Could not connect to MySQL.

Now I am thinking that the reason that I am receiving the above message is because the post is till being written to the DB but the link for the data feed has been posted to Twitter and it usually takes a minute once the link from twitter is clicked on for the post to resolve in my browser.

Now we live in a fast paced internet where the end user expects speed, so in this one minute that it takes for the post to resolve we could be losing a few end users who want to read our information.

Isn't there a way to delay the Twitter post until posts that are auto feed are situated ion the DB correctly? Excuse me if I am not making sense but I have asked this before and I am sure there must be a way to have the feeds post to the DB and then after a 15-30 second delay before the automatic Twitter posts go to Twitter.

Thank you again for your time. If I have time I will make a video so you can see what is happening.

Regards,
Rob
Hello Rob,

I don't think it would make sense to have a timer unless you are trying to auto post to 1,000 different sites, it should be auto posted instantly as that would be an expected user experience
Mark
·
Friday, 12 September 2014 15:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Rob,

I think the problem has something to do with your server's connection. Before it get's submitted to the server, when performing the auto post, it probably took a while due to connectivity issues. Hence, when the script returns, MySQL actually timed out before it reaches back.

There's unfortunately no way around this unless you perform a manual auto post instead of an automatic auto post. In other words, rather than having it autoposted automatically when you create a post, you will need to click on those social icons in the blog listings to manually auto post them.
Mark
·
Thursday, 11 September 2014 11:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you Mark for your well explained answer. I agree with you.

How about a timer delay within Joomla to auto post the received auto feeds at a certain time. Or if you know of something that does this already.

Thanks again for your time. Hope all is well.

Regards,
Rob
Rob
·
Thursday, 11 September 2014 22:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay that would make sense .

I was just thinking if you wanted to streamline the automation of tweet posting. Such as when you write a blog. You can specify what time and date you want the Publishing Date to be. Thanks again my friend Mark - have a nice weekend.

Regards,
Rob
Rob
·
Friday, 12 September 2014 17:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Noted, thanks for the heads up on this Rob
Mark
·
Friday, 12 September 2014 17:30
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post