Danke !
ich hab einen syntaxfehler drinn und find ihn nicht...
Fehler
SQL-Befehl:
UPDATE "phpbb_topics" SET "phpbb_topics". "topic_first_post_id" = SELECT MIN( "phpkit_forumpost". "forumpost_id" )
FROM "phpkit_forumpost"
WHERE "phpkit_forumpost". "forumthread_id" = "phpbb_topic". "thread_id"
MySQL meldet:
#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann für verschiedene Server-Versionen unterschiedlich sein) bei '"phpbb_topics"
SET "phpbb_topics"."topic_first_post_id" = SELECT MIN'in Zeile 1
_____________________________
Habs auch so probiert:
UPDATE "phpkit_forumpost","phpbb_topics"
SET "phpbb_topics"."topic_first_post_id" = SELECT
"phpkit_forumpost"."forumpost_id" MIN("phpkit_forumpost"."forumpost_id")
FROM "phpkit_forumpost"
WHERE "phpkit_forumpost"."forumthread_id"="phpbb_topic". "thread_id"
Und So:
UPDATE "phpkit_forumpost","phpbb_topics"
SET "phpbb_topics"."topic_first_post_id" = SELECT
"phpkit_forumpost"."forumpost_id", MIN("phpkit_forumpost"."forumpost_id")
FROM "phpkit_forumpost"
WHERE "phpkit_forumpost"."forumthread_id"="phpbb_topic". "thread_id"
__________________________________