Page 1 of 2

error while saving entry

Posted: Sun Jul 19, 2009 11:54 pm
by stm999999999
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)

Re: error while saving entry

Posted: Mon Jul 20, 2009 12:19 am
by yellowled
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

Re: error while saving entry

Posted: Mon Jul 20, 2009 2:13 am
by stm999999999
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.

Re: error while saving entry

Posted: Mon Jul 20, 2009 12:02 pm
by yellowled
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

Re: error while saving entry

Posted: Mon Jul 20, 2009 3:54 pm
by garvinhicking
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

Re: error while saving entry

Posted: Mon Jul 20, 2009 4:04 pm
by stm999999999
ok, I will do so.

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

Re: error while saving entry

Posted: Tue Jul 21, 2009 12:17 am
by Oliver
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/ser ... erties.php on line 670

Re: error while saving entry

Posted: Wed Jul 22, 2009 7:00 pm
by garvinhicking
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

Re: error while saving entry

Posted: Thu Jul 23, 2009 9:57 pm
by stm999999999
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

Re: error while saving entry

Posted: Sat Jul 25, 2009 7:49 pm
by garvinhicking
Hi!

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

Regards,
Garvin

Re: error while saving entry

Posted: Sun Jul 26, 2009 1:58 am
by stm999999999
double yes

Re: error while saving entry

Posted: Sun Jul 26, 2009 6:19 pm
by blog.brockha.us
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..

Re: error while saving entry

Posted: Sun Jul 26, 2009 9:37 pm
by stm999999999
JFTR: in the moment it was a single error occurrence, but IIRC I had this problem month before, too.

Re: error while saving entry

Posted: Mon Jul 27, 2009 10:05 am
by garvinhicking
Hi!

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

Regards,
Garvin

Re: error while saving entry

Posted: Sat Aug 01, 2009 12:12 pm
by blackmagic
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??