Postgre and SQLite upgrades April 16, 2013, 05:58:04 pm I'm not sure, so I'll post it here hoping someone with an idea can jump in... Code: [Select]---# Adding new settings ...INSERT IGNORE INTO {$db_prefix}settings (variable, value)VALUES ('avatar_default', '0'), ('visual_verification_num_chars', '6'), ('gravatar_rating', 'g');---#Is this correct?Does the upgrade take care of splitting this into 3 different queries for SQLite and Postgre?ETA: and anyway the MySQL file has more settings...
Re: Postgre and SQLite upgrades Reply #1 – April 17, 2013, 12:23:21 am Quote from: emanuele – April 16, 2013, 05:58:04 pmI'm not sure, so I'll post it here hoping someone with an idea can jump in... Code: [Select]---# Adding new settings ...INSERT IGNORE INTO {$db_prefix}settings (variable, value)VALUES ('avatar_default', '0'), ('visual_verification_num_chars', '6'), ('gravatar_rating', 'g');---#Is this correct?Does the upgrade take care of splitting this into 3 different queries for SQLite and Postgre?ETA: and anyway the MySQL file has more settings... AFAIK no (one insert per line is needed) And, IIRC, you can blame me for this one