warning when switching from default language (en) to other language.

Created on 26 March 2010, over 14 years ago
Updated 2 March 2024, 7 months ago

Hello,

When I change access my site in a language other than /en/ I get this warning:
user warning: Column 'created' in field list is ambiguous query: SELECT CONCAT(DATE_FORMAT(FROM_UNIXTIME(created), '%Y'),DATE_FORMAT(FROM_UNIXTIME(created), '%v')) AS yearweek, COUNT(CONCAT(DATE_FORMAT(FROM_UNIXTIME(created), '%Y'),DATE_FORMAT(FROM_UNIXTIME(created), '%v'))) AS postcount, DATE_FORMAT(FROM_UNIXTIME(created), '%Y') AS year, DATE_FORMAT(FROM_UNIXTIME(created), '%v') AS week, MONTH(FROM_UNIXTIME(created)) AS month FROM node n LEFT JOIN node i18n ON n.tnid > 0 AND n.tnid = i18n.tnid AND i18n.language = 'eo' WHERE (n.language ='eo' OR n.language ='' OR n.language IS NULL OR n.language = 'en' AND i18n.nid IS NULL) AND ( n.type IN ('blog') AND status = 1 )GROUP BY yearweek ORDER BY yearweek DESC LIMIT 0, 6 in /var/www/vhosts/elopio.net/httpdocs/sites/all/modules/week/week.module on line 119.

To see the warning, enter http://elopio.net/es

Any idea of what might be the problem?

I have i18n module enabled. Please let me know if you need more info to spot the error.

thanks,
pura vida.

πŸ› Bug report
Status

Closed: outdated

Version

2.7

Component

Code

Created by

πŸ‡¨πŸ‡·Costa Rica elopio

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024