Check out the SMF Function DB!
Started by Bugo, March 11, 2022, 09:06:32 PM
Quote from: Matthias on April 24, 2022, 09:07:40 AMBut there is also only "de". I wanted to look at the SMF software, what is specified there at german_informal. Unfortunately I can not see that.
Quote from: Bugo on April 24, 2022, 08:03:19 AMI tried, but these codes already exist.You cannot view this attachment. @m4z, can you help with this?
INSERT INTO smf_message_bookmarks (msg_id, topic_id, bookmark_title, user_id, created_at) SELECT t.id_first_msg, b.id_topic, m.subject, b.id_member, m.poster_time FROM smf_bookmarks b INNER JOIN smf_topics t ON b.id_topic = t.id_topic INNER JOIN smf_messages m ON m.id_msg = t.id_first_msg ORDER BY t.id_first_msg
QuoteYou 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 ,,,,,,FROM smf2_message_bookmarks_old' at line 1Datei: /var/www/vhosts/web68.chalmers.kundenserver42.de/httpdocs/smf/Packages/temp/database.phpZeile: 83