May 4, 2011

Database error MySQL server has gone away | CyberSEO Pro | Support Forum

Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Related Related Topics sp_TopicIcon
Database error MySQL server has gone away
Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 Topic Rating: 0 (0 votes) 
December 13, 2011
8:32 pm
Avatar
cyber1
Guest
Guests

Hello Admin,

I'm having issues running the CyberSEO consistently from one site to another. One site is running great while others have stopped running. I am able to run the jobs manually, but through CRON just showing showing Next Update “ASAP” and not progressing further.

And the logs appear to show SQL queries timing out (plus 'class-http.php' warnings):

[13-Dec-2011 15:00:37] WordPress database error MySQL server has gone away for query INSERT INTO `wp_postmeta` (`post_id`,`meta_key`,`meta_value`) VALUES (‘1′,’cyberseo_rss_source’,’http://www.feedsapi.com/makefulltextfeed.php?url=http%3A%2F%2Fnews.search.yahoo.com%2Frss%3Fei%3DUTF-8%26p%3Dprogress%2B%2522world%2Btrade%2Bcenter%2522%26n%3D10%26va%3Dprogress%26va_vt%3Dany%26vo_vt%3Dany%26ve_vt%3Dany%26vp%3Dworld%2Btrade%2Bcenter%26vp_vt%3Dany%26fl%3D0%26timeago%3Dtwoweeks%26smonth%3D10%26emonth%3D11%26sday%3D19%26eday%3D18’key=20’hash=6f543c0ccaea71d6ca59611abb15d00a653e7258’max=7’links=remove’exc=1’what=auto’#039;) made by shutdown_action_hook, do_action, call_user_func_array, cseo_update_feeds, CyberSEO_Syndicator->syndicateFeeds, CyberSEO_Syndicator->parseFeed, CyberSEO_Syndicator->endElement, CyberSEO_Syndicator->insertPost, add_post_meta, add_metadata
[13-Dec-2011 15:19:42] PHP Warning:  parse_url(://RPC2/) [<a href=’function.parse-url’>function.parse-url</a>]: Unable to parse URL in /home/seohost2/public_html/oneworldtradecenternyc.com/wp-includes/class-http.php on line 120
[13-Dec-2011 15:19:42] PHP Warning:  parse_url(://RPC2/) [<a href='function.parse-url'>function.parse-url</a>]: Unable to parse URL in /home/seohost2/public_html/oneworldtradecenternyc.com/wp-includes/class-http.php on line 120

Can you make any sense here?

Note: I've switched the post filter over to regex expression (could this be the issue causing the timeout);

Login to see the code

Sincerely,
Cyber1

December 13, 2011
8:38 pm
Avatar
CyberSEO
Admin
Forum Posts: 3718
Member Since:
July 2, 2009
sp_UserOfflineSmall Offline

Here is the explanation of your error message: /forum/support-eng/getting-cannot-insert-into-wordpress-database-error-log-sample/

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 541

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ninja321: 84

s.baryshev.aoasp: 64

Freedom: 61

MediFormatica: 49

B8europe: 47

saviulisse67: 45

Member Stats:

Guest Posters: 338

Members: 2688

Moderators: 0

Admins: 1

Forum Stats:

Groups: 1

Forums: 5

Topics: 1552

Posts: 7847

Newest Members:

daniel.teamsnordic, pete.pjboyle, kasunperera7b, glover.lemuel1, mmckenna0000uk, dr.tjey

Administrators: CyberSEO: 3718