Serendipity Forums

Posted: **Thu Dec 28, 2006 3:26 pm**

s9y 1.2-alpha1 und PHP 4.4.4

Until some days I have following errors after clicking "save":

Error: 
SELECT max(v.version) AS maxVer,
                           v.id,
                           a.realname,
                           v.version_date
                      FROM serendipity_stm_versioning AS v
           LEFT OUTER JOIN serendipity_stm_authors AS a
                        ON a.authorid = v.version_author
                     WHERE entry_id = 113
                  GROUP BY v.entry_id
/ MySQL server has gone away. Postgresql is driving me nuts.

Warning: Wrong parameter count for min() in /home/.../htdocs/plugins/serendipity_event_google_sitemap/serendipity_event_google_sitemap.php on line 232

Warning: Wrong parameter count for min() in /home/.../htdocs/plugins/serendipity_event_google_sitemap/serendipity_event_google_sitemap.php on line 233
Sitemap Update an Google gemeldet.
Warning: Invalid argument supplied for foreach() in /home/.../htdocs/plugins/serendipity_event_entryproperties/serendipity_event_entryproperties.php on line 564

any idea?

Posted: **Thu Dec 28, 2006 5:50 pm**

The problem is that the above is using non-standard sql (or at least it looks invalid, not sure without seeing the table definitions). Try adding the additional columns you are selecting into your group by clause... something like:

SELECT max(v.version) AS maxVer,
v.id,
a.realname,
v.version_date
FROM serendipity_stm_versioning AS v
LEFT OUTER JOIN serendipity_stm_authors AS a
ON a.authorid = v.version_author
WHERE entry_id = 113
GROUP BY v.id, a.realname, v.version_date

Posted: **Thu Dec 28, 2006 6:02 pm**

hm, I tried to execute this sql-code directly in phpmyadmin. It worked well.

could it be a problem with the connection to the mysql-server?

Posted: **Thu Dec 28, 2006 9:11 pm**

Hi!

I believe it's a server issue:

"MySQL server has gone away. Postgresql is driving me nuts."

This message does not come from s9y

Regards,
Garvin

Serendipity Forums

errors after entry-saving

errors after entry-saving

re: Post subject: errors after entry-saving