Print Page - Postgre and SQLite upgrades

Title: Postgre and SQLite upgrades
Post by: emanuele on 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... O:-)

---# 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... :P

Title: Re: Postgre and SQLite upgrades
Post by: TE on 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... O:-)

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... :P

AFAIK no (one insert per line is needed) And, IIRC, you can blame me for this one ;D

ElkArte Community

Elk Development => Bug Reports => Exterminated Bugs => Topic started by: emanuele on April 16, 2013, 05:58:04 pm