error while saving entry

Found a bug? Tell us!!
stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

error while saving entry

Post by stm999999999 » Sun Jul 19, 2009 11:54 pm

hi folks,

what want s9y say to me here?

Sende XML-RPC ping zu ping.feedburner.com...Success!!
Error:
SELECT max(v.version) AS maxVer,
v.id,
a.realname,
v.version_date
FROM serendipity_xxx_versioning AS v
LEFT OUTER JOIN serendipity_xxx_authors AS a
ON a.authorid = v.version_author
WHERE entry_id = 259
GROUP BY v.entry_id, v.id, a.realname, v.version_date
ORDER BY v.version DESC
/ MySQL server has gone away. Postgresql is driving me nuts.

HTTP_Request Object ( [_url] => Net_URL Object ( [url] => http://www.google.com/webmasters/sitema ... map.xml.gz [protocol] => http [username] => [password] => [host] [...]
Bad Request
Error 400
[_chunkLength] => 0 [_listeners] => Array ( ) ) [_allowRedirects] => [_maxRedirects] => 3 [_redirects] => 0 [_useBrackets] => 1 [_listeners] => Array ( ) [_saveBody] => 1 [_readTimeout] => [_socketOptions] => ) Konnte Update nicht an http://www.google.com melden: http://www.google.com/webmasters/sitema ... Alternativ kann sie auch in die robots.txt eingefügt werden.

Warning: Invalid argument supplied for foreach() in /xxx/s9y/plugins/serendipity_event_entryproperties/serendipity_event_entryproperties.php on line 670
Der Eintrag wurde gespeichert (Anzeigen)
Ciao, Stephan

User avatar
yellowled
Regular
Posts: 7111
Joined: Fri Jan 13, 2006 11:46 am
Location: Eutin, Germany
Contact:

Re: error while saving entry

Post by yellowled » Mon Jul 20, 2009 12:19 am

stm999999999 wrote:what want s9y say to me here?

Phew. That's a load of code I only partially understand, but it seems as if there was some kind of a timeout (MySQL-related?) while trying to send an update of your sitemap to Google using the Google Sitemap plugin. Then again, the last line suggests that this might be somehow related to the extended entry properties. Does the blog in question make heavy use of extended entry properties?

You should by any means keep an eye on this and check if it happens regularly and over a longer period of time (which would suggest that it is a valid issue, not just a temporary server timeout).

YL
amazon Wishlist - Serendipity-Podcast (German only, sorry)

stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by stm999999999 » Mon Jul 20, 2009 2:13 am

more precisely I mean the "SELECT max(v.version) AS maxVer, ... / MySQL server has gone away. Postgresql is driving me nuts."-part and perhaps the "serendipity_event_entryproperties.php on line 670"

I wrote two entries after this - no problem. :!: :?:


And no, I do not have an heavy use of entryproperties.
Ciao, Stephan

User avatar
yellowled
Regular
Posts: 7111
Joined: Fri Jan 13, 2006 11:46 am
Location: Eutin, Germany
Contact:

Re: error while saving entry

Post by yellowled » Mon Jul 20, 2009 12:02 pm

stm999999999 wrote:more precisely I mean the "SELECT max(v.version) AS maxVer, ... / MySQL server has gone away. Postgresql is driving me nuts."-part and perhaps the "serendipity_event_entryproperties.php on line 670"

Hm. Do your actually use a PostgreSQL database?

That particular line is "$avail_users =& $this->getValidAuthors();" -- is this even a multi-author blog?

YL
amazon Wishlist - Serendipity-Podcast (German only, sorry)

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: error while saving entry

Post by garvinhicking » Mon Jul 20, 2009 3:54 pm

Hi!

Never mind that pgsql part. The code is triggered when an error appears, which is usually only in certain postgresql setups. In your case, the MySQL server seems to die. You should ask your provider to inspect the mysql server logs why this happens.

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by stm999999999 » Mon Jul 20, 2009 4:04 pm

ok, I will do so.

And what is about the serendipity_event_entryproperties.php-issue? same source of the problem?
Ciao, Stephan

User avatar
Oliver
Regular
Posts: 178
Joined: Mon Jan 10, 2005 7:43 pm
Location: Herne, Germany
Contact:

Re: error while saving entry

Post by Oliver » Tue Jul 21, 2009 12:17 am

stm999999999 wrote:And what is about the serendipity_event_entryproperties.php-issue? same source of the problem?


After updating to 1.4.1 I get the same error when saving an entry:

Warning: Invalid argument supplied for foreach() in /is/htdocs/49513/www.forum4winde.de/mods/s9y/plugins/serendipity_event_entryproperties/serendipity_event_entryproperties.php on line 670
Image

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: error while saving entry

Post by garvinhicking » Wed Jul 22, 2009 7:00 pm

Hi!

The entryproperties line happens when no authors other than you are available or when you have no privileges to view other authors. Which dropdown values do you get in the entryproperties section for the entry ownership? An empty dropdown? How many authors does your blog have, and as which userlevel are you logged in?

Regards
,Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by stm999999999 » Thu Jul 23, 2009 9:57 pm

garvinhicking wrote:the entryproperties line happens when no authors other than you are available or when you have no privileges to view other authors. Which dropdown values do you get in the entryproperties section for the entry ownership? An empty dropdown? How many authors does your blog have, and as which userlevel are you logged in?



there is only one author/user = me and I am 255/admin
Ciao, Stephan

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: error while saving entry

Post by garvinhicking » Sat Jul 25, 2009 7:49 pm

Hi!

And you do see the dropdown, and it contains your author names as the single option?

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by stm999999999 » Sun Jul 26, 2009 1:58 am

double yes
Ciao, Stephan

User avatar
blog.brockha.us
Regular
Posts: 695
Joined: Tue Jul 03, 2007 3:34 am
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by blog.brockha.us » Sun Jul 26, 2009 6:19 pm

Warning: Invalid argument supplied for foreach() in /xxx/s9y/plugins/serendipity_event_entryproperties/serendipity_event_entryproperties.php on line 670
Der Eintrag wurde gespeichert (Anzeigen)


RobLen reported exactly the same problem now. He never had this before but after "upgrading some plugins" as he said, this problem popped up, too.

Trying to do some debugging with him..
- Grischa Brockhaus - http://blog.brockha.us
- Want to make me happy? http://wishes.brockha.us/

stm999999999
Regular
Posts: 1517
Joined: Tue Mar 07, 2006 11:25 pm
Location: Berlin, Germany
Contact:

Re: error while saving entry

Post by stm999999999 » Sun Jul 26, 2009 9:37 pm

JFTR: in the moment it was a single error occurrence, but IIRC I had this problem month before, too.
Ciao, Stephan

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: error while saving entry

Post by garvinhicking » Mon Jul 27, 2009 10:05 am

Hi!

Hm, okay...strange. I can't really reproduce that, so if you find anything, Grischa, let me know :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

blackmagic
Posts: 2
Joined: Sat Aug 01, 2009 12:05 pm

Re: error while saving entry

Post by blackmagic » Sat Aug 01, 2009 12:12 pm

Guys i get another bug :( . whenever i try to embed some free music for my site visitors from my free music site, it just gives me a MYSQL error :(

Any helps??

Post Reply