Idea [Gelöst] SQL: Kompatibilität

Wie kommst du darauf? In allen Php Fehlermeldungen ist nicht die Rede von Pemission Problemen, nur von SQL Probs?

I'm a bit slow to read German (so I just went quickly through all messages), but the error message said that there is a syntax error in SQL query. I ran it in my local computer with MySQL 5.0.67 (Ubuntu) and there was no error. Very odd.

Do you have access to phpMyAdmin or similiar? Try to run these queries in there:

If this doesn't work, your installation has failed:
SELECT * FROM joomla_fb_messages LIMIT 1

These are to locate the problem:

SELECT a.thread, a.subject FROM joomla_fb_messages AS a WHERE a.parent=0 AND a.moved=0 AND a.hold=0 GROUP BY a.thread LIMIT 100

SELECT thread, MAX(time) AS lastpost FROM joomla_fb_messages WHERE time >'1231500912' AND hold=0 AND moved=0 AND catid IN (1,2,3,5,4,6,7,8,9,10) GROUP BY 1

SELECT a.thread, a.subject, b.lastpost FROM joomla_fb_messages AS a JOIN ( SELECT thread, MAX(time) AS lastpost FROM joomla_fb_messages WHERE time >'1231500912' AND hold=0 AND moved=0 AND catid IN (1,2,3,5,4,6,7,8,9,10) GROUP BY 1) AS b ON b.thread = a.thread WHERE a.parent=0 AND a.moved=0 AND a.hold=0 GROUP BY a.thread ORDER BY b.lastpost DESC LIMIT 100

Any results?

All works, without the last query.
Here is the Sql Error:

Error

SQL query: Documentation

SELECT a.thread, a.subject, b.lastpost
FROM joomla_fb_messages AS a
JOIN (

SELECT thread, MAX( time ) AS lastpost
FROM joomla_fb_messages
WHERE time > '1231500912'
AND hold =0
AND moved =0
AND catid
IN ( 1, 2, 3, 5, 4, 6, 7, 8, 9, 10 )
GROUP BY 1
) AS b ON b.thread = a.thread
WHERE a.parent =0
AND a.moved =0
AND a.hold =0
GROUP BY a.thread
ORDER BY b.lastpost DESC
LIMIT 100

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT thread, MAX(time) AS lastpost FROM joomla_fb_messages WH

@ Lintzy: did you post this one in English? It is installation timeout problem. You need to add php timeout to 60-90 secs during installation.

@ Lintzy: did you post this one in English?

Yes, she did. She wanted it also for a regular bug reporting in German.

so... did the SQL-timeout produced this error??

Matias wrote:

@ Lintzy: did you post this one in English? It is installation timeout problem. You need to add php timeout to 60-90 secs during installation.

Yes, I did, it it the same case. And same question here: How to add php timeout to 60-90 (or 120) secs?